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" <[EMAIL PROTECTED]> To: "Przemysław Słupkowski" <[EMAIL PROTECTED]>; "Lista dyskusyjna pgsql-sql" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html