OSDN Git Service
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.
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.
Bruce Momjian [Thu, 29 Nov 2001 20:43:43 +0000 (20:43 +0000)]
Cleanup of new ps markup.
Bruce Momjian [Thu, 29 Nov 2001 20:26:55 +0000 (20:26 +0000)]
Update ps status display information for Solaris, from Tom Lane.
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
Peter Eisentraut [Thu, 29 Nov 2001 18:59:28 +0000 (18:59 +0000)]
NLS updates, most notably fixed zh_TW translations
Peter Eisentraut [Thu, 29 Nov 2001 18:57:31 +0000 (18:57 +0000)]
Fix results to work with normal systems again.
Barry Lind [Thu, 29 Nov 2001 18:15:33 +0000 (18:15 +0000)]
added CallableStatement support to jdbc todo
Peter Eisentraut [Thu, 29 Nov 2001 16:01:15 +0000 (16:01 +0000)]
Improve wording
Bruce Momjian [Thu, 29 Nov 2001 15:39:11 +0000 (15:39 +0000)]
Update TODO list.
Bruce Momjian [Thu, 29 Nov 2001 05:53:46 +0000 (05:53 +0000)]
Update TODO list.
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.
Bruce Momjian [Wed, 28 Nov 2001 21:11:39 +0000 (21:11 +0000)]
Update FAQ.
Peter Eisentraut [Wed, 28 Nov 2001 20:54:04 +0000 (20:54 +0000)]
Update from source
Peter Eisentraut [Wed, 28 Nov 2001 20:49:10 +0000 (20:49 +0000)]
proof-reading
Bruce Momjian [Wed, 28 Nov 2001 20:36:09 +0000 (20:36 +0000)]
Mention ps environment flag, not just -e.
Bruce Momjian [Wed, 28 Nov 2001 20:28:56 +0000 (20:28 +0000)]
Update 'ps e' comments.
Bruce Momjian [Wed, 28 Nov 2001 20:18:38 +0000 (20:18 +0000)]
Update TODO list.
Bruce Momjian [Wed, 28 Nov 2001 19:57:36 +0000 (19:57 +0000)]
Document that PGPASSWORD is not secure.
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.
Tom Lane [Wed, 28 Nov 2001 15:39:49 +0000 (15:39 +0000)]
Clarify per suggestion from Bruno Wolff.
Tom Lane [Wed, 28 Nov 2001 15:33:48 +0000 (15:33 +0000)]
Point out the dependency on having int8 arithmetic available.
Bruce Momjian [Wed, 28 Nov 2001 05:44:51 +0000 (05:44 +0000)]
Update TODO list.
Tom Lane [Wed, 28 Nov 2001 04:18:46 +0000 (04:18 +0000)]
Reiterate that parsing of plpgsql functions is per-process.
Bruce Momjian [Wed, 28 Nov 2001 01:38:39 +0000 (01:38 +0000)]
Update FAQ_DEV.
Bruce Momjian [Wed, 28 Nov 2001 01:38:09 +0000 (01:38 +0000)]
Update FAQ_DEV.
Bruce Momjian [Wed, 28 Nov 2001 01:20:27 +0000 (01:20 +0000)]
Update FAQ_DEV.
Bruce Momjian [Wed, 28 Nov 2001 00:37:49 +0000 (00:37 +0000)]
Update FAQ_DEV.
Bruce Momjian [Wed, 28 Nov 2001 00:37:03 +0000 (00:37 +0000)]
Update FAQ.
Bruce Momjian [Wed, 28 Nov 2001 00:36:28 +0000 (00:36 +0000)]
Update FAQ_DEV.
Bruce Momjian [Wed, 28 Nov 2001 00:32:10 +0000 (00:32 +0000)]
Update FAQ_DEV.
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.
Bruce Momjian [Wed, 28 Nov 2001 00:13:30 +0000 (00:13 +0000)]
Add mention of init -W flag for security.
Bruce Momjian [Wed, 28 Nov 2001 00:12:39 +0000 (00:12 +0000)]
Manual update.
Bruce Momjian [Wed, 28 Nov 2001 00:10:01 +0000 (00:10 +0000)]
Update FAQ_DEV.
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.
Bruce Momjian [Tue, 27 Nov 2001 23:44:03 +0000 (23:44 +0000)]
Update FAQ_DEV.
Bruce Momjian [Tue, 27 Nov 2001 21:48:45 +0000 (21:48 +0000)]
Update FAQ_DEV.
Bruce Momjian [Tue, 27 Nov 2001 21:23:00 +0000 (21:23 +0000)]
Update TODO list.
Bruce Momjian [Tue, 27 Nov 2001 20:45:27 +0000 (20:45 +0000)]
Update FAQ_DEV.
Bruce Momjian [Tue, 27 Nov 2001 20:42:15 +0000 (20:42 +0000)]
Update TODO list.
Bruce Momjian [Tue, 27 Nov 2001 20:35:08 +0000 (20:35 +0000)]
Update BSD/OS as supported on 7.2.
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.
Bruce Momjian [Tue, 27 Nov 2001 20:25:45 +0000 (20:25 +0000)]
Remove unused entries.
Bruce Momjian [Tue, 27 Nov 2001 19:35:38 +0000 (19:35 +0000)]
Update TODO list.
Bruce Momjian [Tue, 27 Nov 2001 19:31:17 +0000 (19:31 +0000)]
Update TODO list.
Bruce Momjian [Tue, 27 Nov 2001 19:16:55 +0000 (19:16 +0000)]
Update FAQ.
Bruce Momjian [Tue, 27 Nov 2001 18:22:32 +0000 (18:22 +0000)]
Update FAQ.
Tom Lane [Tue, 27 Nov 2001 18:21:51 +0000 (18:21 +0000)]
strcat should obviously be strcpy here.
Bruce Momjian [Tue, 27 Nov 2001 17:51:54 +0000 (17:51 +0000)]
Chinese PO patch
Laser.
Tatsuo Ishii [Tue, 27 Nov 2001 13:02:33 +0000 (13:02 +0000)]
Fix imcomplete SGML tag.
Please check compile errors before you commit!
Bruce Momjian [Tue, 27 Nov 2001 04:11:08 +0000 (04:11 +0000)]
Update TODO list.
Bruce Momjian [Tue, 27 Nov 2001 02:48:20 +0000 (02:48 +0000)]
Update FAQ_DEV.
Bruce Momjian [Tue, 27 Nov 2001 02:36:59 +0000 (02:36 +0000)]
Update FAQ_DEV.
Bruce Momjian [Tue, 27 Nov 2001 02:03:05 +0000 (02:03 +0000)]
Update FAQ_DEV.
Bruce Momjian [Tue, 27 Nov 2001 02:01:55 +0000 (02:01 +0000)]
Update FAQ_DEV.
Barry Lind [Tue, 27 Nov 2001 01:20:17 +0000 (01:20 +0000)]
formating and spelling fixes to my last doc update
Tom Lane [Mon, 26 Nov 2001 23:10:36 +0000 (23:10 +0000)]
Fix various bogosities in usage message.
Tom Lane [Mon, 26 Nov 2001 23:09:21 +0000 (23:09 +0000)]
Fix confusion about -f switch: it's output not input.
Bruce Momjian [Mon, 26 Nov 2001 22:42:51 +0000 (22:42 +0000)]
Update FAQ_DEV.
Bruce Momjian [Mon, 26 Nov 2001 22:41:58 +0000 (22:41 +0000)]
Rename make_keywords.README to make_keywords.
Tom Lane [Mon, 26 Nov 2001 22:31:08 +0000 (22:31 +0000)]
Fix unportable, non-spec-compliant use of offsetof() with a nonconstant
member offset.
Bruce Momjian [Mon, 26 Nov 2001 21:56:40 +0000 (21:56 +0000)]
Update FAQ_DEV.
Bruce Momjian [Mon, 26 Nov 2001 21:42:24 +0000 (21:42 +0000)]
Rename find_baddefs to find_badmacros
Tom Lane [Mon, 26 Nov 2001 21:15:14 +0000 (21:15 +0000)]
Change display of FieldSelect nodes from arg.field to field(arg),
per bug report from Stefan Hadjistoytchev. There are some cases
where the dot notation works, but there are more where it doesn't.
Eventually ought to consider fixing the parser to allow cases like
func().field, but for now this is the simplest patch.
Bruce Momjian [Mon, 26 Nov 2001 21:07:44 +0000 (21:07 +0000)]
Update TODO list.
Bruce Momjian [Mon, 26 Nov 2001 21:07:01 +0000 (21:07 +0000)]
Add MySQL file system mention.
Bruce Momjian [Mon, 26 Nov 2001 21:03:34 +0000 (21:03 +0000)]
Add LAZY messages.
Bruce Momjian [Mon, 26 Nov 2001 21:03:15 +0000 (21:03 +0000)]
Update TODO list.
Bruce Momjian [Mon, 26 Nov 2001 21:01:13 +0000 (21:01 +0000)]
Update for all priviledge items.
Bruce Momjian [Mon, 26 Nov 2001 20:19:30 +0000 (20:19 +0000)]
Add to TODO item about raw device performance.
Bruce Momjian [Mon, 26 Nov 2001 20:11:28 +0000 (20:11 +0000)]
Add mention of UPDATE permissions.
Bruce Momjian [Mon, 26 Nov 2001 19:41:55 +0000 (19:41 +0000)]
Add documentation about "--" not working on Free/OpenBSD.
Bruce Momjian [Mon, 26 Nov 2001 19:33:33 +0000 (19:33 +0000)]
Update TODO list.
Bruce Momjian [Mon, 26 Nov 2001 19:30:58 +0000 (19:30 +0000)]
Fix for "--" options. Allow --xxx as a valid flag, from NetBSD fix.
Bruce Momjian [Mon, 26 Nov 2001 19:07:11 +0000 (19:07 +0000)]
More tag cleanups.
Bruce Momjian [Mon, 26 Nov 2001 18:51:19 +0000 (18:51 +0000)]
Fix SGML tag misspelling.
Bruce Momjian [Mon, 26 Nov 2001 17:56:32 +0000 (17:56 +0000)]
Chinese for psql and pg_dump.
laser
Bruce Momjian [Mon, 26 Nov 2001 17:45:41 +0000 (17:45 +0000)]
This patch mark datatype txtidx as 'extended' storage type.
Thanks.
Teodor Sigaev
Bruce Momjian [Mon, 26 Nov 2001 06:36:04 +0000 (06:36 +0000)]
Update TODO list.
Barry Lind [Mon, 26 Nov 2001 06:08:03 +0000 (06:08 +0000)]
Updated JDBC todo items
Barry Lind [Mon, 26 Nov 2001 05:57:57 +0000 (05:57 +0000)]
Updates to JDBC doc:
Editing pass over entire chapter
Rewrote section dealing with Large Objects to also talk about bytea support
Removed secion on Serialize functionality a we intend to remove it in the
next release
Tom Lane [Mon, 26 Nov 2001 00:29:15 +0000 (00:29 +0000)]
Repair problem with listing rules that have a WHERE condition and
have an INSERT...SELECT as the first or only action. Per bug report
from Sergio Pili.
Barry Lind [Sun, 25 Nov 2001 23:26:59 +0000 (23:26 +0000)]
This patch fixes a bug reported by Graham Leggett (minfrin@sharp.fm).
The bug was that any insert or update would fail if the returned oid was
larger than a signed int. Since OIDs are unsigned int's it was
a bug that the code used a java signed int to deal with the values. The bug
would result in the error message: "Unable to fathom update count".
While fixing the bug, it became apparent that other code made a similar
assumption about OIDs being signed ints. Therefore some methods that returned
or took OIDs are arguements also needed to be changed.
Since we are so close to the 7.2 release I have added new methods that
return longs and deprecated the old methods returning ints. Therefore all
old code should still work without requiring a code change to cast from long to int. Also note that the methods below are PostgreSQL specific extensions to
the JDBC api are are not part of the spec from Sun, thus it is unlikely that
they are used much or at all.
The deprecated methods are:
ResultSet.getInsertedOID()
Statement.getInsertedOID()
Serialize.store()
Connection.putObject()
and are replaced by:
ResultSet.getLastOID()
Statement.getLastOID()
Serialize.storeObject()
Connection.storeObject()
All the deprecated methods returned int, while their replacements return long
This patch also fixes two comments in MD5Digest that the author Jeremy Wohl
submitted.
--Barry
Peter Eisentraut [Sun, 25 Nov 2001 22:19:30 +0000 (22:19 +0000)]
Encoding isn't necessarily multibyte
Peter Eisentraut [Sun, 25 Nov 2001 22:17:27 +0000 (22:17 +0000)]
Fix comment
Bruce Momjian [Sun, 25 Nov 2001 18:25:54 +0000 (18:25 +0000)]
Backend /po patch.
http://laser.zhengmai.com.cn/download/backend_zh_CN.po.diff.gz
Weiping He
Tom Lane [Sun, 25 Nov 2001 01:11:36 +0000 (01:11 +0000)]
Further work on postmaster and postgres reference pages.