"Relation does not exist" Postgresql -


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