OSDN Git Service
Bruce Momjian [Mon, 1 Oct 2001 16:12:23 +0000 (16:12 +0000)]
Add missing pgcrypto files.
Bruce Momjian [Mon, 1 Oct 2001 15:44:45 +0000 (15:44 +0000)]
Update to "7.2".
Bruce Momjian [Mon, 1 Oct 2001 15:33:55 +0000 (15:33 +0000)]
Run autoconf.
Bruce Momjian [Mon, 1 Oct 2001 15:33:31 +0000 (15:33 +0000)]
> > > > > - PostgreSQL requires to be compiled with --enable-multibyte
> > > > > and --enable-unicode-convertion if it ought to work correctly
> > > > > with Tcl/Tk >= 8.1 (client or server side).
> > > > >
> > > > > - PL/Tcl needs to be changed to use pg_do_encoding_conversion
> > > > > if it runs on a Tcl version >= 8.1 .
> > >
> > > > I'll do pl/tcl part in the next version of patch. Using this approach we
> > > > can eliminate overhead for databases in UNICODE.
> > >
> > > Any progress on this? I'd prefer to get rid of this --enable-pltcl-utf
> > > option before release.
> >
> > Done
> >
> > Next version removes --enable-pltcl-utf switch and enables embedded
> > utf conversion of pgsql if tcl version >=8.1 and --enable-unicode-conversion
Michael Meskes [Mon, 1 Oct 2001 12:02:28 +0000 (12:02 +0000)]
- Fixed truncate bug.
- Added patch by Christof Petig <christof.petig@wtal.de> to
clean up
ecpglib.
Tatsuo Ishii [Mon, 1 Oct 2001 08:16:38 +0000 (08:16 +0000)]
Update multibyte Japanese doc
Tom Lane [Mon, 1 Oct 2001 05:36:17 +0000 (05:36 +0000)]
Another round of cleanups for dynahash.c (maybe it's finally clean of
portability issues). Caller-visible data structures are now allocated
on MAXALIGN boundaries, allowing safe use of datatypes wider than 'long'.
Rejigger hash_create API so that caller specifies size of key and
total size of entry, not size of key and size of rest of entry.
This simplifies life considerably since each number is just a sizeof(),
and padding issues etc. are taken care of automatically.
Tom Lane [Mon, 1 Oct 2001 04:19:18 +0000 (04:19 +0000)]
Suppress timestamp_ops for backwards compatibility with 7.1 pg_dump.
Tatsuo Ishii [Mon, 1 Oct 2001 02:31:33 +0000 (02:31 +0000)]
Remove C++ style comment. Some compilers won't accept it.
Tatsuo Ishii [Mon, 1 Oct 2001 02:26:36 +0000 (02:26 +0000)]
Fix a compile error on a platform that does not have PAM.
Tatsuo Ishii [Mon, 1 Oct 2001 01:52:38 +0000 (01:52 +0000)]
Add pgstattuple
Tom Lane [Sun, 30 Sep 2001 22:30:37 +0000 (22:30 +0000)]
Make libpq++ safe again for older C++ compilers. Do 'using namespace std'
only if configure found it was safe to do so; do not assume const_cast
is available.
Bruce Momjian [Sun, 30 Sep 2001 22:18:29 +0000 (22:18 +0000)]
* regression tests
* minor doc updates
Marko Kreen
Bruce Momjian [Sun, 30 Sep 2001 22:17:51 +0000 (22:17 +0000)]
These are further fixes for double quotes missing in the various shell
scripts.
Justin Clift
Tom Lane [Sun, 30 Sep 2001 22:03:41 +0000 (22:03 +0000)]
Clean up encode/decode functions a little bit.
Tom Lane [Sun, 30 Sep 2001 21:48:58 +0000 (21:48 +0000)]
Fix sloppiness about static vs non-static declaration of functions.
Some compilers are pickier about this than gcc is.
Tom Lane [Sun, 30 Sep 2001 21:01:39 +0000 (21:01 +0000)]
pg_stat_get_backend_idset should reset fmgr_info->fn_extra at end of
execution, so that it restarts correctly if query tree is used again.
Tom Lane [Sun, 30 Sep 2001 20:16:21 +0000 (20:16 +0000)]
Allow the postmaster to accept changes in PGC_BACKEND GUC variables
from the config file, so that these changes will propagate to backends
started later. Already-started backends continue to ignore changes
in these variables.
Tom Lane [Sun, 30 Sep 2001 20:08:18 +0000 (20:08 +0000)]
ISTM that IsUnderPostmaster should mean we are a child process of the
postmaster ... it should not be set in the postmaster itself.
Bruce Momjian [Sun, 30 Sep 2001 19:18:29 +0000 (19:18 +0000)]
Change tar -T file to tar `cat file` for BSD tar.
Bruce Momjian [Sun, 30 Sep 2001 19:09:57 +0000 (19:09 +0000)]
Change tar -c -f to -cf for BSD tar.
Bruce Momjian [Sun, 30 Sep 2001 19:01:44 +0000 (19:01 +0000)]
Update TODO list.
Bruce Momjian [Sun, 30 Sep 2001 19:01:18 +0000 (19:01 +0000)]
Update TODO list.
Tom Lane [Sun, 30 Sep 2001 18:57:45 +0000 (18:57 +0000)]
Create a GUC parameter max_files_per_process that is a configurable
upper limit on what we will believe from sysconf(_SC_OPEN_MAX). The
default value is 1000, so that under ordinary conditions it won't
affect the behavior. But on platforms where the kernel promises far
more than it can deliver, this can be used to prevent running out of
file descriptors. See numerous past discussions, eg, pgsql-hackers
around 23-Dec-2000.
Tom Lane [Sun, 30 Sep 2001 17:37:32 +0000 (17:37 +0000)]
Addition of xid=int4 operator makes opr_sanity unhappy.
Tom Lane [Sun, 30 Sep 2001 16:23:30 +0000 (16:23 +0000)]
winsock_strerror crashed on me. This fixes a line of code that looks
cleverer than it actually is ;-) Braces are good for you :-)
Gerhard HÌring
Tom Lane [Sun, 30 Sep 2001 16:16:44 +0000 (16:16 +0000)]
Changes:
1. gist__int_ops is now without lossy
2. added sort entry in picksplit
Oleg Bartunov
Tom Lane [Sun, 30 Sep 2001 16:15:59 +0000 (16:15 +0000)]
Update required due to recent changes in FigureColname.
Peter Eisentraut [Sun, 30 Sep 2001 16:05:54 +0000 (16:05 +0000)]
Use <mediaobject> instead of <graphic> for forward compatibility. Be more
flexible about the extension of the graphic files, allow for other formats
in print output. (Generating these formats is not implemented yet.)
Peter Eisentraut [Sun, 30 Sep 2001 16:01:12 +0000 (16:01 +0000)]
Fix *.gif expansion to be empty when no gif files are used.
Hiroshi Inoue [Sun, 30 Sep 2001 06:46:58 +0000 (06:46 +0000)]
Add an operator xid '=' int and remove BINARY_COMPATI...
Bruce Momjian [Sun, 30 Sep 2001 00:50:05 +0000 (00:50 +0000)]
Update TODO list.
Bruce Momjian [Sun, 30 Sep 2001 00:49:15 +0000 (00:49 +0000)]
Update TODO list.
Bruce Momjian [Sun, 30 Sep 2001 00:46:15 +0000 (00:46 +0000)]
Update TODO list.
Bruce Momjian [Sun, 30 Sep 2001 00:45:48 +0000 (00:45 +0000)]
Back out change. Too many place to change too close to beta:
* HOLDER/HOLDERTAB rename to PROCLOCKLINK/PROCLOCKLINKTAG (Bruce)
Will return later.
Tom Lane [Sat, 29 Sep 2001 23:49:51 +0000 (23:49 +0000)]
Tweak btree page split logic so that when splitting a page that is
rightmost on its tree level, we split 2/3 to the left and 1/3 to the
new right page, rather than the even split we use elsewhere. The idea
is that when faced with a steadily increasing series of inserted keys
(such as sequence or timestamp values), we'll end up with a btree that's
about 2/3ds full not 1/2 full, which is much closer to the desired
steady-state load for a btree. Per suggestion from Ann Harrison of
IBPhoenix.
Hiroshi Inoue [Sat, 29 Sep 2001 23:01:26 +0000 (23:01 +0000)]
Allow comparison between xid and xid, int.
Bruce Momjian [Sat, 29 Sep 2001 21:37:06 +0000 (21:37 +0000)]
Update TODO list.
Bruce Momjian [Sat, 29 Sep 2001 21:35:14 +0000 (21:35 +0000)]
Do this TODO item:
* HOLDER/HOLDERTAB rename to PROCLOCK/PROCLOCKTAG (Tom)
Didn't use PROCLOCKLINK because it made PROCLOCKLINKTAG too long.
Tom Lane [Sat, 29 Sep 2001 21:16:30 +0000 (21:16 +0000)]
Cope with the likelihood that setlocale and localeconv will return
pointers to data that will be changed by any later call to setlocale.
Must copy what they return to be sure we get the right answer.
Karel Zak, further tweaks by Tom Lane.
Tom Lane [Sat, 29 Sep 2001 20:12:07 +0000 (20:12 +0000)]
Fix the setlocale problem in a way that actually works. setlocale
returns a string corresponding to the new setting, not the old,
therefore the previous patch was quite wrong.
Tom Lane [Sat, 29 Sep 2001 19:49:50 +0000 (19:49 +0000)]
Clean up comments.
Tom Lane [Sat, 29 Sep 2001 15:29:48 +0000 (15:29 +0000)]
Whoops, I was a tad too enthusiastic about using shared lock mode for
SInvalLock. GetSnapshotData(true) has to use exclusive lock, since
it sets MyProc->xmin.
Tom Lane [Sat, 29 Sep 2001 15:17:42 +0000 (15:17 +0000)]
Fixes for datetime-related regress tests, from Tom Lockhart.
Hiroshi Inoue [Sat, 29 Sep 2001 07:57:06 +0000 (07:57 +0000)]
Keep the contents of ItemPointerData not the pointers so that
per tuple memory context doesn't discard them.
Tom Lane [Sat, 29 Sep 2001 05:42:24 +0000 (05:42 +0000)]
Remove mistakenly-included file, per request from John Gray.
Tom Lane [Sat, 29 Sep 2001 05:33:25 +0000 (05:33 +0000)]
timetz test was omitted from parallel_schedule.
Tom Lane [Sat, 29 Sep 2001 05:11:10 +0000 (05:11 +0000)]
Update horology-no-DST-before-1970.out for new horology test.
Still need an update for horology-solaris-1947.out ...
Tom Lane [Sat, 29 Sep 2001 04:02:27 +0000 (04:02 +0000)]
Implement new 'lightweight lock manager' that's intermediate between
existing lock manager and spinlocks: it understands exclusive vs shared
lock but has few other fancy features. Replace most uses of spinlocks
with lightweight locks. All remaining uses of spinlocks have very short
lock hold times (a few dozen instructions), so tweak spinlock backoff
code to work efficiently given this assumption. All per my proposal on
pghackers 26-Sep-01.
Bruce Momjian [Sat, 29 Sep 2001 03:46:12 +0000 (03:46 +0000)]
I have made three changes to the rtree code: one bug fix and
two performance improvements. I put an explanation of the
changes at
http://cs1.cs.nyu.edu/been/postgres-rtree.html
The performance improvements are quite significant.
All the changes are in the file src/backend/access/rtree/rtree.c
I was working with the 7.1.3 code.
I'm including the diff output as an attachment.
Kenneth Been
Bruce Momjian [Sat, 29 Sep 2001 03:12:51 +0000 (03:12 +0000)]
Found type mismatch in random.c. Please apply this also.
Marko Kreen
Bruce Momjian [Sat, 29 Sep 2001 03:11:58 +0000 (03:11 +0000)]
I noticed that the contrib Makefiles were reorganized.
Converted pgcrypto one too.
* Changed default randomness source to libc random()
That way pgcrypto does not have any external dependencies
and should work everywhere.
* Re-enabled pgcrypto build in contrib/makefile
* contrib/README update - there is more stuff than
only 'hash functions'
* Noted the libc random fact in README.pgcrypto
Marko Kreen
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.