OSDN Git Service
Bruce Momjian [Fri, 4 Jan 2002 18:23:56 +0000 (18:23 +0000)]
Add from Vadim:
> * Allow command blocks that can ignore certain types of errors
Tom Lane [Fri, 4 Jan 2002 17:06:51 +0000 (17:06 +0000)]
Fix some incorrect and obsolete commentary.
Thomas G. Lockhart [Fri, 4 Jan 2002 17:02:25 +0000 (17:02 +0000)]
Add more complete details on date/time keywords and parsing rules.
Move some tabular information on these from the chapter on data types to
the appendix on dates and times.
Thomas G. Lockhart [Fri, 4 Jan 2002 15:49:42 +0000 (15:49 +0000)]
Have to_date() call timestamptz_date() per Karel's email instructions.
Fixes time zone problems introduced by Thomas' implementation of
TIMESTAMP WITHOUT TIME ZONE which caused the behavior of the previously
appropriate routine, timestamp_date(), to change for the worse in this
context.
Bruce Momjian [Fri, 4 Jan 2002 05:50:25 +0000 (05:50 +0000)]
Replace #ifdef, #endif with # requires comment.
Bruce Momjian [Fri, 4 Jan 2002 05:44:45 +0000 (05:44 +0000)]
Update FAQ.
Bruce Momjian [Fri, 4 Jan 2002 05:03:15 +0000 (05:03 +0000)]
Give attribution:
< perhaps CREATE DATABASE dbname WITH USER = "user"
---
> perhaps CREATE DATABASE dbname WITH USER = "user" (Gavin)
Bruce Momjian [Fri, 4 Jan 2002 04:53:26 +0000 (04:53 +0000)]
Remove:
< * Allow only owner to create indexes
Tom Lane [Thu, 3 Jan 2002 23:21:32 +0000 (23:21 +0000)]
Require ownership permission for CREATE INDEX, per bug report.
Disallow CREATE INDEX on system catalogs, non-tables (views, sequences, etc).
Disallow CREATE/DROP TRIGGER on system catalogs, non-tables.
Disallow ALTER TABLE ADD/DROP CONSTRAINT on system catalogs.
Disallow FOREIGN KEY reference to non-table.
None of these things can actually work in the present system structure,
but the code was letting them pass without complaint.
Tom Lane [Thu, 3 Jan 2002 21:52:05 +0000 (21:52 +0000)]
Instead of waiting a fixed amount of time for the test postmaster to
start up, wait until a psql connection attempt succeeds. Per gripe
from Jason Tishler.
Bruce Momjian [Thu, 3 Jan 2002 21:15:04 +0000 (21:15 +0000)]
Prefer savepoints term:
< allow error codes to be specified; requires nested transactions
---
> allow error codes to be specified; requires savepoints
321c321
< * Allow nested transactions / savepoints [transactions]
---
> * Allow savepoints / nested transactions [transactions]
Bruce Momjian [Thu, 3 Jan 2002 20:42:23 +0000 (20:42 +0000)]
Update:
< allow error codes to be specified
---
> allow error codes to be specified; requires nested transactions
Tom Lane [Thu, 3 Jan 2002 20:30:47 +0000 (20:30 +0000)]
SPI_cursor_open must copy by-reference parameter values into the
portal's memory context, so that they will live as long as the portal does.
Bruce Momjian [Thu, 3 Jan 2002 18:25:43 +0000 (18:25 +0000)]
Add:
> o Allow COPY to report error lines and continue; optionally
> allow error codes to be specified
Bruce Momjian [Thu, 3 Jan 2002 18:22:43 +0000 (18:22 +0000)]
Add:
> * Make equals sign optional in CREATE DATABASE WITH param = 'val'
Bruce Momjian [Thu, 3 Jan 2002 18:13:14 +0000 (18:13 +0000)]
Added:
> * Prevent create/drop scripts from allowing extra args (Bruce)
Tom Lane [Thu, 3 Jan 2002 18:01:59 +0000 (18:01 +0000)]
Shouldn't try to copy null datums with datumCopy.
Bruce Momjian [Thu, 3 Jan 2002 17:31:52 +0000 (17:31 +0000)]
Added:
> * Allow only owner to create indexes
Bruce Momjian [Thu, 3 Jan 2002 17:29:31 +0000 (17:29 +0000)]
Updated:
< * Add config file check for $ODBCINI, $HOME/.odbc.ini, and /etc/odbc.ini
---
> * Add config file check for $ODBCINI, $HOME/.odbc.ini, installpath/etc/odbc.ini
Bruce Momjian [Thu, 3 Jan 2002 17:18:19 +0000 (17:18 +0000)]
Add to java mention of pl/j.
Bruce Momjian [Thu, 3 Jan 2002 08:53:00 +0000 (08:53 +0000)]
Droplang didn't have test for -l, list. This was really broken too.
Took test from createlang.
Bruce Momjian [Thu, 3 Jan 2002 08:38:00 +0000 (08:38 +0000)]
Add mention that createlang.sh indirection not needed but kept for later.
Bruce Momjian [Thu, 3 Jan 2002 08:20:54 +0000 (08:20 +0000)]
Update FAQ_DEV.
Bruce Momjian [Thu, 3 Jan 2002 08:13:51 +0000 (08:13 +0000)]
Update FAQ_DEV.
Bruce Momjian [Thu, 3 Jan 2002 08:04:16 +0000 (08:04 +0000)]
Added
> * Add config file check for $ODBCINI, $HOME/.odbc.ini, and /etc/odbc.ini
Bruce Momjian [Thu, 3 Jan 2002 08:01:17 +0000 (08:01 +0000)]
Added suggested syntax:
> * Make it easier to create a database owned by someone who can't createdb,
> perhaps CREATE DATABASE dbname WITH USER = "user"
Bruce Momjian [Thu, 3 Jan 2002 07:21:48 +0000 (07:21 +0000)]
> > On Fri, Dec 21, 2001 at 11:43:21AM +0800, Christopher Kings-Lynne
wrote:
> > > Just testing pgcrypto on freebsd/alpha. I get some warnings:
> > They should be harmless, although I should fix them.
>
> The actual code is:
>
> if ((dlen & 15) || (((unsigned) res) & 3))
> return -1;
> Hard to imagine how (uint *) & 3 makes any sense, unless res isn't
> always a (uint8 *). Is that true?
At some point it was casted to (uint32*) so I wanted to be sure its ok.
ATM its pointless. Please apply the following patch.
--
marko
Bruce Momjian [Thu, 3 Jan 2002 06:26:22 +0000 (06:26 +0000)]
Add mention of index on foreign key for frequently updated primary key
tables.
Bruce Momjian [Thu, 3 Jan 2002 06:09:02 +0000 (06:09 +0000)]
droplang had same problem as createlang; default are backwards and did
not work. Fixed to match createlang.
Bruce Momjian [Thu, 3 Jan 2002 05:52:48 +0000 (05:52 +0000)]
Add to pool discussion.
Bruce Momjian [Thu, 3 Jan 2002 05:48:48 +0000 (05:48 +0000)]
Added
< o Move to using 'make' rather than 'ant'(?)
---
> o Support both 'make' and 'ant'
Bruce Momjian [Thu, 3 Jan 2002 05:37:43 +0000 (05:37 +0000)]
Add mention of PRIMARY in ALTER TABLE ... [ UNIQUE | PRIMARY ]
Bruce Momjian [Thu, 3 Jan 2002 05:30:04 +0000 (05:30 +0000)]
In createlang, make dbname optional, not langname, or rather, make
existing code of dbname optional actually work.
Bruce Momjian [Thu, 3 Jan 2002 05:20:34 +0000 (05:20 +0000)]
Remove:
< * Change 'createlang [langname] dbname' to 'createlang langname [dbname]'
Bruce Momjian [Thu, 3 Jan 2002 05:06:50 +0000 (05:06 +0000)]
Added:
> * Change 'createlang [langname] dbname' to 'createlang langname [dbname]'
Tom Lane [Thu, 3 Jan 2002 04:02:34 +0000 (04:02 +0000)]
Guard against roundoff errors in new selectivity-estimation code,
per bug report from Laurette Cisneros.
Tom Lane [Wed, 2 Jan 2002 22:09:23 +0000 (22:09 +0000)]
Fix to_timestamp/to_date so that zero year input for Y, YY, or YYY
formats will be taken as 2000, not year zero. Per bug report from
Aasmund Midttun Godal. Fix from Karel Zak.
Tom Lane [Wed, 2 Jan 2002 00:41:26 +0000 (00:41 +0000)]
Fix incorrect description of rowtype variable declarations. Eventually
(IMHO) the code should be fixed to do what the documentation formerly
claimed, and then revert this change.
Tom Lane [Tue, 1 Jan 2002 23:16:22 +0000 (23:16 +0000)]
Do not accept interrupts in RESUME_INTERRUPTS() and END_CRIT_SECTION()
macros, but only at explicit CHECK_FOR_INTERRUPTS() calls. Not clear
whether overenthusiastic acceptance of interrupts accounts for any real
bugs, but it definitely seems risky and unnecessary.
Tom Lane [Tue, 1 Jan 2002 20:32:37 +0000 (20:32 +0000)]
Fix race condition that could allow two concurrent transactions
to insert the same key into a supposedly unique index. The bug is of
low probability, and may not explain any of the recent reports of
duplicated rows; but a bug is a bug.
Thomas G. Lockhart [Tue, 1 Jan 2002 02:54:33 +0000 (02:54 +0000)]
Rename TIME token to ISOTIME to eliminate conflict with gram.y parser
token. Seems to be isolated to datetime.c and datetime.h.
Bruce Momjian [Mon, 31 Dec 2001 13:32:04 +0000 (13:32 +0000)]
Update dbase for Maarten.Boekhold.
Tom Lane [Sun, 30 Dec 2001 23:09:42 +0000 (23:09 +0000)]
Make sure that all <ctype.h> routines are called with unsigned char
values; it's not portable to call them with signed chars. I recall doing
this for the last release, but a few more uncasted calls have snuck in.
Tom Lane [Sun, 30 Dec 2001 04:36:52 +0000 (04:36 +0000)]
Repair example, per note in interactive docs.
Bruce Momjian [Sun, 30 Dec 2001 04:31:29 +0000 (04:31 +0000)]
Update FAQ_DEV.
Bruce Momjian [Sun, 30 Dec 2001 01:51:10 +0000 (01:51 +0000)]
*** empty log message ***
Bruce Momjian [Sun, 30 Dec 2001 01:48:23 +0000 (01:48 +0000)]
Add
> * Make locking of shared data structures more fine-grained
Bruce Momjian [Sat, 29 Dec 2001 21:30:32 +0000 (21:30 +0000)]
Oops, only wanted datetime.c changes in there. lock stuff reversed out.
Bruce Momjian [Sat, 29 Dec 2001 21:28:18 +0000 (21:28 +0000)]
Fix newly introduced datetime.c compile failure; not enough parens.
Bruce Momjian [Sat, 29 Dec 2001 20:40:42 +0000 (20:40 +0000)]
Added
> * Change factorial to return a numeric
Bruce Momjian [Sat, 29 Dec 2001 20:29:49 +0000 (20:29 +0000)]
Add missing <varlistentry>; shown in build logs.
Thomas G. Lockhart [Sat, 29 Dec 2001 18:40:58 +0000 (18:40 +0000)]
Check a bit more carefully for preceeding ISO field tags
when decoding date fields.
Thomas G. Lockhart [Sat, 29 Dec 2001 18:35:54 +0000 (18:35 +0000)]
Document the precision arguments for date/time types per SQL9x.
Update the list of recognized time zones.
Document the range of arguments allowed for SET TIME ZONE.
Still need to add info on other date/time symbols (e.g. "AM", "T")
and to freshen the docs on the date/time parsing rules.
Thomas G. Lockhart [Sat, 29 Dec 2001 18:31:48 +0000 (18:31 +0000)]
Rework the date/time parsing to tighten up some cases and to enable other
cases which should have worked but did not.
Now supports julian day (J2452271), ISO time labels (T040506) and various
combinations of spaces and run-togethers of dates, times, and time zones.
All regression tests pass, and I have more tests to add after the 7.2
release (don't want to require changes to the ancillary horology result
files until after then).
Bruce Momjian [Sat, 29 Dec 2001 17:58:15 +0000 (17:58 +0000)]
Add crossdb TODO.detail item.
Bruce Momjian [Sat, 29 Dec 2001 17:56:46 +0000 (17:56 +0000)]
Add crossdb TODO.detail item:
---
> * Allow queries across multiple databases [crossdb]
Bruce Momjian [Sat, 29 Dec 2001 17:19:03 +0000 (17:19 +0000)]
Update server DEBUG startup tag fixes:
> * Change DEBUG startup tag to NOTICE; change NOTICE to output to client
> only if client exists (Bruce)
This item is not done:
< * -Make elog(LOG) in WAL its own output type, distinct from DEBUG (Peter E)
---
> * Make elog(LOG) in WAL its own output type, distinct from DEBUG
Bruce Momjian [Sat, 29 Dec 2001 17:06:22 +0000 (17:06 +0000)]
Add to java.
Bruce Momjian [Sat, 29 Dec 2001 05:22:37 +0000 (05:22 +0000)]
Added
> * Add --port flag to regression tests
Bruce Momjian [Sat, 29 Dec 2001 05:15:42 +0000 (05:15 +0000)]
Update FAQ_DEV.
Bruce Momjian [Sat, 29 Dec 2001 05:12:45 +0000 (05:12 +0000)]
Update FAQ_DEV.
Bruce Momjian [Sat, 29 Dec 2001 04:55:45 +0000 (04:55 +0000)]
Added
> * Change FIXED_CHAR_SEL to 0.20 from 0.04 to give better selectivity (Bruce)
Bruce Momjian [Sat, 29 Dec 2001 03:42:59 +0000 (03:42 +0000)]
Update FAQ_DEV.
Tom Lane [Fri, 28 Dec 2001 23:26:04 +0000 (23:26 +0000)]
Improve LOCK_DEBUG logging code for LWLocks.
Bruce Momjian [Fri, 28 Dec 2001 19:47:50 +0000 (19:47 +0000)]
Added
> * Report failure to find readline or zlib at end of configure run
Bruce Momjian [Fri, 28 Dec 2001 19:44:20 +0000 (19:44 +0000)]
Add
> o Change syntax to WITH DELIMITER, (keep old syntax around?)
Bruce Momjian [Fri, 28 Dec 2001 19:35:52 +0000 (19:35 +0000)]
Add
> * Add WAL index reliability improvement to non-btree indexes
Peter Eisentraut [Fri, 28 Dec 2001 18:47:54 +0000 (18:47 +0000)]
Update from Serguei Mokhov
Bruce Momjian [Fri, 28 Dec 2001 18:33:44 +0000 (18:33 +0000)]
Add pljava messages.
Bruce Momjian [Fri, 28 Dec 2001 18:31:14 +0000 (18:31 +0000)]
Typo.
< * Improve access-permissions check on data directory in CYGWIN (Tom)
---
> * Improve access-permissions check on data directory in Cygwin (Tom)
Bruce Momjian [Fri, 28 Dec 2001 18:30:50 +0000 (18:30 +0000)]
Added
<
---
> * Improve access-permissions check on data directory in CYGWIN (Tom)
Tom Lane [Fri, 28 Dec 2001 18:16:43 +0000 (18:16 +0000)]
Ensure that all direct uses of spinlock-protected data structures use
'volatile' pointers to access those structures, so that optimizing
compilers will not decide to move the structure accesses outside of the
spinlock-acquire-to-spinlock-release sequence. There are no known bugs
in these uses at present, but based on bad experience with lwlock.c,
it seems prudent to ensure that we protect these other uses too.
Per pghackers discussion around 12-Dec. (Note: it should not be
necessary to worry about structures protected by LWLocks, since the
LWLock acquire and release operations are not inline macros.)
Bruce Momjian [Fri, 28 Dec 2001 05:26:25 +0000 (05:26 +0000)]
Add
> * Allow binding query args over FE/BE protocol
Bruce Momjian [Fri, 28 Dec 2001 05:09:13 +0000 (05:09 +0000)]
Added
> o Have ALTER TABLE OWNER change all dependant objects like indexes
Bruce Momjian [Fri, 28 Dec 2001 05:04:59 +0000 (05:04 +0000)]
Add thread item.
Bruce Momjian [Fri, 28 Dec 2001 05:03:10 +0000 (05:03 +0000)]
Add more Christof Petig ecpg items.
Bruce Momjian [Fri, 28 Dec 2001 05:02:50 +0000 (05:02 +0000)]
Christof Petig changes where for HISTORY, not TODO.
Bruce Momjian [Fri, 28 Dec 2001 05:01:05 +0000 (05:01 +0000)]
Oops, back out paren fix. That is for 7.3.
Bruce Momjian [Fri, 28 Dec 2001 05:00:32 +0000 (05:00 +0000)]
Add mention of Christof Petig for ecpg items.
Bruce Momjian [Fri, 28 Dec 2001 04:57:55 +0000 (04:57 +0000)]
Added for Christof Petig:
< o Allow SELECT of array of strings into a auto-sized variable
---
> o -Allow SELECT of array of strings into a auto-sized variable
> o auto allocation for indicator variable arrays (int *ind_p=NULL)
> o auto allocation for string arrays (char **foo_pp=NULL)
> o ECPGfree_auto_mem fixed
> o all function names with external linkage are now prefixed by ECPG
Bruce Momjian [Fri, 28 Dec 2001 04:32:44 +0000 (04:32 +0000)]
Added:
> * Add OpenBSD's getpeereid() call for local socket authentication (Bruce)
Bruce Momjian [Fri, 28 Dec 2001 04:30:18 +0000 (04:30 +0000)]
Update to show current capability and future direction, from Peter:
> * -Allow secure single-user access without passwords using Unix socket permissions
> * Make single-user local socket access permissions the default (Peter E)
Bruce Momjian [Fri, 28 Dec 2001 03:30:30 +0000 (03:30 +0000)]
Added:
! * Add PGPASSWORDFILE environment variable or ~/.pgpass to store
! user/host/password combinations
Bruce Momjian [Fri, 28 Dec 2001 02:30:37 +0000 (02:30 +0000)]
I know we talked about this in the past but I never got it on the TODO
list:
* Add optional CRC checksum to heap and index pages
Tom Lane [Thu, 27 Dec 2001 21:37:34 +0000 (21:37 +0000)]
Expand on description of when to use or not use TRUST auth method.
Tom Lane [Thu, 27 Dec 2001 21:36:57 +0000 (21:36 +0000)]
Document obj_description and col_description functions; expand
description of COMMENT command.
Peter Eisentraut [Thu, 27 Dec 2001 21:10:15 +0000 (21:10 +0000)]
Small fixes
Peter Eisentraut [Thu, 27 Dec 2001 21:06:07 +0000 (21:06 +0000)]
Update from Serguei Mokhov
Bruce Momjian [Thu, 27 Dec 2001 04:46:08 +0000 (04:46 +0000)]
Mention datatype() casting change.
Bruce Momjian [Thu, 27 Dec 2001 04:28:37 +0000 (04:28 +0000)]
Update TODO list.
Bruce Momjian [Thu, 27 Dec 2001 00:04:44 +0000 (00:04 +0000)]
Update for new timestamp behavior.
Bruce Momjian [Wed, 26 Dec 2001 23:47:32 +0000 (23:47 +0000)]
Add cachable item.
Bruce Momjian [Mon, 24 Dec 2001 04:44:03 +0000 (04:44 +0000)]
Place PAM before REJECT in sample file.
Tom Lane [Sun, 23 Dec 2001 20:45:11 +0000 (20:45 +0000)]
Fix directions for a client-only install, per comments from Alexey Borzov
and Vivek Khera.
Tom Lane [Sun, 23 Dec 2001 20:22:49 +0000 (20:22 +0000)]
Update description of CURRENT_TIMESTAMP and friends.
Tom Lane [Sun, 23 Dec 2001 20:21:37 +0000 (20:21 +0000)]
Type interval takes a precision, too.
Peter Eisentraut [Sun, 23 Dec 2001 18:20:05 +0000 (18:20 +0000)]
Lots of content and formatting improvements in release notes. HISTORY
now generated from DocBook sources.
Peter Eisentraut [Sun, 23 Dec 2001 18:18:09 +0000 (18:18 +0000)]
Add missing id attribute.
Michael Meskes [Sun, 23 Dec 2001 12:21:05 +0000 (12:21 +0000)]
Updated ECPG items
Michael Meskes [Sun, 23 Dec 2001 12:17:41 +0000 (12:17 +0000)]
- Removed space_or_nl and line_end from pgc.l.
- Fixed several bugs concerning arrays of structs including a memory
allocation bug.