Re: New warning code for missing FROM relations

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: New warning code for missing FROM relations
Date: 2000-06-03 07:34:10
Message-ID: 716.960017650@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> I have committed new warning code to alert users who auto-create
> relations without knowing it.
> The code issues the warning if it auto-creates a range table entry, and
> there is already a range table entry identified as coming from a FROM
> clause. Correlated subqueries should not be a problem because they are
> not auto-created.

I still prefer the suggestion I made before: complain only if the
implicit FROM entry is for a table already present in the rangelist
(under a different alias, obviously). The fact that that choice
would not break any existing regression tests seems relevant...

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2000-06-03 08:38:27 Re: [GENERAL] PostgreSQL v7.0.1 Released
Previous Message Bruce Momjian 2000-06-03 04:40:48 New warning code for missing FROM relations