OSDN Git Service
Thomas G. Lockhart [Tue, 6 Nov 2001 16:29:51 +0000 (16:29 +0000)]
Add British Double Standard Time (BDST) per mailing list report.
Thomas G. Lockhart [Tue, 6 Nov 2001 16:27:31 +0000 (16:27 +0000)]
Use PostgreSQL's standard declaration for a 32-bit integer to define
the cash data type.
Tom Lane [Tue, 6 Nov 2001 01:15:29 +0000 (01:15 +0000)]
Add Darwin to list of known systems for ps_status.
Tom Lane [Tue, 6 Nov 2001 00:38:26 +0000 (00:38 +0000)]
The extra semaphore that proc.c now allocates for checkpoint processes
should be accounted for in the PROC_SEM_MAP_ENTRIES() macro. Otherwise
the ports that rely on this macro to size data structures are broken.
Mea culpa.
Tom Lane [Mon, 5 Nov 2001 19:41:56 +0000 (19:41 +0000)]
Fix coredump in plpgsql when trying to return a rowtype result.
Need to return a TupleTableSlot, not just a bare tuple.
Bruce Momjian [Mon, 5 Nov 2001 17:46:40 +0000 (17:46 +0000)]
New pgindent run with fixes suggested by Tom. Patch manually reviewed,
initdb/regression tests pass.
Hiroshi Inoue [Mon, 5 Nov 2001 10:35:14 +0000 (10:35 +0000)]
Preparation for the parameter array handling.
Hiroshi Inoue [Mon, 5 Nov 2001 09:46:17 +0000 (09:46 +0000)]
1) Fix a few bugs about SQLGetData()
reported by Mika Mantyla.
2) Timestamp precision.
3) Separate ODBC3.0 files.
Bruce Momjian [Mon, 5 Nov 2001 06:37:51 +0000 (06:37 +0000)]
More cleanup for stuff after closing brace in first column.
Bruce Momjian [Mon, 5 Nov 2001 05:47:50 +0000 (05:47 +0000)]
Handle tabs after closing brace in first column with less indenting.
Bruce Momjian [Mon, 5 Nov 2001 05:18:43 +0000 (05:18 +0000)]
Improve readability of script.
Tom Lane [Mon, 5 Nov 2001 05:00:14 +0000 (05:00 +0000)]
CREATE TABLE foo (x,y,z) AS SELECT ... can't apply target column names
to the target list in gram.y; it must wait till after expansion of the
target list in analyze.c. Per bug report 4-Nov:
lx=# CREATE TABLE abc (a char, b char, c char);
CREATE
lx=# CREATE TABLE xyz (x, y, z) AS SELECT * FROM abc;
ERROR: CREATE TABLE/AS SELECT has mismatched column count
Tom Lane [Mon, 5 Nov 2001 01:34:37 +0000 (01:34 +0000)]
Remove ill-considered Assert.
Bruce Momjian [Sun, 4 Nov 2001 21:27:41 +0000 (21:27 +0000)]
Pull in variables defined in structs; had too many tabs.
Tom Lane [Sun, 4 Nov 2001 20:12:57 +0000 (20:12 +0000)]
Fix now-obsolete comment.
D'Arcy J.M. Cain [Sun, 4 Nov 2001 20:11:01 +0000 (20:11 +0000)]
Version was 3.3 but last released version was 3.1. Setting to match rest
of the documentation in preparation for upcoming release.
Tom Lane [Sun, 4 Nov 2001 19:55:31 +0000 (19:55 +0000)]
Merge three existing ways of signaling postmaster from child processes,
so that only one signal number is used not three. Flags in shared
memory tell the reason(s) for the current signal. This method is
extensible to handle more signal reasons without chewing up even more
signal numbers, but the immediate reason is to keep pg_pwd reloads
separate from SIGHUP processing in the postmaster.
Also clean up some problems in the postmaster with delayed response to
checkpoint status changes --- basically, it wouldn't schedule a checkpoint
if it wasn't getting connection requests on a regular basis.
D'Arcy J.M. Cain [Sun, 4 Nov 2001 19:47:16 +0000 (19:47 +0000)]
Note that PyGreSQL has been checked against Python 2.1 now.
D'Arcy J.M. Cain [Sun, 4 Nov 2001 19:42:13 +0000 (19:42 +0000)]
The "%d", while syntactically correct, was confusing. Added a space to
make it clearer that d was the argument to the format operator.
Philip Warner [Sun, 4 Nov 2001 04:05:36 +0000 (04:05 +0000)]
- Fix compiler warning in pg_restore
- Fix handling of {data/schema}-only restores when using a full
backup file; prior version was restoring schema in data-only
restores. Added enum to make code easier to understand.
Bruce Momjian [Sun, 4 Nov 2001 03:08:11 +0000 (03:08 +0000)]
Got "ADD" to appear only in ALTER TABLE and not CREATE TABLE
UNIQUE-PRIMARY KEY notice message. This is what Christopher wanted from
his patch.
Bruce Momjian [Sun, 4 Nov 2001 02:41:09 +0000 (02:41 +0000)]
Remove "ADD" from TABLE / ADD UNIQUE-PRIMARY error message because the
same code is called for both creation and alter. Not worth worrying
about.
Bruce Momjian [Sat, 3 Nov 2001 22:34:13 +0000 (22:34 +0000)]
Require closing paren on line above brace to identify function
difinition, just for formatting workaround, per Tom's discovery.
Tom Lane [Sat, 3 Nov 2001 21:42:47 +0000 (21:42 +0000)]
Clean up wrong, misleading, or obsolete documentation about array types,
particularly in the CREATE TYPE reference page. Fix some other errors
in the CREATE TYPE page, too.
Bruce Momjian [Sat, 3 Nov 2001 12:34:15 +0000 (12:34 +0000)]
More updates for GNU indent.
Hiroshi Inoue [Sat, 3 Nov 2001 06:53:50 +0000 (06:53 +0000)]
1) Improve literal handling in parse_statement().
2) Remove some no longer valid comments.
3) Fix an option dialog setting bug.
4) Fix ODBCVER handling errors.
Bruce Momjian [Sat, 3 Nov 2001 01:49:22 +0000 (01:49 +0000)]
Make pgindent use GNU Indent version 2.X better.
Dave Cramer [Fri, 2 Nov 2001 23:51:18 +0000 (23:51 +0000)]
proper select for Jason Davies patch to getImportedKeys
Dave Cramer [Fri, 2 Nov 2001 23:50:08 +0000 (23:50 +0000)]
proper select for Jason Davies patch to getImportedKeys
fixes for compiling Jason's getImportedKeys, getExportedKeys
Bruce Momjian [Fri, 2 Nov 2001 23:43:24 +0000 (23:43 +0000)]
Add check for 'extern "C"' for pgindent.
Tom Lane [Fri, 2 Nov 2001 20:51:27 +0000 (20:51 +0000)]
Windows portability macros SOCK_ERRNO and SOCK_STRERROR should be in
libpq-int.h, not cluttering application namespace in libpq-fe.h.
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.
Peter Eisentraut [Fri, 2 Nov 2001 19:16:47 +0000 (19:16 +0000)]
updates
Peter Eisentraut [Fri, 2 Nov 2001 19:13:09 +0000 (19:13 +0000)]
Update keyword list for 7.2 release.
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 17:00:18 +0000 (17:00 +0000)]
Suppress compiler warning (only seen in MULTIBYTE case).
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.
Michael Meskes [Fri, 2 Nov 2001 15:04:03 +0000 (15:04 +0000)]
Sync parser yet again.
Bruce Momjian [Thu, 1 Nov 2001 20:06:59 +0000 (20:06 +0000)]
Update TODO list.
Tom Lane [Thu, 1 Nov 2001 18:10:48 +0000 (18:10 +0000)]
Minor code cleanups.
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.
Tom Lane [Thu, 1 Nov 2001 06:17:01 +0000 (06:17 +0000)]
Add missing #include.
Tom Lane [Thu, 1 Nov 2001 05:45:28 +0000 (05:45 +0000)]
Suppress trivial compiler warning.
Tom Lane [Thu, 1 Nov 2001 04:48:00 +0000 (04:48 +0000)]
Fix broken markup.
Tom Lane [Thu, 1 Nov 2001 04:07:29 +0000 (04:07 +0000)]
Copy-editing.
Barry Lind [Thu, 1 Nov 2001 01:10:13 +0000 (01:10 +0000)]
minor improvements on Dave's last checkin
Hiroshi Inoue [Wed, 31 Oct 2001 23:54:02 +0000 (23:54 +0000)]
Suppress a compiler warning.
Peter Eisentraut [Wed, 31 Oct 2001 20:39:30 +0000 (20:39 +0000)]
A little reformatting for better print appearance.
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.
Peter Eisentraut [Wed, 31 Oct 2001 20:37:39 +0000 (20:37 +0000)]
Reformat some non-sensical markup.
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.
Dave Cramer [Wed, 31 Oct 2001 20:27:37 +0000 (20:27 +0000)]
changes to support 3rd party ERD tools and staroffice
Dave Cramer [Wed, 31 Oct 2001 20:26:01 +0000 (20:26 +0000)]
allow null passwords
Dave Cramer [Wed, 31 Oct 2001 20:24:32 +0000 (20:24 +0000)]
added dummy login
Bruce Momjian [Wed, 31 Oct 2001 15:11:08 +0000 (15:11 +0000)]
Update TODO list.
Bruce Momjian [Wed, 31 Oct 2001 15:06:02 +0000 (15:06 +0000)]
Update TODO list.
Thomas G. Lockhart [Wed, 31 Oct 2001 14:44:23 +0000 (14:44 +0000)]
Fix queries to insulate from daylight savings time.
Bruce Momjian [Wed, 31 Oct 2001 05:16:31 +0000 (05:16 +0000)]
More *.po cleanups for new spacing.
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.
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
Bruce Momjian [Wed, 31 Oct 2001 04:55:02 +0000 (04:55 +0000)]
Traditional Chinese error messages for JDBC.
Zhenbang Wei
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
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.
Bruce Momjian [Wed, 31 Oct 2001 04:31:17 +0000 (04:31 +0000)]
Apply updated PO language patch.
Zhenbang Wei
Bruce Momjian [Wed, 31 Oct 2001 04:20:26 +0000 (04:20 +0000)]
PO language update.
forth@pagic.net
Bruce Momjian [Wed, 31 Oct 2001 01:56:55 +0000 (01:56 +0000)]
Update TODO list.
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.
Barry Lind [Tue, 30 Oct 2001 20:45:17 +0000 (20:45 +0000)]
updates to JDBC TODO items
Tom Lane [Tue, 30 Oct 2001 20:13:44 +0000 (20:13 +0000)]
Grammatical corrections.
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
Bruce Momjian [Tue, 30 Oct 2001 05:38:56 +0000 (05:38 +0000)]
Fix small problem Tom Lane found with pgindent run.
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
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
Bruce Momjian [Mon, 29 Oct 2001 19:41:54 +0000 (19:41 +0000)]
Add trailing semicolon for Joe Conway
Bruce Momjian [Mon, 29 Oct 2001 19:28:48 +0000 (19:28 +0000)]
Update HISTORY per HACKERS discussion.
Bruce Momjian [Mon, 29 Oct 2001 18:06:54 +0000 (18:06 +0000)]
Add gp->gr_mem != NULL check for Solaris, 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
Tatsuo Ishii [Mon, 29 Oct 2001 06:45:32 +0000 (06:45 +0000)]
Fix bug with illegal call to calloc.
Hiroshi Inoue [Mon, 29 Oct 2001 02:51:46 +0000 (02:51 +0000)]
Change position of a check button in multibyte mode.
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.
Bruce Momjian [Sat, 27 Oct 2001 13:54:45 +0000 (13:54 +0000)]
Add code to trip trailing newlines in a file.
Bruce Momjian [Sat, 27 Oct 2001 03:31:36 +0000 (03:31 +0000)]
Correct fix for indenting.
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.
Tom Lane [Fri, 26 Oct 2001 21:17:03 +0000 (21:17 +0000)]
More cleanup of CREATE FUNCTION examples.
Tom Lane [Fri, 26 Oct 2001 20:45:33 +0000 (20:45 +0000)]
Remove no-longer-needed dependencies on DLSUFFIX.
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.
Bruce Momjian [Fri, 26 Oct 2001 17:54:45 +0000 (17:54 +0000)]
Adjust NR tests. More accurate.
Bruce Momjian [Fri, 26 Oct 2001 16:21:13 +0000 (16:21 +0000)]
Add code to not indent enum, per Tom Lane.
Bruce Momjian [Fri, 26 Oct 2001 15:42:54 +0000 (15:42 +0000)]
Add ODBC typedefs.
Bruce Momjian [Fri, 26 Oct 2001 15:27:41 +0000 (15:27 +0000)]
Update TODO list.
Barry Lind [Thu, 25 Oct 2001 22:00:31 +0000 (22:00 +0000)]
updates to jdbc documentation for 7.2
Tom Lane [Thu, 25 Oct 2001 20:56:53 +0000 (20:56 +0000)]
Remove 294 reduce/reduce conflicts.
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...
Bruce Momjian [Thu, 25 Oct 2001 20:00:58 +0000 (20:00 +0000)]
Mention pgindent/pgjindent.
Bruce Momjian [Thu, 25 Oct 2001 19:59:23 +0000 (19:59 +0000)]
Final update of HISTORY.
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.
Bruce Momjian [Thu, 25 Oct 2001 19:43:53 +0000 (19:43 +0000)]
Update TODO list.
Bruce Momjian [Thu, 25 Oct 2001 19:22:05 +0000 (19:22 +0000)]
Add slash for comment spacing, for Tom.
Bruce Momjian [Thu, 25 Oct 2001 18:44:42 +0000 (18:44 +0000)]
Add comment spaces for trailing ) and comment.