summaryrefslogtreecommitdiff
path: root/src
AgeCommit message (Collapse)Author
2002-01-11Fix pg_dump to read-lock all tables to be dumped as soon as it's readTom Lane
their names from pg_class. This considerably reduces the window wherein someone could DROP or ALTER a table that pg_dump is intending to dump. Not a perfect solution, but definitely an improvement. Per complaints from Marc Fournier; patch by Brent Verner with some kibitzing by Tom Lane.
2002-01-11Sync up.Bruce Momjian
2002-01-11VACUUM must make sure that a HEAP_MARKED_FOR_UPDATE tuple gets markedTom Lane
as either HEAP_XMAX_COMMITTED or HEAP_XMAX_INVALID once the updating transaction is gone. Otherwise some other transaction may come along and try to test the commit status of t_xmax later --- which could be after VACUUM has recycled the CLOG status for that xact. Bug introduced in post-beta4 bug fix.
2002-01-11Fix sequence creation to set the t_xmin of a sequence's tuple toTom Lane
FrozenTransactionId, not the XID of the creating transaction. Without this it's possible for a reference to a long-gone CLOG record to occur, per Christian Meunier's bug report of 10-Jan-02. Worse, the sequence tuple would become invisible to SELECTs after 2 billion transactions. Since the fix is applied during sequence creation it does not help existing databases, unless you drop and recreate every sequence. However, we intend to force initdb for 7.2RC1 anyway, to fix a pg_proc error, so I see no need to do more for this problem.
2002-01-11Added Christof's fixes.Michael Meskes
2002-01-11More testing, more cleanups.Bruce Momjian
2002-01-11pg_resetxlog specifies log location in hex; more pg_upgrade testingBruce Momjian
improvments.
2002-01-11More cleanups.Bruce Momjian
2002-01-11*** empty log message ***Hiroshi Inoue
2002-01-11More updates for int8 sequence restoration. Old dump file not requiredBruce Momjian
anymore.
2002-01-11Handle int4-int8 sequence migration without full data dump.Bruce Momjian
2002-01-11Add a directory to save the changes until 7.3-tree is branched.Hiroshi Inoue
2002-01-11More improvements using pg_resetxlog. still disabled.Bruce Momjian
2002-01-10Include sqlca.h automatically.Michael Meskes
2002-01-10More pg_upgrade improvements. Almost done, except for max transactionBruce Momjian
setting.
2002-01-10More improvements; still disabled. (Don't panic.)Bruce Momjian
2002-01-10The result of getopt() should be compared to -1, not EOF, perTom Lane
pgsql-hackers discussion of this date.
2002-01-09Update with new features. Still disabled.Bruce Momjian
2002-01-09Fix use of 'char' to hold result of getc, per bug report forwarded byTom Lane
Oliver Elphick. A few other minor cleanups while at it.
2002-01-09Fix portability problem (result of getopt is int, not char).Tom Lane
2002-01-09Remove clog copy.Bruce Momjian
2002-01-09Make improvements to pg_upgrade; is still disabled.Bruce Momjian
2002-01-09Add quotes around $bindir.Bruce Momjian
2002-01-09Fix include paths for case of VPATH build.Tom Lane
2002-01-08make install failed in VPATH build.Tom Lane
2002-01-08Fix copy-and-paste mistake exposed by gcc warning.Tom Lane
2002-01-08In a VPATH build, resultmap must be one of the symlinked files, elseTom Lane
pg_regress doesn't see it and you don't get any port-specific comparisons.
2002-01-08Revert last change (CFLAGS+=-g). Probably was a mistake...Peter Eisentraut
2002-01-08Remove shift/reduce conflicts introduced by last change.Tom Lane
2002-01-08Fix lpad() and rpad() to produce correct results in variable-lengthTom Lane
multibyte encodings.
2002-01-08Fixed array pointers, no longer using void * in arithmetics.Michael Meskes
2002-01-07Tweak LWLock algorithms so that an awakened waiter for a lock is notTom Lane
granted the lock when awakened; the signal now only means that the lock is potentially available. The waiting process must retry its attempt to get the lock when it gets to run. This allows the lock releasing process to re-acquire the lock later in its timeslice. Since LWLocks are usually held for short periods, it is possible for a process to acquire and release the same lock many times in a timeslice. The old spinlock-based implementation of these locks allowed for that; but the original coding of LWLock would force a process swap for each acquisition if there was any contention. Although this approach reopens the door to process starvation (a waiter might repeatedly fail to get the lock), the odds of that being a big problem seem low, and the performance cost of the previous approach is considerable.
2002-01-07Fixed parser to accept initializing expressions starting with "(".Michael Meskes
2002-01-07Editorial reviewPeter Eisentraut
2002-01-06If we fail to fork a new backend process, (try to) report the failureTom Lane
to the client before closing the connection. Before 7.2 this was done correctly, but new code would simply close the connection with no report to the client.
2002-01-06Add CHECK_FOR_INTERRUPTS() in various strategic spots, per commentsTom Lane
from Hiroshi.
2002-01-05Bugfix for bug reported by Marcus Better (marcus@dactylis.com). When preformingBarry Lind
a get on a bytea value the code was running the raw value from the server through character set conversion, which if the character set was SQL_ASCII would cause all 8bit characters to become ?'s.
2002-01-04Fix some incorrect and obsolete commentary.Tom Lane
2002-01-04Have to_date() call timestamptz_date() per Karel's email instructions.Thomas G. Lockhart
Fixes time zone problems introduced by Thomas' implementation of TIMESTAMP WITHOUT TIME ZONE which caused the behavior of the previously appropriate routine, timestamp_date(), to change for the worse in this context.
2002-01-04Replace #ifdef, #endif with # requires comment.Bruce Momjian
2002-01-03Require ownership permission for CREATE INDEX, per bug report.Tom Lane
Disallow CREATE INDEX on system catalogs, non-tables (views, sequences, etc). Disallow CREATE/DROP TRIGGER on system catalogs, non-tables. Disallow ALTER TABLE ADD/DROP CONSTRAINT on system catalogs. Disallow FOREIGN KEY reference to non-table. None of these things can actually work in the present system structure, but the code was letting them pass without complaint.
2002-01-03Instead of waiting a fixed amount of time for the test postmaster toTom Lane
start up, wait until a psql connection attempt succeeds. Per gripe from Jason Tishler.
2002-01-03SPI_cursor_open must copy by-reference parameter values into theTom Lane
portal's memory context, so that they will live as long as the portal does.
2002-01-03Shouldn't try to copy null datums with datumCopy.Tom Lane
2002-01-03Droplang didn't have test for -l, list. This was really broken too.Bruce Momjian
Took test from createlang.
2002-01-03Add mention that createlang.sh indirection not needed but kept for later.Bruce Momjian
2002-01-03droplang had same problem as createlang; default are backwards and didBruce Momjian
not work. Fixed to match createlang.
2002-01-03In createlang, make dbname optional, not langname, or rather, makeBruce Momjian
existing code of dbname optional actually work.
2002-01-03Guard against roundoff errors in new selectivity-estimation code,Tom Lane
per bug report from Laurette Cisneros.
2002-01-02Fix to_timestamp/to_date so that zero year input for Y, YY, or YYYTom Lane
formats will be taken as 2000, not year zero. Per bug report from Aasmund Midttun Godal. Fix from Karel Zak.