| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Przemysław Słupkowski <przemyslaw(dot)slupkowski(at)euro(dot)coig(dot)pl>, "Lista dyskusyjna pgsql-sql" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Sequenties in pgSQL 7.3.x |
| Date: | 2003-09-25 07:55:54 |
| Message-ID: | 200309250855.54588.dev@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Przemysław Słupkowski | 2003-09-25 08:16:57 | Re: Sequenties in pgSQL 7.3.x |
| Previous Message | Oliver Elphick | 2003-09-25 07:45:04 | Re: Sequenties in pgSQL 7.3.x |