> 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