]> granicus.if.org Git - postgresql/log
postgresql
23 years agoFix pg_pwd caching mechanism, which was broken by changes to fork
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.

23 years agoSuppress compiler warning (only seen in MULTIBYTE case).
Tom Lane [Fri, 2 Nov 2001 17:00:18 +0000 (17:00 +0000)]
Suppress compiler warning (only seen in MULTIBYTE case).

23 years agoFix problem reported by Alex Korn: if a relation has been dropped and
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.

23 years agoSync parser yet again.
Michael Meskes [Fri, 2 Nov 2001 15:04:03 +0000 (15:04 +0000)]
Sync parser yet again.

23 years agoUpdate TODO list.
Bruce Momjian [Thu, 1 Nov 2001 20:06:59 +0000 (20:06 +0000)]
Update TODO list.

23 years agoMinor code cleanups.
Tom Lane [Thu, 1 Nov 2001 18:10:48 +0000 (18:10 +0000)]
Minor code cleanups.

23 years agoReject tabs and linefeeds in usernames and passwords that are being
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.

23 years agoAdd missing #include.
Tom Lane [Thu, 1 Nov 2001 06:17:01 +0000 (06:17 +0000)]
Add missing #include.

23 years agoSuppress trivial compiler warning.
Tom Lane [Thu, 1 Nov 2001 05:45:28 +0000 (05:45 +0000)]
Suppress trivial compiler warning.

23 years agoFix broken markup.
Tom Lane [Thu, 1 Nov 2001 04:48:00 +0000 (04:48 +0000)]
Fix broken markup.

23 years agoCopy-editing.
Tom Lane [Thu, 1 Nov 2001 04:07:29 +0000 (04:07 +0000)]
Copy-editing.

23 years agominor improvements on Dave's last checkin
Barry Lind [Thu, 1 Nov 2001 01:10:13 +0000 (01:10 +0000)]
minor improvements on Dave's last checkin

23 years agoSuppress a compiler warning.
Hiroshi Inoue [Wed, 31 Oct 2001 23:54:02 +0000 (23:54 +0000)]
Suppress a compiler warning.

23 years agoA little reformatting for better print appearance.
Peter Eisentraut [Wed, 31 Oct 2001 20:39:30 +0000 (20:39 +0000)]
A little reformatting for better print appearance.

23 years agoMore information about partial indexes, and some tips about examining
Peter Eisentraut [Wed, 31 Oct 2001 20:38:26 +0000 (20:38 +0000)]
More information about partial indexes, and some tips about examining
index usage.

23 years agoReformat some non-sensical markup.
Peter Eisentraut [Wed, 31 Oct 2001 20:37:39 +0000 (20:37 +0000)]
Reformat some non-sensical markup.

23 years agoEmpty ulinks show the url string as hot text; no need to repeat the url as
Peter Eisentraut [Wed, 31 Oct 2001 20:35:02 +0000 (20:35 +0000)]
Empty ulinks show the url string as hot text; no need to repeat the url as
element content.

23 years agochanges to support 3rd party ERD tools and staroffice
Dave Cramer [Wed, 31 Oct 2001 20:27:37 +0000 (20:27 +0000)]
changes to support 3rd party ERD tools and staroffice

23 years agoallow null passwords
Dave Cramer [Wed, 31 Oct 2001 20:26:01 +0000 (20:26 +0000)]
allow null passwords

23 years agoadded dummy login
Dave Cramer [Wed, 31 Oct 2001 20:24:32 +0000 (20:24 +0000)]
added dummy login

23 years agoUpdate TODO list.
Bruce Momjian [Wed, 31 Oct 2001 15:11:08 +0000 (15:11 +0000)]
Update TODO list.

23 years agoUpdate TODO list.
Bruce Momjian [Wed, 31 Oct 2001 15:06:02 +0000 (15:06 +0000)]
Update TODO list.

23 years agoFix queries to insulate from daylight savings time.
Thomas G. Lockhart [Wed, 31 Oct 2001 14:44:23 +0000 (14:44 +0000)]
Fix queries to insulate from daylight savings time.

23 years agoMore *.po cleanups for new spacing.
Bruce Momjian [Wed, 31 Oct 2001 05:16:31 +0000 (05:16 +0000)]
More *.po cleanups for new spacing.

23 years agoModify *.po files and regression expected output for new clearer error
Bruce Momjian [Wed, 31 Oct 2001 05:14:33 +0000 (05:14 +0000)]
Modify *.po files and regression expected output for new clearer error
message spacing.

23 years agoHere is an updated version of /src/backend/po/ru.po
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.

--
Serguei A. Mokhov

23 years agoTraditional Chinese error messages for JDBC.
Bruce Momjian [Wed, 31 Oct 2001 04:55:02 +0000 (04:55 +0000)]
Traditional Chinese error messages for JDBC.

Zhenbang Wei

23 years agoAttached is a small patch for the Reference Manual which adds
Bruce Momjian [Wed, 31 Oct 2001 04:50:52 +0000 (04:50 +0000)]
Attached is a small patch for the Reference Manual which adds
information about nulls and sort order.

This is based on information obtained from Peter Eisentraut and
Tom Lane on pgsql-hackers.

Please check my English and Docbook markup, as both are a second
language to me.

Rene Pijlman

23 years agoAdd ALTER TABLE ADD UNIQUE regression tests from Christopher Kings-Lynne.
Bruce Momjian [Wed, 31 Oct 2001 04:49:44 +0000 (04:49 +0000)]
Add ALTER TABLE ADD UNIQUE regression tests from Christopher Kings-Lynne.

Add space between slash for ALTER TABLE / ADD ....

Regression and *.po updates to follow.

23 years agoApply updated PO language patch.
Bruce Momjian [Wed, 31 Oct 2001 04:31:17 +0000 (04:31 +0000)]
Apply updated PO language patch.

Zhenbang Wei

23 years agoPO language update.
Bruce Momjian [Wed, 31 Oct 2001 04:20:26 +0000 (04:20 +0000)]
PO language update.

forth@pagic.net

23 years agoUpdate TODO list.
Bruce Momjian [Wed, 31 Oct 2001 01:56:55 +0000 (01:56 +0000)]
Update TODO list.

23 years agoUpdate solaris-1947 variant files for new datetime regression tests.
Tom Lane [Tue, 30 Oct 2001 22:48:57 +0000 (22:48 +0000)]
Update solaris-1947 variant files for new datetime regression tests.
Results checked by Olivier Prenant.

23 years agoupdates to JDBC TODO items
Barry Lind [Tue, 30 Oct 2001 20:45:17 +0000 (20:45 +0000)]
updates to JDBC TODO items

23 years agoGrammatical corrections.
Tom Lane [Tue, 30 Oct 2001 20:13:44 +0000 (20:13 +0000)]
Grammatical corrections.

23 years agoFix problems with subselects used in GROUP BY expressions, per gripe
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.

23 years agofixed change in behavior introduced in bytea / getBytes changes. This patch reverts...
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

23 years agoFix small problem Tom Lane found with pgindent run.
Bruce Momjian [Tue, 30 Oct 2001 05:38:56 +0000 (05:38 +0000)]
Fix small problem Tom Lane found with pgindent run.

23 years agoupdated patch from Mark Lillywhite per Tom Lane's comments: subtract VARHDRSZ first...
Barry Lind [Tue, 30 Oct 2001 05:09:51 +0000 (05:09 +0000)]
updated patch from Mark Lillywhite per Tom Lane's comments: subtract VARHDRSZ first then and with 0xffff

23 years agoapplied patch from Mark Lillywhite, patch was already applied to jdbc2, this applies...
Barry Lind [Tue, 30 Oct 2001 05:05:25 +0000 (05:05 +0000)]
applied patch from Mark Lillywhite, patch was already applied to jdbc2, this applies same fix to jdbc1 code

23 years agoAdd trailing semicolon for Joe Conway
Bruce Momjian [Mon, 29 Oct 2001 19:41:54 +0000 (19:41 +0000)]
Add trailing semicolon for Joe Conway

23 years agoUpdate HISTORY per HACKERS discussion.
Bruce Momjian [Mon, 29 Oct 2001 19:28:48 +0000 (19:28 +0000)]
Update HISTORY per HACKERS discussion.

23 years agoAdd gp->gr_mem != NULL check for Solaris, per Seth Hettich
Bruce Momjian [Mon, 29 Oct 2001 18:06:54 +0000 (18:06 +0000)]
Add gp->gr_mem != NULL check for Solaris, per Seth Hettich

