aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Update release notes for 7.3.6.Tom Lane2004-03-02
|
* Replace unportable use of /dev/stdin with lynx's -stdin switch.Tom Lane2004-03-02
|
* When returning type "record", replace use of pgresultGetTupleDescJoe Conway2004-02-24
| | | | | | | | with ReturnSetInfo->expectedDesc. This allows custom datatypes (e.g. from tsearch2) to be returned at runtime. Previous behavior depended on the type oid to match between the remote and local database, which obviously doesn't work well for custom types. Per report from Mark Gibson.
* pply quote_literal to the start_with argument of connectby. Fixes problemJoe Conway2004-02-24
| | | | reported by David Garamond when working with bytea parent and child keys.
* Don't crash when a rowtype argument to a plpgsql function is NULL.Tom Lane2004-02-24
| | | | Per report from Chris Campbell.
* Back-patch fix for ReadOffset with off_t wider than int.Tom Lane2004-02-05
|
* Do not let external specification of CFLAGS stop us from addingTom Lane2004-02-02
| | | | -fno-strict-aliasing.
* Avoid generating invalid character encoding sequences in make_greater_string.Tom Lane2004-02-02
| | | | Not sure how this mistake evaded detection for so long.
* Fix text_position to not scan past end of source string in multibyteJoe Conway2004-02-01
| | | | | case, per report from Korea PostgreSQL Users' Group. Copied from Tom Lane's 7.4 branch patch.
* Repair incorrect order of operations in GetNewTransactionId(). We mustTom Lane2004-01-26
| | | | | | complete ExtendCLOG() before advancing nextXid, so that if that routine fails, the next incoming transaction will try it again. Per trouble report from Christopher Kings-Lynne.
* Revert ill-starred change of 13-Feb-02: it appeared to fix a problem ofTom Lane2004-01-14
| | | | | | | | | incorrect permissions checking, but in fact disabled most all permissions checks for view updates. This corrects problems reported by Sergey Yatskevich among others, at the cost of re-introducing the problem previously reported by Tim Burgess. However, since we'd lived with that problem for quite awhile without knowing it, we can live with it awhile longer until a proper fix can be made in 7.5.
* Repair indexed bytea like operations, and related selectivityJoe Conway2003-12-07
| | | | | functionality. Per bug report by Alvar Freude: http://archives.postgresql.org/pgsql-bugs/2003-12/msg00022.php
* Brand 7.3.5.REL7_3_5Tom Lane2003-12-02
|
* Update release notes for 7.3.5.Tom Lane2003-12-02
|
* Force zero_damaged_pages to be effectively ON during recovery from WAL,Tom Lane2003-12-01
| | | | | since there is no need to worry about damaged pages when we are going to overwrite them anyway from the WAL. Per recent discussion.
* Back-patch fix to check vartypmod when matching PlannerParamVar entries.Tom Lane2003-11-30
| | | | | | This should prevent some obscure cases of 'variable not in subplan target lists', although actual failures have only been reported against 7.4 in which the bug is much easier to trigger.
* Back-patch fix to cause stats processes to detach from shared memory,Tom Lane2003-11-30
| | | | | so that they do not prevent the postmaster from deleting the shmem segment during crash recovery.
* Make PQescapeBytea and byteaout consistent with each other, andJoe Conway2003-11-30
| | | | | | octal escape all octets outside the range 0x20 to 0x7e. This fixes the problem pointed out by Sergey Yatskevich here: http://archives.postgresql.org/pgsql-bugs/2003-11/msg00140.php
* Added missing SPI_finish() calls to get_tuple_of_interest(). Fixes bugJoe Conway2003-11-26
| | | | reported by Andrea Grassi.
* Back-patch removal of unnecessary inclusion of <crypt.h>, so thatTom Lane2003-10-31
| | | | 7.3.5 will build out-of-the-box on Solaris.
* Moved the recently added test for foreign key disabled by rewriteJan Wieck2003-10-31
| | | | | | rule into the rule.sql since it affects the latter if run in paralell. Jan
* Fix for possible referential integrity violation when a qualified ON INSERTJan Wieck2003-10-31
| | | | | | | | rule split the query into one INSERT and one UPDATE where the UPDATE then hit's the just created row without modifying the key fields again. In this special case, the new key slipped in totally unchecked. Jan
* Support for qualified type names in PL/Tcl's spi_prepare command.Jan Wieck2003-10-30
| | | | | | | | This is not 100% backward compatible as formerly a double quoted type name containing a dot could be used. But I don't think may people use dot's in the name of user defined types. Jan
* Don't choke when the handler for a procedural language is located inTom Lane2003-10-28
| | | | the pg_catalog schema. Per bug report some months back from Jochem van Dieten.
* It is possible for ResolveNew to be used to insert a sublink into aTom Lane2003-10-20
| | | | | | | | | | subquery that didn't previously have one. We have traditionally made the caller of ResolveNew responsible for updating the hasSubLinks flag of the outermost query, but this fails to account for hasSubLinks in subqueries. Fix ResolveNew to handle this. We might later want to change the calling convention of ResolveNew so that it can fix the outer query too, simplifying callers. But I went with the localized fix for now. Per bug report from J Smith, 20-Oct-03.
* When dumping CREATE INDEX, must show opclass name if the opclass isn'tTom Lane2003-10-02
| | | | | | in the schema search path. Otherwise pg_dump doesn't correctly dump scenarios where a custom opclass is created in 'public' and then used by indexes in other schemas.
* [ Patch applied only to 7.3.X.]Bruce Momjian2003-09-29
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Hi There's a bug in the clusterdb script where it looks like the arguments to the psql command are being passed in the wrong order, so it fails when you run it on a database that is not on localhost. Here's the output from the command: 133 anands-Computer:bin/scripts> clusterdb -h wooster -U rr granada psql: warning: extra option wooster ignored psql: warning: extra option -U ignored psql: warning: extra option rr ignored psql: warning: extra option -F: ignored psql: warning: extra option -P ignored psql: warning: extra option format=unaligned ignored psql: warning: extra option -t ignored psql: warning: extra option -c ignored psql: warning: extra option SELECT nspname, pg_class.relname, pg_class_2.relname FROM pg_class, pg_class AS pg_class_2 JOIN pg_namespace ON (pg_namespace.oid=relnamespace), pg_index WHERE pg_class.oid=pg_index.indrelid AND pg_class_2.oid=pg_index.indexrelid AND pg_index.indisclustered AND pg_class.relowner=(SELECT usesysid FROM pg_user WHERE usename=current_user) ignored psql: FATAL: user "-h" does not exist I'm attaching a patch that fixes the problem. The diff was run on postgresql 7.3.4 Thanks a lot. Anand Ranganathan
* Backpatched changes for rules when casts are dumped according toJan Wieck2003-09-28
| | | | | | | discussion on hackers. Jan
* _SPI_cursor_operation forgot to check for failure return fromTom Lane2003-09-23
| | | | _SPI_begin_call. Per gripe from Tomasz Myrta.
* Back-patch fix for plpython problems with dropped table columns;Tom Lane2003-09-17
| | | | per bug report from Arthur Ward, who also tested this patch.
* Back-patch the other part of Karel's formatting bug fix.Tom Lane2003-09-03
|
* Repair problems with to_char() overrunning its input string.Tom Lane2003-09-03
| | | | From Karel Zak.
* Fix translation mistake.Peter Eisentraut2003-08-24
|
* Fix GB18030 to UTF-8 mapping tableTatsuo Ishii2003-08-24
|
* Fix bug in GB18030 conversion scriptTatsuo Ishii2003-08-24
|
* Sigh, I'm an idiot ... SSL_ERROR_WANT_READ isn't an error conditionTom Lane2003-08-22
| | | | at all, it just means 'no data available yet'.
* Conversion functions must be STRICT to prevent them from getting null inputs.Tom Lane2003-08-08
|
* Backport to 7.3. Third try to fix the sql injectionBarry Lind2003-08-07
| | | | | | | | | | | | | | | | | vulnerability. This fix completely removes the ability (hack) of being able to bind a list of values in an in clause. It was demonstrated that by allowing that functionality you open up the possibility for certain types of sql injection attacks. The previous fix attempts all focused on preventing the insertion of additional sql statements (the semi-colon problem: xxx; any new sql statement here). But that still left the ability to change the where clause on the current statement or perform a subselect which can circumvent applicaiton security logic and/or allow you to call any stored function. Modified Files: Tag: REL7_3_STABLE jdbc/org/postgresql/Driver.java.in jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java
* Fix several places where fractional-second inputs were misprocessedTom Lane2003-08-05
| | | | | | in HAVE_INT64_TIMESTAMP cases, including two potential stack smashes when more than six fractional digits were supplied. Per bug report from Philipp Reisner.
* SSL_read/SSL_write do not approximate the return conventions of recv()Tom Lane2003-08-04
| | | | | | and send() very well at all; and in any case we can't use retval==0 for EOF due to race conditions. Make the same fixes in the backend as are required in libpq.
* Fix some more problems with testing error returns from SSL.Tom Lane2003-08-04
|
* Fix longstanding error in _bt_search(): should moveright at top of loop notTom Lane2003-07-29
| | | | | | | | | bottom. Otherwise we fail to moveright when the root page was split while we were "in flight" to it. This is not a significant problem when the root is above the leaf level, but if the root was also a leaf (ie, a single-page index just got split) we may return the wrong leaf page to the caller, resulting in failure to find a key that is in fact present. Bug has existed at least since 7.1, probably forever.
* Fix timestamp_date for HAVE_INT64_TIMESTAMP case.REL7_3_4Tom Lane2003-07-24
|
* Add Hungarian/Turkish FAQ's to 7.3.4.Bruce Momjian2003-07-24
|
* Add to 7.3.4 release notes:Bruce Momjian2003-07-24
| | | | * Repair breakage in timestamp-to-date conversion for dates before 2000
* Repair 7.3 breakage in timestamp-to-date conversion for dates before 2000.Tom Lane2003-07-24
|
* Patch to fix additional SQL injection vulnerabilities reported by Oliver JowettBarry Lind2003-07-23
| | | | | | | | and Dmitry Tkach Modified Files: Tag: REL7_3_STABLE jdbc/org/postgresql/Driver.java.in jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java
* New WAL fix release text is:Bruce Momjian2003-07-23
| | | | Prevent rare possibility of server startup failure (Tom)
* Update all FAQ's for 7.3.4.Bruce Momjian2003-07-23
|
* Stamp 7.3.4 release.Bruce Momjian2003-07-23
|