[SQL] unrecognized language 'plpgsql'

2001-06-19 Thread Markus Wagner
Hi, when creating a function I get the error message 'unrecognized language'. What's this? I need a powerful language which can retrieve many things (username, tables, attributes, etc.). Isn't plpgsql the best choice? Why this message and where can I find more documentation on plpgsql? Thank you

Re: [SQL] Sequence behaviour.

2001-06-19 Thread Grant
> > binary_data=# create sequence test; > > CREATE > > binary_data=# select nextval('test'); > > NOTICE: test.nextval: sequence was re-created > > Um, how did you get that NOTICE? I don't see it. This is version 7.0.3. I deleted the sequence first. > Anyway, the answer to your question is tha

Re: [SQL] About primary keys.

2001-06-19 Thread Roberto Mello
On Tue, Jun 19, 2001 at 02:10:16PM +0200, David BOURIAUD wrote: > Hi the list ! > Is there a way to get in system tables all the primary keys of a table ? There's a recipe that is related to that in my Postgres CookBook that you could adapt to your needs: http://www.brasileiro.net/postgr