Re: [HACKERS] Bug? - Mailing list pgsql-sql

> Then how do we clear the values of a serial column(is it done only by
> dropping the column?)?

If you look at the following link, you will see that serial is not really a true data-type.  It is
merely a short-cut to get the desired results:

http://www.postgresql.org/docs/8.1/interactive/datatype.html#DATATYPE-SERIAL

Also, if you are interested in resetting your columns "serial" value back to 1 or 0 or -10000, you
can do it using the setval() function for the following link:

http://www.postgresql.org/docs/8.1/interactive/functions-sequence.html

Regards,

Richard Broersma Jr.