i have error:
--------------------------- pgadmin iii --------------------------- error has occurred: error: relation "vettura_tariffa" not exist line 2: vettura_tariffa ^ query: select ( select valore vettura_tariffa new.targa=vettura.targa) context: pl/pgsql function "progettobd".costout() line 14 @ assignment --------------------------- ok --------------------------- the code following
create or replace function costout() returns trigger $$ declare giorno integer; gg1 integer; gg2 integer; tariffa numeric(2,0) ; costo integer; begin gg1=extract (days new.dataconsegna); gg2=extract (days new.dataritiro); giorno=gg1-gg2; tariffa=( select valore vettura join tariffa on vettura.tipotariffa=tariffa.tipo new.targa=vettura.targa); costo=tariffa * giorni; new.costoutilizzo=costo; end; $$ language plpgsql; and 1 trigger's code
create trigger costo_utilizzo after insert on utilizzo each row execute procedure costout(); it seems doesn't find table vettura, it's same other tables, , if try "select * vettura" works fine. tried swapping view problem persists. error appears after insert on "utilizzo". sorry bad english, thank in advance.
solution java problem.
we need engage in double quotes , bars command accepted postgresql.
sql = "insert \"schema\".\"table\"() values(?,?,?)
Comments
Post a Comment