Re: [PATCHES] Warning for missing createlang
Bruce Momjian writes: How about this, that also suggests you mistyped the name: HINT: Perhaps you need to use 'createlang' to load the language into the database, or you mistyped the language name. That's only one step away from this: peter=# SELECT * FROM test; ERROR: relation test does not exist HINT: Perhaps you need to use CREATE TABLE to create the table in the database, or you mistyped the table name. I think not... -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [PATCHES] Warning for missing createlang
Bruce Momjian [EMAIL PROTECTED] writes: I have written a patch to issue an hint if someone tries to create a function in a language that isn't loaded into the database: ERROR: language plpgsql does not exist HINT: Perhaps you need to use 'createlang' to load the language into the database. I know Peter didn't like this idea in the past, but we are getting too many people who forget createlang, and with our new HINT tags, it seems appropriate. I still agree with Peter's opinion ... this hint is fairly silly, especially since it would pop out for simple misspellings of language names. regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [PATCHES] Warning for missing createlang
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: I have written a patch to issue an hint if someone tries to create a function in a language that isn't loaded into the database: ERROR: language plpgsql does not exist HINT: Perhaps you need to use 'createlang' to load the language into the database. I know Peter didn't like this idea in the past, but we are getting too many people who forget createlang, and with our new HINT tags, it seems appropriate. I still agree with Peter's opinion ... this hint is fairly silly, especially since it would pop out for simple misspellings of language names. What can we do to help people remember they have forgotten to load the language? The post that question here too often. I don't see any problem with a hint that starts with Perhaps. -- 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 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])