Re: SERIAL type fields

All,

I have been doing a conversion of an Access 97 database to PostgreSQL -
so far things have been going relatively smoothly. However, I am now
running into a minor issue - one could almost say it is an asthetic
issue more than anything.

In the conversion of my Access tables, to a number of them I had to add
a unique key field. I decided to use a SERIAL type for these fields,
which set up a "sequence" table (table_field_seq) for each table that
uses one.

I am now in a process of doing a multiple conversion of data to these
new tables, where I clear out the table then reload it with new data.

What I came across was that I wanted to reset the sequence number so
that when the new records were added, they would start at number "1" and
increase from there.

When you create the table from new, it does this - but after that, the
sequence table says that the minimum value for the sequence is "1" - and
not zero - so that when you add records to the table the sequence is
used on, the first record has a value of "2" in that field when it is added.

I tried to reset the minimum value to "0" - but it wouldn't let me. Does
anyone know of how you do this, without having to DROP the table and
sequence, and re-creating them? Is there some kind of ALTER TABLE
command, or possibly something the database setup, that would allow me
to alter this behavior?

Thank you for any answers you can provide...

Andrew L. Ayers