]> granicus.if.org Git - postgresql/log
postgresql
24 years agoRemove compiler warnings
Tatsuo Ishii [Tue, 18 Jan 2000 05:14:24 +0000 (05:14 +0000)]
Remove compiler warnings

24 years agoShow encoding name rather than encoding id in case of psql -l.
Tatsuo Ishii [Tue, 18 Jan 2000 05:11:38 +0000 (05:11 +0000)]
Show encoding name rather than encoding id in case of psql -l.

24 years agoAdd builtin functions:
Tatsuo Ishii [Tue, 18 Jan 2000 05:10:29 +0000 (05:10 +0000)]
Add builtin functions:
pg_char_to_encoding()
pg_encoding_to_char()

24 years agonumeric_in accepts exponents; numeric to int4 rounds; float4/8 to numeric
Tom Lane [Tue, 18 Jan 2000 03:44:41 +0000 (03:44 +0000)]
numeric_in accepts exponents; numeric to int4 rounds; float4/8 to numeric
is considerably more robust and accurate than it used to be.
Also, get rid of numeric's private allocation freelist, which is no longer
a win since Jan rewrote palloc.

24 years agoFix multibyte support
Tatsuo Ishii [Tue, 18 Jan 2000 03:01:40 +0000 (03:01 +0000)]
Fix multibyte support

24 years agoAdopt for new psql
Tatsuo Ishii [Tue, 18 Jan 2000 03:00:37 +0000 (03:00 +0000)]
Adopt for new psql

24 years agoUpdated user interfaces on initdb, initlocation, pg_dump, ipcclean to a GNU-compliant...
Peter Eisentraut [Tue, 18 Jan 2000 00:03:37 +0000 (00:03 +0000)]
Updated user interfaces on initdb, initlocation, pg_dump, ipcclean to a GNU-compliant'ish state.
Made ipcclean work on Linux.

24 years agosetheapoverride() is history. Uses replaced with CommandCounterIncrement()
Tom Lane [Mon, 17 Jan 2000 23:57:48 +0000 (23:57 +0000)]
setheapoverride() is history.  Uses replaced with CommandCounterIncrement()
where necessary --- several of them didn't really need it, though.
tqual-checking macros simplified accordingly.

24 years agoCorrect minor typos.
Tom Lane [Mon, 17 Jan 2000 04:47:05 +0000 (04:47 +0000)]
Correct minor typos.

24 years agoUpdate subquery error message.
Bruce Momjian [Mon, 17 Jan 2000 04:43:56 +0000 (04:43 +0000)]
Update subquery error message.

24 years agoAdd .cvsignore so cvs update doesn't complain about derived
Tom Lane [Mon, 17 Jan 2000 04:38:49 +0000 (04:38 +0000)]
Add .cvsignore so cvs update doesn't complain about derived
files being left around.

24 years agoModify libpq's pqexpbuffer to eliminate length restriction on how much
Tom Lane [Mon, 17 Jan 2000 02:59:46 +0000 (02:59 +0000)]
Modify libpq's pqexpbuffer to eliminate length restriction on how much
data can be formatted per call.  This requires relying on vsnprintf().
On machines that haven't got vsnprintf, link in the version from
backend/port/.

24 years agoUpdate TODO list.
Bruce Momjian [Mon, 17 Jan 2000 02:43:13 +0000 (02:43 +0000)]
Update TODO list.

24 years agoPass atttypmod to CoerceTargetExpr, so that it can pass it on to
Tom Lane [Mon, 17 Jan 2000 02:04:16 +0000 (02:04 +0000)]
Pass atttypmod to CoerceTargetExpr, so that it can pass it on to
coerce_type, so that the right things happen when coercing a previously-
unknown constant to a destination data type.

24 years agoHmm, numeric array type was missing too. Added.
Tom Lane [Mon, 17 Jan 2000 01:29:07 +0000 (01:29 +0000)]
Hmm, numeric array type was missing too.  Added.
Of the standard types, only 'timestamp' seems not to have an array type;
should it be added, or are we going to remove that type for 7.0 anyway?

24 years agoFix for TODO item * spinlock stuck problem when elog(FATAL)
Hiroshi Inoue [Mon, 17 Jan 2000 01:15:19 +0000 (01:15 +0000)]
Fix for TODO item * spinlock stuck problem when elog(FATAL)
and elog(ERROR) inside bufmgr.

