Tom Lane [Wed, 14 Jan 2004 03:47:12 +0000 (03:47 +0000)]
pg_settings should have UPDATE privilege allowed to public.
(Can't force initdb for this in 7.4 branch, but we can at least see to it
that post-7.4.2 installations will get it right.)
Tom Lane [Wed, 14 Jan 2004 03:45:02 +0000 (03:45 +0000)]
The no-updates-to-system-catalogs-unless-usecatupd restriction should
not apply to system views. It never mattered before 7.4, but it does now.
Tom Lane [Wed, 14 Jan 2004 03:39:29 +0000 (03:39 +0000)]
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.
Peter Eisentraut [Tue, 13 Jan 2004 22:43:25 +0000 (22:43 +0000)]
Fix format string error.
Peter Eisentraut [Tue, 13 Jan 2004 18:58:42 +0000 (18:58 +0000)]
Translation update
Dennis Bjorklund [Sun, 11 Jan 2004 19:30:42 +0000 (19:30 +0000)]
Translation updates
Dennis Bjorklund [Sun, 11 Jan 2004 19:25:44 +0000 (19:25 +0000)]
Mark string for translation.
Tom Lane [Sat, 10 Jan 2004 00:30:39 +0000 (00:30 +0000)]
Fix subquery pullup logic to not be fooled when a view that appears
'simple' references another view that is not simple. Must recheck
conditions after performing recursive pullup. Per example from
Laurent Perez, 9-Jan-04.
Tom Lane [Fri, 9 Jan 2004 00:15:19 +0000 (00:15 +0000)]
Fix incorrect SQL syntax emitted when -E is given without -P.
Report and fix from Martin Pitt.
Tom Lane [Thu, 8 Jan 2004 23:40:36 +0000 (23:40 +0000)]
Remove broken (and unnecessary) definition of operator <> for _int4
datatype; the generic array comparators added in 7.4 supersede this.
Per report and patch from Korea PostgreSQL Users' Group.
Bruce Momjian [Thu, 8 Jan 2004 15:51:38 +0000 (15:51 +0000)]
Update OSF thread flags for non-gcc compiles.
Dennis Bjorklund [Thu, 8 Jan 2004 08:51:31 +0000 (08:51 +0000)]
Translation updates
Bruce Momjian [Thu, 8 Jan 2004 04:21:20 +0000 (04:21 +0000)]
Update Solaris thread setting for non-gcc compilers.
Peter Eisentraut [Wed, 7 Jan 2004 17:44:07 +0000 (17:44 +0000)]
Translation updates
Peter Eisentraut [Mon, 5 Jan 2004 19:15:55 +0000 (19:15 +0000)]
Translation updates
Peter Eisentraut [Sun, 4 Jan 2004 16:44:22 +0000 (16:44 +0000)]
Correct gettext URL.
Michael Meskes [Sun, 4 Jan 2004 14:50:13 +0000 (14:50 +0000)]
Fixed bug in GRANT OPTION FOR parsing.
Tom Lane [Sun, 4 Jan 2004 04:17:14 +0000 (04:17 +0000)]
Fix portability bugs: char values passed to <ctype.h> functions must
be cast to unsigned char. We have learned this the hard way before.
Tom Lane [Sun, 4 Jan 2004 04:06:45 +0000 (04:06 +0000)]
Fix discrepancy in prototypes for HPUX pg_dlerror.
Tom Lane [Sun, 4 Jan 2004 04:02:22 +0000 (04:02 +0000)]
Fix ReadOffset() to work correctly when off_t is wider than int.
Bruce Momjian [Sun, 4 Jan 2004 00:14:55 +0000 (00:14 +0000)]
Remove trailing semicolons from macro initializations in plpython.
Problem report on True64 Unix by Nikola Milutinovic.
]
Tom Lane [Thu, 1 Jan 2004 19:27:28 +0000 (19:27 +0000)]
Do an explicit fflush after writing a progress message with puts.
This ensures stdout is kept in sync with messages on stderr.
Per report from Olaf Ferger.
Bruce Momjian [Thu, 1 Jan 2004 17:35:32 +0000 (17:35 +0000)]
Backpatch Solaris non-gcc thread compile fix to 7.4.X.
Tom Lane [Tue, 30 Dec 2003 20:05:15 +0000 (20:05 +0000)]
Avoid running out of memory during hash_create, by not passing a
number-of-buckets that exceeds the size we actually plan to allow
the hash table to grow to. Per trouble report from Sean Shanny.
Michael Meskes [Mon, 29 Dec 2003 13:53:17 +0000 (13:53 +0000)]
Added missing whitespaces to array argument parsing.
Tom Lane [Sun, 28 Dec 2003 17:44:05 +0000 (17:44 +0000)]
Fix sanity-check code that mistakenly assumed error and notice messages
could never exceed 30K. Per report from Andreas Pflug.
Tom Lane [Sun, 28 Dec 2003 17:29:51 +0000 (17:29 +0000)]
Avoid infinite loop if connection is lost during PQexecStart() or
PQexecFinish(). Per report from Andreas Pflug.
Michael Meskes [Wed, 24 Dec 2003 22:05:06 +0000 (22:05 +0000)]
Fixed segfault in parsing of EXEC SQL SELECT * FROM foo() AS TBL( c int, i int);
Tom Lane [Tue, 23 Dec 2003 20:34:51 +0000 (20:34 +0000)]
More bogosity in alter_table test: sometimes causes prepare test to fail
by means of arbitrarily renaming tables the other test depends on.
Tom Lane [Tue, 23 Dec 2003 20:17:55 +0000 (20:17 +0000)]
alter_table test sometimes failed in parallel mode, because of transient
table name conflict against rangefuncs test.
Bruce Momjian [Mon, 22 Dec 2003 07:28:46 +0000 (07:28 +0000)]
Regenerate HISTORY for release.
Tom Lane [Sun, 21 Dec 2003 23:44:40 +0000 (23:44 +0000)]
Update HISTORY for 7.4.1 release.
Tom Lane [Sun, 21 Dec 2003 18:06:26 +0000 (18:06 +0000)]
Fix broken markup, adjust 7.4.1 release date, re-sync HEAD with branch.
Peter Eisentraut [Sun, 21 Dec 2003 16:36:34 +0000 (16:36 +0000)]
Some refining of release notes. Markup is still broken by someone else,
so I cannot remake HISTORY.
Bruce Momjian [Sun, 21 Dec 2003 05:24:00 +0000 (05:24 +0000)]
Update 7.4.1 release notes in preparation for release.
Tom Lane [Sat, 20 Dec 2003 18:46:02 +0000 (18:46 +0000)]
Dept. of third thoughts: in fact, libpq should support SCM_CREDS challenge
even when HAVE_GETPEEREID is defined, else it will be unable to connect to
pre-7.4 backends that are using IDENT authentication.
Tom Lane [Sat, 20 Dec 2003 18:25:02 +0000 (18:25 +0000)]
Fix broken IDENT support for FreeBSD (appears to have been broken by
ill-considered conditional logic in getpeereid patch of 3-Dec-2002).
Per bug #1021.
Peter Eisentraut [Sat, 20 Dec 2003 15:32:18 +0000 (15:32 +0000)]
Update INSTALL file for 7.4.1.
Bruce Momjian [Sat, 20 Dec 2003 00:57:32 +0000 (00:57 +0000)]
Update HISTORY file for 7.4.1.
Bruce Momjian [Fri, 19 Dec 2003 23:32:36 +0000 (23:32 +0000)]
Backpatch pg_service.conf file change to not default dbname to match
service name.
Bruce Momjian [Fri, 19 Dec 2003 23:29:29 +0000 (23:29 +0000)]
Supress ecpg thread test if configure didn't enable threads. Fix
tools/thread to run even if configure didn't enable threads because this
test is used before enabling threads for the OS.
Peter Eisentraut [Fri, 19 Dec 2003 20:06:14 +0000 (20:06 +0000)]
7.4.1 release note improvements
Peter Eisentraut [Fri, 19 Dec 2003 14:21:43 +0000 (14:21 +0000)]
Forbid REVOKE on untrusted languages, and don't dump privileges of
untrusted languages (in case they sneak in).
Peter Eisentraut [Fri, 19 Dec 2003 11:54:23 +0000 (11:54 +0000)]
Add missing $(X).
Tom Lane [Fri, 19 Dec 2003 04:56:54 +0000 (04:56 +0000)]
Make to_hex() behave portably on negative input values (treat them as
unsigned integers). Per report from Jim Crate.
Joe Conway [Fri, 19 Dec 2003 00:00:27 +0000 (00:00 +0000)]
Use a shutdown callback to ensure proper clean up when rescanning
partially-evaluated SRFs. Per report found here:
http://archives.postgresql.org/pgsql-general/2003-12/msg00851.php
Tom Lane [Thu, 18 Dec 2003 22:49:34 +0000 (22:49 +0000)]
Fix memory leak with SSL connections due to missing X509_free() calls.
Per Neil Conway.
Tom Lane [Thu, 18 Dec 2003 22:23:55 +0000 (22:23 +0000)]
Use a shutdown callback to clear setArgsValid in a FuncExprState that is
evaluating a set-valued function. This fixes some additional problems
with rescanning partially-evaluated SRFs.
Peter Eisentraut [Thu, 18 Dec 2003 20:25:57 +0000 (20:25 +0000)]
Forgot to change one compatlib.h.
Tom Lane [Thu, 18 Dec 2003 20:21:53 +0000 (20:21 +0000)]
Ensure set-returning functions in the targetlist of a plan node will be
shut down cleanly if the plan node is ReScanned before the SRFs are run
to completion. This fixes the problem for SQL-language functions, but
still need work on functions using the SRF_XXX() macros.
Peter Eisentraut [Thu, 18 Dec 2003 18:55:06 +0000 (18:55 +0000)]
Move Informix compatibility include files out of the way. compatlib.h
was integrated into ecpg_informix.h, the other ones go into their own
subdirectory that is automatically considered by the embedded preprocessor
when in Informix mode.
Dave Cramer [Thu, 18 Dec 2003 04:18:15 +0000 (04:18 +0000)]
patch for new OID74Test
Dave Cramer [Thu, 18 Dec 2003 04:10:12 +0000 (04:10 +0000)]
backpatch for OID74Test to conform with jdbc tests
Dave Cramer [Thu, 18 Dec 2003 03:35:55 +0000 (03:35 +0000)]
backpatch for rs.previous from Kris Jurka, reported by Andrew Fyfe
Dave Cramer [Thu, 18 Dec 2003 03:32:05 +0000 (03:32 +0000)]
patch for building for an alternate port
Dave Cramer [Thu, 18 Dec 2003 03:29:12 +0000 (03:29 +0000)]
back patch by Kris Jurka to get the correct protocol version from the server
Tom Lane [Thu, 18 Dec 2003 01:48:59 +0000 (01:48 +0000)]
Adjust rules output for unknown-vs-any change (affects expected contents
of pg_stats view definition).
Tom Lane [Wed, 17 Dec 2003 22:11:42 +0000 (22:11 +0000)]
information_schema.constraint_column_usage and key_column_usage should
not discriminate against system columns, since we support constraints on
system columns, and in fact constraints on OID are moderately useful.
Tom Lane [Wed, 17 Dec 2003 21:45:51 +0000 (21:45 +0000)]
Fix DecodeInterval to handle '-0.1' sanely, per gripe from Tilo Schwarz.
Tom Lane [Wed, 17 Dec 2003 20:15:53 +0000 (20:15 +0000)]
Repair badly broken estimation of output buffer size in lquery_out().
Tom Lane [Wed, 17 Dec 2003 19:49:52 +0000 (19:49 +0000)]
Reorder tests in parse_coerce so that ANY/ANYELEMENT/ANYARRAY coercion
does not affect UNKNOWN-type literals or Params. This fixes the recent
complaint about count('x') being broken, and improves consistency in
a few other respects too.
Tom Lane [Wed, 17 Dec 2003 17:08:06 +0000 (17:08 +0000)]
Repair planner failure when there are multiple IN clauses, each with
a join in its subselect. In this situation we *must* build a bushy
plan because there are no valid left-sided or right-sided join trees.
Accordingly, hoary sanity check needs an update. Per report from
Alessandro Depase.
Dave Cramer [Wed, 17 Dec 2003 15:48:40 +0000 (15:48 +0000)]
back patching fix for compat 7.1 binary stream issues with the new protocol
added test for same
Michael Meskes [Wed, 17 Dec 2003 15:31:51 +0000 (15:31 +0000)]
Applied all bug fixes from head also to 7.4. Just bugfixes, no new features.
Bruce Momjian [Wed, 17 Dec 2003 07:07:46 +0000 (07:07 +0000)]
Restore information schema upgrade instructions of Peter.
Peter Eisentraut [Tue, 16 Dec 2003 14:56:34 +0000 (14:56 +0000)]
Fix constraint_column_usage for foreign keys.
Peter Eisentraut [Tue, 16 Dec 2003 09:46:12 +0000 (09:46 +0000)]
Repair name.
Bruce Momjian [Tue, 16 Dec 2003 01:06:51 +0000 (01:06 +0000)]
Mention ecpg SET CONNECTION is not thread-aware.
Peter Eisentraut [Mon, 15 Dec 2003 23:58:33 +0000 (23:58 +0000)]
Override some of the changes in DocBook DSSSL stylesheets 1.78 to restore
previous behavior of <literal>, <envar>, <acronym>, and others.
Bruce Momjian [Mon, 15 Dec 2003 22:31:04 +0000 (22:31 +0000)]
Update INSTALL for 7.4.1.
Bruce Momjian [Mon, 15 Dec 2003 22:25:29 +0000 (22:25 +0000)]
Update HISTORY and release notes for 7.4.1.
Bruce Momjian [Mon, 15 Dec 2003 15:30:17 +0000 (15:30 +0000)]
Add Czech FAQ to 7.4.X branch.
Bruce Momjian [Sat, 13 Dec 2003 16:57:36 +0000 (16:57 +0000)]
Stamp 7.4.1.
Update 7.4.1 FAQ's to current.
Dave Cramer [Sat, 13 Dec 2003 00:59:19 +0000 (00:59 +0000)]
patch for returning database metadata as system objects from Kris Jurka
Dave Cramer [Fri, 12 Dec 2003 18:39:01 +0000 (18:39 +0000)]
add missing SQLState by Patrick Higgins
Dave Cramer [Fri, 12 Dec 2003 18:38:19 +0000 (18:38 +0000)]
cancel row updates sets values to null by Kris Jurka
Dave Cramer [Fri, 12 Dec 2003 18:37:06 +0000 (18:37 +0000)]
patch to indicate why test cases failed from Oliver Jowett
Dave Cramer [Fri, 12 Dec 2003 18:06:25 +0000 (18:06 +0000)]
fix casting pooled connections to PGStatement problem patch by JariP
Dave Cramer [Fri, 12 Dec 2003 17:59:08 +0000 (17:59 +0000)]
patch to build under jdk1.1 from Richard Scranton
Dave Cramer [Fri, 12 Dec 2003 00:27:41 +0000 (00:27 +0000)]
binary stream patch by Kris Jurka fixes empty stream failure
Dave Cramer [Fri, 12 Dec 2003 00:24:13 +0000 (00:24 +0000)]
metadata encoding patch from Kris Jurka
Peter Eisentraut [Thu, 11 Dec 2003 19:57:24 +0000 (19:57 +0000)]
Fix instructions how to shut down postmaster.
Dave Cramer [Thu, 11 Dec 2003 19:25:08 +0000 (19:25 +0000)]
patch for unique foreign keys and test case from Kris Jurka
Dave Cramer [Thu, 11 Dec 2003 03:59:37 +0000 (03:59 +0000)]
patch to make PSQLState serializable, and a test case for it
added a test case for getLastOID
Dave Cramer [Wed, 10 Dec 2003 18:25:11 +0000 (18:25 +0000)]
incremented the build number to 210
Tom Lane [Tue, 9 Dec 2003 01:56:41 +0000 (01:56 +0000)]
query_tree_mutator should copy RangeTblEntry nodes even when it's not
planning to modify them itself. Otherwise we end up with shared RTE
substructure, which breaks inheritance_planner because the rte->inh
flag needs to be independent in each copied subquery. Per bug report
from Chris Piker.
Tom Lane [Mon, 8 Dec 2003 21:54:05 +0000 (21:54 +0000)]
Minor autovacuum fixes from Matthew O'Connor.
Tom Lane [Mon, 8 Dec 2003 21:51:37 +0000 (21:51 +0000)]
Add fflush() before sleeping, per Matthew O'Connor.
Tom Lane [Mon, 8 Dec 2003 18:20:10 +0000 (18:20 +0000)]
Whole-row references were broken for subqueries and functions, because
attr_needed/attr_widths optimization failed to allow for Vars with attno
zero in this case. Per report from Tatsuo Ishii.
Tom Lane [Sun, 7 Dec 2003 19:56:07 +0000 (19:56 +0000)]
Replace unportable and overflow-prone use of 'long long' with safer
'double' arithmetic, per recent discussion.
Tom Lane [Sun, 7 Dec 2003 19:43:13 +0000 (19:43 +0000)]
Remove test on c.relkind from check_constraints view; unnecessary and
prevents view from showing constraints on domains. This addresses the
other half of Claus Colloseus' bug report.
Peter Eisentraut [Sun, 7 Dec 2003 10:18:50 +0000 (10:18 +0000)]
Fix typmod interpretation for bit types. (It was erroneously assumed that
for bit(x), the typmod stores x+4, like for the character types.)
Joe Conway [Sun, 7 Dec 2003 04:12:50 +0000 (04:12 +0000)]
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
Dave Cramer [Fri, 5 Dec 2003 21:22:03 +0000 (21:22 +0000)]
backpatch for driver threadsafe problems
Dave Cramer [Fri, 5 Dec 2003 21:06:12 +0000 (21:06 +0000)]
patch from Kris Jurka to allow the server end port to be specified when running
regression tests, this is a backpatch to 7.4
Tom Lane [Fri, 5 Dec 2003 15:50:39 +0000 (15:50 +0000)]
Guard against bug in Solaris' bsearch(), per Michael Wildpaner.
Teodor Sigaev [Fri, 5 Dec 2003 15:38:30 +0000 (15:38 +0000)]
One more fix confusion
Teodor Sigaev [Fri, 5 Dec 2003 14:28:21 +0000 (14:28 +0000)]
Avoid confusion start_parse_str function with tsearch V1
Tom Lane [Wed, 3 Dec 2003 17:45:38 +0000 (17:45 +0000)]
Planner failed to be smart about binary-compatible expressions in pathkeys
and hash bucket-size estimation. Issue has been there awhile but is more
critical in 7.4 because it affects varchar columns. Per report from
Greg Stark.
Teodor Sigaev [Wed, 3 Dec 2003 16:06:59 +0000 (16:06 +0000)]
Fix for word with several infinitives