aboutsummaryrefslogtreecommitdiff
path: root/doc/src/sgml/ref/create_sequence.sgml
Commit message (Collapse)AuthorAge
* Remove TABLESPACE option of CREATE SEQUENCE; sequences will now alwaysTom Lane2004-07-12
| | | | | | | live in database or schema's default tablespace, as per today's discussion. Also, remove some unused keywords from the grammar (PATH, PENDANT, VERSION), and fix ALSO, which was added as a keyword but not added to the keyword classification lists, thus making it worse-than-reserved.
* Tablespaces. Alternate database locations are dead, long live tablespaces.Tom Lane2004-06-18
| | | | | | | | | There are various things left to do: contrib dbsize and oid2name modules need work, and so does the documentation. Also someone should think about COMMENT ON TABLESPACE and maybe RENAME TABLESPACE. Also initlocation is dead, it just doesn't know it yet. Gavin Sherry and Tom Lane.
* $Header: -> $PostgreSQL Changes ...PostgreSQL Daemon2003-11-29
|
* Fix language.Peter Eisentraut2003-11-25
|
* Make the SQL command synopses appear less random.Peter Eisentraut2003-09-22
|
* Fix a batch of speling misteaks identified by Peter's spell-checker tool.Tom Lane2003-09-20
|
* More cleanup of Diagnostics sections.Tom Lane2003-09-12
|
* Add/edit index entries.Peter Eisentraut2003-08-31
|
* More editing of reference pages.Peter Eisentraut2003-04-22
|
* Merge documentation into one book. (Build with "make html".) ReplacePeter Eisentraut2003-03-25
| | | | vague cross-references with real links.
* Todo items:Bruce Momjian2003-03-20
| | | | | | | | | | | | | | | | | | | Add ALTER SEQUENCE to modify min/max/increment/cache/cycle values Also updated create sequence docs to mention NO MINVALUE, & NO MAXVALUE. New Files: doc/src/sgml/ref/alter_sequence.sgml src/test/regress/expected/sequence.out src/test/regress/sql/sequence.sql ALTER SEQUENCE is NOT transactional. It behaves similarly to setval(). It matches the proposed SQL200N spec, as well as Oracle in most ways -- Oracle lacks RESTART WITH for some strange reason. -- Rod Taylor <rbt@rbt.ca>
* This patch includes a lot of minor cleanups to the SGML documentation,Bruce Momjian2003-01-19
| | | | | | | | | | | | | | | | | | including: - replacing all the appropriate usages of <citetitle>PostgreSQL ...</citetitle> with &cite-user;, &cite-admin;, and so on - fix an omission in the EXECUTE documentation - add some more text to the EXPLAIN documentation - improve the PL/PgSQL RETURN NEXT documentation (more work to do here) - minor markup fixes Neil Conway
* Tweak CREATE SEQUENCE grammar to be more SQL1999 standards compliant.Bruce Momjian2002-11-10
| | | | Neil Conway
* Revise command completion tags as per hackers message on 20 March.Peter Eisentraut2002-05-18
|
* Update SQL-command reference pages for schema features.Tom Lane2002-04-23
|
* Augment the date/time examples in the User's Guide to reflect the newerThomas G. Lockhart2002-04-21
| | | | | | | | | capabilities of specifying time zones as intervals per SQL9x. Put refentrytitle contents on the same line as the tag. Otherwise, leading whitespace is propagated into the product, which (at least) messes up the ToC layout. Remove (some) docinfo tags containing dates. Best to omit if the dates are not accurate; maybe use CVS dates instead or leave them out.
* Spell checking and markup additionsPeter Eisentraut2002-03-22
|
* Spell-check and markup policePeter Eisentraut2002-01-20
|
* Use PostgreSQL consistantly throughout docs. Before, usage was split evenlyThomas G. Lockhart2001-12-08
| | | | between Postgres and PostgreSQL.
* Point out the dependency on having int8 arithmetic available.Tom Lane2001-11-28
|
* Expand documentation for sequence functions (nextval and friends).Tom Lane2001-11-17
| | | | | Place it in the expected place in the User's Guide, rather than hiding it in the command reference page for CREATE SEQUENCE.
* Replace ASCII-quotes with proper markup.Peter Eisentraut2001-09-13
|
* Put some kind of grammatical uniformity in the <refpurpose> lines.Peter Eisentraut2001-09-03
|
* Sequences are now based on int8, not int4, arithmetic. SERIAL pseudo-typeTom Lane2001-08-16
| | | | | | | | 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.)
* fix markupPeter Eisentraut2001-06-30
|
* Add TEMPORARY sequences and have SERIAL on a temp table have a temporaryBruce Momjian2001-06-23
| | | | sequence.
* Remove error check that disallowed setval() on a sequence with cacheTom Lane2000-12-08
| | | | | | | | | value greater than one. The behavior this sought to disallow doesn't seem any less confusing than the other behaviors of cached sequences. Improve wording of some error messages, too. Update documentation accordingly. Also add an explanation that aborted transactions do not roll back their nextval() calls; this seems to be a FAQ, so it ought to be mentioned here...
* Add proofreader's changes to docs.Bruce Momjian2000-10-05
| | | | Fix misspelling of disbursion to dispersion.
* CleanupBruce Momjian2000-07-21
|
* Minor fixups for markup and wording.Thomas G. Lockhart2000-05-08
|
* Complete merge of all old man page information.Thomas G. Lockhart1999-07-22
| | | | ecpg reference page still needs formatting.
* Fix markup for docbook2man man page generation.Thomas G. Lockhart1999-07-06
| | | | | | | No big deal; fixed lots of other markup at the same time. Bigest change: make sure there is no whitespace in front of <term> contents. This will probably help the other output types too.
* Clean up to ensure tag completion as required by the newest versionsThomas G. Lockhart1998-12-29
| | | | | of Norm's Modular Style Sheets and jade/docbook. From Vince Vielhaber <vev@michvhf.com>.
* Minor cleanup in markup, especially in the Output section.Thomas G. Lockhart1998-10-30
|
* Minor fixes in markup.Thomas G. Lockhart1998-10-21
| | | | Include cross-references in NOTIFY and UNLISTEN.
* SGML updates from post 6.3.2 manual changes. Added pg_upgrade man page.Bruce Momjian1998-10-15
|
* Markup and editing adjustments...Thomas G. Lockhart1998-09-16
|
* Very minor formatting fixup in the refentry id field to removeThomas G. Lockhart1998-09-07
| | | | | the trailing "-1". This makes a cleaner html output file name. Clean up a few refpurpose fields.
* Make minor formatting improvements to statement synopses.Thomas G. Lockhart1998-08-15
| | | | Make sure all files end with a newline.
* Fix minor end-of-file formatting.Thomas G. Lockhart1998-07-29
|
* First version of files from Oliver Elphick.Thomas G. Lockhart1998-07-14
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-31 12:49:24 +0000