Re: New warning code for missing FROM relations - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: New warning code for missing FROM relations
Date
Msg-id Pine.LNX.4.21.0006041731260.8545-100000@localhost.localdomain
Whole thread Raw
In response to Re: New warning code for missing FROM relations  (Philip Warner <pjw@rhyme.com.au>)
List pgsql-hackers
Philip Warner writes:

> >    SELECT *
> >       INTO TABLE tmp1
> >       FROM tmp
> >       WHERE onek.unique1 < 2;
> >    NOTICE:  Adding missing FROM-clause entry for table onek

> Is is worth adding yet another setting, eg. set sql92=strict, which
> would disallow such flagrant breaches of the standard?

SQL provides for facility called the SQL Flagger, which is supposed to do
exactly that. This might sound like an interesting idea but in order for
it to be useful you'd have to maintain it across the board, which sounds
like a major head ache.

The irony in the given example is that the SELECT INTO command isn't in
the standard in the first place so you'd have to create all sorts of
double standards. Certain things would be "extensions", certain things
would be "misuse". And for all it's worth, we have no idea which is which.

If you want to throw about warnings about "probable" coding errors and the
like one *must* be able to switch them off. Either something is right,
then you shut up. Or it's wrong, then you throw an error. Or you're not
sure, then you better leave it up to the user.


-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: ODBC configure
Next
From: Bruce Momjian
Date:
Subject: Re: ODBC configure