summaryrefslogtreecommitdiff
AgeCommit message (Collapse)Author
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-21Need sys/param.h for endianness macros.Peter Eisentraut
2002-10-21Might need to link with -lcrypt.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-21Improve ECPG documentation.Peter Eisentraut
2002-10-21Merged ecpg_big_bison back into HEADMichael Meskes
2002-10-21Update multibyte Japanese documentTatsuo Ishii
2002-10-21Since ANY is a reserved word, better suggest that ANY be quoted whenTom Lane
used for the input type of an aggregate.
2002-10-21Fix documented sizes of geometric types.Tom Lane
2002-10-21Fix example of doing a restore.Tom Lane
2002-10-21SET autocommit no longer needed in /contrib because pg_regress.sh doesBruce Momjian
it automatically now on regression session startup.
2002-10-21Updates from Ian Barwick.Bruce Momjian
2002-10-21Done:Bruce Momjian
> * -Move /contrib/retep to gborg.postgresql.org
2002-10-21Completely remove /contrib/retep, with Peter's approval; now on SourceBruce Momjian
Forge.
2002-10-21First step to removing /contrib/retep, with Peter Mount's approval.Bruce Momjian
2002-10-20Remove trailing blanks in cvs.sgml.Bruce Momjian
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
generated by cgit v1.2.3 (git 2.46.0) at 2025-10-17 04:05:15 +0000