On 01/31/11 10:55 PM, Adarsh Sharma wrote:
Dear all,
I am not able to distinct these two datatypes ( Serial and Sequence )
in Postgresql which resembles like auto-increment in Mysql.
Which one gets priority and When ?
The only thing I am able to find is to use SERIAL because if a drop
table occurs , still SEQUENCE memory is not freed, its garbage remains.
However if we define a SERIAL column in a table , implicitly it makes
a sequence.
Could anyone Please describe me the difference and Which to Use When ?
neither is actually a data type.
a sequence is a special table-like object that has auto increment logic
associated with it.
a serial is a pseudotype implemented as an integer field with an
associated sequence.
when you drop a table that has an associated sequence, the sequence is
dropped automatically.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general