24 years agoUpdate unused_oids script so it works with non-GNU awk --- /* ... */
Tom Lane [Mon, 17 Jan 2000 00:53:11 +0000 (00:53 +0000)]
Update unused_oids script so it works with non-GNU awk --- /* ... */
comment style apparently isn't portable to other awks.

24 years agoApparently, no one's ever used float4abs(), because it's got incorrect
Tom Lane [Mon, 17 Jan 2000 00:40:51 +0000 (00:40 +0000)]
Apparently, no one's ever used float4abs(), because it's got incorrect
data in its pg_proc entry.  abs() doesn't require two arguments, last
I heard.

24 years agoUpdate strings test to reflect the fact that casting to char() will
Tom Lane [Mon, 17 Jan 2000 00:16:41 +0000 (00:16 +0000)]
Update strings test to reflect the fact that casting to char() will
now truncate or pad to the specified length.

24 years agoCreate a new parsetree node type, TypeCast, so that transformation of
Tom Lane [Mon, 17 Jan 2000 00:14:49 +0000 (00:14 +0000)]
Create a new parsetree node type, TypeCast, so that transformation of
SQL cast constructs can be performed during expression transformation
instead of during parsing.  This allows constructs like x::numeric(9,2)
and x::int2::float8 to behave as one would expect.

24 years agoRearrange coding in COPY so that expansible string buffer for data being
Tom Lane [Sun, 16 Jan 2000 21:37:50 +0000 (21:37 +0000)]
Rearrange coding in COPY so that expansible string buffer for data being
read is reused for successive attributes, instead of being deleted and
recreated from scratch for each value read in.  This reduces palloc/pfree
overhead a lot.  COPY IN still seems to be noticeably slower than it was
in 6.5 --- we need to figure out why.  This change takes care of the only
major performance loss I can see in copy.c itself, so the performance
problem is at a lower level somewhere.

24 years agoSigh, I'm an idiot ... I broke the async startup logic a couple days ago,
Tom Lane [Sun, 16 Jan 2000 21:18:52 +0000 (21:18 +0000)]
Sigh, I'm an idiot ... I broke the async startup logic a couple days ago,
by creating a race condition.  It wasn't waiting for select() to say
write-ready immediately after connect, which meant that you might get
an unhelpful 'broken pipe' error message if connect failed, rather than
the intended error message.

24 years agoPut back change to 'connection failed' message formatting that someone
Tom Lane [Sun, 16 Jan 2000 20:34:54 +0000 (20:34 +0000)]
Put back change to 'connection failed' message formatting that someone
overwrote.

24 years agoRemoved lextest, because lex'ed files are now in the distribution.
Peter Eisentraut [Sun, 16 Jan 2000 20:08:45 +0000 (20:08 +0000)]
Removed lextest, because lex'ed files are now in the distribution.

24 years agoIncluded all yacc and lex files into the distribution.
Peter Eisentraut [Sun, 16 Jan 2000 20:05:00 +0000 (20:05 +0000)]
Included all yacc and lex files into the distribution.

24 years agoAdd check that inherited constraints and defaults work.
Tom Lane [Sun, 16 Jan 2000 19:57:48 +0000 (19:57 +0000)]
Add check that inherited constraints and defaults work.

24 years agoRepair breakage of inherited constraint expressions --- needed a
Tom Lane [Sun, 16 Jan 2000 19:57:00 +0000 (19:57 +0000)]
Repair breakage of inherited constraint expressions --- needed a
CommandCounterIncrement to make new relation visible before trying to
parse/deparse the expressions.  Also, eliminate unnecessary
setheapoverride calls in AddNewAttributeTuples.

24 years agoFix broken FOR UPDATE error message.
Tom Lane [Sun, 16 Jan 2000 08:21:59 +0000 (08:21 +0000)]
Fix broken FOR UPDATE error message.

24 years agoUpdate TODO list.
Bruce Momjian [Sun, 16 Jan 2000 07:05:35 +0000 (07:05 +0000)]
Update TODO list.

24 years agoFix passing of atttypmod that Tom found.
Bruce Momjian [Sun, 16 Jan 2000 05:18:19 +0000 (05:18 +0000)]
Fix passing of atttypmod that Tom found.

