Re: Sequenties in pgSQL 7.3.x - Mailing list pgsql-sql

From Tomasz Myrta
Subject Re: Sequenties in pgSQL 7.3.x
Date
Msg-id 3F729819.3010108@klaster.net
Whole thread Raw
In response to Sequenties in pgSQL 7.3.x  (Przemysław Słupkowski<przemyslaw.slupkowski@euro.coig.pl>)
List pgsql-sql
> Hi
> I am using postgresql 7.3.x. I am upgrating a database PostgreSQL.
> The main problem is how to change field last value in sequencde which 
> exists in database.
> I created script to read this field and then I'm drop the table, do 
> modification and i'm must change this value to another value.
> But DBMS returns me message like that
> ERROR:  You can't change sequence relation seq_id_seq
> How to do this

Documentation says:
6.11. Sequence-Manipulation Functions
select setval('some_sequence',333);


Regards,
Tomasz Myrta



pgsql-sql by date:

Previous
From: Przemysław Słupkowski
Date:
Subject: Sequenties in pgSQL 7.3.x
Next
From: Oliver Elphick
Date:
Subject: Re: Sequenties in pgSQL 7.3.x