OSDN Git Service
Bruce Momjian [Sat, 29 Sep 2001 03:11:11 +0000 (03:11 +0000)]
A couple of lines were missing from my last patch - this one fixes things.
Liam Stewart
Bruce Momjian [Sat, 29 Sep 2001 03:09:32 +0000 (03:09 +0000)]
This is a simple patch to put double quotes around a few cases in
pg_ctl.sh which were unquoted when inside of [].
Justin Clift
Bruce Momjian [Sat, 29 Sep 2001 03:08:01 +0000 (03:08 +0000)]
Per the recent discussion there's been some code changes in JDBC's
DatabaseMetaData.getColumn(). I proposed a patch that would change the
number of queries to find out all columns in a table from 2 * N + 1 to 1 (N
being the number of columns reported) by using some outer joins. I also
fixed the fact that getColumns() only returned columns that had a default
defined. OTOH, I did not use to change the code required for obtaining a
column's remarks (by using col_description() for 7.2 and requested by Tom
Lane).
Finally, I have found a way to get all the column details in a single query
*and* use col_description() for 7.2 servers. A patch is attached. It
overrules Ren? Pijlman's fix for this that was committed just today, but
still used N + 1 queries (sorry Ren? ;-) )
I also fixed the return values for TABLE_CAT and TABLE_SCHEM from "" to
null, to be more standard compliant (and requested in Ren?'s mail found at
http://fts.postgresql.org/db/mw/msg.html?mid=
1034253).
As always, the JDBC1 version has not been tested as I have no JDK 1.1
Jeroen van Vianen
Hiroshi Inoue [Sat, 29 Sep 2001 02:48:04 +0000 (02:48 +0000)]
Fix the bug about boolean type handling reported by
Kristis Markis.
Bruce Momjian [Fri, 28 Sep 2001 21:39:31 +0000 (21:39 +0000)]
Update TODO list.
Thomas G. Lockhart [Fri, 28 Sep 2001 20:48:17 +0000 (20:48 +0000)]
Fix markup to allow compilation. The chapters on failure and recovery
need more work, but at least they have something now.
Bruce Momjian [Fri, 28 Sep 2001 19:25:36 +0000 (19:25 +0000)]
Improve wording.
Bruce Momjian [Fri, 28 Sep 2001 19:06:50 +0000 (19:06 +0000)]
Add to thread thread.
Bruce Momjian [Fri, 28 Sep 2001 18:56:57 +0000 (18:56 +0000)]
Add to thread.
Bruce Momjian [Fri, 28 Sep 2001 18:30:05 +0000 (18:30 +0000)]
Add to threads.
Bruce Momjian [Fri, 28 Sep 2001 15:31:25 +0000 (15:31 +0000)]
Update TODO list.
Bruce Momjian [Fri, 28 Sep 2001 15:31:08 +0000 (15:31 +0000)]
Update TODO list.
Thomas G. Lockhart [Fri, 28 Sep 2001 08:15:35 +0000 (08:15 +0000)]
Add information on new timestamp and timestamptz data types.
Start chapter on recovery techniques. Still needs work for release.
Thomas G. Lockhart [Fri, 28 Sep 2001 08:09:14 +0000 (08:09 +0000)]
Measure the current transaction time to milliseconds.
Define a new function, GetCurrentTransactionStartTimeUsec() to get the time
to this precision.
Allow now() and timestamp 'now' to use this higher precision result so
we now have fractional seconds in this "constant".
Add timestamp without time zone type.
Move previous timestamp type to timestamp with time zone.
Accept another ISO variant for date/time values: yyyy-mm-ddThh:mm:ss
(note the "T" separating the day from hours information).
Remove 'current' from date/time types; convert to 'now' in input.
Separate time and timetz regression tests.
Separate timestamp and timestamptz regression test.
Thomas G. Lockhart [Fri, 28 Sep 2001 08:00:11 +0000 (08:00 +0000)]
Add separate regression tests for timetz and the new timestamptz type.
Modify the timestamp test to reflect the "no time zone" behavior of this
new code; timestamptz resembles the old timestamp code.
Bruce Momjian [Thu, 27 Sep 2001 23:16:23 +0000 (23:16 +0000)]
Put MD5 salt at the end for security.
Tom Lane [Thu, 27 Sep 2001 19:10:02 +0000 (19:10 +0000)]
Move s_lock.c and spin.c into lmgr subdirectory, which seems a much
more reasonable location for them.
Tom Lane [Thu, 27 Sep 2001 16:29:13 +0000 (16:29 +0000)]
Remove useless LockDisable() function and associated overhead, per my
proposal of 26-Aug.
Bruce Momjian [Thu, 27 Sep 2001 00:24:25 +0000 (00:24 +0000)]
Improve postgresql.conf descriptions.
Tom Lane [Wed, 26 Sep 2001 21:35:28 +0000 (21:35 +0000)]
The trailing semicolon in a plpgsql function definition is now optional.
Per gripe 9/26.
Tom Lane [Wed, 26 Sep 2001 21:09:27 +0000 (21:09 +0000)]
Repair oversight in recent changes to index-creation: tuple time qual
check *can* return HEAPTUPLE_INSERT_IN_PROGRESS or HEAPTUPLE_DELETE_IN_PROGRESS,
even though we have ShareLock on the relation. To wit, this can happen
if the tuple was inserted/deleted by our own transaction. Per report from
Justin Clift 9/23.
Tom Lane [Wed, 26 Sep 2001 20:24:02 +0000 (20:24 +0000)]
Remove useless test for time field in pg_control being > 0. We don't
need this, and it will create a Y2038 failure. Per report from David
Wheeler, who is evidently running on a platform where time_t is already
negative.
Bruce Momjian [Wed, 26 Sep 2001 19:57:01 +0000 (19:57 +0000)]
Add ALIGN() for cred packet, for OpenBSD.
Bruce Momjian [Wed, 26 Sep 2001 19:54:12 +0000 (19:54 +0000)]
Disable local creds on OpenBSD because it doesn't support it. Document
supported platforms in pg_hba.conf.
Michael Meskes [Tue, 25 Sep 2001 18:37:17 +0000 (18:37 +0000)]
- Synced preproc.y with gram.y.
- Changed locale handling.
Tatsuo Ishii [Tue, 25 Sep 2001 01:27:03 +0000 (01:27 +0000)]
Fix bug in mic2ascii(). It does not handle correctly if none ASCII
chars are in the input.
Peter Eisentraut [Mon, 24 Sep 2001 20:10:44 +0000 (20:10 +0000)]
Treat __s390x__ the same as __s390__. (taken from RPM patch set)
Hiroshi Inoue [Mon, 24 Sep 2001 00:05:59 +0000 (00:05 +0000)]
1) Fix compile errors on Windows.
2) Change *Common* --> *Default*.
Peter Eisentraut [Sun, 23 Sep 2001 21:52:36 +0000 (21:52 +0000)]
Rename collect_* options to more user-friendly names.
Bruce Momjian [Sun, 23 Sep 2001 14:01:57 +0000 (14:01 +0000)]
Update TODO list.
Bruce Momjian [Sun, 23 Sep 2001 14:01:25 +0000 (14:01 +0000)]
Update TODO list.
Bruce Momjian [Sun, 23 Sep 2001 13:59:17 +0000 (13:59 +0000)]
Update TODO list.
Bruce Momjian [Sun, 23 Sep 2001 13:34:44 +0000 (13:34 +0000)]
One more LIMIT doc update.
Peter Eisentraut [Sun, 23 Sep 2001 13:32:24 +0000 (13:32 +0000)]
Don't refer to odbcinst.ini by absolute path. SQLGetPrivateProfileString
handles this.
Don't install our own odbcinst.ini. That's the driver manager's business.
Tatsuo Ishii [Sun, 23 Sep 2001 11:02:01 +0000 (11:02 +0000)]
Make lpad/rpad/translate multibyte aware. Also add Copright notice etc.
Tatsuo Ishii [Sun, 23 Sep 2001 10:59:45 +0000 (10:59 +0000)]
Add pg_database_encoding_max_length() function.
Bruce Momjian [Sun, 23 Sep 2001 04:41:47 +0000 (04:41 +0000)]
Add mention of MySQL compatibility for LIMIT in HISTORY.
Bruce Momjian [Sun, 23 Sep 2001 04:28:18 +0000 (04:28 +0000)]
Update regress tests for new LIMIT x,y behavior.
Bruce Momjian [Sun, 23 Sep 2001 04:17:53 +0000 (04:17 +0000)]
No, file not needed.
Bruce Momjian [Sun, 23 Sep 2001 04:17:20 +0000 (04:17 +0000)]
Add new file.
Bruce Momjian [Sun, 23 Sep 2001 04:16:16 +0000 (04:16 +0000)]
please apply attached patch to current CVS.
Changes:
1. Added support for boolean queries (indexable operator @@, looks like
a @@ '1|(2&3)'
2. Some code cleanup and optimization
Regards,
Oleg
Bruce Momjian [Sun, 23 Sep 2001 04:15:13 +0000 (04:15 +0000)]
Update TODO list.
Bruce Momjian [Sun, 23 Sep 2001 04:13:29 +0000 (04:13 +0000)]
Update TODO list.
Bruce Momjian [Sun, 23 Sep 2001 04:12:44 +0000 (04:12 +0000)]
Big thanks to Solar Designer who pointed out a bug in bcrypt
salt generation code. He also urged using better random source
and making possible to choose using bcrypt and xdes rounds more
easily. So, here's patch:
* For all salt generation, use Solar Designer's own code. This
is mostly due fact that his code is more fit for get_random_bytes()
style interface.
* New function: gen_salt(type, rounds). This lets specify iteration
count for algorithm.
* random.c: px_get_random_bytes() function.
Supported randomness soure: /dev/urandom, OpenSSL PRNG, libc random()
Default: /dev/urandom.
* Draft description of C API for pgcrypto functions.
New files: API, crypt-gensalt.c, random.c
Marko Kreen
Bruce Momjian [Sun, 23 Sep 2001 04:11:14 +0000 (04:11 +0000)]
The attached patch is my first run-through of the JDBC test suite. A
summary of changes:
. removal of the tablename property from build.xml
. addition of a dropTable method in JDBC2Tests and cleanups of many
methods in the same
. all tests now use non-deprecated assertXYZ methods instead of the
deprecated assert method
. failure in TimestampTest (testSetTimestamp) fixed. The failure is
because testSetTimestamp was inserting a timestamp with hour 7 but
checkTimeTest was expecting a timestamp with hour 8. AFAICS, there are
no issues wrt daylight savings time and timestamps being pushed in and
pulled out (but more explicit tests should be added in the future)
. failure in TimeTest (testGetTime) fixed. Times to be inserted were
interpreted in the localtime zone but checking was done with the
assumption that the insertion was done in GMT.
. formatting changes in a few of the source files (because I found
it convenient to have consistent formatting while working on them). The
formatting is consistent with the new format for java source files in
PostgreSQL.
Liam Stewart
Bruce Momjian [Sun, 23 Sep 2001 04:08:38 +0000 (04:08 +0000)]
Update TODO list.
Bruce Momjian [Sun, 23 Sep 2001 04:06:24 +0000 (04:06 +0000)]
Add mention of log file rotation with mention of syslog SIGHUP capability.
Bruce Momjian [Sun, 23 Sep 2001 03:41:49 +0000 (03:41 +0000)]
Mention LIMIT change in HISTORY file.
Bruce Momjian [Sun, 23 Sep 2001 03:39:01 +0000 (03:39 +0000)]
Implement TODO item:
* Change LIMIT val,val to offset,limit to match MySQL
Documentation updates too.
Bruce Momjian [Sun, 23 Sep 2001 01:16:35 +0000 (01:16 +0000)]
Update anoncvs info, per Marc.
Bruce Momjian [Sun, 23 Sep 2001 00:07:50 +0000 (00:07 +0000)]
Update FAQ.
Peter Eisentraut [Sat, 22 Sep 2001 22:54:33 +0000 (22:54 +0000)]
Provide some initial support for building the ODBC driver for
an already installed iODBC or unixODBC driver manager. In particular,
use the include files provided by the driver manager over our own,
and use the odbcinst library of the driver manager rather than gpps.c.
Migrate portability sections common to several files into psqlodbc.h.
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.