scott.marlowe wrote: > On Thu, 8 Apr 2004, Bruce Momjian wrote: > > > Fabien COELHO wrote: > > > > > > > > This would help me, at least, write correct and portable SQL. :) > > > > > > > > Added to TODO: > > > > > > > > * Add a session mode to warn about non-standard SQL usage > > > > > > So it seems that having C-like operators would hurt a lot;-) > > > > > > So you want to generate warnings for SERIAL, TEXT and a bunch of other > > > types, WITH[OUT] OIDS, RULE, ~ regular expressions, arrays, any use of > > > pg_catalog instead of information_schema (I may be wrong in the list, I > > > don't have the standard at hand, but I think I'm right in the spirit)... > > > > > > This is going to be noisy;-) > > > > Yep, it sure is going to be noisy. > > Could we consider a three (or more) way setting, for what to do? > Something like: > > sql_noncompliance_mode = error; > sql_noncompliance_mode = warn / notice; > sql_noncompliance_mode = ignore;
I think a boolean that turns on warnings would be enough. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org