Tom Lane [Fri, 2 Nov 2001 20:23:02 +0000 (20:23 +0000)]
Add default expressions to INSERTs during planning, not during parse
analysis. This keeps stored rules from prematurely absorbing default
information, which is necessary for ALTER TABLE SET DEFAULT to work
unsurprisingly with rules. See pgsql-bugs discussion 24-Oct-01.
Tom Lane [Fri, 2 Nov 2001 18:39:57 +0000 (18:39 +0000)]
Fix pg_pwd caching mechanism, which was broken by changes to fork
postmaster children before client auth step. Postmaster now rereads
pg_pwd on receipt of SIGHUP, the same way that pg_hba.conf is handled.
No cycles need be expended to validate password cache validity during
connection startup.
Tom Lane [Fri, 2 Nov 2001 16:30:29 +0000 (16:30 +0000)]
Fix problem reported by Alex Korn: if a relation has been dropped and
recreated since the start of our transaction, our first reference to it
errored out because we'd try to reuse our old relcache entry for it.
Do this by accepting SI inval messages just before relcache search in
heap_openr, so that dead relcache entries will be flushed before we
search. Also, break heap_open/openr into two pairs of routines,
relation_open(r) and heap_open(r). The relation_open routines make
no tests on relkind and so can be used to open anything that has a
pg_class entry. The heap_open routines are wrappers that add a relkind
test to preserve their established behavior. Use the relation_open
routines in several places that had various kluge solutions for opening
rels that might be either heap or index rels.
Also, remove the old 'heap stats' code that's been superseded by Jan's
stats collector, and clean up some inconsistencies in error reporting
between the different types of ALTER TABLE.
Tom Lane [Thu, 1 Nov 2001 18:09:58 +0000 (18:09 +0000)]
Reject tabs and linefeeds in usernames and passwords that are being
stored in pg_pwd, to guard against failures of the sort observed by
Tom Yackel. Note: in the case of encrypted passwords this is no
restriction, since the string we are interested in is the MD5 hash.
Bruce Momjian [Wed, 31 Oct 2001 04:58:36 +0000 (04:58 +0000)]
Here is an updated version of /src/backend/po/ru.po
which incorporates recent changes by Bruce to
readability of some messages and few more translations.
Tom Lane [Tue, 30 Oct 2001 19:58:58 +0000 (19:58 +0000)]
Fix problems with subselects used in GROUP BY expressions, per gripe
from Philip Warner. Side effect of change is that GROUP BY expressions
will not be re-evaluated at multiple plan levels anymore, whereas this
sometimes happened with old code.
Barry Lind [Tue, 30 Oct 2001 06:31:59 +0000 (06:31 +0000)]
fixed change in behavior introduced in bytea / getBytes changes. This patch reverts back unintentional change in behavior to return raw value even when not bytea column
Tom Lane [Thu, 25 Oct 2001 20:37:30 +0000 (20:37 +0000)]
Fix a couple of places where lack of parenthesization of a cast
causes pgindent to make weird formatting decisions. Easiest fix
seems to be to put in the extra parens...
Tom Lane [Thu, 25 Oct 2001 14:10:07 +0000 (14:10 +0000)]
Add int2-to-int8 and int8-to-int2 conversion routines. Needed to avoid
breaking existing pg_dump scripts, which try to assign the result of
count(*) to an int2 variable. catversion bumped.
Barry Lind [Wed, 24 Oct 2001 04:31:50 +0000 (04:31 +0000)]
fix for a bug in DatabaseMetaData.getIndexInfo(). This fixes a bug reported by tom_falconer@lineone.net. On Sept 7th, he sent a test case to the list demonstrating the bug. His test case now works successfully with this patch
Tom Lane [Tue, 23 Oct 2001 21:26:44 +0000 (21:26 +0000)]
Forbid the switch combination --clean --create, which is pointless
(why bother dropping individual objects in a just-created database?)
as well as dangerous (as the code stands, the drops will be issued in
the wrong database, namely the one you were originally connected to).