24 years agoUpdate TODO list.
Bruce Momjian [Sun, 16 Jan 2000 05:18:07 +0000 (05:18 +0000)]
Update TODO list.

24 years agoClean up pg_dump coredumps caused by change of output formatting for
Tom Lane [Sun, 16 Jan 2000 03:54:58 +0000 (03:54 +0000)]
Clean up pg_dump coredumps caused by change of output formatting for
oidvector/int2vector.  pg_dump code was assuming that it would see
exactly FUNC_MAX_ARGS integers in the string returned by the backend.
That's no longer true.  (Perhaps that change wasn't such a good idea
after all --- will it break any other applications??)

24 years agoUpdate TODO list.
Bruce Momjian [Sun, 16 Jan 2000 02:35:30 +0000 (02:35 +0000)]
Update TODO list.

24 years agoUpdate TODO list.
Bruce Momjian [Sun, 16 Jan 2000 02:32:13 +0000 (02:32 +0000)]
Update TODO list.

24 years agoAdd some examples to numeric regress test to verify that recently-fixed
Tom Lane [Sat, 15 Jan 2000 23:44:17 +0000 (23:44 +0000)]
Add some examples to numeric regress test to verify that recently-fixed
problems are indeed fixed.

24 years agoClean up problems with rounding/overflow code in NUMERIC, particularly
Tom Lane [Sat, 15 Jan 2000 23:42:49 +0000 (23:42 +0000)]
Clean up problems with rounding/overflow code in NUMERIC, particularly
the case wherein zero was rejected for a field like NUMERIC(4,4).
Miscellaneous other code beautification efforts.

24 years agoFix a passel of problems with incorrect calls to typinput and typoutput
Tom Lane [Sat, 15 Jan 2000 22:43:25 +0000 (22:43 +0000)]
Fix a passel of problems with incorrect calls to typinput and typoutput
functions, which would lead to trouble with datatypes that paid attention
to the typelem or typmod parameters to these functions.  In particular,
incorrect code in pg_aggregate.c explains the platform-specific failures
that have been reported in NUMERIC avg().

24 years agoUpdate TODO list.
Bruce Momjian [Sat, 15 Jan 2000 19:32:06 +0000 (19:32 +0000)]
Update TODO list.

24 years agoNow that new psql is fflush()'ing properly, it emerges that several
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.

24 years agoUpdate arrays regress test to reflect fact that several things
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.

24 years ago- Allow array on int8
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

24 years agoAdd pgench: a TPC-B like benchmarking tool
Tatsuo Ishii [Sat, 15 Jan 2000 12:38:09 +0000 (12:38 +0000)]
Add pgench: a TPC-B like benchmarking tool

24 years agoAdapt to the changes of libpq(eliminateing using putenv()).
Tatsuo Ishii [Sat, 15 Jan 2000 05:38:50 +0000 (05:38 +0000)]
Adapt to the changes of libpq(eliminateing using putenv()).

24 years agoEliminate using putenv().
Tatsuo Ishii [Sat, 15 Jan 2000 05:37:21 +0000 (05:37 +0000)]
Eliminate using putenv().

24 years agoPrepare for new psql
Tatsuo Ishii [Sat, 15 Jan 2000 05:17:45 +0000 (05:17 +0000)]
Prepare for new psql

24 years agoFixed all elog related warnings, as well as a few others.
Peter Eisentraut [Sat, 15 Jan 2000 02:59:43 +0000 (02:59 +0000)]
Fixed all elog related warnings, as well as a few others.

24 years agoFixed psql variables vs array syntax, as well as minor psql enhancements
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

24 years ago* User management commands no longer user pg_exec_query_dest -> more robust
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.

24 years agoClean up some problems in new asynchronous-connection logic
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.

24 years agoMake PSQLexec's behavior on loss of connection more reasonable;
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.

24 years agoMake connection-failed messages a little friendlier on
Tom Lane [Fri, 14 Jan 2000 04:01:55 +0000 (04:01 +0000)]
Make connection-failed messages a little friendlier on
80-column displays...

24 years agoRemove redundant and now-incorrect declaration of pstrdup.
Tom Lane [Fri, 14 Jan 2000 01:36:42 +0000 (01:36 +0000)]
Remove redundant and now-incorrect declaration of pstrdup.