23 years agoCheck for NULL return from getgrgid(), per Seth Hettich
Bruce Momjian [Mon, 29 Oct 2001 17:55:41 +0000 (17:55 +0000)]
Check for NULL return from getgrgid(), per Seth Hettich

23 years agoFix bug with illegal call to calloc.
Tatsuo Ishii [Mon, 29 Oct 2001 06:45:32 +0000 (06:45 +0000)]
Fix bug with illegal call to calloc.

23 years agoChange position of a check button in multibyte mode.
Hiroshi Inoue [Mon, 29 Oct 2001 02:51:46 +0000 (02:51 +0000)]
Change position of a check button in multibyte mode.

23 years agoAnother pgindent run. Fixes enum indenting, and improves #endif
Bruce Momjian [Sun, 28 Oct 2001 06:26:15 +0000 (06:26 +0000)]
Another pgindent run.  Fixes enum indenting, and improves #endif
spacing.  Also adds space for one-line comments.

23 years agoAdd code to trip trailing newlines in a file.
Bruce Momjian [Sat, 27 Oct 2001 13:54:45 +0000 (13:54 +0000)]
Add code to trip trailing newlines in a file.

23 years agoCorrect fix for indenting.
Bruce Momjian [Sat, 27 Oct 2001 03:31:36 +0000 (03:31 +0000)]
Correct fix for indenting.

23 years agoUpdate WAL configuration discussion to reflect post-7.1 tweaking.
Tom Lane [Fri, 26 Oct 2001 23:10:21 +0000 (23:10 +0000)]
Update WAL configuration discussion to reflect post-7.1 tweaking.
Minor copy-editing.

23 years agoMore cleanup of CREATE FUNCTION examples.
Tom Lane [Fri, 26 Oct 2001 21:17:03 +0000 (21:17 +0000)]
More cleanup of CREATE FUNCTION examples.

23 years agoRemove no-longer-needed dependencies on DLSUFFIX.
Tom Lane [Fri, 26 Oct 2001 20:45:33 +0000 (20:45 +0000)]
Remove no-longer-needed dependencies on DLSUFFIX.

23 years agoEditorial work on xfunc chapter --- better explanations about SQL
Tom Lane [Fri, 26 Oct 2001 19:58:12 +0000 (19:58 +0000)]
Editorial work on xfunc chapter --- better explanations about SQL
functions handling composite types and sets, various minor cleanups.

23 years agoAdjust NR tests. More accurate.
Bruce Momjian [Fri, 26 Oct 2001 17:54:45 +0000 (17:54 +0000)]
Adjust NR tests.  More accurate.

23 years agoAdd code to not indent enum, per Tom Lane.
Bruce Momjian [Fri, 26 Oct 2001 16:21:13 +0000 (16:21 +0000)]
Add code to not indent enum, per Tom Lane.

23 years agoAdd ODBC typedefs.
Bruce Momjian [Fri, 26 Oct 2001 15:42:54 +0000 (15:42 +0000)]
Add ODBC typedefs.

23 years agoUpdate TODO list.
Bruce Momjian [Fri, 26 Oct 2001 15:27:41 +0000 (15:27 +0000)]
Update TODO list.

23 years agoupdates to jdbc documentation for 7.2
Barry Lind [Thu, 25 Oct 2001 22:00:31 +0000 (22:00 +0000)]
updates to jdbc documentation for 7.2

23 years agoRemove 294 reduce/reduce conflicts.
Tom Lane [Thu, 25 Oct 2001 20:56:53 +0000 (20:56 +0000)]
Remove 294 reduce/reduce conflicts.

23 years agoFix a couple of places where lack of parenthesization of a cast
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...

23 years agoMention pgindent/pgjindent.
Bruce Momjian [Thu, 25 Oct 2001 20:00:58 +0000 (20:00 +0000)]
Mention pgindent/pgjindent.

23 years agoFinal update of HISTORY.
Bruce Momjian [Thu, 25 Oct 2001 19:59:23 +0000 (19:59 +0000)]
Final update of HISTORY.

23 years agoAdd blank line before #endif to #endif's at the end of the file.
Bruce Momjian [Thu, 25 Oct 2001 19:57:03 +0000 (19:57 +0000)]
Add blank line before #endif to #endif's at the end of the file.

