Обсуждение: Sequenties in pgSQL 7.3.x

> 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

On Thu, 2003-09-25 at 07:36, Przemysław Słupkowski wrote:
> 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

Use the setval() function?

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight, UK                             http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
========================================   "Who shall separate us from the love of Christ? shall      tribulation, or
distress,or persecution, or famine,      or nakedness, or peril, or sword?...But in all these      things we
overwhelminglyconquer through Him who loved     us."               Romans 8:35,37  

On Thursday 25 September 2003 07:36, Przemysław Słupkowski wrote:
> 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

Are you using and UPDATE to set last_value? If so, you should use the setval()
function instead.

SELECT setval('my_seq', 1234);

--  Richard Huxton Archonet Ltd

HI
Thanks for help I'm found this solution and this works, but I'm use
something like that
PERFORM setval(seq_name, value);
It looks better but thanks a lot

----- Original Message -----
From: "Richard Huxton" <dev@archonet.com>
To: "Przemysław Słupkowski" <przemyslaw.slupkowski@euro.coig.pl>; "Lista
dyskusyjna pgsql-sql" <pgsql-sql@postgresql.org>
Sent: Thursday, September 25, 2003 9:55 AM
Subject: Re: [SQL] Sequenties in pgSQL 7.3.x


On Thursday 25 September 2003 07:36, Przemysław Słupkowski wrote:
> 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

Are you using and UPDATE to set last_value? If so, you should use the
setval()
function instead.

SELECT setval('my_seq', 1234);

-- Richard Huxton Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings