Re: New warning code for missing FROM relations
От | Peter Eisentraut |
---|---|
Тема | Re: New warning code for missing FROM relations |
Дата | |
Msg-id | Pine.LNX.4.21.0006041731260.8545-100000@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: New warning code for missing FROM relations (Philip Warner <pjw@rhyme.com.au>) |
Список | 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 по дате отправления: