Commit graph

10478 commits

Author SHA1 Message Date
Tom Lane
a3feaba9aa Fix possible buffer overrun in \d command: substr(..., 128) produces
a result of at most 128 chars, but that could be more than 128 bytes.
Also ensure we don't try to pfree uninitialized pointers during error
cleanup.
2002-12-21 01:07:21 +00:00
Bruce Momjian
9c8ace7f0e Update RELEASE checklist. 2002-12-18 20:07:43 +00:00
PostgreSQL Daemon
d2f0761b82 From the SSL_CTX_new man page:
"SSLv23_method(void), SSLv23_server_method(void), SSLv23_client_method(void)

 A TLS/SSL connection established with these methods will understand the SSLv2,
 SSLv3, and TLSv1 protocol. A client will send out SSLv2 client hello messages
 and will indicate that it also understands SSLv3 and TLSv1. A server will
 understand SSLv2, SSLv3, and TLSv1 client hello messages. This is the best
 choice when compatibility is a concern."

This will maintain backwards compatibility for those us that don't use
TLS connections ...
2002-12-18 13:20:03 +00:00
Bruce Momjian
148e7e06bf Stamp 7.3.1. 2002-12-18 02:07:30 +00:00
Tom Lane
f599d56f51 Fix ALTER TABLE ADD COLUMN to disallow the same column types that are
disallowed by CREATE TABLE (eg, pseudo-types); also disallow these types
from being introduced by the range-function syntax.  While at it, allow
CREATE TABLE to create zero-column tables, per recent pghackers discussion.
I am back-patching this into 7.3 since failure to disallow pseudo-types
is arguably a security hole.
2002-12-16 18:39:57 +00:00
Bruce Momjian
750b3f3825 The actual segfault was caused by a double pfree(), but ISTM that
failing to find pg_hba.conf should be a fatal error anyway, so I
increased the priority of the elog() from LOG to FATAL and refactored
the code a little bit.

Neil Conway
2002-12-14 18:49:43 +00:00
Bruce Momjian
96e9574037 Ok, I think I've gotten this figured out now. I saw this comment in
pqcomm.c, switched the ERROR logs to COMMERROR logs and it all works.
I've attached a patch to be-secure.c that fixes all my problems.

Nathan Mueller
2002-12-14 18:39:39 +00:00
Bruce Momjian
77a9708f85 Backpatch SSL fixes into 7.3.1. 2002-12-13 22:20:22 +00:00
Bruce Momjian
9056af5b63 Increment libpq major number for 7.3.1 and minor for 7.4. 2002-12-13 22:18:22 +00:00
Tom Lane
1c432d60d7 Guard against overrunning CTZName buffer when TZ is bogus. 2002-12-12 19:17:04 +00:00
Tom Lane
68df4f7ca8 Back-patch fix to prevent core dump in EXPLAIN if optimizer has
simplified function call to a constant.  (7.3 won't actually execute
such a plan anyway, but core dump is bad regardless.)
2002-12-12 16:16:58 +00:00
Bruce Momjian
20606b46fd Mark SCO Openserver 5.0.4. supported by 7.3.1 as per chat report from user.
template/sco updated.
2002-12-11 22:27:34 +00:00
Bruce Momjian
bab9c3d555 Fix line count error reporting in config files, like pg_hba.conf, per
report from Oliver Elphick.

Backpatch to 7.3.
2002-12-11 22:17:31 +00:00
Bruce Momjian
f28802cac8 Bump version for 7.3 and 7.4. 2002-12-11 04:08:05 +00:00
Peter Eisentraut
ac3534f973 Translation updates 2002-12-10 20:00:27 +00:00
Peter Eisentraut
39610c8f03 Fix Latin1/Unicode conversion by selecting the right table. 2002-12-09 19:42:31 +00:00
Bruce Momjian
a92a4010a7 As far as I figured from the source code this function only deals with
cleaning up locale names and nothing else. Since all the locale names
are in plain  ASCII I think it will be safe to use ASCII-only lower-case
conversion.

Nicolai Tufar
2002-12-09 17:45:17 +00:00
Tom Lane
b3b39591c1 Explain's code for showing quals of SubqueryScan nodes has been broken
all along; not noticed till now.  It's a scan not an upper qual ...
2002-12-06 19:28:13 +00:00
Tom Lane
500677c40f localbuf.c must be able to do blind writes. 2002-12-05 22:48:10 +00:00
Tom Lane
0e98ae22d3 Avoid pulling up sublinks from a subselect's targetlist. Works around
problems that occur if sublink is referenced via a join alias variable.
Perhaps this can be improved later, but a simple and safe fix is needed
for 7.3.1.
2002-12-05 21:46:55 +00:00
Bruce Momjian
24536e5b3f Allow 'password' encryption even when pg_shadow has MD5 passwords, per
report from Terry Yapt and Hiroshi.

Backpatch to 7.3.
2002-12-05 18:40:08 +00:00
Dave Cramer
0ea3b7b86f changed sort of column names to sort by attnum, not attname 2002-12-05 01:09:58 +00:00
Tom Lane
b8b92c6908 Repair oversight in recent change of dependency extraction code: when
recursing to handle a join alias var, the context had better be set to
be appropriate to the join var's query level.  Per report from Hristo Neshev.
2002-12-04 20:00:19 +00:00
Tom Lane
4390ebc505 Repair core dump when trying to delete an entry from an already-NULL
datconfig or useconfig field.  Per report from Dustin Sallings.
2002-12-02 05:21:02 +00:00
Tom Lane
dac011ebb3 Fix pg_dump failure against 7.1 or older servers, per
report from Philip Warner.
2002-12-01 18:44:09 +00:00
Tom Lane
cc7883a1a2 Repair coredump in COPY OUT when client encoding is different from
server encoding, per report from Nicolai Tufar.  This is a minimum-risk
patch for 7.3.1 --- I intend to apply a more general repair in HEAD.
2002-12-01 17:33:33 +00:00
Tom Lane
f278d8134e Repair prehistoric logic error in lseg_eq and lseg_ne. 2002-11-29 19:25:38 +00:00
Tom Lane
19ddc7ec17 Update resultmap pattern for geometry-solaris-i386-pc: should match
solaris 2.8 as well as 2.7.  Per report from Martin Renters.
2002-11-27 17:04:45 +00:00
Tatsuo Ishii
d59f12daee Guard against 0 length string encoding conversion case. 2002-11-26 02:37:13 +00:00
Bruce Momjian
f5d7da3041 Remove check for pg_group file as part of initdb -W password assignment
--- not needed.
2002-11-25 21:42:11 +00:00
Tom Lane
55994bab8e Fix a dozen or so places that were passing unpredictable data strings
as elog format strings.  Hai-Chen Tu pointed out the problem in
contrib/dbmirror, but it wasn't the only such error.
2002-11-22 16:25:55 +00:00
Tom Lane
1e68232b35 Quote database name properly when invoking pg_dump. Per report from
Christopher Kings-Lynne.
2002-11-22 03:09:59 +00:00
Tom Lane
5fe20771d5 TAS code originally written for s390 (32-bit) does not work for s390x
(64-bit).  Fix it.  Per report from Permaine Cheung.
2002-11-22 01:13:28 +00:00
Tom Lane
4dc8a0e4e1 Fix breakage in new-in-7.3 timetz_zone() function: was giving random
results due to doing arithmetic on uninitialized values.  Add some
documentation about the AT TIME ZONE construct.  Update some other
date/time documentation that seemed out of date for 7.3.
2002-11-21 23:31:37 +00:00
Tom Lane
eda8dd8b2d Code review for superuser_reserved_connections patch. Don't try to do
database access outside a transaction; revert bogus performance improvement
in SIBackendInit(); improve comments; add documentation (this part courtesy
Neil Conway).
2002-11-21 06:36:27 +00:00
Tom Lane
6d227ae782 NetBSD versions 1.6 and (we hope) later can use the standard geometry
comparison file, instead of geometry-positive-zeros.  Per report from
Patrick Welche.
2002-11-21 04:40:41 +00:00
Tom Lane
9b3bcdd41f This locale-specific variant file seems not to have been updated
when a test was added to select_having.sql back in June.
2002-11-21 00:45:18 +00:00
Barry Lind
ce35ce91f9 Fix a stupid cut and paste error from the commit last night.
Modified Files:
  Tag: REL7_3_STABLE
 	AbstractJdbc2Statement.java
2002-11-20 20:42:24 +00:00
Barry Lind
e994389d7b Backport bug with executeBatch. This bug was a regression from 7.2 and has
been reported by Marko Strukelj and Keith Wannamaker

 Modified Files:
  Tag: REL7_3_STABLE
 	jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java
 	jdbc/org/postgresql/jdbc2/AbstractJdbc2Statement.java
 	jdbc/org/postgresql/test/jdbc2/BatchExecuteTest.java
2002-11-20 07:54:27 +00:00
Tom Lane
77c94aca72 Put back error test for DECLARE CURSOR outside a transaction block ...
but do it correctly now.
2002-11-18 01:17:50 +00:00
Tom Lane
779eb54142 Push qual clauses containing subplans to the back of the qual list
at each plan node.  Per gripe from Ross Reedstrom.
2002-11-15 02:37:08 +00:00
Barry Lind
1a34e0e23b Backpatch from head: fixes for a threading bug, a problem with setNull involving
server prepared statements and an improved error message

 Modified Files:
  Tag: REL7_3_STABLE
 	jdbc/org/postgresql/errors.properties
 	jdbc/org/postgresql/core/Encoding.java
 	jdbc/org/postgresql/core/QueryExecutor.java
 	jdbc/org/postgresql/jdbc1/AbstractJdbc1Connection.java
 	jdbc/org/postgresql/jdbc1/AbstractJdbc1DatabaseMetaData.java
 	jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java
2002-11-14 05:54:39 +00:00
Peter Eisentraut
f2ec243389 Update German translations. 2002-11-13 21:30:39 +00:00
Tom Lane
b455344112 Allow +1300 as a numeric timezone specifier; we already accept FJST as meaning +1300. 2002-11-13 17:24:11 +00:00
Tom Lane
c11e948244 Use cat instead of echo or awk, to avoid portability problems with backslashes. 2002-11-13 16:40:29 +00:00
Tom Lane
b5947f433e Update AIX resultmap for horology tests, per Andreas. 2002-11-12 20:02:38 +00:00
Tatsuo Ishii
07a51acac6 Fix broken GB18030 <--> UTF-8 conversion map 2002-11-12 11:30:50 +00:00
Tom Lane
400013ceec Remove NO_MKTIME_BEFORE_1970. I had speculated that it was not needed
anymore given the mktime() workaround now done in DetermineLocalTimeZone.
This has now been confirmed by Robert Bruccoleri for Irix, and I'm going
to extrapolate to AIX as well.
2002-11-12 00:39:36 +00:00
Barry Lind
76c89b3ec1 Merge fix from head for proper join to pg_description
Modified Files:
  Tag: REL7_3_STABLE
 	jdbc/org/postgresql/jdbc1/AbstractJdbc1DatabaseMetaData.java
 	jdbc/org/postgresql/test/jdbc2/DatabaseMetaDataTest.java
2002-11-11 07:30:08 +00:00
Tom Lane
4e7721fdfe Add cast to suppress compile warning on Alphas. 2002-11-11 03:33:44 +00:00