aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Add Bear's SSL comments.Bruce Momjian2002-09-29
|
* Make the world at least somewhat safe for zero-column tables, andTom Lane2002-09-28
| | | | | remove the special case in ALTER DROP COLUMN to prohibit dropping a table's last column.
* ARGH!Tom Lane2002-09-27
| | | | | | | | Vacuum must not advance pg_database.datvacuumxid nor truncate CLOG unless it's processed *all* tables in the database. Vacuums run by unprivileged users don't count. (Beats head against nearest convenient wall...)
* > Fix clusterdb to be schema-awareBruce Momjian2002-09-27
| | | | | | Please apply the patch attached and this should be solved. Alvaro Herrera
* Use heap_formtuple not heap_addheader to construct pg_index tuples.Tom Lane2002-09-27
| | | | | heap_addheader is wrong because it doesn't cope with varlena fields, notably indpred.
* Don't mess with HEAP_XMAX_INVALID in heaptuple.c routines; there isTom Lane2002-09-27
| | | | | | no reason to worry about the tuple commit status bits until the tuple is inserted in a relation by heapam.c. Also, improve comments for heap_addheader().
* Have -d5 -d0 not affect the extra variables set with -d5.Bruce Momjian2002-09-27
|
* Make postgres -d0 set server_min_messages to notice. Reset doesn't workBruce Momjian2002-09-27
| | | | at this area in the code.
* Simplify SSL certificate instructions.Bruce Momjian2002-09-27
|
* Ensure that before truncating CLOG, we force a checkpoint even if noTom Lane2002-09-26
| | | | | | recent WAL activity has occurred. Without this, it's possible that a later crash might leave tuples on disk with un-updated commit status bits.
* Fix problems with loss of tuple commit status bits during WAL redo ofTom Lane2002-09-26
| | | | | | | | | VACUUM FULL tuple moves. Store full-width t_infomask in WAL, rather than storing low 8 bits and expecting to be able to reconstruct upper bits. While at it, remove redundant t_oid field from WAL headers (the OID, if present, is now recorded in the data portion of the tuple). WAL version number bumped --- this does not force an initdb, you can instead run pg_resetxlog after a clean shutdown of the old postmaster.
* Back out /pl memory leak patch. Wait for new version.Bruce Momjian2002-09-26
|
* Clean up SSL compiler warnings.Bruce Momjian2002-09-26
|
* Attached is a patch to contrib/dbmirror that fixes a bug that wasBruce Momjian2002-09-26
| | | | | | | | | | causing the postmaster to crash when the trigger was running on a table without a primary key. I've also updated the docs to explicitly say that tables need primary keys. Steven Singer
* I have attached the pltcl patch again, just in case. For the sake of clarityBruce Momjian2002-09-26
| | | | | | | | | | | | | | let's say this patch superscedes the previous one. I have also attached a patch addressing the similar memory leak problem in plpython. This includes a slight adjustment of the tests in the source directory. The patch also includes a cosmetic change to remove a compiler warning although I think the change makes the code look worse though. BTW, by my reckoning the memory leak would occur with prepared plans and without. If that is not the case then I've been barking up the wrong tree. Nigel J. Andrews
* This patch removes a use of uninitialized memory in lmgr/lock.c, byBruce Momjian2002-09-26
| | | | | | adding a missing sprintf(). Neil Conway
* Pass postmaster -d down to the postgres backend to trigger special -dBruce Momjian2002-09-26
| | | | handling in the backend.
* Allow SSL to work withouth client-side certificate infrastructure.Bruce Momjian2002-09-26
|
* Enhance the description of user and database management. Reduce thePeter Eisentraut2002-09-25
| | | | number of forward references in the admin guide.
* Remove ShutdownBufferPoolAccess exit callback, and do the work inTom Lane2002-09-25
| | | | | | | | | ProcKill instead, where we still have a PGPROC with which to wait on LWLocks. This fixes 'can't wait without a PROC structure' failures occasionally seen during backend shutdown (I'm surprised they weren't more frequent, actually). Add an Assert() to LWLockAcquire to help catch any similar mistakes in future. Fix failure to update MyProcPid for standalone backends and pgstat processes.
* Shouldn't be here ...Tom Lane2002-09-25
|
* Stamp configure for beta2.Bruce Momjian2002-09-25
|
* Install proper earthdistance file, regression passes.Bruce Momjian2002-09-25
|
* Applied patch from Aaron Mulder (ammulder@alumni.princeton.edu) that fixesBarry Lind2002-09-25
| | | | | | | | | | | | | | | | | | | | | | | | | | jdbc datasource support for jdk1.4/jdbc3 Modified Files: jdbc/build.xml jdbc/org/postgresql/Driver.java.in jdbc/org/postgresql/jdbc2/optional/BaseDataSource.java jdbc/org/postgresql/jdbc2/optional/PGObjectFactory.java jdbc/org/postgresql/jdbc2/optional/PooledConnectionImpl.java jdbc/org/postgresql/jdbc2/optional/PoolingDataSource.java jdbc/org/postgresql/test/jdbc2/optional/BaseDataSourceTest.java jdbc/org/postgresql/test/jdbc2/optional/OptionalTestSuite.java jdbc/org/postgresql/test/jdbc3/Jdbc3TestSuite.java Added Files: jdbc/org/postgresql/jdbc3/Jdbc3ConnectionPool.java jdbc/org/postgresql/jdbc3/Jdbc3ObjectFactory.java jdbc/org/postgresql/jdbc3/Jdbc3PooledConnection.java jdbc/org/postgresql/jdbc3/Jdbc3PoolingDataSource.java jdbc/org/postgresql/jdbc3/Jdbc3SimpleDataSource.java jdbc/org/postgresql/test/jdbc2/optional/PoolingDataSourceTest.java jdbc/org/postgresql/test/jdbc3/Jdbc3ConnectionPoolTest.java jdbc/org/postgresql/test/jdbc3/Jdbc3PoolingDataSourceTest.java jdbc/org/postgresql/test/jdbc3/Jdbc3SimpleDataSourceTest.java jdbc/org/postgresql/test/util/MiniJndiContext.java jdbc/org/postgresql/test/util/MiniJndiContextFactory.java
* Add missing earthdistance regression test files.Bruce Momjian2002-09-25
|
* Make PL/pgSQL capitalization consistent.Bruce Momjian2002-09-24
|
* Change default privileges for languages and functions to be PUBLIC USAGETom Lane2002-09-24
| | | | | and PUBLIC EXECUTE, respectively. Per discussion about easing updates from prior versions.
* Update some obsolete comments and column descriptions.Tom Lane2002-09-24
|
* Remove useless O_DIROPEN stuff.Peter Eisentraut2002-09-24
|
* Tweak conversion names to follow the established naming scheme, andPeter Eisentraut2002-09-24
| | | | document that scheme.
* Add earthdistance regression file.Bruce Momjian2002-09-24
|
* Add missing correction of sublevelsup when pulling up a subquery.Tom Lane2002-09-24
| | | | | | Fixes problem with cases like SELECT * FROM foo t WHERE NOT EXISTS (SELECT remoteid FROM (SELECT f1 as remoteid FROM foo WHERE f1 = t.f1) AS t1)
* Fix broken markup.Tom Lane2002-09-23
|
* Further thinking about heap_mark4update: in HeapTupleSelfUpdated case,Tom Lane2002-09-23
| | | | | | | | | executor should not return the tuple as successfully marked, because in fact it's been deleted. Not clear that this case has ever been seen in practice (I think you'd have to write a SELECT FOR UPDATE that calls a function that deletes some row the SELECT will visit later...) but we should be consistent. Also add comments to several other places that got it right but didn't explain what they were doing.
* Move PyGreSQL usage documentation from README into DocBook. Some otherPeter Eisentraut2002-09-23
| | | | editing.
* Disallow VACUUM, ANALYZE, TRUNCATE on temp tables belonging to otherTom Lane2002-09-23
| | | | | backends. Given that temp tables now store data locally in the local buffer manager, these things are not going to work safely.
* Tweak dblink functions to use int4 arguments instead of int2,Tom Lane2002-09-23
| | | | to avoid having to write explicit casts. From Joe Conway.
* Add:Bruce Momjian2002-09-23
| | | | > * Add start time to pg_stat_activity
* Update HISTORY for 7.3beta2.Bruce Momjian2002-09-23
|
* Add win32 rename discussion to archives.Bruce Momjian2002-09-23
|
* The valid return value should be MODIFY instead of MODIFIED.Bruce Momjian2002-09-23
| | | | | | | | | | | | | | | | | The error message said so :-) In 25.3. Using PL/Python If the trigger "when" is BEFORE, you may return None or "OK" from the Python function to indicate the tuple is unmodified, "SKIP" to abort the event, or "MODIFIED" to indicate you've modified the tuple. should read If the trigger "when" is BEFORE, you may return None or "OK" from the Python function to indicate the tuple is unmodified, "SKIP" to abort the event, or "MODIFY" to indicate you've modified the tuple. elein
* Obviously noone has ever tested the doubling of availiable result idsBruce Momjian2002-09-23
| | | | | | | | | | | | | | | | | | | up to reaching the hard limit. After opening 16(=current REST_START value) results via pg_exec, the next pg_exec tries to find an empty slot forever :-( . In PgSetResultId file pgtclId.c in the for loop there has to be done a break, if res_max ist reached. The piece of code should look like if (resid == connid->res_max) { resid = 0; break; /* the break as to be added */ } now everything works (double available results after reaching RES_START up to reaching RES_HARD_MAX) Gerhard Hintermayer
* Nothing.Bruce Momjian2002-09-23
|
* Get rid of bogus use of heap_mark4update in reindex operations (cf.Tom Lane2002-09-23
| | | | | recent bug report). Fix processing of nailed-in-cache indexes; it appears that REINDEX DATABASE has been broken for months :-(.
* In UpdateStats(), don't bother to update the pg_class row if it alreadyTom Lane2002-09-22
| | | | | | | | contains the correct statistics. This is a partial solution for the problem of allowing concurrent CREATE INDEX commands: unless they commit at nearly the same instant, the second one will see the first one's pg_class updates as committed, and won't try to update again, thus avoiding the 'tuple concurrently updated' failure.
* Remove commas for compatibility with newer releases of bison.Tom Lane2002-09-22
|
* Remove commas for compatibility with newer bisons.Tom Lane2002-09-22
|
* Remove extraneous | ... while bison 1.28 doesn't object, newer versionsTom Lane2002-09-22
| | | | do.
* Remove commas from %type and %token lists, for compatibility with newerTom Lane2002-09-22
| | | | versions of bison.
* Translation updates, some messages tweaked.Peter Eisentraut2002-09-22
|