To: pgsql-sql@postgresql.org
From: PropAAS DBA <dba@propaas.com>
Subject: Odd sql error ..
Message-ID: <c9c0defe-49f0-0dd6-6b5a-6414731b910a@propaas.com>
Date: Sat, 16 Sep 2017 21:01:21 -0600
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.3.0
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="------------72833F5A940F9ED471E24A34"
Content-Language: en-US
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

This is a multi-part message in MIME format.
--------------72833F5A940F9ED471E24A34
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit

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


--------------72833F5A940F9ED471E24A34
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=utf-8">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    I'm running this sql (see below) and I get this error:<br>
    <br>
    <font color="#3333ff">ERROR:  column "last_modified" does not exist<br>
      LINE 3: ...repricefee"  , "tot_savings"  , "last_updated"  ,
      "last_modi...<br>
                                                                   ^<br>
      HINT:  There is a column named "last_modified" in table "mytable",
      but it can<br>
      not be referenced from this part of the query.</font><br>
    <br>
    <br>
    Thoughts?<br>
    <br>
    <br>
    <br>
    <br>
    INSERT INTO myschema.mytable <br>
                   (  "invoiceseq"  , "claseq"  , "clasub"  , "invby"  ,
    "invrectyp"<br>
      , "invstatus"  , "invnum"  , "createdate"  , "postdate"  ,
    "invdate"  , <br>
    "invamt"  , "preinvnum"  , "preinvamt"  , "billed"  , "adjpaid"  ,
    "expenses"  , <br>
    "first_reviewsav"  , "first_reviewfee"  , "first_appealfee"  ,
    "first_fraudsav"  , <br>
    "first_fraudfee"  , "first_repricesav"  , "first_repricefee"  ,
    "dent_reviewsav"<br>
    , "dent_reviewfee"  , "dent_appealfee"  , "dent_fraudsav"  ,
    "dent_fraudfee"  ,<br>
    "dent_repricesav"  , "dent_repricefee"  , "fac_reviewsav"  ,
    "fac_reviewfee"  ,<br>
    "fac_appealfee"  , "fac_fraudsav"  , "fac_fraudfee"  ,
    "fac_repricesav"  , <br>
    "fac_repricefee"  , "tot_savings"  , "last_updated"  ,
    "last_modified"  )<br>
                   SELECT  "invoiceseq"  , "claseq"  , "clasub"  ,
    "invby"  , "invrectyp"  , <br>
    "invstatus"  , "invnum"  , "createdate"  , "postdate"  , "invdate" 
    , "<br>
    invamt"  , "preinvnum"  , "preinvamt"  , "billed"  , "adjpaid"  ,
    "expenses"  ,<br>
    "first_reviewsav"  , "first_reviewfee"  , "first_appealfee"  ,
    "first_fraudsav"<br>
     , "first_fraudfee"  , "first_repricesav"  , "first_repricefee"  , <br>
    "dent_reviewsav"  , "dent_reviewfee"  , "dent_appealfee"  ,
    "dent_fraudsav"  , <br>
    "dent_fraudfee"  , "dent_repricesav"  , "dent_repricefee"  ,
    "fac_reviewsav"  , <br>
    "fac_reviewfee"  , "fac_appealfee"  , "fac_fraudsav"  ,
    "fac_fraudfee"  , "fac_repricesav"  ,<br>
    "fac_repricefee"  , "tot_savings"  , "last_updated"  ,
    "last_modified"<br>
                   FROM old_schema.mytable<br>
    <br>
  </body>
</html>

--------------72833F5A940F9ED471E24A34--