23 years agoUpdate TODO list.
Bruce Momjian [Thu, 25 Oct 2001 19:43:53 +0000 (19:43 +0000)]
Update TODO list.

23 years agoAdd slash for comment spacing, for Tom.
Bruce Momjian [Thu, 25 Oct 2001 19:22:05 +0000 (19:22 +0000)]
Add slash for comment spacing, for Tom.

23 years agoAdd comment spaces for trailing ) and comment.
Bruce Momjian [Thu, 25 Oct 2001 18:44:42 +0000 (18:44 +0000)]
Add comment spaces for trailing ) and comment.

23 years agoAdd spacing for single-line comments with trailing semicolon _and_
Bruce Momjian [Thu, 25 Oct 2001 18:25:23 +0000 (18:25 +0000)]
Add spacing for single-line comments with trailing semicolon _and_
comma, per Tom.

23 years agoRemove <> from FAQ_MSWIN, for Vince.
Bruce Momjian [Thu, 25 Oct 2001 16:20:51 +0000 (16:20 +0000)]
Remove <> from FAQ_MSWIN, for Vince.

23 years agoAdd int2-to-int8 and int8-to-int2 conversion routines. Needed to avoid
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.

23 years agoAdd missing output routine for FkConstraint nodes.
Tom Lane [Thu, 25 Oct 2001 14:08:11 +0000 (14:08 +0000)]
Add missing output routine for FkConstraint nodes.

23 years agobmake sure that configure is tags as 7.2b1 now instead of 7.2devel
PostgreSQL Daemon [Thu, 25 Oct 2001 13:02:01 +0000 (13:02 +0000)]
bmake sure that configure is tags as 7.2b1 now instead of 7.2devel

23 years agoCode cleanup. REL7_2_BETA1
Bruce Momjian [Thu, 25 Oct 2001 06:27:56 +0000 (06:27 +0000)]
Code cleanup.

23 years agopgjindent jdbc files. First time jdbc files were formatted.
Bruce Momjian [Thu, 25 Oct 2001 06:00:05 +0000 (06:00 +0000)]
pgjindent jdbc files.  First time jdbc files were formatted.

23 years agopgindent run on all C files. Java run to follow. initdb/regression
Bruce Momjian [Thu, 25 Oct 2001 05:50:21 +0000 (05:50 +0000)]
pgindent run on all C files.  Java run to follow.  initdb/regression
tests pass.

23 years agoUpdate to prevent CATALOG() from wrapping.
Bruce Momjian [Thu, 25 Oct 2001 05:07:56 +0000 (05:07 +0000)]
Update to prevent CATALOG() from wrapping.

23 years agoAdd current typedef symbols to pgindent.
Bruce Momjian [Thu, 25 Oct 2001 03:56:35 +0000 (03:56 +0000)]
Add current typedef symbols to pgindent.

23 years agoAdd do { ... } while (0) to more bad macros.
Bruce Momjian [Thu, 25 Oct 2001 01:29:37 +0000 (01:29 +0000)]
Add do { ... } while (0) to more bad macros.

23 years agoAdd more missing 'do { ... } while (0)' in missing macros. Without it,
Bruce Momjian [Thu, 25 Oct 2001 00:55:48 +0000 (00:55 +0000)]
Add more missing 'do { ... } while (0)' in missing macros.  Without it,
these macros fail in if/else cases:

#define X \
{ \
... \
}

{

if (...)
X;
else
...
}

with proper setup:

#define X \
do { \
... \
} while (0)

it works fine.

23 years agoAdd missing "do { ... } while(0)" in ODBC macros and add find_baddefs
Bruce Momjian [Thu, 25 Oct 2001 00:50:50 +0000 (00:50 +0000)]
Add missing "do { ... } while(0)" in ODBC macros and add find_baddefs
script.

23 years agoInclude locale.h before undefining gettext() to avoid compilation errors
Peter Eisentraut [Wed, 24 Oct 2001 21:49:14 +0000 (21:49 +0000)]
Include locale.h before undefining gettext() to avoid compilation errors
on Solaris.

per report from Lee Kindness, 2001-10-23

23 years agoAll three *.po patches applied.
Bruce Momjian [Wed, 24 Oct 2001 17:52:28 +0000 (17:52 +0000)]
All three *.po patches applied.

