summaryrefslogtreecommitdiff
AgeCommit message (Collapse)Author
2002-10-20Fix potential problem with btbulkdelete deleting an indexscan's currentTom Lane
item, if the page containing the current item is split while the indexscan is stopped and holds no read-lock on the page. The current item might move right onto a page that the indexscan holds no pin on. In the prior code this would allow btbulkdelete to reach and possibly delete the item, causing 'my bits moved right off the end of the world!' when the indexscan finally resumes. Fix by chaining read-locks to the right during _bt_restscan and requiring btbulkdelete to LockBufferForCleanup on every page it scans, not only those with deletable items. Per my pghackers message of 25-May-02. (Too bad no one could think of a better way.)
2002-10-20Fix core dump recently introduced into pgbench.Tom Lane
2002-10-20Returns exit status 1 if invalid encoding name orTatsuo Ishii
encoding number is given.
2002-10-20Update description of numeric constants to match 7.3 reality.Tom Lane
Miscellaneous other copy-editing.
2002-10-20Update char/varchar()/text/bytea to mention they have similar performanceBruce Momjian
characteristics.
2002-10-20Applied patch from Teofilis Martisius to improve performance.Barry Lind
Also removed some unused files and fixed the which needed a small change after the previous patch to build.xml. Modified Files: jdbc/Makefile jdbc/org/postgresql/core/Encoding.java jdbc/org/postgresql/jdbc1/AbstractJdbc1Connection.java Removed Files: jdbc/utils/CheckVersion.java jdbc/utils/buildDriver jdbc/utils/changelog.pl
2002-10-20Add:Bruce Momjian
> * Make a transaction-safe TRUNCATE
2002-10-20Update Japanese FAQ, from Jun Kuwamura.Bruce Momjian
2002-10-20Add:Bruce Momjian
> o Add GUC parameter to control the maximum number of rewrite cycles
2002-10-20Add warning that autocommit=off is not well-supported yet.Tom Lane
2002-10-20Move BeOS and QNX4 to unsupported-platform list, until someone caresTom Lane
to expend the effort to update them for new semaphore code.
2002-10-20Rule rewriter was doing the wrong thing with conditional INSTEAD rulesTom Lane
whose conditions might yield NULL. The negated qual to attach to the original query is properly 'x IS NOT TRUE', not 'NOT x'. This fix produces correct behavior, but we may be taking a performance hit because the planner is much stupider about IS NOT TRUE than it is about NOT clauses. Future TODO: teach prepqual, other parts of planner how to cope with BooleanTest clauses more effectively.
2002-10-20Disallow aggregate functions in rule WHERE clauses. Per gripe fromTom Lane
Fritz Lehmann-Grube back in January.
2002-10-20Applied patch submitted by Mike Beachy to give a better error message ifBarry Lind
configure hasn't been run before trying to build. Also cleaned up the README file and removed some obsolete files. Modified Files: jdbc/README jdbc/build.xml Removed Files: jdbc/CHANGELOG jdbc/Implementation jdbc/jdbc.jpx
2002-10-19Fix inconsistent formatting.Tom Lane
2002-10-19Fix incomplete definition of ALTER TABLE ADD/DROP CONSTRAINT syntax.Tom Lane
Add some verbiage about recent tweaks to behavior of ADD and DROP COLUMN when there are descendant tables.
2002-10-19Fix within-function memory leaks in the various PLs' interfaces toTom Lane
SPI_prepare: they all save the prepared plan into topCxt, and so the procCxt copy that's actually returned by SPI_prepare ought to be freed. Diagnosis and plpython fix by Nigel Andrews, followup for other PLs by Tom Lane.
2002-10-19Applied patch submitted by Kris Jurka to result in a better error messageBarry Lind
under some circumstances and handle negative money values better. Modified Files: jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSet.java
2002-10-19Fix pltcl self-test for recent changes to elog.Tom Lane
2002-10-19Backed out part of the change from 1.6. The attempt to support int8 bindsBarry Lind
in such a way that indexes on int8 columns would be used (by quoting the value) caused other problems. Will need to wait for the backend to properly fix the root problem. Modified Files: jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java
2002-10-19Fix case where a function in FROM returns a scalar type, but isTom Lane
referred to with whole-tuple syntax.
2002-10-19Make psql's \df display functions that return sets as having return typeTom Lane
'setof something'; formerly you could not tell at all that the function returns set.
2002-10-19Invert logic in pg_exec_query_string() so that we set a snapshot forTom Lane
all utility statement types *except* a short list, per discussion a few days ago. Add missing SetQuerySnapshot calls in VACUUM and REINDEX, and guard against calling REINDEX DATABASE from a function (has same problem as VACUUM).
2002-10-19Fix rewrite code so that rules are in fact executed in order by name,Tom Lane
rather than being reordered according to INSTEAD attribute for implementation convenience. Also, increase compiled-in recursion depth limit from 10 to 100 rewrite cycles. 10 seems pretty marginal for situations where multiple rules exist for the same query. There was a complaint about this recently, so I'm going to bump it up. (Perhaps we should make the limit a GUC parameter, but that's too close to being a new feature to do in beta.)
2002-10-19Back out Alvaro's patch until regression tests pass.Bruce Momjian
2002-10-19Fix range-query estimation to not double-exclude NULLs, per gripe fromTom Lane
Ray Ontko 28-June-02. Also, fix prefix_selectivity for NAME lefthand variables (it was bogusly assuming binary compatibility), and adjust make_greater_string() to not call pg_mbcliplen() with invalid multibyte data (this last per bug report that I can't find at the moment, but it was in July '02).
2002-10-19Add:Bruce Momjian
> * Move /contrib/retep to gborg.postgresql.org
2002-10-19Fix compile failure caused by new patch.Bruce Momjian
2002-10-19Remove mention of utils/getopt.c. Not used anymore.Bruce Momjian
2002-10-19It includesBruce Momjian
-Support for mirroring tables in different Schema's -Improved documentation for compiling with 7.1.x and 7.2.x -Fixes a buffer overrun bug. Steven Singer
2002-10-19> Huh, I don't know where I got the idea you were (or someone else was?)Bruce Momjian
> in the position that attislocal should be reset. I'll clean everything > up and submit the patch I had originally made. All right, this is it. This patch merely checks if child tables have the column. If atttypid and atttypmod are the same, the attributes' attinhcount is incremented; else the operation is aborted. If child tables don't have the column, recursively add it. attislocal is not touched in any case. Alvaro Herrera
2002-10-19This patch adds some missing functions for float8 math operations,Bruce Momjian
specifically ceil(), floor(), and sign(). There may be other functions that need to be added, but this is a start. I've included some simple regression tests. Neil Conway
2002-10-19Make regression tests safe for autocommit = 'off'.Bruce Momjian
2002-10-19Add missing #include <errno.h>.Tom Lane
2002-10-19Fix psql's \copy to accept table names containing schemas, as well asTom Lane
a column list. Bring its parsing of quoted names and quoted strings somewhat up to speed --- I believe it now handles all non-error cases the same way the backend would, but weird boundary conditions are not necessarily done the same way.
2002-10-18Improve formatting of --help output.Peter Eisentraut
2002-10-18Fix breakage that had crept into setlocale() usage: once again we'veTom Lane
been bit by the fact that the locale functions return pointers to modifiable variables. I added some comments that might help us avoid the mistake in future.
2002-10-18Make 'dummy' declarations in header files be 'extern int no_such_variable'Tom Lane
instead of 'extern int errno'; the latter is unsafe according to the ANSI C standard, as well as in practice on some platforms.
2002-10-18Un-break createlang build.Tom Lane
2002-10-18Clean up for dblink autocommit OFF handling.Bruce Momjian
2002-10-18Update /contrib for "autocommit TO 'on'".Bruce Momjian
Create objects in public schema. Make spacing/capitalization consistent. Remove transaction block use for object creation. Remove unneeded function GRANTs.
2002-10-18Improve discussion of FOR UPDATE.Tom Lane
2002-10-17Update for tables returning function, item 5.3, from Joe Conway.Bruce Momjian
2002-10-17Fix in updateable result sets to handle binding null values correctlyBarry Lind
Patch submitted by Kris Jurka (applied with some modifications) Modified Files: jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java
2002-10-17Fix free-slot search in PgSetResultId so it actually works.Tom Lane
2002-10-17Improve formatting of error message.Tom Lane
2002-10-17Fixed support in jdbc for 7.3 server autocommit. With these changes theBarry Lind
jdbc regression tests pass for both autocommit on and autocommit off Modified Files: jdbc/org/postgresql/jdbc1/AbstractJdbc1Connection.java jdbc/org/postgresql/test/jdbc2/ConnectionTest.java
2002-10-17Add:Bruce Momjian
> o Allow copy to understand \x as hex
2002-10-16Put the disk information all in one chapter.Peter Eisentraut
2002-10-16Make pg_dump save for autocommit = off.Bruce Momjian