summaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAgeFilesLines
* Implement SQL92-compatible FIRST, LAST, ABSOLUTE n, RELATIVE n optionsTom Lane2003-03-1113-347/+629
| | | | for FETCH and MOVE.
* This patch fixes a bunch of spelling mistakes in comments throughout theTom Lane2003-03-1064-149/+149
| | | | | | PostgreSQL source code. Neil Conway
* Update German FAQBruce Momjian2003-03-102-25/+40
| | | | Ian Barwick
* Cleanup up psql \connect and \pset pager setting display, DennisBruce Momjian2003-03-102-6/+6
| | | | Bj?rklund.
* Restructure parsetree representation of DECLARE CURSOR: now it's aTom Lane2003-03-1040-571/+661
| | | | | | | | | | | | utility statement (DeclareCursorStmt) with a SELECT query dangling from it, rather than a SELECT query with a few unusual fields in it. Add code to determine whether a planned query can safely be run backwards. If DECLARE CURSOR specifies SCROLL, ensure that the plan can be run backwards by adding a Materialize plan node if it can't. Without SCROLL, you get an error if you try to fetch backwards from a cursor that can't handle it. (There is still some discussion about what the exact behavior should be, but this is necessary infrastructure in any case.) Along the way, make EXPLAIN DECLARE CURSOR work.
* pg_restore failed to restore blobs if -X disable-triggers is specified.Tom Lane2003-03-091-2/+11
|
* tuplestore_donestoring() isn't needed anymore, but provide a no-opTom Lane2003-03-091-1/+4
| | | | macro definition so as not to create compatibility problems.
* Revise tuplestore and nodeMaterial so that we don't have to read theTom Lane2003-03-097-227/+267
| | | | | | | | | | entire contents of the subplan into the tuplestore before we can return any tuples. Instead, the tuplestore holds what we've already read, and we fetch additional rows from the subplan as needed. Random access to the previously-read rows works with the tuplestore, and doesn't affect the state of the partially-read subplan. This is a step towards fixing the problems with cursors over complex queries --- we don't want to stick in Materialize nodes if they'll prevent quick startup for a cursor.
* Applied patch from Paul Sorenson to correctly handle schema names in ↵Barry Lind2003-03-084-33/+111
| | | | | | | | | | | | | updateable result sets. Applied patch from Rich Cullingford to fix a NPE in the absolute() method of result set. Applied patch from Tarjei Skorgenes to fix a NPE when logging is enabled. Modified Files: jdbc/org/postgresql/core/BaseResultSet.java jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSet.java jdbc/org/postgresql/jdbc2/Array.java jdbc/org/postgresql/util/PSQLException.java
* Not done:Bruce Momjian2003-03-081-2/+2
| | | | > * Precompile SQL functions to avoid overhead (Neil)
* Reorder items and mark some as completed.Bruce Momjian2003-03-081-16/+7
| | | | | | | | | | | | | | | | | | | | | | | > * Allow savepoints / nested transactions [transactions] (Bruce) 215d210 < o Add GUC parameter to control the maximum number of rewrite cycles 227,228c222 < o Allow parameters to be specified by name and type during < definition > o Allow parameters to be specified by name and type during definition 304,305d297 < * Overhaul bufmgr/lockmgr/transaction manager < * Allow savepoints / nested transactions [transactions] (Bruce) 386,387c378,379 < * Add checkpoint_min_warning postgresql.conf option to warn about checkpoints < that are too frequent > * -Add checkpoint_min_warning postgresql.conf option to warn about checkpoints > that are too frequent (Bruce) 390d381 < * Allow pg_xlog to be moved without symlinks 406c397 < * Precompile SQL functions to avoid overhead (Neil) > * -Precompile SQL functions to avoid overhead (Neil)
* Cleanup and reorganization.Barry Lind2003-03-0772-1519/+1122
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | - Added a private api layer (org.postgresql.core.Base*) - Cleaned up public api (org.postgresql.PG*) - Added consistent headers and copywrite info - Removed deprecated Serialize functionality - Cleaned up imports - Moved some files to more appropriate locations Modified Files: jdbc/org/postgresql/Driver.java.in jdbc/org/postgresql/PGConnection.java jdbc/org/postgresql/PGNotification.java jdbc/org/postgresql/PGStatement.java jdbc/org/postgresql/core/Encoding.java jdbc/org/postgresql/core/Notification.java jdbc/org/postgresql/core/QueryExecutor.java jdbc/org/postgresql/core/StartupPacket.java jdbc/org/postgresql/fastpath/Fastpath.java jdbc/org/postgresql/fastpath/FastpathArg.java jdbc/org/postgresql/geometric/PGbox.java jdbc/org/postgresql/geometric/PGcircle.java jdbc/org/postgresql/geometric/PGline.java jdbc/org/postgresql/geometric/PGlseg.java jdbc/org/postgresql/geometric/PGpath.java jdbc/org/postgresql/geometric/PGpoint.java jdbc/org/postgresql/geometric/PGpolygon.java jdbc/org/postgresql/jdbc1/AbstractJdbc1Connection.java jdbc/org/postgresql/jdbc1/AbstractJdbc1DatabaseMetaData.java jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSet.java jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSetMetaData.java jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java jdbc/org/postgresql/jdbc1/Jdbc1CallableStatement.java jdbc/org/postgresql/jdbc1/Jdbc1Connection.java jdbc/org/postgresql/jdbc1/Jdbc1DatabaseMetaData.java jdbc/org/postgresql/jdbc1/Jdbc1PreparedStatement.java jdbc/org/postgresql/jdbc1/Jdbc1ResultSet.java jdbc/org/postgresql/jdbc1/Jdbc1ResultSetMetaData.java jdbc/org/postgresql/jdbc1/Jdbc1Statement.java jdbc/org/postgresql/jdbc2/AbstractJdbc2Blob.java jdbc/org/postgresql/jdbc2/AbstractJdbc2Clob.java jdbc/org/postgresql/jdbc2/AbstractJdbc2Connection.java jdbc/org/postgresql/jdbc2/AbstractJdbc2DatabaseMetaData.java jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSetMetaData.java jdbc/org/postgresql/jdbc2/AbstractJdbc2Statement.java jdbc/org/postgresql/jdbc2/Array.java jdbc/org/postgresql/jdbc2/Jdbc2CallableStatement.java jdbc/org/postgresql/jdbc2/Jdbc2Connection.java jdbc/org/postgresql/jdbc2/Jdbc2PreparedStatement.java jdbc/org/postgresql/jdbc2/Jdbc2ResultSet.java jdbc/org/postgresql/jdbc2/Jdbc2ResultSetMetaData.java jdbc/org/postgresql/jdbc2/Jdbc2Statement.java jdbc/org/postgresql/jdbc3/AbstractJdbc3ResultSet.java jdbc/org/postgresql/jdbc3/Jdbc3CallableStatement.java jdbc/org/postgresql/jdbc3/Jdbc3Connection.java jdbc/org/postgresql/jdbc3/Jdbc3PreparedStatement.java jdbc/org/postgresql/jdbc3/Jdbc3ResultSet.java jdbc/org/postgresql/jdbc3/Jdbc3ResultSetMetaData.java jdbc/org/postgresql/jdbc3/Jdbc3Statement.java jdbc/org/postgresql/largeobject/BlobInputStream.java jdbc/org/postgresql/largeobject/BlobOutputStream.java jdbc/org/postgresql/largeobject/LargeObject.java jdbc/org/postgresql/largeobject/LargeObjectManager.java jdbc/org/postgresql/test/jdbc2/Jdbc2TestSuite.java jdbc/org/postgresql/test/jdbc2/optional/BaseDataSourceTest.java jdbc/org/postgresql/util/MD5Digest.java jdbc/org/postgresql/util/MessageTranslator.java jdbc/org/postgresql/util/PGbytea.java jdbc/org/postgresql/util/PGmoney.java jdbc/org/postgresql/util/PGobject.java jdbc/org/postgresql/util/PGtokenizer.java jdbc/org/postgresql/util/PSQLException.java jdbc/org/postgresql/util/UnixCrypt.java Added Files: jdbc/org/postgresql/core/BaseConnection.java jdbc/org/postgresql/core/BaseResultSet.java jdbc/org/postgresql/core/BaseStatement.java jdbc/org/postgresql/core/Field.java jdbc/org/postgresql/core/PGStream.java Removed Files: jdbc/org/postgresql/Field.java jdbc/org/postgresql/PG_Stream.java jdbc/org/postgresql/test/jdbc2/SerializeObject.java jdbc/org/postgresql/test/jdbc2/SerializeTest.java jdbc/org/postgresql/util/Serialize.java
* Add to mmap emails.Bruce Momjian2003-03-071-0/+251
|
* Update FAQ.Bruce Momjian2003-03-072-2/+2
|
* Update Russian FAQ, from Viktor Vislobokov.Bruce Momjian2003-03-072-29/+28
|
* Tweak dependency code to suppress NOTICEs generated by new method forTom Lane2003-03-063-24/+32
| | | | | | cleaning out temp namespaces. We don't really want the server log to be cluttered with 'Drop cascades to table foo' every time someone uses a temp table...
* Add missing --globals-only (long form of -g).Tom Lane2003-03-061-1/+2
|
* Add:Bruce Momjian2003-03-061-2/+2
| | | | > o Report server version number, database encoding, client encoding
* Add for protocol changes:Bruce Momjian2003-03-061-1/+2
| | | | > o Report server version number
* Remove:Bruce Momjian2003-03-061-2/+1
| | | | < * Require DROP COLUMN CASCADE for a column that is part of a multi-column index
* Done:Bruce Momjian2003-03-061-2/+2
| | | | > * -Modify regression tests to prevent failures do to minor numeric rounding
* Use poll(2) in preference to select(2), if available. This solvesTom Lane2003-03-064-125/+167
| | | | | | problems in applications that may have a large number of files open, such that libpq's socket number exceeds the range supported by fd_set. From Chris Brown.
* Add:Bruce Momjian2003-03-061-11/+12
| | | | > o Have ALTER TABLE rename SERIAL sequences
* Add code to dump contents of free space map into $PGDATA/global/pg_fsm.cacheTom Lane2003-03-064-83/+376
| | | | | | at database shutdown, and then load it again at database startup. This preserves our hard-won knowledge of free space across restarts (given an orderly shutdown, that is).
* Turns out new IN implementation has got some problems in an UPDATE orTom Lane2003-03-058-20/+80
| | | | | DELETE with inherited target table. Fix it; add a regression test. Also, correct ancient misspelling of 'inherited'.
* Repair bug reported by Laurent Perez: bad plan generated when UPDATE orTom Lane2003-03-051-1/+21
| | | | | | DELETE of an inheritance tree references another inherited relation. This bug has been latent since 7.1; I'm still not quite sure why 7.1 and 7.2 don't manifest it (at least, they don't crash on a simple test case).
* Reimplement free-space-map management as per recent discussions.Tom Lane2003-03-0410-678/+1102
| | | | | | | | | | | | Adjustable threshold is gone in favor of keeping track of total requested page storage and doling out proportional fractions to each relation (with a minimum amount per relation, and some quantization of the results to avoid thrashing with small changes in page counts). Provide special- case code for indexes so as not to waste space storing useless page free space counts. Restructure internal data storage to be a flat array instead of list-of-chunks; this may cost a little more work in data copying when reorganizing, but allows binary search to be used during lookup_fsm_page_entry().
* Prevent clustering on incomplete indexes: partial indexes are verboten,Tom Lane2003-03-031-1/+30
| | | | as are non-amindexnulls AMs unless first column is attnotnull.
* Improve description of geometric operators.Tom Lane2003-03-031-33/+48
|
* Correct/edit comments for geometric operators. No change except toTom Lane2003-03-031-46/+46
| | | | pg_description entries, so I did not force initdb.
* Be smart about outer-join qualifications that mention only one side ofTom Lane2003-03-021-62/+89
| | | | | | the join, per recent discussion on pgsql-sql. Not clear that this will come up often in real queries, but it's not any more expensive to do it right, so we may as well do it right.
* Repair memory leak introduced by recent change to make SPI return aTom Lane2003-03-021-31/+31
| | | | | tupdesc even with zero tuples returned: some plpgsql routines assumed they didn't need to do SPI_freetuptable() after retrieving no tuples.
* Change EXTRACT(EPOCH FROM timestamp) so that a timestamp without time zoneTom Lane2003-02-271-4/+17
| | | | | | is assumed to be in local time, not GMT. This improves consistency with other operations, which all assume local timezone when it matters. Per bug #897.
* up build number to 202 for a new development buildBarry Lind2003-02-271-1/+1
| | | | | Modified Files: jdbc/org/postgresql/Driver.java.in
* A little cleanup. Removing an unnecessary method.Barry Lind2003-02-271-20/+9
| | | | | Modified Files: jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java
* Added support for SSL in the jdbc driverBarry Lind2003-02-276-40/+159
| | | | | | | | | Modified Files: jdbc/build.xml jdbc/org/postgresql/Driver.java.in jdbc/org/postgresql/PG_Stream.java jdbc/org/postgresql/errors.properties jdbc/org/postgresql/jdbc1/AbstractJdbc1Connection.java jdbc/org/postgresql/util/PSQLException.java
* The quote function should return a string suitable for dropping into aD'Arcy J.M. Cain2003-02-261-1/+1
| | | | | query string. This fixes a bug where bool types sometimes returned with a string that could not be dropped into a query.
* Remove REWRITE_INVOKE_MAX in favor of making an accurate check forTom Lane2003-02-251-140/+128
| | | | | | recursion in RewriteQuery(); also, detect recursion in fireRIRrules(), so as to catch self-referential views per example from Ryan VanderBijl. Minor code restructuring to make it easier to catch recursive case.
* Allow SET CONNECTION to be followed by connection object without leading ↵Michael Meskes2003-02-252-1/+17
| | | | | | "TO" or "=". Allow whenever statement to list function without parameters.
* Avoid using a separate query to fetch the default expressions forTom Lane2003-02-241-19/+9
| | | | columns. Improved version of patch by mallah@trade-india.com.
* During VACUUM FULL, truncate off any deletable pages that are at theTom Lane2003-02-247-30/+79
| | | | | | end of a btree index. This isn't super-effective, since we won't move nondeletable pages, but it's better than nothing. Also, improve stats displayed during VACUUM VERBOSE.
* Remove no-longer-used FixBTree GUC variable.Tom Lane2003-02-233-14/+3
|
* btree page recycling can be done as soon as page's next-xact label isTom Lane2003-02-234-8/+13
| | | | | older than current Xmin; we don't have to wait till it's older than GlobalXmin.
* Adjust btbulkdelete logic so that only one WAL record is issued whileTom Lane2003-02-234-107/+135
| | | | | | deleting multiple index entries on a single index page. This makes for a very substantial reduction in the amount of WAL traffic during a large delete operation.
* Improve coding of log_heap_clean() and heap_xlog_clean().Tom Lane2003-02-234-40/+33
|
* First cut at recycling space in btree indexes. Still some rough edgesTom Lane2003-02-238-32/+745
| | | | to fix, but it seems to basically work...
* If a shutdown request comes in while we're still starting up, don'tTom Lane2003-02-231-12/+20
| | | | | | | service it until after we execute SetThisStartUpID(). Else shutdown process will write the wrong SUI into the shutdown checkpoint, which seems likely to be trouble --- although I've not quite figured out how significant it really is.
* Simplify timezone-handling code per proposal to pghackers: get rid ofTom Lane2003-02-225-179/+43
| | | | | | | | setting timezone-related variables during transaction start. They were not used anyway in platforms that HAVE_TM_ZONE or HAVE_INT_TIMEZONE, which it appears is *all* the platforms we are currently supporting. For platforms that have neither, we now only support UTC or numeric- offset-from-UTC timezones.
* More infrastructure for btree compaction project. Tree-traversal codeTom Lane2003-02-2218-341/+705
| | | | | | | | now knows what to do upon hitting a dead page (in theory anyway, it's untested...). Add a post-VACUUM-cleanup entry point for index AMs, to provide a place for dead-page scavenging to happen. Also, fix oversight that broke btpo_prev links in temporary indexes. initdb forced due to additions in pg_am.
* Revert patch that broke \d commands, until it can be fixed.Tom Lane2003-02-211-229/+181
|
View Lorry Controller Status