forth@pagic.net

23 years agoHere is a patch for DatabaseMetaData to show precision properly. It is
Bruce Momjian [Wed, 24 Oct 2001 17:44:28 +0000 (17:44 +0000)]
Here is a patch for DatabaseMetaData to show precision properly.  It is
from Mark Lillywhite.  I am adding to the patch queue.

23 years agoAllow concurrent index creation for the same table.
Hiroshi Inoue [Wed, 24 Oct 2001 09:28:31 +0000 (09:28 +0000)]
Allow concurrent index creation for the same table.

23 years ago"time" is now a reserved keyword(changed to "mtime").
Tatsuo Ishii [Wed, 24 Oct 2001 08:07:22 +0000 (08:07 +0000)]
"time" is now a reserved keyword(changed to "mtime").

23 years agofix for a bug in DatabaseMetaData.getIndexInfo(). This fixes a bug reported by tom_f...
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

23 years agoUpdate TODO list.
Bruce Momjian [Wed, 24 Oct 2001 01:01:36 +0000 (01:01 +0000)]
Update TODO list.

23 years agoUpdate TODO list.
Bruce Momjian [Tue, 23 Oct 2001 23:27:18 +0000 (23:27 +0000)]
Update TODO list.

23 years agoEditorial work on descriptions of options.
Tom Lane [Tue, 23 Oct 2001 22:11:22 +0000 (22:11 +0000)]
Editorial work on descriptions of options.

23 years agoForbid the switch combination --clean --create, which is pointless
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).

23 years agoDocument range restriction on bit values used in INTERVAL typmod.
Tom Lane [Tue, 23 Oct 2001 20:17:27 +0000 (20:17 +0000)]
Document range restriction on bit values used in INTERVAL typmod.

23 years agoAdd support for INTERVAL's new typmod values to format_type.
Tom Lane [Tue, 23 Oct 2001 20:12:54 +0000 (20:12 +0000)]
Add support for INTERVAL's new typmod values to format_type.

23 years agoFix foreign keys on system columns.
Tom Lane [Tue, 23 Oct 2001 17:39:03 +0000 (17:39 +0000)]
Fix foreign keys on system columns.

23 years agoMake SPI's column-accessing functions work for system columns as well as
Tom Lane [Tue, 23 Oct 2001 17:38:25 +0000 (17:38 +0000)]
Make SPI's column-accessing functions work for system columns as well as
user columns.  Needed for foreign keys on OID, but useful in general.

23 years agoMove ALL out of UNION|INTERSECT|EXCEPT syntax.
Bruce Momjian [Tue, 23 Oct 2001 16:42:36 +0000 (16:42 +0000)]
Move ALL out of UNION|INTERSECT|EXCEPT syntax.

Alvaro Herrera

23 years agoUpdate TODO list.
Bruce Momjian [Tue, 23 Oct 2001 02:52:19 +0000 (02:52 +0000)]
Update TODO list.

23 years agoUpdate TODO list.
Bruce Momjian [Tue, 23 Oct 2001 02:51:35 +0000 (02:51 +0000)]
Update TODO list.

23 years agoNow I had them reversed. Wow that syntax is error-prone.
Bruce Momjian [Tue, 23 Oct 2001 02:50:41 +0000 (02:50 +0000)]
Now I had them reversed.  Wow that syntax is error-prone.

23 years agoSyntax fix. Can't use #ifdef in gram.y.
Bruce Momjian [Tue, 23 Oct 2001 02:47:14 +0000 (02:47 +0000)]
Syntax fix.  Can't use #ifdef in gram.y.

23 years agoBack out LIMIT #,# removal and mark it as to-be-removed in 7.3.
Bruce Momjian [Tue, 23 Oct 2001 02:45:37 +0000 (02:45 +0000)]
Back out LIMIT #,# removal and mark it as to-be-removed in 7.3.

23 years agoAdd error checking to PageRepairFragmentation to ensure that it can
Tom Lane [Tue, 23 Oct 2001 02:20:15 +0000 (02:20 +0000)]
Add error checking to PageRepairFragmentation to ensure that it can
never overwrite adjacent pages with copied data, even if page header
and/or item pointers are already corrupt.  Change inspired by trouble
report from Alvaro Herrera.