Bug with sequence - Mailing list pgsql-general

From taich@gmx.at (Thomas Aichinger)
Subject Bug with sequence
Date
Msg-id 92c0776e.0211180745.49911131@posting.google.com
Whole thread Raw
Responses Re: Bug with sequence  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-general
Hi,

I recently installed pg 7.2.3 on my linux box and discovered that
there are some problems with datatype serial and sequence.

1.) If you create a table with a datatype serial, the corrsponding
sequence will be created, but if you drop the table the sequence is
not dropped.

2.) If you create a sequence and grant it to public one cant use
currval() until one used setval() or nextval().
"ERROR:  midnr.currval is not yet defined in this session"

3.) Sometimes one gets 'not enogh privileges' error when using
nexval()


Am I the first one who discovered that?

Thanks
Thomas

pgsql-general by date:

Previous
From: Tariq Muhammad
Date:
Subject: Re: [ANNOUNCE] RC1 Packaged for Testing ...
Next
From: "Dorward Villaruz"
Date:
Subject: help in starting up / shutting down postgres as another user