]> granicus.if.org Git - postgresql/log
postgresql
22 years agoUpdate HISTORY to current.
Bruce Momjian [Tue, 4 Dec 2001 20:15:41 +0000 (20:15 +0000)]
Update HISTORY to current.

22 years agoReplace pq_getbytes(&ch, 1) calls with pq_getbyte(), which is easier
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...

22 years agoRemove now-dead code for processing CONSTR_UNIQUE nodes in
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.

22 years agoUpdate FAQ_DEV.
Bruce Momjian [Tue, 4 Dec 2001 17:12:25 +0000 (17:12 +0000)]
Update FAQ_DEV.

22 years agoHi Bruce, here is a first version of the hu.po file for the backend. I
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

22 years agoSuppress data directory access-permissions check when __CYGWIN__,
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.

22 years ago Fixed dumping of structs without indicators.
Michael Meskes [Tue, 4 Dec 2001 12:33:15 +0000 (12:33 +0000)]
Fixed dumping of structs without indicators.

22 years agoUpdate FAQ.
Bruce Momjian [Tue, 4 Dec 2001 07:12:08 +0000 (07:12 +0000)]
Update FAQ.

22 years agoAnother test of double-commit. It used only commit one file.
Bruce Momjian [Tue, 4 Dec 2001 07:10:45 +0000 (07:10 +0000)]
Another test of double-commit.  It used only commit one file.

22 years agoTest of double-commit.
Bruce Momjian [Tue, 4 Dec 2001 07:09:53 +0000 (07:09 +0000)]
Test of double-commit.

22 years agoUpdate FAQ_DEV.
Bruce Momjian [Tue, 4 Dec 2001 06:44:45 +0000 (06:44 +0000)]
Update FAQ_DEV.

22 years agoUpdate FAQ_DEV.
Bruce Momjian [Tue, 4 Dec 2001 06:40:09 +0000 (06:40 +0000)]
Update FAQ_DEV.

22 years agoUpdate FAQ_DEV.
Bruce Momjian [Tue, 4 Dec 2001 06:37:26 +0000 (06:37 +0000)]
Update FAQ_DEV.

22 years agoUpdate FAQ_DEV.
Bruce Momjian [Tue, 4 Dec 2001 06:35:51 +0000 (06:35 +0000)]
Update FAQ_DEV.

22 years agoUpdate FAQ_DEV.
Bruce Momjian [Tue, 4 Dec 2001 06:26:59 +0000 (06:26 +0000)]
Update FAQ_DEV.

22 years agoUpdate FAQ_DEV.
Bruce Momjian [Tue, 4 Dec 2001 06:20:53 +0000 (06:20 +0000)]
Update FAQ_DEV.

22 years agoUpdate FAQ_DEV.
Bruce Momjian [Tue, 4 Dec 2001 06:20:09 +0000 (06:20 +0000)]
Update FAQ_DEV.

22 years agoUpdate FAQ_DEV.
Bruce Momjian [Tue, 4 Dec 2001 06:14:44 +0000 (06:14 +0000)]
Update FAQ_DEV.

22 years agoUpdate FAQ_DEV.
Bruce Momjian [Tue, 4 Dec 2001 06:14:04 +0000 (06:14 +0000)]
Update FAQ_DEV.

22 years agoRecommend --enable-debug with somewhat more enthusiasm.
Tom Lane [Tue, 4 Dec 2001 02:21:35 +0000 (02:21 +0000)]
Recommend --enable-debug with somewhat more enthusiasm.

22 years agoFix trigger example for PG 7.2 change: count(*) now returns int8.
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.

22 years agoDocument max-processes-per-user limit as a possible cause of failures
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.

22 years agoAdd some more material to the section about partial indexes.
Tom Lane [Tue, 4 Dec 2001 01:22:13 +0000 (01:22 +0000)]
Add some more material to the section about partial indexes.

22 years agoUpdate to get around backslash problems
Peter Eisentraut [Mon, 3 Dec 2001 19:56:43 +0000 (19:56 +0000)]
Update to get around backslash problems

22 years agoA quickie FAQ_IRIX covering some known issues, from Luis Amigo.
Tom Lane [Mon, 3 Dec 2001 19:33:35 +0000 (19:33 +0000)]
A quickie FAQ_IRIX covering some known issues, from Luis Amigo.

22 years agoFix latent bug in checking for failure of hashtable creation.
Tom Lane [Mon, 3 Dec 2001 19:02:58 +0000 (19:02 +0000)]
Fix latent bug in checking for failure of hashtable creation.

22 years agoattachement is the NLS patch for backend/po & pg_dump,
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

22 years agoUpdate IRIX geometry results to match newer MIPS FPUs, rather than
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 ...