24 years agoUpdate TODO list.
Bruce Momjian [Fri, 14 Jan 2000 01:10:22 +0000 (01:10 +0000)]
Update TODO list.

24 years agoBump catversion to ensure initdb.
Tom Lane [Fri, 14 Jan 2000 00:53:50 +0000 (00:53 +0000)]
Bump catversion to ensure initdb.

24 years agoRevise quoting conventions in outfuncs/readfuncs so that nodeRead doesn't
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.

24 years agoFixed everything in and surrounding createdb and dropdb to make it more
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.

24 years agoinitdb didn't load pg_description
Peter Eisentraut [Thu, 13 Jan 2000 18:22:10 +0000 (18:22 +0000)]
initdb didn't load pg_description

24 years agoUpdate TODO list.
Bruce Momjian [Thu, 13 Jan 2000 13:22:05 +0000 (13:22 +0000)]
Update TODO list.

24 years agoUpdate TODO list.
Bruce Momjian [Thu, 13 Jan 2000 03:39:45 +0000 (03:39 +0000)]
Update TODO list.

24 years agoUpdate TODO list.
Bruce Momjian [Thu, 13 Jan 2000 03:36:42 +0000 (03:36 +0000)]
Update TODO list.

24 years agoUpdate TODO list.
Bruce Momjian [Thu, 13 Jan 2000 03:06:29 +0000 (03:06 +0000)]
Update TODO list.

24 years agoUpdate TODO list.
Bruce Momjian [Thu, 13 Jan 2000 02:38:21 +0000 (02:38 +0000)]
Update TODO list.

24 years agoUpdate TODO list.
Bruce Momjian [Thu, 13 Jan 2000 01:57:04 +0000 (01:57 +0000)]
Update TODO list.

24 years agoUpdate TODO list.
Bruce Momjian [Thu, 13 Jan 2000 01:48:46 +0000 (01:48 +0000)]
Update TODO list.

24 years agoAdd UDC (User Defined Characters) support to SJIS/EUC_JP conversion
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)

24 years agoFixed a few "fixes" and bugs. Adjusted messages and options to GNU suggestions.
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.

24 years agoMulti-byte case fix by Oliver Elphick (olly@lfix.co.uk)
Tatsuo Ishii [Wed, 12 Jan 2000 13:08:55 +0000 (13:08 +0000)]
Multi-byte case fix by Oliver Elphick (olly@lfix.co.uk)

24 years agoUse fmgr_array_args() to avoid dependency on FUNC_MAX_ARGS.
Tom Lane [Wed, 12 Jan 2000 05:28:47 +0000 (05:28 +0000)]
Use fmgr_array_args() to avoid dependency on FUNC_MAX_ARGS.

24 years agoIn PQfn(), defend against too many args, and avoid dependency
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.

24 years agoRemoveFunction didn't defend against too many args.
Tom Lane [Wed, 12 Jan 2000 05:25:09 +0000 (05:25 +0000)]
RemoveFunction didn't defend against too many args.

24 years agoDefend against > INDEX_MAX_KEYS keys in an index.
Tom Lane [Wed, 12 Jan 2000 05:04:42 +0000 (05:04 +0000)]
Defend against > INDEX_MAX_KEYS keys in an index.

24 years agoCommentProc was careless about too many arguments.
Tom Lane [Wed, 12 Jan 2000 04:59:41 +0000 (04:59 +0000)]
CommentProc was careless about too many arguments.

24 years agoPut back erroneously removed zeroing of sentinel elements
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.

24 years agoUpdate TODO list.
Bruce Momjian [Tue, 11 Jan 2000 12:11:20 +0000 (12:11 +0000)]
Update TODO list.

24 years agoMake FUNC_MAX_ARGS equal INDEX_MAX_KEYS, as it should.
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.

24 years agooid8 => oidvector in alter_table regress test
Tom Lane [Tue, 11 Jan 2000 05:56:33 +0000 (05:56 +0000)]
oid8 => oidvector in alter_table regress test

24 years agoAnother FUNC_MAX_ARGS tweak.
Tom Lane [Tue, 11 Jan 2000 05:41:49 +0000 (05:41 +0000)]
Another FUNC_MAX_ARGS tweak.

