]> granicus.if.org Git - postgresql/log
postgresql
22 years agoUpdate from Serguei Mokhov
Peter Eisentraut [Fri, 28 Dec 2001 18:47:54 +0000 (18:47 +0000)]
Update from Serguei Mokhov

22 years agoAdd pljava messages.
Bruce Momjian [Fri, 28 Dec 2001 18:33:44 +0000 (18:33 +0000)]
Add pljava messages.

22 years agoTypo.
Bruce Momjian [Fri, 28 Dec 2001 18:31:14 +0000 (18:31 +0000)]
Typo.

< * Improve access-permissions check on data directory in CYGWIN (Tom)
---
> * Improve access-permissions check on data directory in Cygwin (Tom)

22 years agoAdded
Bruce Momjian [Fri, 28 Dec 2001 18:30:50 +0000 (18:30 +0000)]
Added

<
---
> * Improve access-permissions check on data directory in CYGWIN (Tom)

22 years agoEnsure that all direct uses of spinlock-protected data structures use
Tom Lane [Fri, 28 Dec 2001 18:16:43 +0000 (18:16 +0000)]
Ensure that all direct uses of spinlock-protected data structures use
'volatile' pointers to access those structures, so that optimizing
compilers will not decide to move the structure accesses outside of the
spinlock-acquire-to-spinlock-release sequence.  There are no known bugs
in these uses at present, but based on bad experience with lwlock.c,
it seems prudent to ensure that we protect these other uses too.
Per pghackers discussion around 12-Dec.  (Note: it should not be
necessary to worry about structures protected by LWLocks, since the
LWLock acquire and release operations are not inline macros.)

22 years agoAdd
Bruce Momjian [Fri, 28 Dec 2001 05:26:25 +0000 (05:26 +0000)]
Add

> * Allow binding query args over FE/BE protocol

22 years agoAdded
Bruce Momjian [Fri, 28 Dec 2001 05:09:13 +0000 (05:09 +0000)]
Added

>  o Have ALTER TABLE OWNER change all dependant objects like indexes

22 years agoAdd thread item.
Bruce Momjian [Fri, 28 Dec 2001 05:04:59 +0000 (05:04 +0000)]
Add thread item.

22 years agoAdd more Christof Petig ecpg items.
Bruce Momjian [Fri, 28 Dec 2001 05:03:10 +0000 (05:03 +0000)]
Add more Christof Petig ecpg items.

22 years agoChristof Petig changes where for HISTORY, not TODO.
Bruce Momjian [Fri, 28 Dec 2001 05:02:50 +0000 (05:02 +0000)]
Christof Petig changes where for HISTORY, not TODO.

22 years agoOops, back out paren fix. That is for 7.3.
Bruce Momjian [Fri, 28 Dec 2001 05:01:05 +0000 (05:01 +0000)]
Oops, back out paren fix.  That is for 7.3.

22 years agoAdd mention of Christof Petig for ecpg items.
Bruce Momjian [Fri, 28 Dec 2001 05:00:32 +0000 (05:00 +0000)]
Add mention of Christof Petig for ecpg items.

22 years agoAdded for Christof Petig:
Bruce Momjian [Fri, 28 Dec 2001 04:57:55 +0000 (04:57 +0000)]
Added for Christof Petig:

<  o Allow SELECT of array of strings into a auto-sized variable
---
>  o -Allow SELECT of array of strings into a auto-sized variable

>  o auto allocation for indicator variable arrays (int *ind_p=NULL)
>  o auto allocation for string arrays (char **foo_pp=NULL)
>  o ECPGfree_auto_mem fixed
>  o all function names with external linkage are now prefixed by ECPG

22 years agoAdded:
Bruce Momjian [Fri, 28 Dec 2001 04:32:44 +0000 (04:32 +0000)]
Added:

> * Add OpenBSD's getpeereid() call for local socket authentication (Bruce)

22 years agoUpdate to show current capability and future direction, from Peter:
Bruce Momjian [Fri, 28 Dec 2001 04:30:18 +0000 (04:30 +0000)]
Update to show current capability and future direction, from Peter:

> * -Allow secure single-user access without passwords using Unix socket permissions
> * Make single-user local socket access permissions the default (Peter E)

22 years agoAdded:
Bruce Momjian [Fri, 28 Dec 2001 03:30:30 +0000 (03:30 +0000)]
Added:

! * Add PGPASSWORDFILE environment variable or ~/.pgpass to store
!   user/host/password combinations

22 years agoI know we talked about this in the past but I never got it on the TODO
Bruce Momjian [Fri, 28 Dec 2001 02:30:37 +0000 (02:30 +0000)]
I know we talked about this in the past but I never got it on the TODO
list:

* Add optional CRC checksum to heap and index pages

22 years agoExpand on description of when to use or not use TRUST auth method.
Tom Lane [Thu, 27 Dec 2001 21:37:34 +0000 (21:37 +0000)]
Expand on description of when to use or not use TRUST auth method.

22 years agoDocument obj_description and col_description functions; expand
Tom Lane [Thu, 27 Dec 2001 21:36:57 +0000 (21:36 +0000)]
Document obj_description and col_description functions; expand
description of COMMENT command.

22 years agoSmall fixes
Peter Eisentraut [Thu, 27 Dec 2001 21:10:15 +0000 (21:10 +0000)]
Small fixes

22 years agoUpdate from Serguei Mokhov
Peter Eisentraut [Thu, 27 Dec 2001 21:06:07 +0000 (21:06 +0000)]
Update from Serguei Mokhov

22 years agoMention datatype() casting change.
Bruce Momjian [Thu, 27 Dec 2001 04:46:08 +0000 (04:46 +0000)]
Mention datatype() casting change.

22 years agoUpdate TODO list.
Bruce Momjian [Thu, 27 Dec 2001 04:28:37 +0000 (04:28 +0000)]
Update TODO list.

22 years agoUpdate for new timestamp behavior.
Bruce Momjian [Thu, 27 Dec 2001 00:04:44 +0000 (00:04 +0000)]
Update for new timestamp behavior.

22 years agoAdd cachable item.
Bruce Momjian [Wed, 26 Dec 2001 23:47:32 +0000 (23:47 +0000)]
Add cachable item.

22 years agoPlace PAM before REJECT in sample file.
Bruce Momjian [Mon, 24 Dec 2001 04:44:03 +0000 (04:44 +0000)]
Place PAM before REJECT in sample file.

22 years agoFix directions for a client-only install, per comments from Alexey Borzov
Tom Lane [Sun, 23 Dec 2001 20:45:11 +0000 (20:45 +0000)]
Fix directions for a client-only install, per comments from Alexey Borzov
and Vivek Khera.

22 years agoUpdate description of CURRENT_TIMESTAMP and friends.
Tom Lane [Sun, 23 Dec 2001 20:22:49 +0000 (20:22 +0000)]
Update description of CURRENT_TIMESTAMP and friends.

22 years agoType interval takes a precision, too.
Tom Lane [Sun, 23 Dec 2001 20:21:37 +0000 (20:21 +0000)]
Type interval takes a precision, too.

22 years agoLots of content and formatting improvements in release notes. HISTORY
Peter Eisentraut [Sun, 23 Dec 2001 18:20:05 +0000 (18:20 +0000)]
Lots of content and formatting improvements in release notes.  HISTORY
now generated from DocBook sources.

22 years agoAdd missing id attribute.
Peter Eisentraut [Sun, 23 Dec 2001 18:18:09 +0000 (18:18 +0000)]
Add missing id attribute.

22 years agoUpdated ECPG items
Michael Meskes [Sun, 23 Dec 2001 12:21:05 +0000 (12:21 +0000)]
Updated ECPG items

22 years ago- Removed space_or_nl and line_end from pgc.l.
Michael Meskes [Sun, 23 Dec 2001 12:17:41 +0000 (12:17 +0000)]
- Removed space_or_nl and line_end from pgc.l.
- Fixed several bugs concerning arrays of structs including a memory
  allocation bug.

22 years agoFix mispeling ...
Tom Lane [Sun, 23 Dec 2001 07:25:39 +0000 (07:25 +0000)]
Fix mispeling ...