22 years agoAdd configure-time check whether sig_atomic_t is defined; if not,
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.

22 years agoPg_lo_open must OR together multiple modes, not AND them. Per report
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.

22 years agoBump version to 3.3. Mostly this is because there is some confusion about
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.

22 years agoRemove code to lookup WinSock error strings in netmsg.dll; according to
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.

22 years agoHPUX 11 should use geometry-solaris-precision, not geometry-positive-zeros
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.

22 years agoMore correct way to check for existence of types, which allows to specify
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.

22 years agoUpdate since left and right are no longer key words.
Peter Eisentraut [Sun, 2 Dec 2001 11:36:04 +0000 (11:36 +0000)]
Update since left and right are no longer key words.

22 years agoProvide some documentation for EXISTS, IN, NOT IN, ANY/SOME/ALL,
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?

22 years agoTry to make genbki.sh a little more bulletproof, per trouble report
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.

22 years agoRepair failure to mark an inserted Materialize node with the appropriate
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.

22 years agoupdates
Peter Eisentraut [Fri, 30 Nov 2001 18:04:23 +0000 (18:04 +0000)]
updates

22 years ago* include <endian.h> is not enough, include sys/types.h too
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

22 years agoMention rules and views instead of SELECT triggers.
Bruce Momjian [Fri, 30 Nov 2001 01:22:47 +0000 (01:22 +0000)]
Mention rules and views instead of SELECT triggers.

22 years agoAdd to Java.
Bruce Momjian [Thu, 29 Nov 2001 23:13:19 +0000 (23:13 +0000)]
Add to Java.

22 years agoTweak plpgsql's expression reader to be smarter about parentheses and
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.

22 years agoAdd mention of no SELECT triggers.
Bruce Momjian [Thu, 29 Nov 2001 22:18:14 +0000 (22:18 +0000)]
Add mention of no SELECT triggers.

22 years agoFix array_out's failure to backslash backslashes, per bug# 524. Also,
Tom Lane [Thu, 29 Nov 2001 21:02:41 +0000 (21:02 +0000)]
Fix array_out's failure to backslash backslashes, per bug# 524.  Also,
remove brain-dead rule that double quotes are needed if and only if the
datatype is pass-by-reference; neither direction of the implication holds
water.  Instead, examine the actual data string to see if it contains
any characters that force us to quote it.
Add some documentation about quoting of array values, which was previously
explained nowhere AFAICT.

22 years agoCleanup of new ps markup.
Bruce Momjian [Thu, 29 Nov 2001 20:43:43 +0000 (20:43 +0000)]
Cleanup of new ps markup.

22 years agoUpdate ps status display information for Solaris, from Tom Lane.
Bruce Momjian [Thu, 29 Nov 2001 20:26:55 +0000 (20:26 +0000)]
Update ps status display information for Solaris, from Tom Lane.

22 years ago* When postgres.h does not define BYTE_ENDIAN pgcrypto
Bruce Momjian [Thu, 29 Nov 2001 19:40:37 +0000 (19:40 +0000)]
* When postgres.h does not define BYTE_ENDIAN pgcrypto
  produces garbage.

I learned the hard way that

        #if UNDEFINED_1 == UNDEFINED_2
        #error "gcc is idiot"
        #endif

prints "gcc is idiot" ...

Affected are MD5/SHA1 in internal library, and also HMAC-MD5/HMAC-SHA1/
crypt-md5 which use them.  Blowfish is ok, also Rijndael on at
least x86.

