https://github.com/postgres/postgres

sort by:
Revision Author Date Message Commit Date
2d558b2 Brand 7.3.6. 02 March 2004, 00:44:55 UTC
040f11d Update release notes for 7.3.6. 02 March 2004, 00:39:09 UTC
d367707 Replace unportable use of /dev/stdin with lynx's -stdin switch. 02 March 2004, 00:03:15 UTC
a7e5e2f When returning type "record", replace use of pgresultGetTupleDesc 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. 24 February 2004, 06:07:52 UTC
7ce7e3f pply quote_literal to the start_with argument of connectby. Fixes problem reported by David Garamond when working with bytea parent and child keys. 24 February 2004, 05:26:27 UTC
d301dcb Don't crash when a rowtype argument to a plpgsql function is NULL. Per report from Chris Campbell. 24 February 2004, 01:44:58 UTC
8fd0eb8 Back-patch fix for ReadOffset with off_t wider than int. 05 February 2004, 22:12:48 UTC
3c37388 Do not let external specification of CFLAGS stop us from adding -fno-strict-aliasing. 02 February 2004, 04:08:12 UTC
a60442a Avoid generating invalid character encoding sequences in make_greater_string. Not sure how this mistake evaded detection for so long. 02 February 2004, 03:07:25 UTC
b59917f Fix text_position to not scan past end of source string in multibyte case, per report from Korea PostgreSQL Users' Group. Copied from Tom Lane's 7.4 branch patch. 01 February 2004, 04:05:13 UTC
1b25db6 Repair incorrect order of operations in GetNewTransactionId(). We must 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. 26 January 2004, 19:16:40 UTC
15ae5d2 Revert ill-starred change of 13-Feb-02: it appeared to fix a problem of 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. 14 January 2004, 03:39:36 UTC
c9eb119 Repair indexed bytea like operations, and related selectivity functionality. Per bug report by Alvar Freude: http://archives.postgresql.org/pgsql-bugs/2003-12/msg00022.php 07 December 2003, 04:11:26 UTC
7af352f Brand 7.3.5. 02 December 2003, 16:26:00 UTC
3299a09 Update release notes for 7.3.5. 02 December 2003, 16:15:47 UTC
8d802d4 Force zero_damaged_pages to be effectively ON during recovery from WAL, since there is no need to worry about damaged pages when we are going to overwrite them anyway from the WAL. Per recent discussion. 01 December 2003, 16:53:42 UTC
6144601 Back-patch fix to check vartypmod when matching PlannerParamVar entries. 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. 30 November 2003, 22:24:16 UTC
a0547f6 Back-patch fix to cause stats processes to detach from shared memory, so that they do not prevent the postmaster from deleting the shmem segment during crash recovery. 30 November 2003, 21:56:36 UTC
8582f21 Make PQescapeBytea and byteaout consistent with each other, and 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 30 November 2003, 20:52:37 UTC
005887d Added missing SPI_finish() calls to get_tuple_of_interest(). Fixes bug reported by Andrea Grassi. 26 November 2003, 20:44:54 UTC
fe979ae Back-patch removal of unnecessary inclusion of <crypt.h>, so that 7.3.5 will build out-of-the-box on Solaris. 31 October 2003, 18:14:11 UTC
dde926b Moved the recently added test for foreign key disabled by rewrite rule into the rule.sql since it affects the latter if run in paralell. Jan 31 October 2003, 14:27:51 UTC
d1c496e Fix for possible referential integrity violation when a qualified ON INSERT 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 31 October 2003, 03:57:42 UTC
9e692f2 Support for qualified type names in PL/Tcl's spi_prepare command. 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 30 October 2003, 02:00:44 UTC
0847c87 Don't choke when the handler for a procedural language is located in the pg_catalog schema. Per bug report some months back from Jochem van Dieten. 28 October 2003, 21:05:39 UTC
98c7f15 It is possible for ResolveNew to be used to insert a sublink into a 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. 20 October 2003, 20:02:30 UTC
f8ee74f When dumping CREATE INDEX, must show opclass name if the opclass isn't 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. 02 October 2003, 22:25:08 UTC
243f11c [ Patch applied only to 7.3.X.] 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 29 September 2003, 18:53:08 UTC
6518b4c Backpatched changes for rules when casts are dumped according to discussion on hackers. Jan 28 September 2003, 17:46:19 UTC
57040f5 _SPI_cursor_operation forgot to check for failure return from _SPI_begin_call. Per gripe from Tomasz Myrta. 23 September 2003, 15:11:41 UTC
5f2b17e Back-patch fix for plpython problems with dropped table columns; per bug report from Arthur Ward, who also tested this patch. 17 September 2003, 18:40:11 UTC
64b9dfa Back-patch the other part of Karel's formatting bug fix. 03 September 2003, 19:01:35 UTC
e6d6713 Repair problems with to_char() overrunning its input string. From Karel Zak. 03 September 2003, 15:00:07 UTC
ba91f3b Fix translation mistake. 24 August 2003, 21:26:54 UTC
0fc3b22 Fix GB18030 to UTF-8 mapping table 24 August 2003, 05:13:40 UTC
1de4434 Fix bug in GB18030 conversion script 24 August 2003, 05:00:45 UTC
b0a0a80 Sigh, I'm an idiot ... SSL_ERROR_WANT_READ isn't an error condition at all, it just means 'no data available yet'. 22 August 2003, 21:57:44 UTC
efbc85c Conversion functions must be STRICT to prevent them from getting null inputs. 08 August 2003, 15:49:10 UTC
8ba1fa7 Backport to 7.3. Third try to fix the sql injection 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 07 August 2003, 17:56:27 UTC
1b637d7 Fix several places where fractional-second inputs were misprocessed in HAVE_INT64_TIMESTAMP cases, including two potential stack smashes when more than six fractional digits were supplied. Per bug report from Philipp Reisner. 05 August 2003, 17:39:36 UTC
d1f35b7 SSL_read/SSL_write do not approximate the return conventions of recv() 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. 04 August 2003, 17:58:25 UTC
5365a0c Fix some more problems with testing error returns from SSL. 04 August 2003, 17:25:29 UTC
a4ffca6 Fix longstanding error in _bt_search(): should moveright at top of loop not 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. 29 July 2003, 22:18:48 UTC
091b9c2 Fix timestamp_date for HAVE_INT64_TIMESTAMP case. 24 July 2003, 04:38:27 UTC
5a8e537 Add Hungarian/Turkish FAQ's to 7.3.4. 24 July 2003, 00:53:57 UTC
0878a5e Add to 7.3.4 release notes: * Repair breakage in timestamp-to-date conversion for dates before 2000 24 July 2003, 00:44:24 UTC
fa67e2c Repair 7.3 breakage in timestamp-to-date conversion for dates before 2000. 24 July 2003, 00:21:31 UTC
83bc9b9 Patch to fix additional SQL injection vulnerabilities reported by Oliver Jowett and Dmitry Tkach Modified Files: Tag: REL7_3_STABLE jdbc/org/postgresql/Driver.java.in jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java 23 July 2003, 23:34:31 UTC
97dcee2 New WAL fix release text is: Prevent rare possibility of server startup failure (Tom) 23 July 2003, 22:59:39 UTC
79b0da6 Update all FAQ's for 7.3.4. 23 July 2003, 04:13:13 UTC
1ecc0fd Stamp 7.3.4 release. 23 July 2003, 04:10:16 UTC
3abd139 wups, took out one memset too many ... 22 July 2003, 19:13:25 UTC
3196738 Back-patch fix for bugs in pgstat_initstats. 22 July 2003, 19:00:36 UTC
fd9397c Allow sub[path|ltre] return void result 22 July 2003, 14:08:58 UTC
57970c3 Mark as deprecated 22 July 2003, 14:04:50 UTC
5d882f7 Fix to prevent SQL injection attacks when calling setObject(int,Object,int) where the Object is a String and the type is numeric (i.e. INTEGER,LONG,etc). The fix applies the standard escaping for these values. Modified Files: Tag: REL7_3_STABLE jdbc/org/postgresql/Driver.java.in jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java 22 July 2003, 05:13:05 UTC
004d2be Oh, for crying in a bucket ... relax Assert so that glibc's strxfrm does not dump core. 17 July 2003, 22:20:22 UTC
df32af1 Work around buggy strxfrm() present in some Solaris releases. 17 July 2003, 20:52:42 UTC
19de9d2 For COMMENT ON DATABASE where database name is unknown or not the current database, emit a WARNING and do nothing, rather than raising ERROR. Per recent discussion in which we concluded this is the best way to deal with database dumps that are reloaded into a database of a new name. 17 July 2003, 20:14:09 UTC
0a49e77 Repair boundary-case bug introduced by patch of two months ago that fixed incorrect initial setting of StartUpID. The logic in XLogWrite() expects that Write->curridx is advanced to the next page as soon as LogwrtResult points to the end of the current page, but StartupXLOG() failed to make that happen when the old WAL ended exactly on a page boundary. Per trouble report from Hannu Krosing. 17 July 2003, 16:45:25 UTC
537c1c1 Fix a *second* buffer overrun bug in to_ascii(). Grumble. 14 July 2003, 16:41:46 UTC
263b42f Don't generate 'zero' typeids in the output from gen_cross_product. This is no longer necessary or appropriate since we don't use zero typeid as a wildcard anymore, and it fixes a nasty performance problem with functions with many parameters. Per recent example from Reuven Lerner. 25 June 2003, 20:07:54 UTC
612cbaf [ Backpatch to 7.3.X.] If they're not, the below causes problems, as the foreign key is added after the CHECK. Cluster depends on the index name, so I thought it wise to ensure all names are available, rather than leaving off the CONSTRAINT "$n" portion for internally named constraints. CREATE TABLE jkey (col integer primary key); CREATE TABLE j (col integer REFERENCES jkey); ALTER TABLE j ADD CHECK(col > 5); This is a problem in 7.3 series as well as -Tip. -- Rod Taylor <rbt@rbt.ca> 25 June 2003, 04:09:15 UTC
5fbc1d4 Fix bugs in interval-to-time conversion: HAVE_INT64_TIMESTAMP case did not work at all, and neither case behaved sanely for negative intervals. 16 June 2003, 18:56:53 UTC
1e2d209 Fix SQL function executor for case where last command of a function is not a SELECT. We didn't use to allow that, but we do now. 12 June 2003, 17:29:37 UTC
0a8fc25 Fix brain damage in deciding which python input converter to use. 11 June 2003, 18:33:46 UTC
f9e42d2 Add defense in assign_session_authorization() against trying to do catalog lookups when not in a transaction. This prevents bizarre failures if someone tries to set a value for session_authorization in postgresql.conf. Per report from Fernando Nasser. 06 June 2003, 16:25:52 UTC
5218f77 Fix misstatement in release-notes item. 26 May 2003, 18:58:36 UTC
abb2963 Update for 7.3.3. 22 May 2003, 20:38:56 UTC
9bc3438 Brand 7.3.3. 22 May 2003, 20:17:24 UTC
2ff6e92 Update release history for impending 7.3.3 release. 22 May 2003, 18:32:01 UTC
bab030b Repair sometimes-incorrect computation of StartUpID after a crash, per example from Rao Kumar. This is a very corner corner-case, requiring a minimum of three closely-spaced database crashes and an unlucky positioning of the second recovery's checkpoint record before you'd notice any problem. But the consequences are dire enough that it's a must-fix. 22 May 2003, 14:39:49 UTC
3284e34 Back-patch Jan's fix to avoid primary key lookup (and lock) if foreign key does not change on UPDATE. 21 May 2003, 18:14:46 UTC
af1850f Use -fPIC on Sparc, per Tom Callaway. 19 May 2003, 17:51:08 UTC
529ec66 Back-patch change to avoid O(N^2) behavior with lots of deferred triggers, by making deferredTriggerInvokeEvents only scan events added since it last ran. 19 May 2003, 17:23:54 UTC
f3ed902 Upped JDBC build number to 110 for the 7.3.3 release Modified Files: Tag: REL7_3_STABLE Driver.java.in 19 May 2003, 04:12:52 UTC
8236cd7 Repair quoting sloppiness, lack of schema awareness in reindexdb. 19 May 2003, 01:00:18 UTC
977aded Small translation updates for 7.3.3 release. 18 May 2003, 23:51:41 UTC
1e3fbcc Fix failure when uniq-ifying an array of zero elements. Teodor Sigaev 16 May 2003, 18:50:00 UTC
bdec417 Back-patch fix to allow createuser to exit on control-C (Oliver Elphick) 16 May 2003, 15:17:02 UTC
583736f Back-patch fix from Oliver Elphick to force ISO datestyle in dumps. 16 May 2003, 13:57:03 UTC
3055ca0 Small changes to use the absolute path to system catalogs. Greg Sabino Mullane 16 May 2003, 13:37:11 UTC
ab90b49 Check calling context for connectby_text(), per Joe Conway. 16 May 2003, 06:07:58 UTC
3ffaf20 Apply fixes for problems with dropped columns whose types have also been dropped. Add regression test, too. 12 May 2003, 00:17:34 UTC
016e059 Adjust CreateCheckpoint so that buffer dumping activities and cleanup of dead xlog segments are not considered part of a critical section. It is not necessary to force a database-wide panic if we get a failure in these operations. Per recent trouble reports. 10 May 2003, 18:01:49 UTC
f52c9c6 Be more precise about check for flex 2.5.3, backpatched to 7.3.X. 07 May 2003, 04:49:02 UTC
c04e80c Allow 60 in seconds fields of timestamp, time, interval input values. Per recent discussion on pgsql-general, this is appropriate for spec compliance, and has the nice side-effect of easing porting from old pg_dump files that exhibit the 59.999=>60.000 roundoff problem. 04 May 2003, 04:30:35 UTC
f1b3af2 When a TIMESTAMP, TIME, or INTERVAL precision is specified larger than our implementation limits, do not issue an ERROR; instead issue a NOTICE and use the max supported value. Per pgsql-general discussion of 28-Apr, this is needed to allow easy porting from pre-7.3 releases where the limits were higher. Unrelated change in same area: accept GLOBAL TEMP/TEMPORARY as a synonym for TEMPORARY, as per pgsql-hackers discussion of 15-Apr. We previously rejected it, but that was based on a misreading of the spec --- SQL92's GLOBAL temp tables are really closer to what we have than their LOCAL ones. 04 May 2003, 00:04:10 UTC
fd9dd1b Fix erroneous space calculation leading to core dump in dumpProcLangs, per report from Olivier Prenant. Also fix off-by-one space calculation in ReadToc; this woould not have hurt us until we had more than 100 dependencies for a single object, but wrong is wrong. 03 May 2003, 22:19:18 UTC
2df153b Repair permissions problem in RI triggers: query parsing has to be done as the correct user, not only query execution. Per report from Sean Chittenden. 26 April 2003, 22:21:58 UTC
cb1ad87 Correct oversight in createlang: test for pre-existing handler function was broken by opaque->language_handler change. I see this is already fixed in CVS tip, but must back-patch for 7.3.3. 26 April 2003, 15:19:05 UTC
66e0ea4 Back-patch fixes for zero-column tables in COPY, pg_dump. 25 April 2003, 22:14:33 UTC
de9c299 Make [VACUUM] ANALYZE safe on zero-column tables. 25 April 2003, 21:29:22 UTC
60bc45a Fix misbehavior of func_error() on type names containing '%'. Will patch separately but equivalently in HEAD. 23 April 2003, 18:20:10 UTC
f094673 Fix misbehavior of replace() on strings containing '%'. Will patch separately but equivalently in HEAD. 23 April 2003, 18:19:23 UTC
a72fd0d Prevent palloc(0) error when parent table has zero columns. 21 April 2003, 15:20:02 UTC
9ccfbe2 Fix char-vs-pg_wchar confusion in p_ere(), per failure report from Tom O'Dowd. This fix is not relevant to CVS tip anymore, but we should fix it in 7.3.*. 20 April 2003, 17:37:22 UTC
8363ed7 Fix abstime-to-time cast function, which has had broken implementation since 7.2, per bug #947. Turns out it had wrong volatility label, too. Can't force initdb in 7.3 branch, but fix anyway for future installs. 17 April 2003, 04:50:35 UTC
52eeb49 Applied patches from Kris Jurka fixing a string tokenizing problem and fixing an order by problem for index metadata results. Also includes removing some unused code as well as a fix to the toString method on statement. Modified Files: Tag: REL7_3_STABLE jdbc/org/postgresql/jdbc1/AbstractJdbc1DatabaseMetaData.java jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java 17 April 2003, 04:19:55 UTC
dc3e14d Fix stupid oversight ... 16 April 2003, 04:38:05 UTC
back to top