summaryrefslogtreecommitdiff
AgeCommit message (Collapse)Author
2003-03-18Some bugfixes for numerical library.Michael Meskes
2003-03-18Applied updated translation patchBarry Lind
Modified Files: errors_zh_TW.properties
2003-03-18Add to mmap discussion.Bruce Momjian
2003-03-18Add mention of ANALYZE after object restore.Bruce Momjian
2003-03-17Add mention of new sets returning functions capability.Bruce Momjian
2003-03-17Update links, from Ian BarwickBruce Momjian
2003-03-17Add:Bruce Momjian
> * Allow UPDATE tab SET ROW (col, ...) = (...) for updating multiple columns
2003-03-17Reorder crypt.h include for SunOS compile problem.Bruce Momjian
Fred Houweling
2003-03-17Increase max known database size.Bruce Momjian
2003-03-16Forgot some files...Michael Meskes
2003-03-16Started working on a seperate pgtypes library. First test work. PLEASE test ↵Michael Meskes
compilation on iother systems.
2003-03-15Arrange to print the relevant key values when reporting a foreign-keyTom Lane
violation. Also, factor out some duplicate code in the RI triggers. Patch by Dmitry Tkach, reviewed by Stephan Szabo and Tom Lane.
2003-03-15A typo in src/backend/libpq/hba.c breaks local ident authenticationBruce Momjian
in the SO_PEERCRED case. elif is misspelled as elsif for the test. A patch is attached. Bruno Wolff III
2003-03-14pg_dumpall failed on groups having no members. Per report fromTom Lane
Nick Eskelinen.
2003-03-14Remove unneeded dash blocks around function start comments.Bruce Momjian
2003-03-14Update name of GUC var:Bruce Momjian
< * Add GUC log_statement_duration to print statement and >= min duration > * Add GUC log_statement_and_duration to print statement and >= min duration
2003-03-14Add:Bruce Momjian
> * Add GUC log_statement_duration to print statement and >= min duration
2003-03-14Fixed parsing to handle \n for updateable result sets. Bug reported by Rich ↵Barry Lind
Cullingford. Modified Files: jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java
2003-03-14Repair incorrect prorettype entry for timestamptz_izone. Can't forceTom Lane
initdb in the 7.3 branch, but we can at least make it right for people who install 7.3.3 from scratch.
2003-03-14Improved error message and added some log messages in batch update functionalityBarry Lind
Modified Files: jdbc/org/postgresql/errors.properties jdbc/org/postgresql/jdbc2/AbstractJdbc2Statement.java jdbc/org/postgresql/util/PSQLException.java
2003-03-14Make eval_const_expressions simplify FieldSelect from a whole-row VarTom Lane
into an ordinary one-field Var. Per example from Chris Mungall.
2003-03-14Prevent infinite loop in ln_var() due to roundoff error.Tom Lane
Per report from Dave Marin.
2003-03-13GROUP BY got confused if there were multiple equal() GROUP BY items.Tom Lane
This bug has been latent since 7.0 or maybe even further back, but it was only exposed when parse_clause.c stopped suppressing duplicate items (see its rev 1.96 of 18-Aug-02).
2003-03-13Big editing for consistent content and presentation.Peter Eisentraut
2003-03-11Add explicit tests for division by zero to all user-accessible integerTom Lane
division and modulo functions, to avoid problems on OS X (which fails to trap 0 divide at all) and Windows (which traps it in some bizarre nonstandard fashion). Standardize on 'division by zero' as the one true spelling of this error message. Add regression tests as suggested by Neil Conway.
2003-03-11Implement SQL92-compatible FIRST, LAST, ABSOLUTE n, RELATIVE n optionsTom Lane
for FETCH and MOVE.
2003-03-10This patch fixes a bunch of spelling mistakes in comments throughout theTom Lane
PostgreSQL source code. Neil Conway
2003-03-10Update German FAQBruce Momjian
Ian Barwick
2003-03-10Cleanup up psql \connect and \pset pager setting display, DennisBruce Momjian
Bj?rklund.
2003-03-10Restructure parsetree representation of DECLARE CURSOR: now it's aTom Lane
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.
2003-03-09pg_restore failed to restore blobs if -X disable-triggers is specified.Tom Lane
2003-03-09tuplestore_donestoring() isn't needed anymore, but provide a no-opTom Lane
macro definition so as not to create compatibility problems.
2003-03-09Revise tuplestore and nodeMaterial so that we don't have to read theTom Lane
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.
2003-03-08Applied patch from Paul Sorenson to correctly handle schema names in ↵Barry Lind
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
2003-03-08Not done:Bruce Momjian
> * Precompile SQL functions to avoid overhead (Neil)
2003-03-08Reorder items and mark some as completed.Bruce Momjian
> * 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)
2003-03-07Cleanup and reorganization.Barry Lind
- 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
2003-03-07Add to mmap emails.Bruce Momjian
2003-03-07Update FAQ.Bruce Momjian
2003-03-07Update Russian FAQ, from Viktor Vislobokov.Bruce Momjian
2003-03-06Tweak dependency code to suppress NOTICEs generated by new method forTom Lane
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...
2003-03-06Add missing --globals-only (long form of -g).Tom Lane
2003-03-06Add:Bruce Momjian
> o Report server version number, database encoding, client encoding
2003-03-06Add for protocol changes:Bruce Momjian
> o Report server version number
2003-03-06Remove:Bruce Momjian
< * Require DROP COLUMN CASCADE for a column that is part of a multi-column index
2003-03-06Done:Bruce Momjian
> * -Modify regression tests to prevent failures do to minor numeric rounding
2003-03-06Use poll(2) in preference to select(2), if available. This solvesTom Lane
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.
2003-03-06Add:Bruce Momjian
> o Have ALTER TABLE rename SERIAL sequences
2003-03-06Add code to dump contents of free space map into $PGDATA/global/pg_fsm.cacheTom Lane
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).
2003-03-05Turns out new IN implementation has got some problems in an UPDATE orTom Lane
DELETE with inherited target table. Fix it; add a regression test. Also, correct ancient misspelling of 'inherited'.
generated by cgit v1.2.3 (git 2.46.0) at 2025-10-27 23:55:03 +0000