Big thanks to Daniel Holtzman who send me a build log which
contained warning:

        md5.c:246: warning: `X' defined but not used

Yes, gcc is that helpful...

Please apply this.

--
marko

22 years agoNLS updates, most notably fixed zh_TW translations
Peter Eisentraut [Thu, 29 Nov 2001 18:59:28 +0000 (18:59 +0000)]
NLS updates, most notably fixed zh_TW translations

22 years agoFix results to work with normal systems again.
Peter Eisentraut [Thu, 29 Nov 2001 18:57:31 +0000 (18:57 +0000)]
Fix results to work with normal systems again.

22 years agoadded CallableStatement support to jdbc todo
Barry Lind [Thu, 29 Nov 2001 18:15:33 +0000 (18:15 +0000)]
added CallableStatement support to jdbc todo

22 years agoImprove wording
Peter Eisentraut [Thu, 29 Nov 2001 16:01:15 +0000 (16:01 +0000)]
Improve wording

22 years agoUpdate TODO list.
Bruce Momjian [Thu, 29 Nov 2001 15:39:11 +0000 (15:39 +0000)]
Update TODO list.

22 years agoUpdate TODO list.
Bruce Momjian [Thu, 29 Nov 2001 05:53:46 +0000 (05:53 +0000)]
Update TODO list.

22 years agoUpdated jdbc docs to reflect the doc comments received. Most comments were
Barry Lind [Thu, 29 Nov 2001 05:35:51 +0000 (05:35 +0000)]
Updated jdbc docs to reflect the doc comments received.  Most comments were
already addressed by previous doc updates.

22 years agoUpdate FAQ.
Bruce Momjian [Wed, 28 Nov 2001 21:11:39 +0000 (21:11 +0000)]
Update FAQ.

22 years agoUpdate from source
Peter Eisentraut [Wed, 28 Nov 2001 20:54:04 +0000 (20:54 +0000)]
Update from source

22 years agoproof-reading
Peter Eisentraut [Wed, 28 Nov 2001 20:49:10 +0000 (20:49 +0000)]
proof-reading

22 years agoMention ps environment flag, not just -e.
Bruce Momjian [Wed, 28 Nov 2001 20:36:09 +0000 (20:36 +0000)]
Mention ps environment flag, not just -e.

22 years agoUpdate 'ps e' comments.
Bruce Momjian [Wed, 28 Nov 2001 20:28:56 +0000 (20:28 +0000)]
Update 'ps e' comments.

22 years agoUpdate TODO list.
Bruce Momjian [Wed, 28 Nov 2001 20:18:38 +0000 (20:18 +0000)]
Update TODO list.

22 years agoDocument that PGPASSWORD is not secure.
Bruce Momjian [Wed, 28 Nov 2001 19:57:36 +0000 (19:57 +0000)]
Document that PGPASSWORD is not secure.

22 years agoLoad netmsg.dll locally in winsock_strerror, to avoid actual and
Tom Lane [Wed, 28 Nov 2001 19:40:29 +0000 (19:40 +0000)]
Load netmsg.dll locally in winsock_strerror, to avoid actual and
potential problems discussed in pgsql-interfaces.

22 years agoClarify per suggestion from Bruno Wolff.
Tom Lane [Wed, 28 Nov 2001 15:39:49 +0000 (15:39 +0000)]
Clarify per suggestion from Bruno Wolff.

22 years agoPoint out the dependency on having int8 arithmetic available.
Tom Lane [Wed, 28 Nov 2001 15:33:48 +0000 (15:33 +0000)]
Point out the dependency on having int8 arithmetic available.

22 years agoUpdate TODO list.
Bruce Momjian [Wed, 28 Nov 2001 05:44:51 +0000 (05:44 +0000)]
Update TODO list.

22 years agoReiterate that parsing of plpgsql functions is per-process.
Tom Lane [Wed, 28 Nov 2001 04:18:46 +0000 (04:18 +0000)]
Reiterate that parsing of plpgsql functions is per-process.

22 years agoUpdate FAQ_DEV.
Bruce Momjian [Wed, 28 Nov 2001 01:38:39 +0000 (01:38 +0000)]
Update FAQ_DEV.

22 years agoUpdate FAQ_DEV.
Bruce Momjian [Wed, 28 Nov 2001 01:38:09 +0000 (01:38 +0000)]
Update FAQ_DEV.

22 years agoUpdate FAQ_DEV.
Bruce Momjian [Wed, 28 Nov 2001 01:20:27 +0000 (01:20 +0000)]
Update FAQ_DEV.

22 years agoUpdate FAQ_DEV.
Bruce Momjian [Wed, 28 Nov 2001 00:37:49 +0000 (00:37 +0000)]
Update FAQ_DEV.

22 years agoUpdate FAQ.
Bruce Momjian [Wed, 28 Nov 2001 00:37:03 +0000 (00:37 +0000)]
Update FAQ.

22 years agoUpdate FAQ_DEV.
Bruce Momjian [Wed, 28 Nov 2001 00:36:28 +0000 (00:36 +0000)]
Update FAQ_DEV.

22 years agoUpdate FAQ_DEV.
Bruce Momjian [Wed, 28 Nov 2001 00:32:10 +0000 (00:32 +0000)]
Update FAQ_DEV.

22 years agoNo longer need define test in md5.h because of Hiroshi's win_md5.c.
Bruce Momjian [Wed, 28 Nov 2001 00:16:53 +0000 (00:16 +0000)]
No longer need define test in md5.h because of Hiroshi's win_md5.c.

22 years agoAdd mention of init -W flag for security.
Bruce Momjian [Wed, 28 Nov 2001 00:13:30 +0000 (00:13 +0000)]
Add mention of init -W flag for security.

22 years agoManual update.
Bruce Momjian [Wed, 28 Nov 2001 00:12:39 +0000 (00:12 +0000)]
Manual update.

22 years agoUpdate FAQ_DEV.
Bruce Momjian [Wed, 28 Nov 2001 00:10:01 +0000 (00:10 +0000)]
Update FAQ_DEV.

22 years agoFix nasty memory leak in pg_restore: _PrintData called inflateInit but
Tom Lane [Tue, 27 Nov 2001 23:48:12 +0000 (23:48 +0000)]
Fix nasty memory leak in pg_restore: _PrintData called inflateInit but
never did inflateEnd, thus leaking some tens of KB per call.  Which
added up *real fast* when dealing with, say, thousands of BLOBs.
Thanks to Lane Rollins for the bug report.

22 years agoUpdate FAQ_DEV.
Bruce Momjian [Tue, 27 Nov 2001 23:44:03 +0000 (23:44 +0000)]
Update FAQ_DEV.

22 years agoUpdate FAQ_DEV.
Bruce Momjian [Tue, 27 Nov 2001 21:48:45 +0000 (21:48 +0000)]
Update FAQ_DEV.

22 years agoUpdate TODO list.
Bruce Momjian [Tue, 27 Nov 2001 21:23:00 +0000 (21:23 +0000)]
Update TODO list.

22 years agoUpdate FAQ_DEV.
Bruce Momjian [Tue, 27 Nov 2001 20:45:27 +0000 (20:45 +0000)]
Update FAQ_DEV.

22 years agoUpdate TODO list.
Bruce Momjian [Tue, 27 Nov 2001 20:42:15 +0000 (20:42 +0000)]
Update TODO list.

22 years agoUpdate BSD/OS as supported on 7.2.
Bruce Momjian [Tue, 27 Nov 2001 20:35:08 +0000 (20:35 +0000)]
Update BSD/OS as supported on 7.2.

22 years agoAdd a section about loading libpgtcl; fix errors and omissions in
Tom Lane [Tue, 27 Nov 2001 20:33:29 +0000 (20:33 +0000)]
Add a section about loading libpgtcl; fix errors and omissions in
documentation of pg_select command.

22 years agoRemove unused entries.
Bruce Momjian [Tue, 27 Nov 2001 20:25:45 +0000 (20:25 +0000)]
Remove unused entries.

22 years agoUpdate TODO list.
Bruce Momjian [Tue, 27 Nov 2001 19:35:38 +0000 (19:35 +0000)]
Update TODO list.

22 years agoUpdate TODO list.
Bruce Momjian [Tue, 27 Nov 2001 19:31:17 +0000 (19:31 +0000)]
Update TODO list.

22 years agoUpdate FAQ.
Bruce Momjian [Tue, 27 Nov 2001 19:16:55 +0000 (19:16 +0000)]
Update FAQ.

22 years agoUpdate FAQ.
Bruce Momjian [Tue, 27 Nov 2001 18:22:32 +0000 (18:22 +0000)]
Update FAQ.

22 years agostrcat should obviously be strcpy here.
Tom Lane [Tue, 27 Nov 2001 18:21:51 +0000 (18:21 +0000)]
strcat should obviously be strcpy here.

22 years agoChinese PO patch
Bruce Momjian [Tue, 27 Nov 2001 17:51:54 +0000 (17:51 +0000)]
Chinese PO patch

Laser.

22 years agoFix imcomplete SGML tag.
Tatsuo Ishii [Tue, 27 Nov 2001 13:02:33 +0000 (13:02 +0000)]
Fix imcomplete SGML tag.
Please check compile errors before you commit!

22 years agoUpdate TODO list.
Bruce Momjian [Tue, 27 Nov 2001 04:11:08 +0000 (04:11 +0000)]
Update TODO list.

22 years agoUpdate FAQ_DEV.
Bruce Momjian [Tue, 27 Nov 2001 02:48:20 +0000 (02:48 +0000)]
Update FAQ_DEV.

22 years agoUpdate FAQ_DEV.
Bruce Momjian [Tue, 27 Nov 2001 02:36:59 +0000 (02:36 +0000)]
Update FAQ_DEV.

22 years agoUpdate FAQ_DEV.
Bruce Momjian [Tue, 27 Nov 2001 02:03:05 +0000 (02:03 +0000)]
Update FAQ_DEV.

22 years agoUpdate FAQ_DEV.
Bruce Momjian [Tue, 27 Nov 2001 02:01:55 +0000 (02:01 +0000)]
Update FAQ_DEV.

22 years agoformating and spelling fixes to my last doc update
Barry Lind [Tue, 27 Nov 2001 01:20:17 +0000 (01:20 +0000)]
formating and spelling fixes to my last doc update