Sequences are now based on int8, not int4, arithmetic. SERIAL pseudo-type
Tom Lane <tgl@sss.pgh.pa.us>
Sequences are now based on int8, not int4, arithmetic. SERIAL pseudo-type has an alias SERIAL4 and a sister SERIAL8. SERIAL8 is just the same except the created column is type int8 not int4. initdb forced. Note this also breaks any chance of pg_upgrade from 7.1, unless we hack up pg_upgrade to drop and recreate sequences. (Which is not out of the question, but I don't wanna do it.)
Files
| Path | Change | +/− |
|---|---|---|
| contrib/spi/autoinc.c | modified | +5 −0 |
| doc/src/sgml/datatype.sgml | modified | +50 −12 |
| doc/src/sgml/ref/create_sequence.sgml | modified | +3 −3 |
| src/backend/commands/creatinh.c | modified | +1 −2 |
| src/backend/commands/sequence.c | modified | +81 −66 |
| src/backend/commands/view.c | modified | +1 −2 |
| src/backend/nodes/copyfuncs.c | modified | +1 −2 |
| src/backend/nodes/equalfuncs.c | modified | +1 −3 |
| src/backend/nodes/outfuncs.c | modified | +3 −4 |
| src/backend/parser/analyze.c | modified | +25 −4 |
| src/backend/parser/gram.y | modified | +7 −24 |
| src/backend/parser/keywords.c | modified | +1 −2 |
| src/bin/pg_dump/pg_dump.c | modified | +30 −28 |
| src/include/catalog/catversion.h | modified | +2 −2 |
| src/include/catalog/pg_proc.h | modified | +5 −5 |
| src/include/commands/sequence.h | modified | +27 −2 |
| src/include/nodes/parsenodes.h | modified | +2 −3 |
| src/interfaces/ecpg/preproc/keywords.c | modified | +1 −2 |
| src/interfaces/ecpg/preproc/preproc.y | modified | +1 −11 |
| src/test/regress/expected/rules.out | modified | +4 −4 |
| src/test/regress/regress.c | modified | +3 −1 |