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

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

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Voillequin, Jean-Marc 2019-04-30 13:53:44 RE: ERROR: missing FROM-clause entry for table "new"
Previous Message Mike LAZLO 2019-04-30 13:41:32 ERROR: missing FROM-clause entry for table "new"