OSDN Git Service
Peter Eisentraut [Fri, 14 Jan 2000 22:18:03 +0000 (22:18 +0000)]
Fixed psql variables vs array syntax, as well as minor psql enhancements
Peter Eisentraut [Fri, 14 Jan 2000 22:11:38 +0000 (22:11 +0000)]
* User management commands no longer user pg_exec_query_dest -> more robust
* Let unprivileged users change their own passwords.
* The password is now an Sconst in the parser, which better reflects its text datatype and also
forces users to quote them.
* If your password is NULL you won't be written to the password file, meaning you can't connect
until you have a password set up (if you use password authentication).
* When you drop a user that owns a database you get an error. The database is not gone.
Tom Lane [Fri, 14 Jan 2000 05:33:15 +0000 (05:33 +0000)]
Clean up some problems in new asynchronous-connection logic
in libpq --- mostly, poor response to error conditions. You now actually
get to see the postmaster's 'The Data Base System is starting up' message,
which you didn't before. I suspect the SSL code is still broken though.
Tom Lane [Fri, 14 Jan 2000 05:28:31 +0000 (05:28 +0000)]
Make PSQLexec's behavior on loss of connection more reasonable;
report original error before attempting reset, not after.
Tom Lane [Fri, 14 Jan 2000 04:01:55 +0000 (04:01 +0000)]
Make connection-failed messages a little friendlier on
80-column displays...
Tom Lane [Fri, 14 Jan 2000 01:36:42 +0000 (01:36 +0000)]
Remove redundant and now-incorrect declaration of pstrdup.
Bruce Momjian [Fri, 14 Jan 2000 01:10:22 +0000 (01:10 +0000)]
Update TODO list.
Tom Lane [Fri, 14 Jan 2000 00:53:50 +0000 (00:53 +0000)]
Bump catversion to ensure initdb.
Tom Lane [Fri, 14 Jan 2000 00:53:21 +0000 (00:53 +0000)]
Revise quoting conventions in outfuncs/readfuncs so that nodeRead doesn't
choke on relation or attribute names containing spaces, quotes, or other
special characters. This fixes a TODO item. It also forces initdb,
since stored rule strings change.
Peter Eisentraut [Thu, 13 Jan 2000 18:26:18 +0000 (18:26 +0000)]
Fixed everything in and surrounding createdb and dropdb to make it more
error-proof. Rearranged some old code and removed dead sections.
Peter Eisentraut [Thu, 13 Jan 2000 18:22:10 +0000 (18:22 +0000)]
initdb didn't load pg_description
Bruce Momjian [Thu, 13 Jan 2000 13:22:05 +0000 (13:22 +0000)]
Update TODO list.
Bruce Momjian [Thu, 13 Jan 2000 03:39:45 +0000 (03:39 +0000)]
Update TODO list.
Bruce Momjian [Thu, 13 Jan 2000 03:36:42 +0000 (03:36 +0000)]
Update TODO list.
Bruce Momjian [Thu, 13 Jan 2000 03:06:29 +0000 (03:06 +0000)]
Update TODO list.
Bruce Momjian [Thu, 13 Jan 2000 02:38:21 +0000 (02:38 +0000)]
Update TODO list.
Bruce Momjian [Thu, 13 Jan 2000 01:57:04 +0000 (01:57 +0000)]
Update TODO list.
Bruce Momjian [Thu, 13 Jan 2000 01:48:46 +0000 (01:48 +0000)]
Update TODO list.
Tatsuo Ishii [Thu, 13 Jan 2000 01:08:14 +0000 (01:08 +0000)]
Add UDC (User Defined Characters) support to SJIS/EUC_JP conversion
Update README so that it reflects all source file names
Add an entry to make sjistest (testing between SJIS/EUC_JP conversion)
Peter Eisentraut [Wed, 12 Jan 2000 19:36:36 +0000 (19:36 +0000)]
Fixed a few "fixes" and bugs. Adjusted messages and options to GNU suggestions.
Tatsuo Ishii [Wed, 12 Jan 2000 13:08:55 +0000 (13:08 +0000)]
Multi-byte case fix by Oliver Elphick (olly@lfix.co.uk)
Tom Lane [Wed, 12 Jan 2000 05:28:47 +0000 (05:28 +0000)]
Use fmgr_array_args() to avoid dependency on FUNC_MAX_ARGS.
Tom Lane [Wed, 12 Jan 2000 05:27:20 +0000 (05:27 +0000)]
In PQfn(), defend against too many args, and avoid dependency
on FUNC_MAX_ARGS by using an appropriate fmgr() call.
Tom Lane [Wed, 12 Jan 2000 05:25:09 +0000 (05:25 +0000)]
RemoveFunction didn't defend against too many args.
Tom Lane [Wed, 12 Jan 2000 05:04:42 +0000 (05:04 +0000)]
Defend against > INDEX_MAX_KEYS keys in an index.
Tom Lane [Wed, 12 Jan 2000 04:59:41 +0000 (04:59 +0000)]
CommentProc was careless about too many arguments.
Tom Lane [Wed, 12 Jan 2000 00:53:21 +0000 (00:53 +0000)]
Put back erroneously removed zeroing of sentinel elements
in indexkeys, classlist arrays.
Bruce Momjian [Tue, 11 Jan 2000 12:11:20 +0000 (12:11 +0000)]
Update TODO list.
Tom Lane [Tue, 11 Jan 2000 05:58:55 +0000 (05:58 +0000)]
Make FUNC_MAX_ARGS equal INDEX_MAX_KEYS, as it should.
Set default INDEX_MAX_KEYS to 16. Document minimum safe value is 9.
Tom Lane [Tue, 11 Jan 2000 05:56:33 +0000 (05:56 +0000)]
oid8 => oidvector in alter_table regress test
Tom Lane [Tue, 11 Jan 2000 05:41:49 +0000 (05:41 +0000)]
Another FUNC_MAX_ARGS tweak.
Tom Lane [Tue, 11 Jan 2000 05:37:11 +0000 (05:37 +0000)]
Update struct Trigger definition.
Tom Lane [Tue, 11 Jan 2000 05:22:25 +0000 (05:22 +0000)]
Wrong boundary condition on number-of-args check.
Tom Lane [Tue, 11 Jan 2000 05:18:42 +0000 (05:18 +0000)]
Ah-hah, there are attribute size constants lurking here too.
Tom Lane [Tue, 11 Jan 2000 04:02:28 +0000 (04:02 +0000)]
Use symbolic INDEX_MAX_KEYS in pg_type entries for oidvector
and int2vector.
Tom Lane [Tue, 11 Jan 2000 04:00:30 +0000 (04:00 +0000)]
Correct hardwired type information in bootstrap.
Tom Lane [Tue, 11 Jan 2000 03:59:31 +0000 (03:59 +0000)]
Remove no-longer-used symbols.
Bruce Momjian [Tue, 11 Jan 2000 03:33:14 +0000 (03:33 +0000)]
More cleanups. Still doesn't work.
Bruce Momjian [Tue, 11 Jan 2000 02:46:48 +0000 (02:46 +0000)]
More cleanups.
Bruce Momjian [Tue, 11 Jan 2000 02:30:06 +0000 (02:30 +0000)]
More fixes, but still need +1 for FUNC_MAX_ARGS
Tom Lane [Tue, 11 Jan 2000 01:42:08 +0000 (01:42 +0000)]
Remove outdated comment about 8 arguments.
Tom Lane [Tue, 11 Jan 2000 01:40:04 +0000 (01:40 +0000)]
Change oid8/int28 -> oidvector/int2vector.
Bruce Momjian [Mon, 10 Jan 2000 23:03:41 +0000 (23:03 +0000)]
Fix initdb so it works, but still only for 8.
Bruce Momjian [Mon, 10 Jan 2000 20:46:23 +0000 (20:46 +0000)]
Update type stuff.
Bruce Momjian [Mon, 10 Jan 2000 20:23:31 +0000 (20:23 +0000)]
Cleanup for func args > 8.
Bruce Momjian [Mon, 10 Jan 2000 18:27:41 +0000 (18:27 +0000)]
More updates for function call interface > 8.
Bruce Momjian [Mon, 10 Jan 2000 18:18:30 +0000 (18:18 +0000)]
Update fmgr to allow 32 arguments.
Bruce Momjian [Mon, 10 Jan 2000 17:14:46 +0000 (17:14 +0000)]
Make number of args to a function configurable.
Bruce Momjian [Mon, 10 Jan 2000 16:13:23 +0000 (16:13 +0000)]
Rename oid8 -> oidvector and int28 -> int2vector. Cleanup of *out functions.
Bruce Momjian [Mon, 10 Jan 2000 15:41:34 +0000 (15:41 +0000)]
Update int28out and out8out and _in_ functions to handle trailing zeros
properly.
Bruce Momjian [Mon, 10 Jan 2000 13:20:57 +0000 (13:20 +0000)]
Update TODO list.
Hiroshi Inoue [Mon, 10 Jan 2000 06:30:56 +0000 (06:30 +0000)]
Improve cache invalidation handling. Eespecially
this would fix TODO
* elog() flushes cache, try invalidating just entries from
current xact, perhaps using invalidation cache
Bruce Momjian [Mon, 10 Jan 2000 05:23:47 +0000 (05:23 +0000)]
Fix oid8in and int28in for spaces
Bruce Momjian [Mon, 10 Jan 2000 05:20:26 +0000 (05:20 +0000)]
Move fixes for >8 indexed fields.
Bruce Momjian [Mon, 10 Jan 2000 04:36:37 +0000 (04:36 +0000)]
Move INDEX_MAX_KEYS to postgres.h, and make it configurable for users.
Bruce Momjian [Mon, 10 Jan 2000 04:23:58 +0000 (04:23 +0000)]
Update TODO list.
Tom Lane [Mon, 10 Jan 2000 04:09:50 +0000 (04:09 +0000)]
Repair subtle VACUUM bug that led to 'HEAP_MOVED_IN was not expected'
errors. VACUUM normally compacts the table back-to-front, and stops
as soon as it gets to a page that it has moved some tuples onto.
(This logic doesn't make for a complete packing of the table, but it
should be pretty close.) But the way it was checking whether it had
got to a page with some moved-in tuples was to look at whether the
current page was the same as the last page of the list of pages that
have enough free space to be move-in targets. And there was other
code that would remove pages from that list once they got full.
There was a kluge that prevented the last list entry from being
removed, but it didn't get the job done. Fixed by keeping a separate
variable that contains the largest block number into which a tuple
has been moved. There's no longer any need to protect the last element
of the fraged_pages list.
Also, fix NOTICE messages to describe elapsed user/system CPU time
correctly.
Tom Lane [Sun, 9 Jan 2000 20:54:36 +0000 (20:54 +0000)]
Update platform-specific-expected-file support so that platforms can be
specified by regular-expression patterns. Add some more files.
Tom Lane [Sun, 9 Jan 2000 19:34:43 +0000 (19:34 +0000)]
install_plpgsql is no longer a regress test (it's done via createlang);
remove the no-longer-used files.
Bruce Momjian [Sun, 9 Jan 2000 17:35:27 +0000 (17:35 +0000)]
The psql online help for ALTER TABLE (\h alter table) is corrupt. I
traced this back to what I believe is an error in the sgml file used to
generate this comment, found in pgsql/doc/src/sgml/ref/alter_table.sgml.
Stephen Birch
Tatsuo Ishii [Sun, 9 Jan 2000 12:19:27 +0000 (12:19 +0000)]
Add SetPidFile() and friends.
Tatsuo Ishii [Sun, 9 Jan 2000 12:17:33 +0000 (12:17 +0000)]
Do not start if postmaster is running.
Tatsuo Ishii [Sun, 9 Jan 2000 12:15:57 +0000 (12:15 +0000)]
Move SetPidFile() and firends to utils/init/miscinit.c from
postmaster/postmaster.c so that
tcop/postgres.c can use them. Now we have an interlock between
postmaster and postgres.
Tatsuo Ishii [Sun, 9 Jan 2000 12:13:24 +0000 (12:13 +0000)]
Move SetPidFile() and firends to utils/init/miscinit.c so that
tcop/postgres.c can use them. Now we have an interlock between
postmaster and postgres.
Tatsuo Ishii [Sun, 9 Jan 2000 12:06:52 +0000 (12:06 +0000)]
Add more portability to echo -n (code stolen from createlang)
Do not start postmaster if postgres is running
Tom Lane [Sun, 9 Jan 2000 07:54:00 +0000 (07:54 +0000)]
New scheme for managing platform-specific regress test result files.
Instead of hard-wiring one result file per platform, there is a map file
'resultmap' that says which one to use --- a lot like template/.similar.
I have only created entries in resultmap for my own platform (HPUX) so
far; feel free to add lines for other platforms.
Tom Lane [Sun, 9 Jan 2000 06:34:46 +0000 (06:34 +0000)]
Remove obsolete platform-specific comparison files.
Tom Lane [Sun, 9 Jan 2000 06:32:33 +0000 (06:32 +0000)]
First examples of multiplatform result comparison files.
Tom Lane [Sun, 9 Jan 2000 06:30:55 +0000 (06:30 +0000)]
Remove obsolete platform-specific regress test comparison files.
Note: don't put any of these back till you've grokked the new code for
platform-specific comparisons that I'm about to commit...
Tom Lane [Sun, 9 Jan 2000 04:01:49 +0000 (04:01 +0000)]
Remove CVS $Header lines from a couple of regress test files that had
them --- it is just *way* too painful to keep expected results in sync
when these are present.
Tom Lane [Sun, 9 Jan 2000 03:50:27 +0000 (03:50 +0000)]
Update remaining tests for new psql, with the exception of 'arrays'.
Tom Lane [Sun, 9 Jan 2000 03:48:39 +0000 (03:48 +0000)]
Update remaining tests for new psql, with the exception of 'arrays',
which is broken in some weird way that I don't understand. I think it
may be exposing a bug in the new psql --- for one thing, I get different
results when I run psql by hand than the regress script gets. What
the heck???
Tom Lane [Sun, 9 Jan 2000 02:48:01 +0000 (02:48 +0000)]
Fix some missing substitutions of _OBJWD_ and _DLSUFFIX_.
Tom Lane [Sun, 9 Jan 2000 00:26:47 +0000 (00:26 +0000)]
Another round of planner/optimizer work. This is just restructuring and
code cleanup; no major improvements yet. However, EXPLAIN does produce
more intuitive outputs for nested loops with indexscans now...
Bruce Momjian [Sat, 8 Jan 2000 22:58:03 +0000 (22:58 +0000)]
This patch removes the initialization of ri in loop in
quote_postgres(...) in ecpglib.c.
The code in CVS reads:
quote_postgres(char *arg, int lineno)
{
char *res = (char *) ecpg_alloc(2 * strlen(arg) + 3, lineno);
int i,
ri = 0;
if (!res)
return (res);
res[ri++] = '\'';
for (i = 0, ri=0; arg[i]; i++, ri++)
{
switch (arg[i])
{
case '\'':
res[ri++] = '\'';
break;
case '\\':
res[ri++] = '\\';
break;
default:
;
}
The problem here is that ri is reset to 0, thus overwriting the initial
quote.
Stephen Birch
Tom Lane [Sat, 8 Jan 2000 21:59:55 +0000 (21:59 +0000)]
Modify PageIsEmpty and PageGetMaxOffsetNumber macros to behave sanely
if presented an uninitialized (all zeroes) page. The system no longer
crashes hard if an all-zeroes page is present in a relation. There seem
to be some boundary conditions where a page will be appended to a relation
and zeroed, but its page header is never initialized; until we can track
down and fix all of those, robustness seems like a good idea.
Also, clean up some obsolete and downright wrong comments.
Tom Lane [Sat, 8 Jan 2000 21:24:49 +0000 (21:24 +0000)]
Need defense against oversize index entries in btree CREATE INDEX,
as well as when inserting entries into an existing index.
Bruce Momjian [Fri, 7 Jan 2000 17:22:47 +0000 (17:22 +0000)]
Sorry, that I send this letter/patch again, but previous sending is
still
without answer. I want continue with to_char(), but I need any answer
for this patch. Please.
Thank! (and sorry of my impatient :-)
Karel
Tatsuo Ishii [Fri, 7 Jan 2000 09:28:03 +0000 (09:28 +0000)]
Correct grammatical error
Michael Meskes [Fri, 7 Jan 2000 08:01:18 +0000 (08:01 +0000)]
*** empty log message ***
Bruce Momjian [Thu, 6 Jan 2000 21:16:18 +0000 (21:16 +0000)]
Update pg_dumpall for new psql format.
Jan Wieck [Thu, 6 Jan 2000 20:47:01 +0000 (20:47 +0000)]
Changed "triggered data change violation" detection code
in trigger manager.
Jan
Jan Wieck [Thu, 6 Jan 2000 16:30:43 +0000 (16:30 +0000)]
Fixed bug in targetlist expression replacement of
SET DEFAULT referential action triggers.
Jan
Thomas G. Lockhart [Thu, 6 Jan 2000 06:41:55 +0000 (06:41 +0000)]
Clean up header for uniform appearance throughout tests.
Thomas G. Lockhart [Thu, 6 Jan 2000 06:40:54 +0000 (06:40 +0000)]
Update for new psql formatting.
Thomas G. Lockhart [Thu, 6 Jan 2000 06:40:18 +0000 (06:40 +0000)]
Freshen up the banner displayed when running the regression test.
Bruce Momjian [Wed, 5 Jan 2000 18:23:54 +0000 (18:23 +0000)]
Fix it's and its to be correct.
Thomas G. Lockhart [Wed, 5 Jan 2000 17:32:29 +0000 (17:32 +0000)]
Update format to add uniform headers on files.
Thomas G. Lockhart [Wed, 5 Jan 2000 17:32:18 +0000 (17:32 +0000)]
Update format to add uniform headers on files.
Update output to new psql conventions.
Thomas G. Lockhart [Wed, 5 Jan 2000 17:31:08 +0000 (17:31 +0000)]
Update output to new psql conventions.
Thomas G. Lockhart [Wed, 5 Jan 2000 17:30:05 +0000 (17:30 +0000)]
Fix spaces in text message.
Thomas G. Lockhart [Wed, 5 Jan 2000 06:07:58 +0000 (06:07 +0000)]
Clean up format of tests.
Remove older "::" type coersion syntax in favor of extended SQL92 style.
Include a few new tests for datetime/timespan arithmetic.
Thomas G. Lockhart [Wed, 5 Jan 2000 06:06:23 +0000 (06:06 +0000)]
Verified output from new psql.
Include a few new tests for datetime/timespan arithmetic.
Thomas G. Lockhart [Wed, 5 Jan 2000 06:04:56 +0000 (06:04 +0000)]
Move numeric test to be near other numeric data types like int4 and float8.
Thomas G. Lockhart [Tue, 4 Jan 2000 16:21:02 +0000 (16:21 +0000)]
Clean up syntax to use SQL92-ish type coersion
rather than the Postgres "::" notation.
All of these tests have been completely inspected and give correct results.
Thomas G. Lockhart [Tue, 4 Jan 2000 16:19:34 +0000 (16:19 +0000)]
Match results with format from new psql.
All of these tests have been completely inspected and give correct results.
Thomas G. Lockhart [Tue, 4 Jan 2000 07:53:27 +0000 (07:53 +0000)]
Repair two recently reported problems:
1) datetime_pl_span() added the seconds field before adding the months
field. This lead to erroneous results for e.g.
select datetime '1999-11-30' + timespan '1 mon - 1 sec';
Reverse the order of operations to add months first.
2) tm2timespan() did all intermediate math as integer, converting to double
at the very end. This resulted in hidden overflows when given very large
integer days, hours, etc. For example,
select '74565 days'::timespan;
produced the wrong result. Change code to ensure that doubles are used
for intermediate calculations.
Thanks to Olivier PRENANT <ohp@pyrenet.fr> and
Tulassay Zsolt <zsolt@tek.bke.hu> for problem reports and to Tom Lane for
accurate analyses.
Bruce Momjian [Sun, 2 Jan 2000 02:32:37 +0000 (02:32 +0000)]
Update DATEDEBUG removal.
Bruce Momjian [Sun, 2 Jan 2000 02:11:08 +0000 (02:11 +0000)]
Update length of timestamp to 30.
Bruce Momjian [Sun, 2 Jan 2000 01:37:28 +0000 (01:37 +0000)]
Remove DATEDEBUG because it didn't look Y2K safe, and fix timestamp elog
to be Y2K safe.