summaryrefslogtreecommitdiff
path: root/src
AgeCommit message (Collapse)Author
2002-10-23Page \h output and centralize psql paging code in PageOutput().Bruce Momjian
2002-10-22Perform transaction cleanup operations in a less ad-hoc, moreTom Lane
principled order; in particular ensure that all shared resources are released before we release transaction locks. The code used to release locks before buffer pins, which might explain an ancient note I have about a bufmgr assertion failure I'd seen once several years ago, and been unable to reproduce since. (Theory: someone trying to drop a relation might be able to reach FlushRelationBuffers before the last user of the relation had gotten around to dropping his buffer pins.)
2002-10-22create_index test must run after create_misc test.Tom Lane
2002-10-22Update for test changes.Peter Eisentraut
2002-10-22Add DLLIMPORT declarations required by contrib with asserts enabled.Peter Eisentraut
2002-10-22Allow 8-byte off_t to properly pg_dump, from Philip Warner with mods by Bruce.Bruce Momjian
2002-10-21Fix places that were using IsTransactionBlock() as an (inadequate) checkTom Lane
that they'd get to commit immediately on finishing. There's now a centralized routine PreventTransactionChain() that implements the necessary tests.
2002-10-21Cleanup for CLUSTERDB failure:Bruce Momjian
On Sat, Oct 19, 2002 at 12:11:32AM +0200, Peter Eisentraut wrote: > $ ./clusterdb > psql: could not connect to server: No such file or directory > Is the server running locally and accepting > connections on Unix domain socket "/tmp/.s.PGSQL.5432"? > psql: could not connect to server: No such file or directory > Is the server running locally and accepting > connections on Unix domain socket "/tmp/.s.PGSQL.5432"? > clusterdb: While clustering peter, the following failed: > $ > > This could probably handled a little more gracefully. Yes, sorry. A patch for this is attached. Please apply. Alvaro Herrera
2002-10-21Fix ALTER TABLE ... ADD COLUMN for inheritance cases.Bruce Momjian
Alvaro Herrera
2002-10-21Remove unnecessary (and inadequate) check of IsTransactionBlock() inTom Lane
pgstat_vacuum_tabstat(). Assume that caller (namely, VACUUM) has done the appropriate state checking beforehand.
2002-10-21Avoid using IsTransactionBlock() in DeferredTriggerSetState(); no realTom Lane
need for this optimization, and it's too easily fooled anyway.
2002-10-21Make CREATE/ALTER/DROP USER/GROUP transaction-safe, or at least prettyTom Lane
nearly so, by postponing write of flat password file until transaction commit.
2002-10-21Add DLLIMPORT declarations needed by contrib modules.Peter Eisentraut
2002-10-21Add guards against double inclusion.Peter Eisentraut
2002-10-21Translation updatesPeter Eisentraut
2002-10-21Remove obsoleted stuff merged in from branch.Peter Eisentraut
2002-10-21Merged ecpg_big_bison back into HEADMichael Meskes
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-20Returns exit status 1 if invalid encoding name orTatsuo Ishii
encoding number is given.
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-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 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-19Fix compile failure caused by new patch.Bruce Momjian
2002-10-19Remove mention of utils/getopt.c. Not used anymore.Bruce Momjian
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-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-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-16Make pg_dump save for autocommit = off.Bruce Momjian
generated by cgit v1.2.3 (git 2.46.0) at 2025-08-21 09:13:50 +0000