aboutsummaryrefslogtreecommitdiff
path: root/doc/src
Commit message (Collapse)AuthorAge
...
* Add Oracle-compatible GREATEST and LEAST functions. Pavel StehuleTom Lane2005-06-26
|
* Code review for escape-strings patch. Sync psql and plpgsql lexersTom Lane2005-06-26
| | | | | | | with main, avoid using a SQL-defined SQLSTATE for what is most definitely not a SQL-compatible error condition, fix documentation omissions, adhere to message style guidelines, don't use two GUC_REPORT variables when one is sufficient. Nothing done about pg_dump issues.
* Add E'' syntax so eventually normal strings can treat backslashesBruce Momjian2005-06-26
| | | | | | | | | | | | literally. Add GUC variables: "escape_string_warning" - warn about backslashes in non-E strings "escape_string_syntax" - supports E'' syntax? "standard_compliant_strings" - treats backslashes literally in '' Update code to use E'' when escapes are used.
* Force a checkpoint before committing a CREATE DATABASE command. ThisTom Lane2005-06-25
| | | | | | should fix the recent reports of "index is not a btree" failures, as well as preventing a more obscure race condition involving changes to a template database just after copying it with CREATE DATABASE.
* Add:Bruce Momjian2005-06-25
| | | | | > o Pass arrays natively instead of as text between plperl and postgres > o Add support for polymorphic arguments and return types to plperl
* Update:Bruce Momjian2005-06-25
| | | | | < * Allow per-user, per-group quotas per-tablespace > * Allow per-tablespace quotas
* Update:Bruce Momjian2005-06-25
| | | | | < * Allow per-user and per-tablespaces quotas > * Allow per-user, per-group quotas per-tablespace
* Add:Bruce Momjian2005-06-25
| | | | > * Allow per-user and per-tablespaces quotas
* Add item:Bruce Momjian2005-06-25
| | | | | | | | | | | | | | > * Add NUMERIC division operator that doesn't round? > > Currently NUMERIC _rounds_ the result to the specified precision. > This means division can return a result that multiplied by the > divisor is greater than the dividend, e.g. this returns a value > 10: > > SELECT (10::numeric(2,0) / 6::numeric(2,0))::numeric(2,0) * 6; > > The positive modulus result returned by NUMERICs might be considered > inaccurate, in one sense. >
* Add desciption for terminate:Bruce Momjian2005-06-24
| | | | | | > > Currently SIGTERM of a backend can lead to lock table corruption. >
* Extend r-tree operator classes to handle Y-direction tests equivalentTom Lane2005-06-24
| | | | | | | | | | | | | | | to the existing X-direction tests. An rtree class now includes 4 actual 2-D tests, 4 1-D X-direction tests, and 4 1-D Y-direction tests. This involved adding four new Y-direction test operators for each of box and polygon; I followed the PostGIS project's lead as to the names of these operators. NON BACKWARDS COMPATIBLE CHANGE: the poly_overleft (&<) and poly_overright (&>) operators now have semantics comparable to box_overleft and box_overright. This is necessary to make r-tree indexes work correctly on polygons. Also, I changed circle_left and circle_right to agree with box_left and box_right --- formerly they allowed the boundaries to touch. This isn't actually essential given the lack of any r-tree opclass for circles, but it seems best to sync all the definitions while we are at it.
* Done:Bruce Momjian2005-06-24
| | | | | > * -Fix incorrect rtree results due to wrong assumptions about "over" > operator semantics
* Completed:Bruce Momjian2005-06-24
| | | | | < * Allow REINDEX to rebuild all database indexes, remove /contrib/reindex > * -Allow REINDEX to rebuild all database indexes
* Add:Bruce Momjian2005-06-24
| | | | > * Add program to test if fsync has a delay compared to non-fsync
* Update text of terminate:Bruce Momjian2005-06-23
| | | | | | | | | | | | | < * Allow administrators to safely terminate individual sessions < < Right now, SIGTERM will terminate a session, but it is treated as < though the postmaster has paniced and shared memory might not be < cleaned up properly. A new signal is needed for safe termination < because backends must first do a query cancel, then exit once they < have run the query cancel cleanup routine. < > * Allow administrators to safely terminate individual sessions either > via an SQL function or SIGTERM
* Make REINDEX DATABASE do what one would expect, namely reindex all indexesTom Lane2005-06-22
| | | | | | | in the database. The old behavior (reindex system catalogs only) is now available as REINDEX SYSTEM. I did not add the complementary REINDEX USER case since there did not seem to be consensus for this, but it would be trivial to add later. Per recent discussions.
* Add a hack requested by the JDBC driver writers: when a function'sTom Lane2005-06-22
| | | | | | | | | argument list contains parameter symbols ($n) declared as type VOID, discard these arguments. This allows the driver to avoid renumbering mixed IN and OUT argument placeholders (the JDBC syntax involves writing ? for both IN and OUT parameters, but on the server side we don't think that OUT parameters are arguments). This doesn't break any currently- useful cases since VOID is not used as an input argument type.
* Add a CONTINUE statement to PL/PgSQL, which can be used to begin theNeil Conway2005-06-22
| | | | | next iteration of a loop. Update documentation and add regression tests. Patch from Pavel Stehule, reviewed by Neil Conway.
* pg_dump can now dump large objects even in plain-text output mode, byTom Lane2005-06-21
| | | | | | using the recently added lo_create() function. The restore logic in pg_restore is greatly simplified as well, since there's no need anymore to try to adjust database references to match a new set of blob OIDs.
* Cause initdb to create a third standard database "postgres", whichTom Lane2005-06-21
| | | | | | | | | | | | | | unlike template0 and template1 does not have any special status in terms of backend functionality. However, all external utilities such as createuser and createdb now connect to "postgres" instead of template1, and the documentation is changed to encourage people to use "postgres" instead of template1 as a play area. This should fix some longstanding gotchas involving unexpected propagation of database objects by createdb (when you used template1 without understanding the implications), as well as ameliorating the problem that CREATE DATABASE is unhappy if anyone else is connected to template1. Patch by Dave Page, minor editing by Tom Lane. All per recent pghackers discussions.
* Remove statement that GiST indexes aren't WAL-logged.Tom Lane2005-06-20
|
* Update text that stated GiST indexes aren't WAL-logged.Tom Lane2005-06-20
|
* Minor documentation update for RAISE expression patch.Neil Conway2005-06-19
|
* Add a time-of-preparation column to the pg_prepared_xacts view, per anTom Lane2005-06-18
| | | | | | | | | | old suggestion by Oliver Jowett. Also, add a transaction column to the pg_locks view to show the xid of each transaction holding or awaiting locks; this allows prepared transactions to be properly associated with the locks they own. There was already a column named 'transaction', and I chose to rename it to 'transactionid' --- since this column is new in the current devel cycle there should be no backwards compatibility issue to worry about.
* Remove TODO.detail.Bruce Momjian2005-06-18
| | | | | < * -Add two-phase commit [2phase] > * -Add two-phase commit
* Done:Bruce Momjian2005-06-18
| | | | | < * Add two-phase commit [2phase] > * -Add two-phase commit [2phase]
* Two-phase commit. Original patch by Heikki Linnakangas, with additionalTom Lane2005-06-17
| | | | hacking by Alvaro Herrera and Tom Lane.
* Re-order item.Bruce Momjian2005-06-17
| | | | | | | > * Auto-fill the free space map by scanning the buffer cache or by > checking pages written by the background writer < * Auto-fill the free space map by scanning the buffer cache or by < checking pages written by the background writer
* Move item:Bruce Momjian2005-06-17
| | | | | * Auto-fill the free space map by scanning the buffer cache or by checking pages written by the background writer
* Update NetBSD 'options' description.Bruce Momjian2005-06-17
| | | | Kris Jurka
* Improve wording of read-only GUC variables; shows -> reports.Bruce Momjian2005-06-17
|
* Add:Bruce Momjian2005-06-17
| | | | | | | | | | > > * Create a bitmap of pages that need vacuuming > > Instead of sequentially scanning the entire table, have the background > writer or some other process record pages that have expired rows, then > VACUUM can look at just those pages rather than the entire table. In > the event of a system crash, the bitmap would probably be invalidated.
* Minor SGML markup cleanup.Neil Conway2005-06-15
|
* This patch makes it possible to use the full set of timezones when doingBruce Momjian2005-06-15
| | | | | | | | | | | | | | | | | | "AT TIME ZONE", and not just the shorlist previously available. For example: SELECT CURRENT_TIMESTAMP AT TIME ZONE 'Europe/London'; works fine now. It will also obey whatever DST rules were in effect at just that date, which the previous implementation did not. It also supports the AT TIME ZONE on the timetz datatype. The whole handling of DST is a bit bogus there, so I chose to make it use whatever DST rules are in effect at the time of executig the query. not sure if anybody is actuallyi *using* timetz though, it seems pretty unpredictable just because of this... Magnus Hagander
* Add BETWEEN SYMMETRIC.Bruce Momjian2005-06-14
| | | | Pavel Stehule
* reorder:Bruce Momjian2005-06-14
| | | | | < * -Add BETWEEN ASYMMETRIC/SYMMETRIC > * -Add BETWEEN SYMMETRIC/ASYMMETRIC
* Done:Bruce Momjian2005-06-14
| | | | > * -Add BETWEEN ASYMMETRIC/SYMMETRIC
* Add pg_postmaster_start_time() function.Bruce Momjian2005-06-14
| | | | | Euler Taveira de Oliveira Matthias Schmidt
* Done:Bruce Momjian2005-06-14
| | | | > o -Have SHOW ALL show descriptions for server-side variables
* Have SHOW ALL include variable descriptions.Bruce Momjian2005-06-14
| | | | Matthias Schmidt
* Update:Bruce Momjian2005-06-14
| | | | | < o Have SHOW ALL and pg_settings show descriptions for server-side variables > o Have SHOW ALL show descriptions for server-side variables
* Move item into proper section:Bruce Momjian2005-06-14
| | | | o Have SHOW ALL and pg_settings show descriptions for server-side variables
* Add GUC krb_server_hostname so the server hostname can be specified asBruce Momjian2005-06-14
| | | | | | | | | part of service principal. If not set, any service principal matching an entry in the keytab can be used. NEW KERBEROS MATCHING BEHAVIOR FOR 8.1. Todd Kover
* Done:Bruce Momjian2005-06-14
| | | | > o -Allow PL/PgSQL's RAISE function to take expressions
* Allow the parameters to PL/PgSQL's RAISE statement to be expressions,Neil Conway2005-06-14
| | | | | | | | instead of just scalar variables. Add regression tests and update the documentation. Along the way, remove some redundant error checking code from exec_stmt_perform(). Original patch from Pavel Stehule, reworked by Neil Conway.
* Done:Bruce Momjian2005-06-14
| | | | > * -Use index to restrict rows returned by multi-key index when used with
* Add -L option to psql to log sessions.Bruce Momjian2005-06-14
| | | | Lorne Sunley
* Change the planner to allow indexscan qualification clauses to useTom Lane2005-06-13
| | | | | | | | | nonconsecutive columns of a multicolumn index, as per discussion around mid-May (pghackers thread "Best way to scan on-disk bitmaps"). This turns out to require only minimal changes in btree, and so far as I can see none at all in GiST. btcostestimate did need some work, but its original assumption that index selectivity == heap selectivity was quite bogus even before this.
* Per discussion on -hackers, this patch changes psql's "expanded" outputNeil Conway2005-06-13
| | | | | | mode to only affect the presentation of normal query results, not the output of psql slash commands. Documentation updated. I also made some unrelated minor psql cleanup. Per suggestion from Stuart Cooper.
* SGML cleanup: consistently use "endterm" in <xref>s that link to theNeil Conway2005-06-13
| | | | reference page for SQL commands, so that the link text is italicized.
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-30 16:22:32 +0000