pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedOdd sql error ..
2+ messages / 2 participants
[nested] [flat]
* Odd sql error ..
@ 2017-09-17 03:01 PropAAS DBA <dba@propaas.com>
2017-09-17 03:59 ` Re: Odd sql error .. Steve Midgley <science@misuse.org>
0 siblings, 1 reply; 2+ messages in thread
From: PropAAS DBA @ 2017-09-17 03:01 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Odd sql error ..
2017-09-17 03:01 Odd sql error .. PropAAS DBA <dba@propaas.com>
@ 2017-09-17 03:59 ` Steve Midgley <science@misuse.org>
0 siblings, 0 replies; 2+ messages in thread
From: Steve Midgley @ 2017-09-17 03:59 UTC (permalink / raw)
To: PropAAS DBA <dba@propaas.com>; +Cc: pgsql-sql
On Sat, Sep 16, 2017 at 8:01 PM, PropAAS DBA <dba@propaas.com> wrote:
> 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?
>
If you just run the select portion of that insert statement, does it work?
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2017-09-17 03:59 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-09-17 03:01 Odd sql error .. PropAAS DBA <dba@propaas.com>
2017-09-17 03:59 ` Steve Midgley <science@misuse.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox