From: Richard Broersma Jr <rabroersma@yahoo.com>
To: Indira Muthuswamy <indumuthu@gmail.com>
To: Jim C. Nasby <jim@nasby.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: [HACKERS] Bug?
Date: Sat, 21 Oct 2006 08:25:54 -0700 (PDT)
Message-ID: <20061021152555.78840.qmail@web31805.mail.mud.yahoo.com> (raw)
In-Reply-To: <e1a645540610182358n3468d7bv9f152a49c7e650@mail.gmail.com>
> 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rabroersma@yahoo.com, indumuthu@gmail.com, jim@nasby.net
Subject: Re: [HACKERS] Bug?
In-Reply-To: <20061021152555.78840.qmail@web31805.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox