X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 38C29563D3 for ; Sun, 27 Feb 2005 17:31:26 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 86634-06 for ; Sun, 27 Feb 2005 17:31:00 +0000 (GMT) Received: from sranda.klamovka.kosire.czf (unknown [82.113.63.66]) by svr1.postgresql.org (Postfix) with ESMTP id 7873456441 for ; Sun, 27 Feb 2005 17:31:05 +0000 (GMT) Received: (qmail 30607 invoked from network); 27 Feb 2005 18:31:16 +0100 Received: from fordfrog.klamovka.kosire.czf (HELO ?192.168.2.2?) (10.15.70.18) by ns.klamovka.kosire.czf with AES256-SHA encrypted SMTP; 27 Feb 2005 18:31:16 +0100 Message-ID: <422203E7.7010109@startnet.cz> Date: Sun, 27 Feb 2005 18:31:19 +0100 From: =?UTF-8?B?TWlyb3NsYXYgxaB1bGM=?= Organization: StartNet s.r.o. User-Agent: Mozilla Thunderbird 1.0 (X11/20041208) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Sam Adams Cc: pgsql-sql@postgresql.org Subject: Re: Serial and Index References: <1109508892.19366.216118816@webmail.messagingengine.com> In-Reply-To: <1109508892.19366.216118816@webmail.messagingengine.com> X-Enigmail-Version: 0.89.5.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: multipart/mixed; boundary="------------020704070506030202020508" X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200502/340 X-Sequence-Number: 20450 This is a multi-part message in MIME format. --------------020704070506030202020508 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Documentation at http://www.postgresql.org/docs/8.0/interactive/datatype.html#DATATYPE-SERIAL says: "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 > > --------------020704070506030202020508 Content-Type: text/x-vcard; charset=utf-8; name="miroslav.sulc.vcf" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="miroslav.sulc.vcf" YmVnaW46dmNhcmQNCmZuO3F1b3RlZC1wcmludGFibGU6TWlyb3NsYXYgPUM1PUEwdWxjDQpu O3F1b3RlZC1wcmludGFibGU6PUM1PUEwdWxjO01pcm9zbGF2DQpvcmc6U3RhcnROZXQgcy5y Lm8uDQphZHI7cXVvdGVkLXByaW50YWJsZTtxdW90ZWQtcHJpbnRhYmxlOjs7VnJjaGxpY2s9 QzM9QTlobyAxNjEvNTtQcmFoYSA1OzsxNTAgMDA7PUM0PThDZXNrPUMzPUExIHJlcHVibGlr YQ0KZW1haWw7aW50ZXJuZXQ6bWlyb3NsYXYuc3VsY0BzdGFydG5ldC5jeg0KdGl0bGU6Q0VP DQp0ZWw7d29yazorNDIwIDI1NyAyMjUgNjAyDQp0ZWw7Y2VsbDorNDIwIDYwMyA3MTEgNDEz DQp4LW1vemlsbGEtaHRtbDpUUlVFDQp1cmw6aHR0cDovL3d3dy5zdGFydG5ldC5jeg0KdmVy c2lvbjoyLjENCmVuZDp2Y2FyZA0KDQo= --------------020704070506030202020508--