"In most cases you would also want to attach a UNIQUE or PRIMARY KEY constraint to prevent duplicate values from being inserted by accident, but this is not automatic."
and
"*Note: * Prior to PostgreSQL 7.3, serial implied UNIQUE. This is no longer automatic. If you wish a serial column to be in a unique constraint or a primary key, it must now be specified, same as with any other data type."
Miroslav Åulc, CEO StartNet s.r.o. ---------------------------------------------------- VrchlickÃho 161/5, Praha 5, 150 00, Äeskà republika ---------------------------------------------------- ICQ: 60144073 web: www.startnet.cz, www.novavystavba.cz ---------------------------------------------------- mobil: +420 603 711 413 telefon: +420 257 225 602 ----------------------------------------------------
Sam Adams wrote:
I read at http://jamesthornton.com/postgres/FAQ/faq-english.html#4.15.1 that when a serial is created then an index is created on the column. However I can't seem to find this anywhere in the PoistgreSQL manual. Is this true? Thanks.
-Sam
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
begin:vcard fn;quoted-printable:Miroslav =C5=A0ulc n;quoted-printable:=C5=A0ulc;Miroslav org:StartNet s.r.o. adr;quoted-printable;quoted-printable:;;Vrchlick=C3=A9ho 161/5;Praha 5;;150 00;=C4=8Cesk=C3=A1 republika email;internet:[EMAIL PROTECTED] title:CEO tel;work:+420 257 225 602 tel;cell:+420 603 711 413 x-mozilla-html:TRUE url:http://www.startnet.cz version:2.1 end:vcard
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
