ok, it's working without the alias inside the SET thanks
2009/4/24 Filip Rembiałkowski <plk.zu...@gmail.com> > > > 2009/4/24 josep porres <jmpor...@gmail.com> > >> Hello, >> >> I am migrating a database to pg and modifying the app. >> In that process I found an error and i don't see the reason. >> >> It's happening when executing the next update sentence >> Do you see what's wrong? > > > table name / alias is not allowed in SET section. > > http://www.postgresql.org/docs/current/static/sql-update.html > > > Do not include the table's name in the specification of a target column — > for example, UPDATE tab SET tab.col = 1 is invalid. > > >> >> >> The server is pg8.3.7 for w32 >> ________________________________________________________________ >> >> update talls as t >> set t.estat=5, t.d_pag=now(), t.ts_update=now() >> where >> t.estat in (0,1) and t.data = '02/04/2009' >> and t.clau not in ( select p.clau from pendents p >> where (t.data - p.data) >= 90 ) >> ________________________________________________________ >> ERROR: column "t" of relation "talls" does not exist >> LINE 3: set t.estat=5, t.d_pag=now(), t.ts_update=now() >> ^ >> >> ********** Error ********** >> >> ERROR: column "t" of relation "talls" does not exist >> estat SQL: 42703 >> Caràcter: 25 >> _________________________________________________________ >> >> the table definitions are these: >> >> CREATE TABLE TALLS ( >> DATA DATE NOT NULL, >> CLAU VARCHAR(12) NOT NULL, >> CLAU_ABO VARCHAR(12), >> LLIBRE INTEGER, >> FULLA NUMERIC(10) DEFAULT 0, >> NOM VARCHAR(40), >> ADRECA VARCHAR(40), >> NUMERCOMPT VARCHAR(15), >> LECACT NUMERIC(10) DEFAULT 0, >> LECTURA NUMERIC(10) DEFAULT 0, >> REFORMA NUMERIC(1) DEFAULT 0, >> MOTIU NUMERIC(1) DEFAULT 0, >> NOTES VARCHAR(100), >> D_TALL DATE, >> D_PAG DATE, >> D_RECON DATE, >> TS_UPDATE TIMESTAMP, >> ESTAT NUMERIC(2) DEFAULT 0, >> CPARAT NUMERIC(1) DEFAULT 0, >> NOUCOMPT VARCHAR(15), >> REINCID NUMERIC(1) DEFAULT 0, >> CPOSTAL NUMERIC(5), >> CONSTRAINT PK_TALLS PRIMARY KEY (DATA, CLAU)); >> >> CREATE TABLE PENDENTS ( >> CLAU VARCHAR(12), >> DATA DATE, >> TITULAR VARCHAR(40), >> BANC VARCHAR(4), >> SUCURSAL VARCHAR(4), >> COMPTE VARCHAR(10), >> IMPORT NUMERIC(10,2), >> L1 VARCHAR(40) DEFAULT '', >> L2 VARCHAR(40) DEFAULT '', >> L3 VARCHAR(40) DEFAULT '', >> L4 VARCHAR(40) DEFAULT '', >> L5 VARCHAR(40) DEFAULT '', >> L6 VARCHAR(40) DEFAULT '', >> L7 VARCHAR(40) DEFAULT '', >> L8 VARCHAR(40) DEFAULT '', >> L9 VARCHAR(40) DEFAULT '', >> L10 VARCHAR(40) DEFAULT '', >> L11 VARCHAR(40) DEFAULT '', >> L12 VARCHAR(40) DEFAULT '', >> L13 VARCHAR(40) DEFAULT '', >> L14 VARCHAR(40) DEFAULT '', >> L15 VARCHAR(40) DEFAULT '', >> L16 VARCHAR(40) DEFAULT '', >> NOM VARCHAR(40), >> AIGUA NUMERIC(10,2) DEFAULT 0, >> QS NUMERIC(10,2) DEFAULT 0, >> LLOGUER NUMERIC(10,2) DEFAULT 0, >> CANON NUMERIC(10,2) DEFAULT 0, >> MATERIALS NUMERIC(10,2) DEFAULT 0, >> IVA7 NUMERIC(10,2) DEFAULT 0, >> DESPESES NUMERIC(10,2) DEFAULT 0, >> FIANCA NUMERIC(10,2) DEFAULT 0, >> DRET NUMERIC(10,2) DEFAULT 0, >> DATACOBRAMENT DATE, >> CLAVEGUERAM NUMERIC(10,2) DEFAULT 0, >> QSCLAVEGUERAM NUMERIC(10,2) DEFAULT 0, >> DOCUMENT VARCHAR(10), >> DEVOLUCIO NUMERIC(1) DEFAULT 0, >> ESTAT VARCHAR(1), >> CARTA NUMERIC(1) DEFAULT 0, >> ESPECIAL NUMERIC(1) DEFAULT 0, >> CONSTRAINT PK_PENDENTS PRIMARY KEY (DOCUMENT)); >> >> > > > -- > Filip Rembiałkowski > JID,mailto:filip.rembialkow...@gmail.com > http://filip.rembialkowski.net/ >
