Re: [PATCHES] Warning for missing createlang

2003-09-05 Thread Bruce Momjian
Peter Eisentraut wrote: > 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: > >

Re: [PATCHES] Warning for missing createlang

2003-09-05 Thread Peter Eisentraut
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: rela

Re: [PATCHES] Warning for missing createlang

2003-09-04 Thread Bruce Momjian
Bruce Momjian wrote: > 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: > > test=> CREATE FUNCTION xx() RETURNS INT AS ' > test'> select 1' > test-> LANGUAGE 'plpgsql'; > ERROR: language "plp

Re: [PATCHES] Warning for missing createlang

2003-09-04 Thread Bruce Momjian
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 'createlan

Re: [PATCHES] Warning for missing createlang

2003-09-04 Thread Tom Lane
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