aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
...
* > Alvaro Herrera <alvherre@atentus.com> writes:Bruce Momjian2002-10-09
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | > > I'm looking at pg_dump/common.c:flagInhAttrs() and suspect that it can > > be more or less rewritten completely, and probably should to get rigth > > all the cases mentioned in the past attisinherited discussion. Is this > > desirable for 7.3? It can probably be hacked around and the rewrite > > kept for 7.4, but I think it will be much simpler after the rewrite. > > If it's a bug then it's fair game to fix in 7.3. But keep in mind that > pg_dump has to behave at least somewhat sanely when called against older > servers ... will your rewrite behave reasonably if the server does not > offer attinhcount values? Nah. I don't think it's worth it: I had forgotten that older versions should be supported. I just left the code as is and added a version-specific test. This patch allows pg_dump to dump correctly local definition of columns. In particular, CREATE TABLE p1 (f1 int, f2 int); CREATE TABLE p2 (f1 int); CREATE TABLE c () INHERITS (p1, p2); ALTER TABLE ONLY p1 DROP COLUMN f1; CREATE TABLE p3 (f1 int); CREATE TABLE c2 (f1 int) INHERITS (p3); Will be dumped as CREATE TABLE p1 (f2 int); CREATE TABLE p2 (f1 int); CREATE TABLE c (f1 int) INHERITS (p1, p2); CREATE TABLE c2 (f1 int) INHERITS (p3); (Previous version will dump CREATE TABLE c () INHERITS (p1, p2) CREATE TABLE c2 () INHERITS (p3) ) Alvaro Herrera
* Have SET not start transaction when autocommit off, with doc updates.Bruce Momjian2002-10-09
|
* Again improve MemSet comments.Bruce Momjian2002-10-08
|
* Update MemSet comments.Bruce Momjian2002-10-08
|
* Move responsibility for setting QuerySnapshot for utility statementsTom Lane2002-10-08
| | | | | | into postgres.c; make sure it happens for all cases that seem to need it. Perhaps it would be better to explicitly exclude just a few utility statement types from setting a snapshot?
* fixed missing apostropheDave Cramer2002-10-08
|
* Change order of operations during XLogFlush so that we try to includeTom Lane2002-10-07
| | | | | | | in our write/flush operation any WAL entries that got queued while we were waiting to get the WALWriteLock. This improves throughput when transactions are small enough that several can be committed per WAL write (ie, per disk revolution).
* Clarify comment.Bruce Momjian2002-10-06
|
* Restrict CREATE OPERATOR CLASS to superusers, per discussion some weeksTom Lane2002-10-04
| | | | ago.
* Require superuser privilege to create a binary-compatible cast, perTom Lane2002-10-04
| | | | | | discussion some weeks ago. Also, add a check that two types to be binary-equivalenced match as to typlen, typbyval, and typalign; if they don't then it's surely a mistake to equivalence them.
* Fix a couple of grammatical errors in error messages.Tom Lane2002-10-04
|
* Tweak a few of the most heavily used function call points to zero outTom Lane2002-10-04
| | | | | | | | | | just the significant fields of FunctionCallInfoData, rather than MemSet'ing the whole struct to zero. Unused positions in the arg[] array will thereby contain garbage rather than zeroes. This buys back some of the performance hit from increasing FUNC_MAX_ARGS. Also tweak tuplesort.c code for more speed by marking some routines 'inline'. All together these changes speed up simple sorts, like count(distinct int4column), by about 25% on a P4 running RH Linux 7.2.
* Hack to make it possible to load CREATE CONSTRAINT TRIGGER commands thatTom Lane2002-10-03
| | | | | are missing the FROM clause (due to a long-ago pg_dump bug). Patch by Stephan Szabo, minor tweaking by Tom Lane.
* In a bootstrap process or standalone backend, set MaxBackends = 1Tom Lane2002-10-03
| | | | to avoid unnecessary consumption of semaphores.
* Avoid palloc(0) when MaxBackends = 1.Tom Lane2002-10-03
|
* Restore NOTICEs that were mistakenly removed from triggers regressionTom Lane2002-10-03
| | | | | test expected output. Tweak contrib/spi Makefile so that refint.so is by default built with appropriate NOTICE support for regression testing.
* Add SSL documentation info to README.SSLBruce Momjian2002-10-03
|
* The attached patch fixes a number of issues related to compiling theBruce Momjian2002-10-03
| | | | | | | | | | | | | | | | | | client utilities (libpq.dll and psql.exe) for win32 (missing defines, adjustments to includes, pedantic casting, non-existent functions) per: http://developer.postgresql.org/docs/postgres/install-win32.html. It compiles cleanly under Windows 2000 using Visual Studio .net. Also compiles clean and passes all regression tests (regular and contrib) under Linux. In addition to a review by the usual suspects, it would be very desirable for someone well versed in the peculiarities of win32 to take a look. Joe Conway
* This patch removes two unused global variables from globals.cBruce Momjian2002-10-03
| | | | Neil Conway
* Re-enable pg_resetxlog to accept -l values in hexadecimal (it used toTom Lane2002-10-02
| | | | | | be able to do that, but the ability seems to have got lost in the shuffle). Add a -o nextOID switch for completeness. Improve the documentation to explain how and why to use these switches.
* pg_resetxlog was missing support for the pg_control fields added in 7.3.Tom Lane2002-10-02
|
* Alter scale selection for NUMERIC division and transcendental functionsTom Lane2002-10-02
| | | | | | so that precision of result is always at least as good as you'd get from float8 arithmetic (ie, always at least 16 digits of accuracy). Per pg_hackers discussion a few days ago.
* Turn GUC log_min_error_statement off by default by setting it to PANIC.Bruce Momjian2002-10-02
|
* test files added by Kris JurkaDave Cramer2002-10-01
|
* Pass less-unsafe parameters to Darwin's NSLinkModule. While this change ↵Tom Lane2002-10-01
| | | | prevents a backend coredump when loading a broken shlib, it also seems to suppress the error messages that might help debug the problem :-(. Perhaps someone would like to supply a 'linkEdit' hook to get the best of both worlds. But in the meantime, backend crash trumps error reporting.
* Fixed test suite to call PoolingDataSourceTest which was missedBarry Lind2002-10-01
| | | | | Modified Files: OptionalTestSuite.java
* schema awareness patch provided by Kris JurkaDave Cramer2002-10-01
|
* 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.
* 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
|
* 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
|
* 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.
* 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
* 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 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)
generated by cgit v1.2.3 (git 2.25.1) at 2025-06-20 15:37:57 +0000