Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hLUgp-0003gS-Ai for pgsql-sql@arkaria.postgresql.org; Tue, 30 Apr 2019 15:29:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hLUfp-00052J-KS for pgsql-sql@arkaria.postgresql.org; Tue, 30 Apr 2019 15:28:01 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hLUfo-0004ya-Ut for pgsql-sql@lists.postgresql.org; Tue, 30 Apr 2019 15:28:01 +0000 Received: from resqmta-po-11v.sys.comcast.net ([2001:558:fe16:19:96:114:154:170]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hLUfl-0001Hd-C3 for pgsql-sql@lists.postgresql.org; Tue, 30 Apr 2019 15:28:00 +0000 Received: from resomta-po-14v.sys.comcast.net ([96.114.154.238]) by resqmta-po-11v.sys.comcast.net with ESMTP id LQUHhXb7DVIRHLUffhwEUq; Tue, 30 Apr 2019 15:27:51 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net; s=20190202a; t=1556638071; bh=ByopjDpmvGEpdq2BZMKixU1vCoppujsl3aZXLtB6cZg=; h=Received:Received:Date:From:Reply-To:To:Message-ID:Subject: MIME-Version:Content-Type; b=jBhVW9UygDsykOD3C5IFIQV6FILGzH1YnDVFWkfJbhz9uic+rRkwoF7z8jpdEyqYR j8W4tp5b7vhbK2N5R+KhYpt61RtpudxVTqpPQ/2ObQ66Rkz/ARbOq1HEJhNLfAR6yG hAHMumAVet6qKd3oIRfp6qEJtZbB6YVMUhglV0X3a7yantQnnLDoFQnfdWAUeBkC6E cUN6AAIfAC0n7T90EZ3cq2XBKNHjFWzdxRCLMWTJdi1knJVGuN0sXPTtrrmW+2W02k SP219jg/vgAbyU65xvzl9tX9F6zYNhAaruReW2uNYy4X2QG1SwAiJCrt76G4odr/zW 2ZM0AeiAgksPQ== Received: from oxapp-asd-17o.email.comcast.net ([96.115.233.255]) by resomta-po-14v.sys.comcast.net with ESMTPS id LUfehK6NswpUALUfehoYYX; Tue, 30 Apr 2019 15:27:51 +0000 X-Xfinity-VAAS: gggruggvucftvghtrhhoucdtuddrgeduuddrieehgdeftdcutefuodetggdotefrodftvfcurfhrohhfihhlvgemucevohhmtggrshhtqdftvghsihdpqfgfvfdppffquffrtefokffrnecuuegrihhlohhuthemuceftddtnecuogfthfevqddquegrugfkmhhpohhrthgrnhgtvgculddvtddmnecujfgurhepfffhrhfvkfgjfhfugggtgffrkghiofesthejsgdtredtjeenucfhrhhomhepofhikhgvucfntegknffquceoghhirghnthhmvghtfhgrnhestghomhgtrghsthdrnhgvtheqnecukfhppeeliedrudduhedrvdeffedrvdehhedpudehhedrudejkedrudektddruddunecurfgrrhgrmhephhgvlhhopehogigrphhpqdgrshguqddujehordgvmhgrihhlrdgtohhmtggrshhtrdhnvghtpdhinhgvthepleeirdduudehrddvfeefrddvheehpdhmrghilhhfrhhomhepghhirghnthhmvghtfhgrnhestghomhgtrghsthdrnhgvthdprhgtphhtthhopehtghhlsehsshhsrdhpghhhrdhprgdruhhspdhrtghpthhtohepphhgshhqlhdqshhqlheslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhgnecuvehluhhsthgvrhfuihiivgeptd X-Xfinity-VMeta: sc=20;st=legit Date: Tue, 30 Apr 2019 11:27:49 -0400 (EDT) From: Mike LAZLO Reply-To: Mike LAZLO To: Tom Lane Cc: pgsql-sql@lists.postgresql.org Message-ID: <1574448700.109324.1556638069968@connect.xfinity.com> In-Reply-To: <26223.1556632058@sss.pgh.pa.us> References: <625497565.102576.1556631694006@connect.xfinity.com> <26223.1556632058@sss.pgh.pa.us> Subject: Re: ERROR: missing FROM-clause entry for table "new" MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Priority: 3 Importance: Medium X-Originating-Client: open-xchange-appsuite X-Originating-IP: ::ffff:155.178.180.11 X-Mailer: Open-Xchange Mailer v7.8.4-Rev38 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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 wrote: > > > Mike LAZLO 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 > >