OSDN Git Service
Bruce Momjian [Sat, 22 Sep 2001 21:36:38 +0000 (21:36 +0000)]
Fix 6.4.* release dates, pointed out by Tom Lane.
Tatsuo Ishii [Sat, 22 Sep 2001 08:47:20 +0000 (08:47 +0000)]
Fix expected files.
Tatsuo Ishii [Sat, 22 Sep 2001 08:44:49 +0000 (08:44 +0000)]
Remove test drivers
Also fix comment in conv.c.
Bruce Momjian [Sat, 22 Sep 2001 04:28:12 +0000 (04:28 +0000)]
sbasename $0 is now basename "$0"
Bruce Momjian [Sat, 22 Sep 2001 03:59:17 +0000 (03:59 +0000)]
WAL file numbers: Sequenatial -> ever-increasing
Tatsuo Ishii [Sat, 22 Sep 2001 03:30:39 +0000 (03:30 +0000)]
Make trim/ltrim/rtrim/btrim multibyte aware
(previous commit was missing commit messages)
Tatsuo Ishii [Sat, 22 Sep 2001 03:26:30 +0000 (03:26 +0000)]
*** empty log message ***
Peter Eisentraut [Fri, 21 Sep 2001 23:20:02 +0000 (23:20 +0000)]
Suggest running ldconfig after installation if available.
Peter Eisentraut [Fri, 21 Sep 2001 21:58:30 +0000 (21:58 +0000)]
For consistency with the rest of PostgreSQL, rename BLOBs to large objects
in messages and documentation.
Tom Lane [Fri, 21 Sep 2001 21:10:56 +0000 (21:10 +0000)]
Add 'reload' option to pg_ctl to send SIGHUP to the post
Tom Lane [Fri, 21 Sep 2001 20:31:49 +0000 (20:31 +0000)]
Code review for MD5 authorization patch. Clean up some breakage
(salts were always zero!?), add much missing documentation.
Peter Eisentraut [Fri, 21 Sep 2001 18:37:05 +0000 (18:37 +0000)]
Readd test/regress/README file, this time with a well-defined and simple
rule to remake it when necessary.
Tom Lane [Fri, 21 Sep 2001 17:06:12 +0000 (17:06 +0000)]
Add an overall timeout on the client authentication cycle, so that
a hung client or lost connection can't indefinitely block a postmaster
child (not to mention the possibility of deliberate DoS attacks).
Timeout is controlled by new authentication_timeout GUC variable,
which I set to 60 seconds by default ... does that seem reasonable?
Tom Lane [Fri, 21 Sep 2001 15:27:38 +0000 (15:27 +0000)]
Fix type_maximum_size() to give the right answer in MULTIBYTE cases.
Avoid use of prototype-less function pointers in MB code.
Hiroshi Inoue [Fri, 21 Sep 2001 07:51:52 +0000 (07:51 +0000)]
1) Avoid an overflow of connection string for Access(Microsoft Jet).
2) Change to retry lower version in case of "Unsupported frontend
procotol".
Tom Lane [Fri, 21 Sep 2001 04:06:04 +0000 (04:06 +0000)]
Produce slightly saner-looking EXPLAIN output for a Result node.
Tom Lane [Fri, 21 Sep 2001 03:32:36 +0000 (03:32 +0000)]
Give VACUUM its own GUC parameter for memory usage, rather than
piggybacking on SortMem. Add documentation for some recently-added
GUC parameters that had so far escaped it.
Tom Lane [Fri, 21 Sep 2001 00:11:31 +0000 (00:11 +0000)]
Quick-and-dirty fix for recursive plpgsql functions, per bug report from
Frank Miles 7-Sep-01. This is really just sticking a finger in the dike.
Frank's case works now, but we still couldn't support a recursive function
returning a set. Really need to restructure querytrees and execution
state so that the querytree is *read only*. We've run into this over and
over and over again ... it has to happen sometime soon.
Tom Lane [Thu, 20 Sep 2001 23:31:08 +0000 (23:31 +0000)]
Suppress gcc warning.
Tom Lane [Thu, 20 Sep 2001 21:07:57 +0000 (21:07 +0000)]
Remove some dead code and obsolete, misleading comments.
Peter Eisentraut [Thu, 20 Sep 2001 16:41:26 +0000 (16:41 +0000)]
Document the sign() function.
Peter Eisentraut [Thu, 20 Sep 2001 14:20:28 +0000 (14:20 +0000)]
Provide tunable knob for x = NULL -> x IS NULL transformation, default to off.
Peter Eisentraut [Wed, 19 Sep 2001 21:28:55 +0000 (21:28 +0000)]
Remove old file.
D'Arcy J.M. Cain [Wed, 19 Sep 2001 18:58:47 +0000 (18:58 +0000)]
Change the version. We are moving towards the next release.
Fixed a nasty bug that messed up negative money amounts.
Peter Eisentraut [Wed, 19 Sep 2001 15:19:12 +0000 (15:19 +0000)]
Avoid unnecessary strcasecmp -- replace by strcmp. Fixes reported bug
that made setting serializable isolation level impossible in Turkish
locale.
Michael Meskes [Wed, 19 Sep 2001 14:09:32 +0000 (14:09 +0000)]
- Synced preproc.y with gram.y.
- Synced pgc.l with scan.l.
- Synced keyword.c.
- Include the remaining patches by Christof Petig <christof.petig@wtal.de>.
Peter Eisentraut [Wed, 19 Sep 2001 09:48:42 +0000 (09:48 +0000)]
Replace useless strcasecmp's by strcmp's.
Peter Eisentraut [Tue, 18 Sep 2001 12:08:27 +0000 (12:08 +0000)]
Generate index.html as the root file name of the documentation set,
rather than making index.html a symlink to the autogenerated name.
Fixes fatal problems with tar programs that don't handle symlinks
very well (MacOS X).
(The names user.html, admin.html, etc. are still available as make
targets, but they aren't packaged anymore.)
Use the manifest file that the stylesheets generate as the file list
for packaging. Put graphics in the right place while building, not
while packaging, so you can actually look at them after building.
Tom Lane [Tue, 18 Sep 2001 01:59:07 +0000 (01:59 +0000)]
EXPLAIN ANALYZE feature to measure and show actual runtimes and tuple
counts alongside the planner's estimates. By Martijn van Oosterhout,
with some further work by Tom Lane.
Peter Eisentraut [Mon, 17 Sep 2001 23:00:27 +0000 (23:00 +0000)]
Unify the zip rules and variables.
Tom Lane [Mon, 17 Sep 2001 20:05:47 +0000 (20:05 +0000)]
Fix bogus failure-return value from lo_create, per report from Gavin
Sherry. Also clean up leakage of open files and LOs in failure exits
from lo_import and lo_export.
Bruce Momjian [Mon, 17 Sep 2001 15:56:11 +0000 (15:56 +0000)]
Attached is a patch that fixes ResultSetMetaData.isNullable() in
the JDBC driver.
This method is currently unimplemented and always returns
ResultSetMetaData.columnNullable. This is obviously incorrect
when a column is defined with NOT NULL or PRIMARY KEY. And we
have to think of check constraints, views, functions etc.
The patch simply changes the return value to
ResultSetMetaData.columnNullableUnknown. This is until someone
comes up with a real implementation of course.
On Fri, 14 Sep 2001 17:53:50 +0200, Tomisaw Kity?ski wrote:
>Hello there,
>
>could someone tell me, please, do I have any chance to get
>proper implementation of above method in JDBC (1.1+) soon?
>
>Current "return 1" works fine on most tables, however it seems
>to be a little bit incorrect with some of them ;)
Ren? Pijlman
Bruce Momjian [Mon, 17 Sep 2001 15:54:50 +0000 (15:54 +0000)]
I'm attaching a patch which fixes the corruption in strings caused
by escape processing in the SQL statement. I've tested this for a
while now and it appears to work well. Previously string data
with {d was getting corrupt as the {d was being stripped regardless
of whether it was an escape code or not.
I also added checking for time and timestamp escape processing strings
as per 11.3 in the specification. The patch is against the latest
CVS.
Thomas O'Dowd
Hiroshi Inoue [Mon, 17 Sep 2001 02:30:54 +0000 (02:30 +0000)]
Change vacuumlo to take 'lo' type into account.
Hiroshi Inoue [Mon, 17 Sep 2001 02:07:51 +0000 (02:07 +0000)]
Change FixupBlobXrefs() to take 'lo' type into account.
Tom Lane [Mon, 17 Sep 2001 01:06:36 +0000 (01:06 +0000)]
Simplify and clean up FigureColname; make it work without coredumping
for TypeCast case.
Tom Lane [Mon, 17 Sep 2001 00:42:42 +0000 (00:42 +0000)]
Use portable putenv(), not unportable setenv().
Tom Lane [Mon, 17 Sep 2001 00:29:10 +0000 (00:29 +0000)]
Suppress compiler warning.
Tom Lane [Sun, 16 Sep 2001 23:52:29 +0000 (23:52 +0000)]
Update documentation's info about location of our CVSROOT.
Peter Eisentraut [Sun, 16 Sep 2001 23:10:16 +0000 (23:10 +0000)]
Russian translation from Serguei Mokhov
Peter Eisentraut [Sun, 16 Sep 2001 23:06:33 +0000 (23:06 +0000)]
Update from Serguei Mokhov
Peter Eisentraut [Sun, 16 Sep 2001 22:53:52 +0000 (22:53 +0000)]
Update intro in face of TOAST.
Peter Eisentraut [Sun, 16 Sep 2001 16:11:11 +0000 (16:11 +0000)]
Install dynamically loadable modules into a private subdirectory
under libdir, for a cleaner separation in the installation layout
and compatibility with binary packaging standards. Point backend's
default search location there. The contrib modules are also
installed in the said location, giving them the benefit of the
default search path as well. No changes in user interface
nevertheless.
Bruce Momjian [Sun, 16 Sep 2001 04:26:22 +0000 (04:26 +0000)]
Update highlights. More items to add.
Bruce Momjian [Sun, 16 Sep 2001 04:18:57 +0000 (04:18 +0000)]
Point to HISTORY File for current info.
Bruce Momjian [Sun, 16 Sep 2001 04:12:35 +0000 (04:12 +0000)]
Add list of 7.2 changes in preparation for beta.
Peter Eisentraut [Sat, 15 Sep 2001 19:56:59 +0000 (19:56 +0000)]
updates
Peter Eisentraut [Sat, 15 Sep 2001 16:08:59 +0000 (16:08 +0000)]
Markup examples as examples.
Peter Eisentraut [Sat, 15 Sep 2001 00:48:59 +0000 (00:48 +0000)]
Markup examples as examples. Fix formatting of examples.
Peter Eisentraut [Fri, 14 Sep 2001 20:37:55 +0000 (20:37 +0000)]
Some formatting changes, add CSS stylesheet. Include indexes in
documentation tarball builds.
Bruce Momjian [Fri, 14 Sep 2001 17:46:40 +0000 (17:46 +0000)]
> Here's a revised patch. Changes:
>
> 1. Now outputs '\\' instead of '\134' when using encode(bytea, 'escape')
> Note that I ended up leaving \0 as \000 so that there are no ambiguities
> when decoding something like, for example, \0123.
>
> 2. Fixed bug in byteain which allowed input values which were not valid
> octals (e.g. \789), to be parsed as if they were octals.
>
> Joe
>
Here's rev 2 of the bytea string support patch. Changes:
1. Added missing declaration for MatchBytea function
2. Added PQescapeBytea to fe-exec.c
3. Applies cleanly on cvs tip from this afternoon
I'm hoping that someone can review/approve/apply this before beta starts, so
I guess I'd vote (not that it counts for much) to delay beta a few days :-)
Joe Conway
Bruce Momjian [Fri, 14 Sep 2001 17:40:41 +0000 (17:40 +0000)]
Allow '1' in jdbc2 boolean test.
Tatsuo Ishii [Fri, 14 Sep 2001 10:36:52 +0000 (10:36 +0000)]
Remove --enable-unicode-conversion
unicode-conversion is always on if --enable-multibyte is specified
Tatsuo Ishii
Tatsuo Ishii [Fri, 14 Sep 2001 10:28:09 +0000 (10:28 +0000)]
Add semicolon
Tatsuo Ishii [Fri, 14 Sep 2001 10:24:35 +0000 (10:24 +0000)]
Fix typo.
Tatsuo Ishii [Fri, 14 Sep 2001 09:49:00 +0000 (09:49 +0000)]
Fix exmaple
Tatsuo Ishii
Tatsuo Ishii [Fri, 14 Sep 2001 08:47:00 +0000 (08:47 +0000)]
Fix show message
Tatsuo Ishii
Tatsuo Ishii [Fri, 14 Sep 2001 08:24:29 +0000 (08:24 +0000)]
Add semicolon
Tatsuo Ishii
Tatsuo Ishii [Fri, 14 Sep 2001 08:19:55 +0000 (08:19 +0000)]
Example rules do not work.
CREATE RULE bad_rule_combination_1 AS
ON SELECT TO emp
DO INSTEAD
SELECT * FROM toyemp;
CREATE RULE bad_rule_combination_2 AS
ON SELECT TO toyemp
DO INSTEAD
SELECT * FROM emp;
Tatsuo Ishii
Tatsuo Ishii [Fri, 14 Sep 2001 08:05:55 +0000 (08:05 +0000)]
Add semicolon
Tatsuo Ishii [Fri, 14 Sep 2001 07:59:31 +0000 (07:59 +0000)]
Add semicolon
Tatsuo Ishii
Hiroshi Inoue [Fri, 14 Sep 2001 06:46:45 +0000 (06:46 +0000)]
Change an *if condition*.
Hiroshi Inoue
Hiroshi Inoue [Fri, 14 Sep 2001 06:30:37 +0000 (06:30 +0000)]
1) Improve the implementation of *Disallow Premature* for
older versions of servers.
2) Implement SQLProcedures.
Hiroshi Inoue
Bruce Momjian [Fri, 14 Sep 2001 03:21:42 +0000 (03:21 +0000)]
Update TODO list.
Hiroshi Inoue [Fri, 14 Sep 2001 01:50:33 +0000 (01:50 +0000)]
Fix a coversation error with pre 6.4 versions.
Hiroshi Inoue
Bruce Momjian [Fri, 14 Sep 2001 01:23:14 +0000 (01:23 +0000)]
Update TODO list.
Bruce Momjian [Fri, 14 Sep 2001 00:41:06 +0000 (00:41 +0000)]
Update TODO list.
Bruce Momjian [Thu, 13 Sep 2001 22:39:29 +0000 (22:39 +0000)]
Add missing paren to ODBC compiles.
Peter Eisentraut [Thu, 13 Sep 2001 19:40:34 +0000 (19:40 +0000)]
Update compatibility information.
Peter Eisentraut [Thu, 13 Sep 2001 19:05:29 +0000 (19:05 +0000)]
Update compatibility information.
Peter Eisentraut [Thu, 13 Sep 2001 18:17:44 +0000 (18:17 +0000)]
Update compatibility information.
Bruce Momjian [Thu, 13 Sep 2001 17:01:31 +0000 (17:01 +0000)]
Didn't want that jdbc patch in there yet.
Bruce Momjian [Thu, 13 Sep 2001 17:00:34 +0000 (17:00 +0000)]
> I found a problem with PQescapeString (I think). Since it escapes
> null bytes to be literally '\0', the following can happen:
> 1. User inputs string value as "<null byte>##" where ## are digits in the
> range of 0 to 7.
> 2. PQescapeString converts this to "\0##"
> 3. Escaped string is used in a context that causes "\0##" to be evaluated as
> an octal escape sequence.
I agree that this is a problem, though it is not possible to do
anything harmful with it. In addition, it only occurs if there are
any NUL characters in its input, which is very unlikely if you are
using C strings.
The patch below addresses the issue by removing escaping of \0
characters entirely.
> If the goal is to "safely" encode null bytes, and preserve the rest of the
> string as it was entered, I think the null bytes should be escaped as \\000
> (note that if you simply use \000 the same string truncation problem
> occurs).
We can't do that, this would require 4n + 1 bytes of storage for the
result, breaking the interface.
Florian Weimer
Peter Eisentraut [Thu, 13 Sep 2001 15:55:24 +0000 (15:55 +0000)]
Replace ASCII-quotes with proper markup.
Hiroshi Inoue [Thu, 13 Sep 2001 00:27:11 +0000 (00:27 +0000)]
1) Not export ODBC 3.0 functions.
2) (Maybe) fix a bug reported by Mika Muntila.
Peter Eisentraut [Wed, 12 Sep 2001 20:57:28 +0000 (20:57 +0000)]
'chown -R postgres /usr/local/pgsql' is wrong. Need to do some more typing.
Bruce Momjian [Wed, 12 Sep 2001 15:55:00 +0000 (15:55 +0000)]
Attached patch is correction for 'doc/jdbc.sgml' of PostgreSQL 7.1.3.
Correction content:
* I revised a mistake of type (copy and paste).
* I revised multiplicity of description.
Ryouichi Matsuda
Bruce Momjian [Wed, 12 Sep 2001 15:49:10 +0000 (15:49 +0000)]
Followings are proposed fixes to jdbc.sgml(line numbers are for 7.1.3
doc).
Hiroyuki Yatabe
Peter Eisentraut [Wed, 12 Sep 2001 14:06:37 +0000 (14:06 +0000)]
max_locks_per_transaction seems to be a more consistent name than
max_locks_per_xact.
Peter Eisentraut [Wed, 12 Sep 2001 12:14:41 +0000 (12:14 +0000)]
Check both -lrt and -lposix4 for fdatasync, to cover all Solaris versions.
Bruce Momjian [Wed, 12 Sep 2001 04:01:57 +0000 (04:01 +0000)]
It is not fixed and I doubt that it is working fine in current CVS. The
bugfix is in the attached patch. Please apply it. Thanks.
Output must be:
test=# SELECT to_char(485, 'RN');
to_char
-----------------
CDLXXXV
(1 row)
test=# SELECT to_char(485, 'FMRN');
to_char
---------
CDLXXXV
(1 row)
test=# SELECT to_char(1000, 'RN');
to_char
-----------------
M
(1 row)
test=# SELECT to_char(7.2, '"Welcome to"9.9 "release! :-)"');
to_char
-----------------------------
Welcome to 7.2 release! :-)
(1 row)
Karel Zak
Bruce Momjian [Wed, 12 Sep 2001 03:58:15 +0000 (03:58 +0000)]
Here's some matching documentation, including some other
undocumented items in TD.
Should doc patches alse be sent to pgsql-patches, or do I
have to subscribe to pgsql-docs?
The archive link for pgsql-patches is broken, and I don't
see any patches in spot checking the archive for pgsql-docs.
-Brad McLean.
Bruce Momjian [Wed, 12 Sep 2001 03:03:25 +0000 (03:03 +0000)]
I noticed that plpython does not make the relid available inside
a trigger the way that pltcl does.
Here's a little patch that adds it in.
-Brad McLean
Tatsuo Ishii [Wed, 12 Sep 2001 02:13:25 +0000 (02:13 +0000)]
Fix typo (add ;)
Tatsuo Ishii [Wed, 12 Sep 2001 01:55:25 +0000 (01:55 +0000)]
Fix typo (add ;)
Tatsuo Ishii [Wed, 12 Sep 2001 01:22:25 +0000 (01:22 +0000)]
Fix typo.
Peter Eisentraut [Tue, 11 Sep 2001 23:27:10 +0000 (23:27 +0000)]
Link ODBC driver with -lnsl and -lsocket, for Solaris.
reported by Bob Deblier (bob@virtualunlimited.com)
Peter Eisentraut [Tue, 11 Sep 2001 23:20:41 +0000 (23:20 +0000)]
Use gcc -shared rather than gcc -G for shared library linking on Solaris.
suggested by Bob Deblier (bob@virtualunlimited.com)
Peter Eisentraut [Tue, 11 Sep 2001 23:08:07 +0000 (23:08 +0000)]
Invoke on_exit() with correct number and type of arguments.
Peter Eisentraut [Tue, 11 Sep 2001 14:31:23 +0000 (14:31 +0000)]
Look for fdatasync() in librt, for Solaris.
partially from Kenji Sugita
Hiroshi Inoue [Tue, 11 Sep 2001 06:39:20 +0000 (06:39 +0000)]
Fix some multibyte related bugs.
Psqlodbc is 7.01.0007 now.
Hiroshi Inoue
Tatsuo Ishii [Tue, 11 Sep 2001 05:18:59 +0000 (05:18 +0000)]
Implement following item in TODO:
* Reject character sequences those are not valid in their charset
Tatsuo Ishii [Tue, 11 Sep 2001 05:11:59 +0000 (05:11 +0000)]
Add single quote (example given here does not work)
Bruce Momjian [Tue, 11 Sep 2001 05:09:45 +0000 (05:09 +0000)]
Update TODO list.
Tatsuo Ishii [Tue, 11 Sep 2001 04:50:36 +0000 (04:50 +0000)]
Implement following item in TODO:
* Reject character sequences those are not valid in their charset
Tatsuo Ishii [Tue, 11 Sep 2001 02:24:52 +0000 (02:24 +0000)]
Fix regression test in the case of building as root.
Peter Eisentraut [Mon, 10 Sep 2001 23:52:04 +0000 (23:52 +0000)]
When testing for source and build tree equality, and test -ef doesn't work,
fall back to `cd $srcdir && /bin/pwd` = `/bin/pwd`. One of these ought to
work, and if not, prep_buildtree is harmless.
Peter Eisentraut [Mon, 10 Sep 2001 23:28:59 +0000 (23:28 +0000)]
Make prep_buildtree harmless when run on top of the source tree.
from Ian Lance Taylor
Peter Eisentraut [Mon, 10 Sep 2001 22:25:48 +0000 (22:25 +0000)]
Add explicit '-print' to 'find' commands.
(partially) from Ian Lance Taylor
Peter Eisentraut [Mon, 10 Sep 2001 21:58:47 +0000 (21:58 +0000)]
Markup and spell-check run over Programmer's Guide (rather incomplete still).