Re: ERROR: missing FROM-clause entry for table "new"

From: Mike LAZLO <giantmetfan(at)comcast(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: Re: ERROR: missing FROM-clause entry for table "new"
Date: 2019-04-30 15:27:49
Message-ID: 1574448700.109324.1556638069968@connect.xfinity.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

THANKS! That was done with an pgAdmin replace! Now it runs.
Sometimes it just takes a second set of eyes!

> On April 30, 2019 at 9:47 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
>
> Mike LAZLO <giantmetfan(at)comcast(dot)net> writes:
> > What is wrong with this picture:
>
> Hm, the error message is pretty unhelpful, but I think the root problem
> is too many "NEW"s in several places:
>
> > , NEW.NEW.aircraft_key::int
> ^^^^^^^
>
> regards, tom lane
>
>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Mark Teper 2019-05-02 17:51:22
Previous Message Voillequin, Jean-Marc 2019-04-30 13:53:44 RE: ERROR: missing FROM-clause entry for table "new"