OSDN Git Service
Bruce Momjian [Fri, 14 Dec 2001 00:40:31 +0000 (00:40 +0000)]
Clean up comment in libpgeasy.
Peter Eisentraut [Thu, 13 Dec 2001 22:06:33 +0000 (22:06 +0000)]
Add Swedish
Peter Eisentraut [Thu, 13 Dec 2001 22:04:40 +0000 (22:04 +0000)]
update
Peter Eisentraut [Thu, 13 Dec 2001 22:04:12 +0000 (22:04 +0000)]
Update from Serguei Mokhov
Peter Eisentraut [Thu, 13 Dec 2001 22:02:20 +0000 (22:02 +0000)]
Update Hungarian from Kovacs Zoltan
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.
Peter Eisentraut [Thu, 13 Dec 2001 18:39:04 +0000 (18:39 +0000)]
revert last change
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
Bruce Momjian [Thu, 13 Dec 2001 09:40:18 +0000 (09:40 +0000)]
Free libpgeasy result structure on database close; fixed memory leak.
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 ...
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
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.
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.
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.
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.
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.
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.
Peter Eisentraut [Mon, 10 Dec 2001 18:45:57 +0000 (18:45 +0000)]
Update from Weiping He
Peter Eisentraut [Mon, 10 Dec 2001 18:44:44 +0000 (18:44 +0000)]
Update from Serguei Mokhov
Tom Lane [Mon, 10 Dec 2001 16:31:23 +0000 (16:31 +0000)]
AIX 5 needs same resultmap tweaks as AIX 4.
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.
Michael Meskes [Mon, 10 Dec 2001 14:55:47 +0000 (14:55 +0000)]
committed the missing files
Peter Eisentraut [Mon, 10 Dec 2001 13:07:16 +0000 (13:07 +0000)]
Revert breakage
Peter Eisentraut [Mon, 10 Dec 2001 13:03:55 +0000 (13:03 +0000)]
Add French translation
Peter Eisentraut [Mon, 10 Dec 2001 13:03:12 +0000 (13:03 +0000)]
update
Bruce Momjian [Mon, 10 Dec 2001 11:17:51 +0000 (11:17 +0000)]
Add new Japanese FAQ versions.
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. :(
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.
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.
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.
Thomas G. Lockhart [Sun, 9 Dec 2001 04:37:50 +0000 (04:37 +0000)]
Honor the typmod field for time zone intervals.
Michael Meskes [Sat, 8 Dec 2001 20:43:35 +0000 (20:43 +0000)]
Fix ecpg to allow pointer to structs.
Thomas G. Lockhart [Sat, 8 Dec 2001 03:24:40 +0000 (03:24 +0000)]
Use PostgreSQL consistantly throughout docs. Before, usage was split evenly
between Postgres and PostgreSQL.
Thomas G. Lockhart [Sat, 8 Dec 2001 03:24:23 +0000 (03:24 +0000)]
Update list of currently supported platforms.
Mention SQL9x precision syntax for date/time types.
Use PostgreSQL consistantly throughout docs. Before, usage was split evenly
between Postgres and PostgreSQL.
Hiroshi Inoue [Fri, 7 Dec 2001 04:18:31 +0000 (04:18 +0000)]
Fix a lo_manage()'s bug.
Michael Meskes [Thu, 6 Dec 2001 14:46:20 +0000 (14:46 +0000)]
- Removed debug message from preproc.y.
- Fixed some bugs in exec sql var and exec sql type command.
Bruce Momjian [Thu, 6 Dec 2001 10:19:24 +0000 (10:19 +0000)]
Update TODO list.
Bruce Momjian [Wed, 5 Dec 2001 23:12:16 +0000 (23:12 +0000)]
Add to java.
Bruce Momjian [Wed, 5 Dec 2001 23:11:30 +0000 (23:11 +0000)]
Update TODO list.
Bruce Momjian [Wed, 5 Dec 2001 21:25:28 +0000 (21:25 +0000)]
Update TODO list.
Bruce Momjian [Wed, 5 Dec 2001 21:23:45 +0000 (21:23 +0000)]
Update TODO list.
Bruce Momjian [Wed, 5 Dec 2001 21:07:23 +0000 (21:07 +0000)]
Add mention of CREATE TABLE and atttypmod problems.
Bruce Momjian [Wed, 5 Dec 2001 21:06:40 +0000 (21:06 +0000)]
Update TODO list.
Bruce Momjian [Wed, 5 Dec 2001 21:02:43 +0000 (21:02 +0000)]
Add mention of aggregates and updates causing problems.
Bruce Momjian [Wed, 5 Dec 2001 18:25:28 +0000 (18:25 +0000)]
We forgot to mention in README.rtree_gist we implemented new
picksplit algorithm for Rtree. Please apply patch below to CVS
Oleg Bartunov
Bruce Momjian [Wed, 5 Dec 2001 18:23:40 +0000 (18:23 +0000)]
Attached is the FAQ_MSWIN patch as promised. Hopefully, it is not too
little, too late...
Jason Tishler
Bruce Momjian [Wed, 5 Dec 2001 18:20:42 +0000 (18:20 +0000)]
Update TODO list.
Michael Meskes [Wed, 5 Dec 2001 15:32:07 +0000 (15:32 +0000)]
- Fixed variable handling in AT statement.
- Fixed bug that caused segfault when given incorrect DB name.
- Fixed bug in ecpglib causing indicator to list the size of the
variable instead of the size of the data.
Bruce Momjian [Wed, 5 Dec 2001 05:41:13 +0000 (05:41 +0000)]
Update FAQ.
Bruce Momjian [Wed, 5 Dec 2001 05:38:51 +0000 (05:38 +0000)]
Update FAQ.
Bruce Momjian [Wed, 5 Dec 2001 05:33:48 +0000 (05:33 +0000)]
Update FAQ.
Tatsuo Ishii [Wed, 5 Dec 2001 02:06:19 +0000 (02:06 +0000)]
Fix for usage of spirntf in more portable way.
Tatsuo Ishii [Wed, 5 Dec 2001 02:03:59 +0000 (02:03 +0000)]
Re-enable SunOS4 port. Replace
RTLD_LAZY | RTLD_GLOBAL to 1.
It seems sunos4.h was accidentally modified between 7.1 and 7.2.
Tom Lane [Tue, 4 Dec 2001 21:19:57 +0000 (21:19 +0000)]
Enforce restriction that COPY DELIMITERS string must be exactly one
character; replace strchr() search with simple comparison to speed up
COPY IN. Per discussion in pghackers.
Tom Lane [Tue, 4 Dec 2001 20:57:22 +0000 (20:57 +0000)]
Change appendStringInfoChar to appendStringInfoCharMacro in a couple of
hot spots --- buys about 10% in Verner's INSERT example.
Bruce Momjian [Tue, 4 Dec 2001 20:25:01 +0000 (20:25 +0000)]
Update possible release date 2001-12-??
Bruce Momjian [Tue, 4 Dec 2001 20:15:41 +0000 (20:15 +0000)]
Update HISTORY to current.
Tom Lane [Tue, 4 Dec 2001 19:40:17 +0000 (19:40 +0000)]
Replace pq_getbytes(&ch, 1) calls with pq_getbyte(), which is easier
to use and significantly faster. This tweak saves 25% (!) of the runtime
of COPY IN in a test with 8000-character lines. I wouldn't normally
commit a performance improvement this late in the cycle, but 25% got
my attention...
Tom Lane [Tue, 4 Dec 2001 17:19:48 +0000 (17:19 +0000)]
Remove now-dead code for processing CONSTR_UNIQUE nodes in
AlterTableAddConstraint. Earlier reorganization of the parser's
processing of ALTER TABLE means that these node types no longer get here.
Bruce Momjian [Tue, 4 Dec 2001 17:12:25 +0000 (17:12 +0000)]
Update FAQ_DEV.
Bruce Momjian [Tue, 4 Dec 2001 17:00:51 +0000 (17:00 +0000)]
Hi Bruce, here is a first version of the hu.po file for the backend. I
tested it with 7.2b3 and worked fine.
Regards, Zoltan
Tom Lane [Tue, 4 Dec 2001 16:17:48 +0000 (16:17 +0000)]
Suppress data directory access-permissions check when __CYGWIN__,
per recent pghackers discussions. Improving this should be a TODO
for 7.3.
Michael Meskes [Tue, 4 Dec 2001 12:33:15 +0000 (12:33 +0000)]
Fixed dumping of structs without indicators.
Bruce Momjian [Tue, 4 Dec 2001 07:12:08 +0000 (07:12 +0000)]
Update FAQ.
Bruce Momjian [Tue, 4 Dec 2001 07:10:45 +0000 (07:10 +0000)]
Another test of double-commit. It used only commit one file.
Bruce Momjian [Tue, 4 Dec 2001 07:09:53 +0000 (07:09 +0000)]
Test of double-commit.
Bruce Momjian [Tue, 4 Dec 2001 06:44:45 +0000 (06:44 +0000)]
Update FAQ_DEV.
Bruce Momjian [Tue, 4 Dec 2001 06:40:09 +0000 (06:40 +0000)]
Update FAQ_DEV.
Bruce Momjian [Tue, 4 Dec 2001 06:37:26 +0000 (06:37 +0000)]
Update FAQ_DEV.
Bruce Momjian [Tue, 4 Dec 2001 06:35:51 +0000 (06:35 +0000)]
Update FAQ_DEV.
Bruce Momjian [Tue, 4 Dec 2001 06:26:59 +0000 (06:26 +0000)]
Update FAQ_DEV.
Bruce Momjian [Tue, 4 Dec 2001 06:20:53 +0000 (06:20 +0000)]
Update FAQ_DEV.
Bruce Momjian [Tue, 4 Dec 2001 06:20:09 +0000 (06:20 +0000)]
Update FAQ_DEV.
Bruce Momjian [Tue, 4 Dec 2001 06:14:44 +0000 (06:14 +0000)]
Update FAQ_DEV.
Bruce Momjian [Tue, 4 Dec 2001 06:14:04 +0000 (06:14 +0000)]
Update FAQ_DEV.
Tom Lane [Tue, 4 Dec 2001 02:21:35 +0000 (02:21 +0000)]
Recommend --enable-debug with somewhat more enthusiasm.
Tom Lane [Tue, 4 Dec 2001 02:07:11 +0000 (02:07 +0000)]
Fix trigger example for PG 7.2 change: count(*) now returns int8.
Tom Lane [Tue, 4 Dec 2001 01:49:17 +0000 (01:49 +0000)]
Document max-processes-per-user limit as a possible cause of failures
in the parallel regression tests. Suggest editing parallel_schedule
as a workaround if one cannot fix the system limits.
Tom Lane [Tue, 4 Dec 2001 01:22:13 +0000 (01:22 +0000)]
Add some more material to the section about partial indexes.
Peter Eisentraut [Mon, 3 Dec 2001 19:56:43 +0000 (19:56 +0000)]
Update to get around backslash problems
Tom Lane [Mon, 3 Dec 2001 19:33:35 +0000 (19:33 +0000)]
A quickie FAQ_IRIX covering some known issues, from Luis Amigo.
Tom Lane [Mon, 3 Dec 2001 19:02:58 +0000 (19:02 +0000)]
Fix latent bug in checking for failure of hashtable creation.
Bruce Momjian [Mon, 3 Dec 2001 18:43:21 +0000 (18:43 +0000)]
attachement is the NLS patch for backend/po & pg_dump,
they are all against the current CVS tree. the patch is about 70K.
regards laser
Tom Lane [Mon, 3 Dec 2001 17:48:57 +0000 (17:48 +0000)]
Update IRIX geometry results to match newer MIPS FPUs, rather than
older ones. We really gotta get out of the business of matching every
last low-order bit in this test ...
Tom Lane [Mon, 3 Dec 2001 17:44:52 +0000 (17:44 +0000)]
Add configure-time check whether sig_atomic_t is defined; if not,
provide a default definition equating it to 'int'. Should trigger only
on machines with pre-ANSI-C header files, eg SunOS 4.1.x.
Tom Lane [Mon, 3 Dec 2001 14:49:46 +0000 (14:49 +0000)]
Pg_lo_open must OR together multiple modes, not AND them. Per report
from Andreas Kretzer.
D'Arcy J.M. Cain [Mon, 3 Dec 2001 12:39:44 +0000 (12:39 +0000)]
Bump version to 3.3. Mostly this is because there is some confusion about
the latest version and I wanted to make sure that there was a clean release.
I also change the build files as I discussed in my letter of Nov 6, 2001. At
the time I was asked to hold off until after the release.
Tom Lane [Mon, 3 Dec 2001 00:28:24 +0000 (00:28 +0000)]
Remove code to lookup WinSock error strings in netmsg.dll; according to
Magnus Hagander that DLL only contains error strings for the Net***
functions, *not* WinSock. We need to look for a workable solution for
older Windows flavors ... but it won't happen for PG 7.2.
Tom Lane [Sun, 2 Dec 2001 15:48:19 +0000 (15:48 +0000)]
HPUX 11 should use geometry-solaris-precision, not geometry-positive-zeros
as is needed for HPUX 9 and 10.
Peter Eisentraut [Sun, 2 Dec 2001 11:38:40 +0000 (11:38 +0000)]
More correct way to check for existence of types, which allows to specify
which include files to consider. Should fix BeOS problems with int8 types.
Peter Eisentraut [Sun, 2 Dec 2001 11:36:04 +0000 (11:36 +0000)]
Update since left and right are no longer key words.
Tom Lane [Sat, 1 Dec 2001 04:19:20 +0000 (04:19 +0000)]
Provide some documentation for EXISTS, IN, NOT IN, ANY/SOME/ALL,
and row comparisons. How'd this manage to slip through the cracks?
Tom Lane [Fri, 30 Nov 2001 20:21:06 +0000 (20:21 +0000)]
Try to make genbki.sh a little more bulletproof, per trouble report
from Paul Stavrides.
Tom Lane [Fri, 30 Nov 2001 19:24:15 +0000 (19:24 +0000)]
Repair failure to mark an inserted Materialize node with the appropriate
extParam/locParam lists. Per bug #526.
Peter Eisentraut [Fri, 30 Nov 2001 18:04:23 +0000 (18:04 +0000)]
updates
Bruce Momjian [Fri, 30 Nov 2001 17:39:20 +0000 (17:39 +0000)]
* include <endian.h> is not enough, include sys/types.h too
everywhere.
At least it was now detected correctly.
marko
Bruce Momjian [Fri, 30 Nov 2001 01:22:47 +0000 (01:22 +0000)]
Mention rules and views instead of SELECT triggers.
Bruce Momjian [Thu, 29 Nov 2001 23:13:19 +0000 (23:13 +0000)]
Add to Java.
Tom Lane [Thu, 29 Nov 2001 22:57:37 +0000 (22:57 +0000)]
Tweak plpgsql's expression reader to be smarter about parentheses and
to give more useful error messages. Stephen Szabo's example of this
morning ('loop' used as a variable name inside a subselect) works
correctly now, and a FOR that is misinterpreted as an integer FOR will
draw 'missing .. at end of SQL expression', which is at least
marginally helpful.
Bruce Momjian [Thu, 29 Nov 2001 22:18:14 +0000 (22:18 +0000)]
Add mention of no SELECT triggers.