OSDN Git Service
Bruce Momjian [Sat, 15 Jan 2000 19:32:06 +0000 (19:32 +0000)]
Update TODO list.
Tom Lane [Sat, 15 Jan 2000 19:18:24 +0000 (19:18 +0000)]
Now that new psql is fflush()'ing properly, it emerges that several
regress test expected outputs were committed with NOTICEs appearing out
of order. Update to correct results.
Tom Lane [Sat, 15 Jan 2000 19:11:40 +0000 (19:11 +0000)]
Update arrays regress test to reflect fact that several things
work now that did not work in 6.5.
Peter Eisentraut [Sat, 15 Jan 2000 18:30:35 +0000 (18:30 +0000)]
- Allow array on int8
- Prevent permissions on indexes
- Instituted --enable-multibyte option and tweaked the MB build process where necessary
- initdb prompts for superuser password
Tatsuo Ishii [Sat, 15 Jan 2000 12:38:09 +0000 (12:38 +0000)]
Add pgench: a TPC-B like benchmarking tool
Tatsuo Ishii [Sat, 15 Jan 2000 05:38:50 +0000 (05:38 +0000)]
Adapt to the changes of libpq(eliminateing using putenv()).
Tatsuo Ishii [Sat, 15 Jan 2000 05:37:21 +0000 (05:37 +0000)]
Eliminate using putenv().
Tatsuo Ishii [Sat, 15 Jan 2000 05:17:45 +0000 (05:17 +0000)]
Prepare for new psql
Peter Eisentraut [Sat, 15 Jan 2000 02:59:43 +0000 (02:59 +0000)]
Fixed all elog related warnings, as well as a few others.
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.