22 years agoCzech translation updates from Karel Zak
Peter Eisentraut [Fri, 21 Dec 2001 22:30:49 +0000 (22:30 +0000)]
Czech translation updates from Karel Zak

22 years agoFix error
Peter Eisentraut [Fri, 21 Dec 2001 22:27:34 +0000 (22:27 +0000)]
Fix error

22 years agoUse MemSet() rather than a loop to do blank-padding on PS_USE_CLOBBER_ARGV
Tom Lane [Fri, 21 Dec 2001 15:22:09 +0000 (15:22 +0000)]
Use MemSet() rather than a loop to do blank-padding on PS_USE_CLOBBER_ARGV
machines.  I have just been observing some scenarios where set_ps_display
accounts for more than 10% of the backend CPU, and this loop has to be
the reason.

22 years agoAdd full name of the month of July to the lookup table.
Thomas G. Lockhart [Fri, 21 Dec 2001 06:03:27 +0000 (06:03 +0000)]
Add full name of the month of July to the lookup table.
Thanks to Greg Sabino Mullane <greg@turnstep.com> for finding the problem.

22 years agoRemove duplicate lines from fouled up last commit (my DSL line failed
Thomas G. Lockhart [Fri, 21 Dec 2001 06:01:36 +0000 (06:01 +0000)]
Remove duplicate lines from fouled up last commit (my DSL line failed
 during the CVS update, leaving locks and bad files).

22 years agoUpdates for next release from Bernd Tegge.
Thomas G. Lockhart [Fri, 21 Dec 2001 06:00:15 +0000 (06:00 +0000)]
Updates for next release from Bernd Tegge.

22 years agoDo not require iconv for dbase conversion.
Bruce Momjian [Fri, 21 Dec 2001 05:29:46 +0000 (05:29 +0000)]
Do not require iconv for dbase conversion.

22 years agoRemove:
Bruce Momjian [Fri, 21 Dec 2001 05:27:19 +0000 (05:27 +0000)]
Remove:

* Fix contrib/dbase to not require libiconv

22 years ago* Fix contrib/dbase to not require libiconv.
Bruce Momjian [Fri, 21 Dec 2001 04:31:58 +0000 (04:31 +0000)]
* Fix contrib/dbase to not require libiconv.

22 years agoAllow contrib/dbase to compile if HAVE_ICONV_H it not defined. This is
Bruce Momjian [Fri, 21 Dec 2001 04:30:59 +0000 (04:30 +0000)]
Allow contrib/dbase to compile if HAVE_ICONV_H it not defined.  This is
only a partial solution but a step in the right direction.

22 years agoAdd needed libiconv link to contrib/dbase, per Christopher Kings-Lynne
Bruce Momjian [Fri, 21 Dec 2001 04:13:12 +0000 (04:13 +0000)]
Add needed libiconv link to contrib/dbase, per Christopher Kings-Lynne

22 years agopre-page -> after-change, per Vadim.
Bruce Momjian [Fri, 21 Dec 2001 03:55:45 +0000 (03:55 +0000)]
pre-page ->  after-change, per Vadim.

22 years agoSpiff up discussion of precision on date/time data types.
Thomas G. Lockhart [Fri, 21 Dec 2001 03:54:02 +0000 (03:54 +0000)]
Spiff up discussion of precision on date/time data types.
Add a NetBSD/alpha and update info on a few other platforms.

22 years agoAllow location of index creation perl script be be specified in
Thomas G. Lockhart [Fri, 21 Dec 2001 03:53:04 +0000 (03:53 +0000)]
Allow location of index creation perl script be be specified in
 Makefile.custom, to allow finding it on Mandrake systems (at least).

22 years agoSelect proper geometry comparison file for freebsd/alpha.
Tom Lane [Fri, 21 Dec 2001 03:03:55 +0000 (03:03 +0000)]
Select proper geometry comparison file for freebsd/alpha.
Per report from Christopher Kings-Lynne.

22 years agoPre-page write additions.
Bruce Momjian [Thu, 20 Dec 2001 22:01:29 +0000 (22:01 +0000)]
Pre-page write additions.

22 years agoAdd memcmp() test and new memcmp.c file, for SunOS. Tested by Tatsuo.
Bruce Momjian [Thu, 20 Dec 2001 21:23:05 +0000 (21:23 +0000)]
Add memcmp() test and new memcmp.c file, for SunOS.  Tested by Tatsuo.

22 years agoFix for SunOS4 horology test
Tatsuo Ishii [Thu, 20 Dec 2001 04:25:00 +0000 (04:25 +0000)]
Fix for SunOS4 horology test

22 years agoMIN() -> Min, fixes compile problem.
Bruce Momjian [Thu, 20 Dec 2001 02:39:26 +0000 (02:39 +0000)]
MIN() -> Min, fixes compile problem.

22 years agoReflect Tom's change
Tatsuo Ishii [Thu, 20 Dec 2001 01:56:08 +0000 (01:56 +0000)]
Reflect Tom's change

22 years agoFix buffer-overrun problem in pretty printer.
Tom Lane [Wed, 19 Dec 2001 22:35:35 +0000 (22:35 +0000)]
Fix buffer-overrun problem in pretty printer.

22 years agoFix pgstattuple to acquire a read lock on the target table. This
Tom Lane [Wed, 19 Dec 2001 20:28:41 +0000 (20:28 +0000)]
Fix pgstattuple to acquire a read lock on the target table.  This
prevents embarassments such as having the table dropped or truncated
partway through the scan.  Also, fix free space calculation to include
pages that currently contain no tuples.

22 years agoTemporarily dike out GetUndoRecPtr() in checkpoint generation, since we
Tom Lane [Wed, 19 Dec 2001 19:42:51 +0000 (19:42 +0000)]
Temporarily dike out GetUndoRecPtr() in checkpoint generation, since we
do not use the undo pointer anyway.  This is a quick-hack solution for
the three-way deadlock condition discussed in pghackers 17-Dec-01.
Need to find a better way of doing it.

22 years agoNew edition
Peter Eisentraut [Wed, 19 Dec 2001 18:53:58 +0000 (18:53 +0000)]
New edition

22 years agoBetter formatting
Peter Eisentraut [Wed, 19 Dec 2001 18:53:47 +0000 (18:53 +0000)]
Better formatting

22 years agoMinor improvements
Peter Eisentraut [Wed, 19 Dec 2001 18:50:48 +0000 (18:50 +0000)]
Minor improvements

22 years agoSome tuning
Peter Eisentraut [Wed, 19 Dec 2001 18:49:56 +0000 (18:49 +0000)]
Some tuning

22 years agoFix warning
Peter Eisentraut [Wed, 19 Dec 2001 18:49:24 +0000 (18:49 +0000)]
Fix warning

22 years agoTweak to make freebsd/alpha use the correct float8 comparison file.
Tom Lane [Wed, 19 Dec 2001 17:25:55 +0000 (17:25 +0000)]
Tweak to make freebsd/alpha use the correct float8 comparison file.

22 years agoMake sure that all variants of HeapTupleSatisfies will do the right thing
Tom Lane [Wed, 19 Dec 2001 17:18:39 +0000 (17:18 +0000)]
Make sure that all variants of HeapTupleSatisfies will do the right thing
if presented with a tuple in process of being moved by VACUUM.  Per
bug report from Brian Hirt.

22 years agoMove geqo enable into proper section.
Bruce Momjian [Mon, 17 Dec 2001 19:09:01 +0000 (19:09 +0000)]
Move geqo enable into proper section.

22 years agoUpdate TODO list.
Bruce Momjian [Sat, 15 Dec 2001 17:28:51 +0000 (17:28 +0000)]
Update TODO list.

22 years agoUpdate TODO list.
Bruce Momjian [Sat, 15 Dec 2001 16:11:57 +0000 (16:11 +0000)]
Update TODO list.

22 years agoMore comment for libpgeasy.
Bruce Momjian [Fri, 14 Dec 2001 02:15:04 +0000 (02:15 +0000)]
More comment for libpgeasy.

22 years agoFix double-memory free in libpgeasy; problem introduced yesterday.
Bruce Momjian [Fri, 14 Dec 2001 00:52:53 +0000 (00:52 +0000)]
Fix double-memory free in libpgeasy;  problem introduced yesterday.

22 years agoClean up comment in libpgeasy.
Bruce Momjian [Fri, 14 Dec 2001 00:40:31 +0000 (00:40 +0000)]
Clean up comment in libpgeasy.

22 years agoAdd Swedish
Peter Eisentraut [Thu, 13 Dec 2001 22:06:33 +0000 (22:06 +0000)]
Add Swedish

22 years agoupdate
Peter Eisentraut [Thu, 13 Dec 2001 22:04:40 +0000 (22:04 +0000)]
update

22 years agoUpdate from Serguei Mokhov
Peter Eisentraut [Thu, 13 Dec 2001 22:04:12 +0000 (22:04 +0000)]
Update from Serguei Mokhov

22 years agoUpdate Hungarian from Kovacs Zoltan
Peter Eisentraut [Thu, 13 Dec 2001 22:02:20 +0000 (22:02 +0000)]
Update Hungarian from Kovacs Zoltan

22 years ago--with-pam was claiming to take an argument, but didn't. Help display fixed.
Peter Eisentraut [Thu, 13 Dec 2001 22:00:22 +0000 (22:00 +0000)]
--with-pam was claiming to take an argument, but didn't.  Help display fixed.

22 years agorevert last change
Peter Eisentraut [Thu, 13 Dec 2001 18:39:04 +0000 (18:39 +0000)]
revert last change

22 years ago>>I confirmed the UNION hack is no longer required. Thanks! Is it too late
Bruce Momjian [Thu, 13 Dec 2001 10:48:39 +0000 (10:48 +0000)]
>>I confirmed the UNION hack is no longer required. Thanks! Is it too late
>>to change the README in contrib/dblink?
>>
>
> No, I don't think that's a problem.  Send a patch.
>

Here's a (documentation only) patch for the contrib/dblink README.

Joe Conway

22 years agoFree libpgeasy result structure on database close; fixed memory leak.
Bruce Momjian [Thu, 13 Dec 2001 09:40:18 +0000 (09:40 +0000)]
Free libpgeasy result structure on database close; fixed memory leak.

22 years agotag it as b4, with all the changes that have gone on ... REL7_2_BETA4
PostgreSQL Daemon [Wed, 12 Dec 2001 13:30:12 +0000 (13:30 +0000)]
tag it as b4, with all the changes that have gone on ...

22 years agoDon't accept names of complex types (ie, relation types) as being
Tom Lane [Wed, 12 Dec 2001 03:28:49 +0000 (03:28 +0000)]
Don't accept names of complex types (ie, relation types) as being
requests for implicit trivial coercions.  Prevents sillinesses like
this one:
regression=# select x.int8_tbl.q1 from int8_tbl x;
ERROR:  fmgr_info: function 270997776: cache lookup failed

22 years agoApplied patch from Thomas O'Dowd that fixes timestamp parsing. The jdbc code
Barry Lind [Tue, 11 Dec 2001 04:48:05 +0000 (04:48 +0000)]
Applied patch from Thomas O'Dowd that fixes timestamp parsing.  The jdbc code
wasn't updated to handle more than two decimal digits for fractional seconds
that now are possible in 7.2.  This patch fixes the timestamp parsing logic.
I have built and tested on both jdbc1 and jdbc2.

22 years agoPatch from Ned Wolpert that fixes a bug that caused the cache of types not
Barry Lind [Tue, 11 Dec 2001 04:44:23 +0000 (04:44 +0000)]
Patch from Ned Wolpert that fixes a bug that caused the cache of types not
to be used, causing extra sql statements to be executed.  This was a
significant performance problem with the database meta data classes.
The fix is a simple one liner.

22 years agoMake sure that inlined S_UNLOCK is marked as an update of a 'volatile'
Tom Lane [Tue, 11 Dec 2001 02:58:49 +0000 (02:58 +0000)]
Make sure that inlined S_UNLOCK is marked as an update of a 'volatile'
object.  This should prevent the compiler from reordering loads and stores
into or out of a critical section.

22 years agoRepair roundoff-error problem for stddev/variance results near zero,
Tom Lane [Tue, 11 Dec 2001 02:02:12 +0000 (02:02 +0000)]
Repair roundoff-error problem for stddev/variance results near zero,
per complaint from Kemin Zhou.
Fix lack of precision in numeric stddev/variance.

22 years agoSuppress subquery pullup and pushdown when the subquery has any
Tom Lane [Mon, 10 Dec 2001 22:54:12 +0000 (22:54 +0000)]
Suppress subquery pullup and pushdown when the subquery has any
set-returning functions in its target list.  This ensures that we
won't rewrite the query in a way that places set-returning functions
into quals (WHERE clauses).  Cf. bug reports from Joe Conway.

22 years agoDeclare LWLock pointers as volatile to prevent AIX compiler from
Tom Lane [Mon, 10 Dec 2001 21:13:50 +0000 (21:13 +0000)]
Declare LWLock pointers as volatile to prevent AIX compiler from
reordering operations at its whim.  Releasing TAS lock before we've
finished updating proc structure is uncool.

22 years agoUpdate from Weiping He
Peter Eisentraut [Mon, 10 Dec 2001 18:45:57 +0000 (18:45 +0000)]
Update from Weiping He

22 years agoUpdate from Serguei Mokhov
Peter Eisentraut [Mon, 10 Dec 2001 18:44:44 +0000 (18:44 +0000)]
Update from Serguei Mokhov

22 years agoAIX 5 needs same resultmap tweaks as AIX 4.
Tom Lane [Mon, 10 Dec 2001 16:31:23 +0000 (16:31 +0000)]
AIX 5 needs same resultmap tweaks as AIX 4.

22 years agoRepair case-conversion error in to_date's handling of roman numerals.
Tom Lane [Mon, 10 Dec 2001 15:34:05 +0000 (15:34 +0000)]
Repair case-conversion error in to_date's handling of roman numerals.
From Manuel Sugawara, approved by Karel Zak.

22 years agocommitted the missing files
Michael Meskes [Mon, 10 Dec 2001 14:55:47 +0000 (14:55 +0000)]
committed the missing files

22 years agoRevert breakage
Peter Eisentraut [Mon, 10 Dec 2001 13:07:16 +0000 (13:07 +0000)]
Revert breakage

22 years agoAdd French translation
Peter Eisentraut [Mon, 10 Dec 2001 13:03:55 +0000 (13:03 +0000)]
Add French translation

22 years agoupdate
Peter Eisentraut [Mon, 10 Dec 2001 13:03:12 +0000 (13:03 +0000)]
update

22 years agoAdd new Japanese FAQ versions.
Bruce Momjian [Mon, 10 Dec 2001 11:17:51 +0000 (11:17 +0000)]
Add new Japanese FAQ versions.

22 years agoRemove duplicate lines from previous patch attempt. Trouble with my
Thomas G. Lockhart [Mon, 10 Dec 2001 00:11:06 +0000 (00:11 +0000)]
Remove duplicate lines from previous patch attempt. Trouble with my
 DSL line at home broke things right in the middle of an update. :(

22 years agoSupport ODBC-style CURRENT_TIME, CURRENT_USER, etc with trailing empty
Thomas G. Lockhart [Mon, 10 Dec 2001 00:01:14 +0000 (00:01 +0000)]
Support ODBC-style CURRENT_TIME, CURRENT_USER, etc with trailing empty
 parens. This is not SQL spec syntax, so later we will remove
 this extension from gram.y.

22 years agoFixed several bugs concerning indicators and added error messages instead of segfaults.
Michael Meskes [Sun, 9 Dec 2001 15:27:49 +0000 (15:27 +0000)]
Fixed several bugs concerning indicators and added error messages instead of segfaults.

22 years agoAllow variable (unrestricted) precision for TIME and TIMESTAMP types in parser.
Thomas G. Lockhart [Sun, 9 Dec 2001 04:39:39 +0000 (04:39 +0000)]
Allow variable (unrestricted) precision for TIME and TIMESTAMP types in parser.

22 years agoHonor the typmod field for time zone intervals.
Thomas G. Lockhart [Sun, 9 Dec 2001 04:37:50 +0000 (04:37 +0000)]
Honor the typmod field for time zone intervals.