24 years agoUpdate struct Trigger definition.
Tom Lane [Tue, 11 Jan 2000 05:37:11 +0000 (05:37 +0000)]
Update struct Trigger definition.

24 years agoWrong boundary condition on number-of-args check.
Tom Lane [Tue, 11 Jan 2000 05:22:25 +0000 (05:22 +0000)]
Wrong boundary condition on number-of-args check.

24 years agoAh-hah, there are attribute size constants lurking here too.
Tom Lane [Tue, 11 Jan 2000 05:18:42 +0000 (05:18 +0000)]
Ah-hah, there are attribute size constants lurking here too.

24 years agoUse symbolic INDEX_MAX_KEYS in pg_type entries for oidvector
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.

24 years agoCorrect hardwired type information in bootstrap.
Tom Lane [Tue, 11 Jan 2000 04:00:30 +0000 (04:00 +0000)]
Correct hardwired type information in bootstrap.

24 years agoRemove no-longer-used symbols.
Tom Lane [Tue, 11 Jan 2000 03:59:31 +0000 (03:59 +0000)]
Remove no-longer-used symbols.

24 years agoMore cleanups. Still doesn't work.
Bruce Momjian [Tue, 11 Jan 2000 03:33:14 +0000 (03:33 +0000)]
More cleanups.  Still doesn't work.

24 years agoMore cleanups.
Bruce Momjian [Tue, 11 Jan 2000 02:46:48 +0000 (02:46 +0000)]
More cleanups.

24 years agoMore fixes, but still need +1 for FUNC_MAX_ARGS
Bruce Momjian [Tue, 11 Jan 2000 02:30:06 +0000 (02:30 +0000)]
More fixes, but still need +1 for FUNC_MAX_ARGS

24 years agoRemove outdated comment about 8 arguments.
Tom Lane [Tue, 11 Jan 2000 01:42:08 +0000 (01:42 +0000)]
Remove outdated comment about 8 arguments.

24 years agoChange oid8/int28 -> oidvector/int2vector.
Tom Lane [Tue, 11 Jan 2000 01:40:04 +0000 (01:40 +0000)]
Change oid8/int28 -> oidvector/int2vector.

24 years agoFix initdb so it works, but still only for 8.
Bruce Momjian [Mon, 10 Jan 2000 23:03:41 +0000 (23:03 +0000)]
Fix initdb so it works, but still only for 8.

24 years agoUpdate type stuff.
Bruce Momjian [Mon, 10 Jan 2000 20:46:23 +0000 (20:46 +0000)]
Update type stuff.

24 years agoCleanup for func args > 8.
Bruce Momjian [Mon, 10 Jan 2000 20:23:31 +0000 (20:23 +0000)]
Cleanup for func args > 8.

24 years agoMore updates for function call interface > 8.
Bruce Momjian [Mon, 10 Jan 2000 18:27:41 +0000 (18:27 +0000)]
More updates for function call interface > 8.

24 years agoUpdate fmgr to allow 32 arguments.
Bruce Momjian [Mon, 10 Jan 2000 18:18:30 +0000 (18:18 +0000)]
Update fmgr to allow 32 arguments.

24 years agoMake number of args to a function configurable.
Bruce Momjian [Mon, 10 Jan 2000 17:14:46 +0000 (17:14 +0000)]
Make number of args to a function configurable.

24 years agoRename oid8 -> oidvector and int28 -> int2vector. Cleanup of *out functions.
Bruce Momjian [Mon, 10 Jan 2000 16:13:23 +0000 (16:13 +0000)]
Rename oid8 -> oidvector and int28 -> int2vector.  Cleanup of *out functions.

24 years agoUpdate int28out and out8out and _in_ functions to handle trailing zeros
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.

24 years agoUpdate TODO list.
Bruce Momjian [Mon, 10 Jan 2000 13:20:57 +0000 (13:20 +0000)]
Update TODO list.

24 years agoImprove cache invalidation handling. Eespecially
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

24 years agoFix oid8in and int28in for spaces
Bruce Momjian [Mon, 10 Jan 2000 05:23:47 +0000 (05:23 +0000)]
Fix oid8in and int28in for spaces

24 years agoMove fixes for >8 indexed fields.
Bruce Momjian [Mon, 10 Jan 2000 05:20:26 +0000 (05:20 +0000)]
Move fixes for >8 indexed fields.