Re: [SQL] About primary keys.

[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/postgres/cookbook/view-one-recipe.adp?recipe_id=36

-Roberto
-- 
+| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+
  Roberto Mello - Computer Science, USU - http://www.brasileiro.net 
   http://www.sdl.usu.edu - Space Dynamics Lab, Developer
TAGLINE NO ESPELHO ¤ OHLEPSE ON ENILGAT

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl

Re: [SQL] Sequence behaviour.

[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 that there's another bit of
> state in a sequence: the is_called flag is initially false and is
> set true during the first-ever nextval().  This allows nextval to
> deliver the specified start value on the first call, rather than
> the one after that.  In 7.1 setval() takes an optional third
> argument to reset the value of is_called...

Ok. Still a bit weird to me anyhow.

Thanks.


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

[SQL] unrecognized language 'plpgsql'

[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,

Markus

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])