| From: | Tomasz Myrta <jasiek(at)klaster(dot)net> |
|---|---|
| To: | Przemysław Słupkowski <przemyslaw(dot)slupkowski(at)euro(dot)coig(dot)pl> |
| Cc: | Lista dyskusyjna pgsql-sql <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Sequenties in pgSQL 7.3.x |
| Date: | 2003-09-25 07:24:09 |
| Message-ID: | 3F729819.3010108@klaster.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Elphick | 2003-09-25 07:45:04 | Re: Sequenties in pgSQL 7.3.x |
| Previous Message | Przemysław Słupkowski | 2003-09-25 06:36:42 | Sequenties in pgSQL 7.3.x |