OSDN Git Service
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.
Tatsuo Ishii [Tue, 18 Jan 2000 05:10:29 +0000 (05:10 +0000)]
Add builtin functions:
pg_char_to_encoding()
pg_encoding_to_char()
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.
Tatsuo Ishii [Tue, 18 Jan 2000 03:01:40 +0000 (03:01 +0000)]
Fix multibyte support
Tatsuo Ishii [Tue, 18 Jan 2000 03:00:37 +0000 (03:00 +0000)]
Adopt for new psql
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.
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.
Tom Lane [Mon, 17 Jan 2000 04:47:05 +0000 (04:47 +0000)]
Correct minor typos.
Bruce Momjian [Mon, 17 Jan 2000 04:43:56 +0000 (04:43 +0000)]
Update subquery error message.
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.
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/.
Bruce Momjian [Mon, 17 Jan 2000 02:43:13 +0000 (02:43 +0000)]
Update TODO list.
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.
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?
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.
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.
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.
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.
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.
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.
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.
Tom Lane [Sun, 16 Jan 2000 20:34:54 +0000 (20:34 +0000)]
Put back change to 'connection failed' message formatting that someone
overwrote.
Peter Eisentraut [Sun, 16 Jan 2000 20:08:45 +0000 (20:08 +0000)]
Removed lextest, because lex'ed files are now in the distribution.
Peter Eisentraut [Sun, 16 Jan 2000 20:05:00 +0000 (20:05 +0000)]
Included all yacc and lex files into the distribution.
Tom Lane [Sun, 16 Jan 2000 19:57:48 +0000 (19:57 +0000)]
Add check that inherited constraints and defaults work.
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.
Tom Lane [Sun, 16 Jan 2000 08:21:59 +0000 (08:21 +0000)]
Fix broken FOR UPDATE error message.
Bruce Momjian [Sun, 16 Jan 2000 07:05:35 +0000 (07:05 +0000)]
Update TODO list.
Bruce Momjian [Sun, 16 Jan 2000 05:18:19 +0000 (05:18 +0000)]
Fix passing of atttypmod that Tom found.
Bruce Momjian [Sun, 16 Jan 2000 05:18:07 +0000 (05:18 +0000)]
Update TODO list.
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??)
Bruce Momjian [Sun, 16 Jan 2000 02:35:30 +0000 (02:35 +0000)]
Update TODO list.
Bruce Momjian [Sun, 16 Jan 2000 02:32:13 +0000 (02:32 +0000)]
Update TODO list.
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.
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.
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().
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.