]> granicus.if.org Git - postgresql/commit
projects / postgresql / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 12cf9f8) | patch
Support SERIAL column type. Expand column marked is_sequence into three
authorThomas G. Lockhart <lockhart@fourpalms.org>
Tue, 25 Aug 1998 15:08:12 +0000 (15:08 +0000)
committerThomas G. Lockhart <lockhart@fourpalms.org>
Tue, 25 Aug 1998 15:08:12 +0000 (15:08 +0000)
commit7ff198cd46d646206cab5a8547d8bf8fe1a39cbb
treea9d0b67f3ab9dd2702872a92cd20a3d327c3571btree | snapshot
parent12cf9f8075dac3bb81efa845285922ed520d9dc7commit | diff
Support SERIAL column type. Expand column marked is_sequence into three
 statements:
 - the table definition with a default clause referencing the sequence;
 - a CREATE SEQUENCE statement;
 - a UNIQUE constraint, which expands into a CREATE INDEX statement.
This is not a perfect solution, since the sequence will remain even if
 the table is dropped. Also, there is no absolute protection on updating
 the sequence column.
src/backend/parser/analyze.c diff | blob | history
Unnamed repository; edit this file 'description' to name the repository.