summaryrefslogtreecommitdiff
path: root/src
AgeCommit message (Collapse)Author
2003-03-08Back ported patches from head to 7.3 branch (fixes for NPE in result set ↵Barry Lind
absolute() and NPE when logging enabled) Modified Files: Tag: REL7_3_STABLE jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java jdbc/org/postgresql/util/PSQLException.java
2003-03-06Tweak dependency code to suppress NOTICEs generated by new method forTom Lane
cleaning out temp namespaces. We don't really want the server log to be cluttered with 'Drop cascades to table foo' every time someone uses a temp table...
2003-03-06Add missing --globals-only (long form of -g).Tom Lane
2003-03-05Repair bug reported by Laurent Perez: bad plan generated when UPDATE orTom Lane
DELETE of an inheritance tree references another inherited relation. This bug has been latent since 7.1; I'm still not quite sure why 7.1 and 7.2 don't manifest it (at least, they don't crash on a simple test case).
2003-03-03Prevent clustering on incomplete indexes: partial indexes are verboten,Tom Lane
as are non-amindexnulls AMs unless first column is attnotnull.
2003-03-02Repair memory leak introduced by recent change to make SPI return aTom Lane
tupdesc even with zero tuples returned: some plpgsql routines assumed they didn't need to do SPI_freetuptable() after retrieving no tuples.
2003-02-27Change EXTRACT(EPOCH FROM timestamp) so that a timestamp without time zoneTom Lane
is assumed to be in local time, not GMT. This improves consistency with other operations, which all assume local timezone when it matters. Per bug #897.
2003-02-27Back patch bug fix to quote function.D'Arcy J.M. Cain
2003-02-24Backport a fix from 7.4 to 7.3 to better handle case in updateable result sets.Barry Lind
This backports part of the fix made in version 1.11. Modified Files: Tag: REL7_3_STABLE jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java
2003-02-23If a shutdown request comes in while we're still starting up, don'tTom Lane
service it until after we execute SetThisStartUpID(). Else shutdown process will write the wrong SUI into the shutdown checkpoint, which seems likely to be trouble --- although I've not quite figured out how significant it really is.
2003-02-21Repair nasty oversight in bt_split: if the index is temporary, we weren'tTom Lane
updating the left-link from the split page's right sibling. This could result in backwards index scans missing some entries. Same bug exists in HEAD, will be patched later.
2003-02-20Fix timestamptz_in so that parsing of 'now'::timestamptz gives rightTom Lane
answer when SET TIMEZONE has been done since the start of the current transaction. Per bug report from Robert Haas. I plan some futher cleanup in HEAD, but this is a low-risk patch for the immediate issue in 7.3.
2003-02-19Back patch for GUC client_encoding variable not being handledTatsuo Ishii
correctly. However the patch for PostgresPollingStatusType() is not included to avoid 7.3 libpq vs. pre-7.3 backend compatibility problem. See following thread for more details. Subject: [HACKERS] client_encoding directive is ignored in postgresql.conf From: Tatsuo Ishii <t-ishii@sra.co.jp> Date: Wed, 29 Jan 2003 22:24:04 +0900 (JST)
2003-02-18Async_NotifyHandler must save and restore ImmediateInterruptOK. FixesTom Lane
known problem with failure to respond to 'pg_ctl stop -m fast', and probable problems if SIGINT or SIGTERM arrives while processing a SIGUSR2 interrupt that arrived while waiting for a new client query.
2003-02-14Fix SPI result logic for case where there are multiple statements of theTom Lane
same type in a rule. Per bug report from Pavel Hanak.
2003-02-13Repair incorrect indexing for atttypmod, per Brad McLean.Tom Lane
2003-02-13Result of lo_read() is int, not size_t. Per Oleg Drokin.Tom Lane
2003-02-13Parser was dropping foreign-key constraints on the floor if present inTom Lane
an ALTER TABLE ADD COLUMN command. Per bug #896.
2003-02-13Repair rule permissions-checking bug reported by Tim Burgess 10-Feb-02:Tom Lane
the table(s) modified by the original query would get checked for the type of write permission needed by a rule query.
2003-02-13Prevent timetz2tm() from scribbling on its input in HAVE_INT64_TIMESTAMP case.Tom Lane
2003-02-12Applied patch to update translation file, submitted by Zhenbang WeiBarry Lind
Modified Files: Tag: REL7_3_STABLE jdbc/org/postgresql/errors_zh_TW.properties
2003-02-12Backport patch from Fernando Nasser and Harald Krake to fix an invalid ↵Barry Lind
datatype problem. Modified Files: Tag: REL7_3_STABLE jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java
2003-02-12Backport a patch from Kris Jurka to 7.3. Allows getTables() method to workBarry Lind
against 7.1 servers. Modified Files: Tag: REL7_3_STABLE jdbc/org/postgresql/jdbc1/AbstractJdbc1DatabaseMetaData.java
2003-02-11Use a varno not chosen at random for dummy variables in the top-levelTom Lane
targetlist of a set-operation tree. I'm not sure that this solution will really stand the test of time --- perhaps we need to make a special RTE for such vars to refer to. But this quick hack fixes Brandon Craig Rhodes' complaint of 10-Feb-02 about EXCEPT in CREATE RULE, while not changing any behavior in the better-tested cases where leftmostRTI is one anyway.
2003-02-09up build # to 108Barry Lind
2003-02-09Merge changes from head to 7.3 branch: better error message on character set ↵Barry Lind
conversion problems and patch from Kris Jurka for numeric scale Modified Files: Tag: REL7_3_STABLE jdbc/org/postgresql/errors.properties jdbc/org/postgresql/core/Encoding.java jdbc/org/postgresql/jdbc1/AbstractJdbc1DatabaseMetaData.java
2003-02-07Revise mechanism for getting rid of temp tables at backend shutdown.Tom Lane
Instead of grovelling through pg_class to find them, make use of the handy dandy dependency mechanism: just delete everything that depends on our temp schema. Unlike the pg_class scan, the dependency mechanism is smart enough to delete things in an order that doesn't fall foul of any dependency restrictions. Fixes problem reported by David Heggie: a temp table with a serial column may cause a backend FATAL exit at shutdown time, if it chances to try to delete the temp sequence first.
2003-02-07Avoid generating relid lists with duplicate entries. Fixes bugsTom Lane
reported by Stefanos Harhalakis 2/2/2003.
2003-02-06Fix core dump when pltcl_elog is called with wrong number of parameters,Tom Lane
per report from Ian Harding.
2003-02-06Fix regexp slowness reported by Wade Klaver.Tatsuo Ishii
2003-02-05Allow qualified type names in CREATE CAST, DROP CAST. Also allow theTom Lane
construction 'SETOF type[]' which for some reason was previously overlooked (you'd have to name the array type directly to make it work).
2003-02-04Fix for rollback SQLException from Kris JurkaDave Cramer
2003-02-02Brand 7.3.2.Tom Lane
2003-02-02Fix nodeUnique to behave correctly when reversing direction after reachingTom Lane
either end of subplan results. This prevents misbehavior of cursors on SELECT DISTINCT ... queries. Per bug report 1-Feb-02.
2003-02-01Remove restriction that cast functions cannot be volatile. ThisTom Lane
restriction was debatable to begin with, but it has now become obvious that it breaks forward-porting of user-defined types; contrib/lo being the most salient example.
2003-02-01Cleaner solution to the problem of loading pre-7.3 dumps containingTom Lane
columns of type lo (see contrib/lo). Rather than hacking the function definitions on-the-fly, just modify the queries issued by FixupBlobRefs so that they work even if CREATE CAST hasn't been issued.
2003-02-01Changes of 6-Sep-02 broke pg_restore's ability to recognize tar-formatTom Lane
files. Fix it.
2003-02-01Fix assign_session_authorization() to not be confused by all-numericTom Lane
user names. Per recent reports.
2003-02-01Prevent core dump from calling Tcl_DontCallWhenDeleted() with a nullTom Lane
interp pointer. Per report from Gerhard Hintermayer.
2003-02-01Apply ljb's patch to prevent both memory leak and core dump duringTom Lane
connection shutdown. This is a grotty workaround for a Tcl bug, but said bug has been there long enough that I'm not holding my breath for a real fix. Per discussions and testing from ljb and g.hintermayer.
2003-01-31Make plpython's spi_execute interface handle NULLs properly.Tom Lane
From Andrew Bosma.
2003-01-31Clean up plpython error reporting so that its regression test passesTom Lane
with some amount of cleanliness. I see no need to report the internal Python name rather than the SQL procedure name in error tracebacks.
2003-01-31Tweak bison build rules so that we get the same error messages fromTom Lane
bison 1.875 and later as we did from earlier bison releases. Eventually we will probably want to adopt the newer message spelling ... but not yet. Per recent discussion on pgpatches. Note: I didn't change the build rules for bootstrap, ecpg, or plpgsql grammars, since these do not affect regression test results.
2003-01-31Handle mixed-case names properly in plpgsql_parse_tripwordtype.Tom Lane
From Neil Conway.
2003-01-30Fix regression in .pgpass support. From Neil Conway.Tom Lane
2003-01-29SPI_exec shouldn't return SPI_OK_SELECT if it hasn't actually returnedTom Lane
a tuple table. Fixes core dump in pltcl (and probably other PLs) when executing a query rewritten by a rule. Per bug report from Wolfgang Walter.
2003-01-29Repair array subscript overrun identified by Yichen Xie. Reduce theTom Lane
value of MAX_TIME_PRECISION in floating-point-timestamp-storage case from 13 to 10, which is as much as time_out is actually willing to print. (The alternative of increasing the number of digits we are willing to print looks risky; we might find ourselves printing roundoff garbage.)
2003-01-29Fix array subscript overruns identified by Yichen Xie.Tom Lane
2003-01-28Convert variable name to canonical spelling before checking for matchesTom Lane
in GUCArrayAdd/GUCArrayDelete. This prevents the multiple-entry bug exhibited by Frank Lupo 28-Jan-2003.
2003-01-28Revert off setting mention for client_min_messages.Bruce Momjian
Set log_min_error_messages to the proper and agreed-upon default, PANIC (off). (BACKPATCH)