aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
...
* Add fields in the control file to check for whether the backend wasThomas G. Lockhart2002-04-21
| | | | | | | | compiled for integer date/time storage and to check the length of storage for the locale fields in the same data structure. Slightly reword some of the error messages to be more accurate on possible recovery options (e.g. recompile *or* re-initdb). Bump version number on this file.
* 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.
* Minor wording change for readability.Thomas G. Lockhart2002-04-21
|
* Make pg_dump independent of FUNC_MAX_ARGS.Peter Eisentraut2002-04-21
|
* Fix typo.Tom Lane2002-04-21
|
* Restructure AclItem representation so that we can have more than eightTom Lane2002-04-21
| | | | | | | | | different privilege bits (might as well make use of the space we were wasting on padding). EXECUTE and USAGE bits for procedures, languages now are separate privileges instead of being overlaid on SELECT. Add privileges for namespaces and databases. The GRANT and REVOKE commands work for these object types, but we don't actually enforce the privileges yet...
* Remove --enable-syslog optionTatsuo Ishii2002-04-21
|
* pq_getstring doesn't go through pq_getbyte anymore, for better performance.Peter Eisentraut2002-04-20
|
* Scanner performance improvementsPeter Eisentraut2002-04-20
| | | | | | | | Use flex flags -CF. Pass the to-be-scanned string around as StringInfo type, to avoid querying the length repeatedly. Clean up some code and remove lex-compatibility cruft. Escape backslash sequences inline. Use flex-provided yy_scan_buffer() function to set up input, rather than using myinput().
* Add missing include.Peter Eisentraut2002-04-20
|
* Change naming rule for ON SELECT rules of views: they're all justTom Lane2002-04-19
| | | | _RETURN now, since there's no need to keep 'em unique anymore.
* pg_trigger's index on tgrelid is replaced by a unique index onTom Lane2002-04-19
| | | | | | | | | | (tgrelid, tgname). This provides an additional check on trigger name uniqueness per-table (which was already enforced by the code anyway). With this change, RelationBuildTriggers will read the triggers in order by tgname, since it's scanning using this index. Since a predictable trigger ordering has been requested for some time, document this behavior as a feature. Also document that rules fire in name order, since yesterday's changes to pg_rewrite indexing cause that too.
* Make PUBLIC an unreserved word (in fact, not a keyword at all),Tom Lane2002-04-18
| | | | per previous discussion.
* Rule names are now unique per-relation, rather than unique globally.Tom Lane2002-04-18
| | | | | | | | DROP RULE and COMMENT ON RULE syntax adds an 'ON tablename' clause, similar to TRIGGER syntaxes. To allow loading of existing pg_dump files containing COMMENT ON RULE, the COMMENT code will still accept the old syntax --- but only if the target rulename is unique across the whole database.
* Suggest another possible solution for funcs using temp tables:Bruce Momjian2002-04-18
| | | | | < without using PL/PgSQL EXECUTE, needs cached plan invalidation > without using PL/PgSQL EXECUTE, needs cache prevention/invalidation
* More neutral:Bruce Momjian2002-04-18
| | | | > o Abort all, some or, no SET changes made in an aborted transaction
* Update:Bruce Momjian2002-04-18
| | | | > o Abort all or commit all SET changes made in an aborted transaction
* Correct documention of lo_unlink return value as int, not Oid.Bruce Momjian2002-04-18
|
* Update:Bruce Momjian2002-04-18
| | | | | > o Allow Java server-side programming, http://pljava.sourceforge.net > [java]
* Ant 1.4.1 now requires for jdbc. Mention in HISTORY release notes.Bruce Momjian2002-04-18
|
* Add how to get database/user listing information.Bruce Momjian2002-04-18
|
* Add user:Bruce Momjian2002-04-18
| | | | > * Rod is Rod Taylor <rbt@zort.ca>
* Add to DROP COLUMN.Bruce Momjian2002-04-18
|
* Add to PREPARE archive.Bruce Momjian2002-04-18
|
* Update for Neil:Bruce Momjian2002-04-18
| | | | | > * Cache most recent query plan(s) (Neil) [prepare] > * Neil is Neil Conway <nconway@klamath.dyndns.org>
* Update for Oleg:Bruce Momjian2002-04-18
| | | | > using a sequential scan for highest/lowest values (Oleg)
* Add:Bruce Momjian2002-04-18
| | | | Add to DROP COLUMN description.
* Update:Bruce Momjian2002-04-18
| | | | > o Abort SET changes made in aborted transactions (?)
* Back out python change, needs delay.Bruce Momjian2002-04-18
|
* Change docs to do 20! rather than larger.Bruce Momjian2002-04-18
|
* Updated:Bruce Momjian2002-04-18
| | | | | > * Add BETWEEN ASYMMETRIC/SYMMETRIC (Christopher) > * Christopher is Christopher Kings-Lynne <chriskl@familyhealth.com.au>
* Add:Bruce Momjian2002-04-18
| | | | > * Add BSD-licensed qsort() for Solaris
* Add:Bruce Momjian2002-04-18
| | | | > o Allow SHOW to output as a query result, like EXPLAIN
* Add mention of -DLINUX_PROFILE to profile mention.Bruce Momjian2002-04-18
|
* Add:Bruce Momjian2002-04-18
| | | | > * Try flex flags -Cf and -CF to see if performance improves
* Add:Bruce Momjian2002-04-17
| | | | > * Add utility to compute accurate random_page_cost value
* Opclasses live in namespaces. I also took the opportunity to createTom Lane2002-04-17
| | | | | | | an 'opclass owner' column in pg_opclass. Nothing is done with it at present, but since there are plans to invent a CREATE OPERATOR CLASS command soon, we'll probably want DROP OPERATOR CLASS too, which suggests that a notion of ownership would be a good idea.
* Add:Bruce Momjian2002-04-17
| | | | > * Allow easy display of usernames in a group
* Add SQL92 document name.Bruce Momjian2002-04-17
|
* Update to point directly to ANSI store.Bruce Momjian2002-04-17
|
* Add mention of standards documents.Bruce Momjian2002-04-17
|
* Add steps for typical patch.Bruce Momjian2002-04-17
|
* Operators live in namespaces. CREATE/DROP/COMMENT ON OPERATOR takeTom Lane2002-04-16
| | | | | | | | | | qualified operator names directly, for example CREATE OPERATOR myschema.+ ( ... ). To qualify an operator name in an expression you need to write OPERATOR(myschema.+) (thanks to Peter for suggesting an escape hatch). I also took advantage of having to reformat pg_operator to fix something that'd been bugging me for a while: mergejoinable operators should have explicit links to the associated cross-data-type comparison operators, rather than hardwiring an assumption that they are named < and >.
* Added some rudimentary table and column testsDave Cramer2002-04-16
| | | | added a setup/teardown to create and drop the connection, and table
* fixed getColumns as per Panu Outinen's email. At this point have only ↵Dave Cramer2002-04-16
| | | | repaired the bug, haven't made it caseInsensitive
* Fixed typo in preproc/type.hMichael Meskes2002-04-16
|
* The patch I sent to -patches a little while ago wasn't applied: itBruce Momjian2002-04-15
| | | | | | | | | | was in the thread "make BufferGetBlockNumber() a macro". Tom objected to the original patch, so I prepared a new one which doesn't change BufferGetBlockNumber() into a macro, it just cleans up some comments and fixes an assertion. The patch is attached. Neil Conway
* The attached patch corrects an inaccuracy in src/backend/catalog/READMEBruce Momjian2002-04-15
| | | | | | and fixes a few spelling mistakes in src/bakckend/lmgr/README. Neil Conway
* CATALOG VERSION UPDATED:Bruce Momjian2002-04-15
| | | | | | | | | The indexes on most system catalogs are named with the suffix "_index"; not so with TOAST table indexes, which use "_idx". This trivial patch changes TOAST table index names to use the "_index" suffix for consistency. Neil Conway
* Disable VACUUM from being called from a function because function memoryBruce Momjian2002-04-15
| | | | would be cleared by vacuum; fix idea from Tom Lane.
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-07 16:15:27 +0000