On Thu, Feb 19, 2004 at 07:16:42PM +0100, Alexander Troppmann wrote:
>SELECT SETVAL('recipe_id_seq', max(id)) FROM recipe;
>
> returns the following output:
>
> setval
>
>455
>(1 row)
Ok.
> Now I tried to fetch the next free primary key id for my "recipe" table:
POSTGRESQL BUG REPORT TEMPLATE
Your name : Alexander Troppmann
Your email address : [EMAIL PROTECTED]
Syste
Look at this:
test=> CREATE SEQUENCE x;
CREATE SEQUENCE
test=> \d x
Sequence "public.x"
Column | Type
---+-
sequence_name | name
last_value| bigint
increment_by | bigint
