Commit022da0e

committed

SERIAL no longer creates an index by default, as of 7.3.

1 parentcfeca62 commit022da0eCopy full SHA for 022da0e

File tree

-7

lines changed

-7

lines changed

Lines changed: 3 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,7 +1,7 @@`
`1`	`1`
`2`	`2`	`Frequently Asked Questions (FAQ) for PostgreSQL`
`3`	`3`
`4`		`- Last updated:Sat Nov15 23:41:03 EST 2003`
	`4`	`+ Last updated:Wed Nov19 11:50:04 EST 2003`
`5`	`5`
`6`	`6`	`Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)`
`7`	`7`
`@@ -879,8 +879,8 @@ BYTEA bytea variable-length byte array (null-byte safe)`
`879`	`879`
`880`	`880`	`4.15.1) How do I create a serial/auto-incrementing field?`
`881`	`881`
`882`		`- PostgreSQL supports a SERIAL data type. It auto-creates a sequence and`
`883`		`-index on the column.For example, this:`
	`882`	`+ PostgreSQL supports a SERIAL data type. It auto-creates a sequence.`
	`883`	`+ For example, this:`
`884`	`884`	`CREATE TABLE person (`
`885`	`885`	`id SERIAL,`
`886`	`886`	`name TEXT`
`@@ -892,7 +892,6 @@ BYTEA bytea variable-length byte array (null-byte safe)`
`892`	`892`	`id INT4 NOT NULL DEFAULT nextval('person_id_seq'),`
`893`	`893`	`name TEXT`
`894`	`894`	`);`
`895`		`- CREATE UNIQUE INDEX person_id_key ON person ( id );`
`896`	`895`
`897`	`896`	`See the create_sequence manual page for more information about`
`898`	`897`	`sequences. You can also use each row's OID field as a unique value.`

Lines changed: 2 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -10,7 +10,7 @@`
`10`	`10`	`alink="#0000ff">`
`11`	`11`	`<H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1>`
`12`	`12`
`13`		`-<P>Last updated:Sat Nov15 23:41:03 EST 2003</P>`
	`13`	`+<P>Last updated:Wed Nov19 11:50:04 EST 2003</P>`
`14`	`14`
`15`	`15`	`<P>Current maintainer: Bruce Momjian (<Ahref=`
`16`	`16`	`"mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)<BR>`
`@@ -1102,7 +1102,7 @@ <H4><A name="4.15.1">4.15.1</A>) How do I create a`
`1102`	`1102`	`serial/auto-incrementing field?</H4>`
`1103`	`1103`
`1104`	`1104`	`<P>PostgreSQL supports a<SMALL>SERIAL</SMALL> data type. It`
`1105`		`- auto-creates a sequence and index on the column. For example,`
	`1105`	`+ auto-creates a sequence. For example,`
`1106`	`1106`	`this:</P>`
`1107`	`1107`	`<PRE>`
`1108`	`1108`	`CREATE TABLE person (`
`@@ -1118,7 +1118,6 @@ <H4><A name="4.15.1">4.15.1</A>) How do I create a`
`1118`	`1118`	`id INT4 NOT NULL DEFAULT nextval('person_id_seq'),`
`1119`	`1119`	`name TEXT`
`1120`	`1120`	`);`
`1121`		`- CREATE UNIQUE INDEX person_id_key ON person ( id );`
`1122`	`1121`	`</PRE>`
`1123`	`1122`
`1124`	`1123`	`See the<I>create_sequence</I> manual page for more information`

Comments

(0)