NotificationsYou must be signed in to change notification settings
Fork28
Star151

Commitbf4507e

committed

I think it's important that it's actually documented that they can add

primary keys after the fact!Also, we need to add regression tests for alter table / add primary keyand alter table / drop constraint. These shouldn't be added until 7.3thomethinks...Chris

1 parenta966ac1 commitbf4507eCopy full SHA for bf4507e

File tree

1 file changed

+10

-1

lines changed

doc/src/sgml/ref
- alter_table.sgml

1 file changed

+10

-1

lines changed

`‎doc/src/sgml/ref/alter_table.sgml`

Lines changed: 10 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`<!--`
`2`		`-$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.36 2002/02/16 23:45:48 momjian Exp $`
	`2`	`+$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.37 2002/02/17 11:50:09 momjian Exp $`
`3`	`3`	`PostgreSQL documentation`
`4`	`4`	`-->`
`5`	`5`
`@@ -295,6 +295,15 @@ ALTER TABLE distributors ADD CONSTRAINT dist_id_zipcode_key UNIQUE (dist_id, zip`
`295`	`295`	`</para>`
`296`	`296`	`</refsect1>`
`297`	`297`
	`298`	`+ <para>`
	`299`	`+ To add an automatically named primary key constraint to a table, noting`
	`300`	`+ that a table can only ever have one primary key:`
	`301`	`+ <programlisting>`
	`302`	`+ALTER TABLE distributors ADD PRIMARY KEY (dist_id);`
	`303`	`+ </programlisting>`
	`304`	`+ </para>`
	`305`	`+ </refsect1>`
	`306`	`+`
`298`	`307`	`<refsect1 id="R1-SQL-ALTERTABLE-3">`
`299`	`308`	`<title>`
`300`	`309`	`Compatibility`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commitbf4507e

File tree

1 file changed

1 file changed

`‎doc/src/sgml/ref/alter_table.sgml`

0 commit comments