From: | PropAAS DBA <dba(at)propaas(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Odd sql error .. |
Date: | 2017-09-17 03:01:21 |
Message-ID: | c9c0defe-49f0-0dd6-6b5a-6414731b910a@propaas.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
I'm running this sql (see below) and I get this error:
ERROR: column "last_modified" does not exist
LINE 3: ...repricefee" , "tot_savings" , "last_updated" , "last_modi...
^
HINT: There is a column named "last_modified" in table "mytable", but
it can
not be referenced from this part of the query.
Thoughts?
INSERT INTO myschema.mytable
( "invoiceseq" , "claseq" , "clasub" , "invby" ,
"invrectyp"
, "invstatus" , "invnum" , "createdate" , "postdate" , "invdate" ,
"invamt" , "preinvnum" , "preinvamt" , "billed" , "adjpaid" ,
"expenses" ,
"first_reviewsav" , "first_reviewfee" , "first_appealfee" ,
"first_fraudsav" ,
"first_fraudfee" , "first_repricesav" , "first_repricefee" ,
"dent_reviewsav"
, "dent_reviewfee" , "dent_appealfee" , "dent_fraudsav" ,
"dent_fraudfee" ,
"dent_repricesav" , "dent_repricefee" , "fac_reviewsav" ,
"fac_reviewfee" ,
"fac_appealfee" , "fac_fraudsav" , "fac_fraudfee" , "fac_repricesav" ,
"fac_repricefee" , "tot_savings" , "last_updated" , "last_modified" )
SELECT "invoiceseq" , "claseq" , "clasub" , "invby"
, "invrectyp" ,
"invstatus" , "invnum" , "createdate" , "postdate" , "invdate" , "
invamt" , "preinvnum" , "preinvamt" , "billed" , "adjpaid" ,
"expenses" ,
"first_reviewsav" , "first_reviewfee" , "first_appealfee" ,
"first_fraudsav"
, "first_fraudfee" , "first_repricesav" , "first_repricefee" ,
"dent_reviewsav" , "dent_reviewfee" , "dent_appealfee" ,
"dent_fraudsav" ,
"dent_fraudfee" , "dent_repricesav" , "dent_repricefee" ,
"fac_reviewsav" ,
"fac_reviewfee" , "fac_appealfee" , "fac_fraudsav" , "fac_fraudfee"
, "fac_repricesav" ,
"fac_repricefee" , "tot_savings" , "last_updated" , "last_modified"
FROM old_schema.mytable
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Midgley | 2017-09-17 03:59:19 | Re: Odd sql error .. |
Previous Message | srilinux | 2017-09-14 16:27:40 | Re: Query is executing but giving error when using with shell scripting |