OSDN Git Service
Bruce Momjian [Sun, 26 Oct 2003 01:06:35 +0000 (01:06 +0000)]
Mark true64 os version as 5.1.
Bruce Momjian [Sun, 26 Oct 2003 01:05:53 +0000 (01:05 +0000)]
Mark true64 alpha port as working.
Bruce Momjian [Sun, 26 Oct 2003 00:58:31 +0000 (00:58 +0000)]
Fix Hans' name in SGML.
Bruce Momjian [Sun, 26 Oct 2003 00:31:48 +0000 (00:31 +0000)]
Update aix port.
Bruce Momjian [Sun, 26 Oct 2003 00:27:59 +0000 (00:27 +0000)]
Fix #elif typo.
Bruce Momjian [Sun, 26 Oct 2003 00:26:13 +0000 (00:26 +0000)]
Update linux/mips port.
Add m68k to linux port.
Bruce Momjian [Sun, 26 Oct 2003 00:22:51 +0000 (00:22 +0000)]
Update linux/mips port.
Bruce Momjian [Sun, 26 Oct 2003 00:21:04 +0000 (00:21 +0000)]
update linux ports for arm, s390, itanium.
Bruce Momjian [Sun, 26 Oct 2003 00:00:40 +0000 (00:00 +0000)]
Update for port freebsd/alpha.
Peter Eisentraut [Sat, 25 Oct 2003 20:18:53 +0000 (20:18 +0000)]
Get Tru64/cc to compile. Need to add -ieee so that it doesn't choke on
0.0/0.0. That option appears to affect the regression test result as well.
The compiler documentation doesn't recommend -O4 for universal use, so
let's stick to the conservative -O (== -O2) by default.
Peter Eisentraut [Sat, 25 Oct 2003 18:18:19 +0000 (18:18 +0000)]
Translation update
Peter Eisentraut [Sat, 25 Oct 2003 18:03:21 +0000 (18:03 +0000)]
Translation updates
Peter Eisentraut [Sat, 25 Oct 2003 15:32:11 +0000 (15:32 +0000)]
Fix CFLAGS selection to actually work. Add test to detect whether gcc's
option -fno-strict-aliasing is available.
Bruce Momjian [Sat, 25 Oct 2003 03:48:47 +0000 (03:48 +0000)]
Remove socket credentials defines not referenced.
Bruce Momjian [Sat, 25 Oct 2003 03:23:47 +0000 (03:23 +0000)]
Update Netbsd/i386 port.
Bruce Momjian [Sat, 25 Oct 2003 03:17:43 +0000 (03:17 +0000)]
Update ports for Solaris.
Bruce Momjian [Fri, 24 Oct 2003 21:28:52 +0000 (21:28 +0000)]
Remove weird test in ccsym
Bruce Momjian [Fri, 24 Oct 2003 21:09:08 +0000 (21:09 +0000)]
Update openbsd port.
Bruce Momjian [Fri, 24 Oct 2003 20:48:10 +0000 (20:48 +0000)]
Don't reference pthread.h unless we have threads enabled, per Peter.
Bruce Momjian [Fri, 24 Oct 2003 20:44:19 +0000 (20:44 +0000)]
Update for osX 10.3.
Bruce Momjian [Fri, 24 Oct 2003 20:39:09 +0000 (20:39 +0000)]
Update ports for freebsd, cygwin.
Peter Eisentraut [Fri, 24 Oct 2003 20:31:43 +0000 (20:31 +0000)]
Use AROPT, not hard-coded flags.
Bruce Momjian [Fri, 24 Oct 2003 16:30:53 +0000 (16:30 +0000)]
Update Linux/Sparc 32-bit port.
Bruce Momjian [Fri, 24 Oct 2003 16:29:00 +0000 (16:29 +0000)]
Update Linux x86 port.
Bruce Momjian [Fri, 24 Oct 2003 15:56:29 +0000 (15:56 +0000)]
Update OSX port.
Bruce Momjian [Fri, 24 Oct 2003 15:31:29 +0000 (15:31 +0000)]
Mark BSD/OS as working in 7.4.
Bruce Momjian [Fri, 24 Oct 2003 15:30:52 +0000 (15:30 +0000)]
Move pre-7.3 platforms to unsupported.
Peter Eisentraut [Fri, 24 Oct 2003 12:07:56 +0000 (12:07 +0000)]
Translation updates
Bruce Momjian [Fri, 24 Oct 2003 03:24:56 +0000 (03:24 +0000)]
Move 2phase discussion to 7.5 queue, not TODO.detail.
Bruce Momjian [Fri, 24 Oct 2003 03:24:32 +0000 (03:24 +0000)]
Move 2phase discussion to 7.5 queue, not TODO.detail.
< o Queries across databases or servers (two-phase commit) [2phase]
> o Queries across databases or servers (two-phase commit)
Bruce Momjian [Fri, 24 Oct 2003 03:21:37 +0000 (03:21 +0000)]
Add 2-phase TODO.detail.
Bruce Momjian [Fri, 24 Oct 2003 03:20:36 +0000 (03:20 +0000)]
Add TODO.detail:
> o Queries across databases or servers (two-phase commit) [2phase]
Bruce Momjian [Thu, 23 Oct 2003 16:40:14 +0000 (16:40 +0000)]
Update INSTALL to say beta5.
Tom Lane [Thu, 23 Oct 2003 13:58:43 +0000 (13:58 +0000)]
Remove obsolete information about altering default optimization flags for
gcc. Per comment from original author, Brian Gallew:
"Ancient history. Kill it fast."
Tom Lane [Wed, 22 Oct 2003 22:28:10 +0000 (22:28 +0000)]
Move docs about index cost estimation functions and writing a procedural
language handler to the 'Internals' area, per my proposal of yesterday.
Clean up the trigger documentation a bit. Push SPI chapter to the end
of its part, and reorder the Internals chapters into what seems a more
sensible order (at the moment anyway).
Bruce Momjian [Wed, 22 Oct 2003 18:10:53 +0000 (18:10 +0000)]
Here is a documentation patch that makes zulu, etc. all more consistent.
Bruce Momjian [Wed, 22 Oct 2003 17:27:14 +0000 (17:27 +0000)]
Release notes updates from Neil Conway.
Bruce Momjian [Wed, 22 Oct 2003 17:14:39 +0000 (17:14 +0000)]
Add:
> * Allow functions to have a search path specified at creation time
Tom Lane [Wed, 22 Oct 2003 16:43:42 +0000 (16:43 +0000)]
Add missing semicolon, per Johann Uhrmann.
Avoids warnings from newer bisons.
Bruce Momjian [Wed, 22 Oct 2003 05:09:12 +0000 (05:09 +0000)]
Add mention that "today" doesn't work as column default anymore.
PostgreSQL Daemon [Wed, 22 Oct 2003 04:16:39 +0000 (04:16 +0000)]
up configure to beta5
Tom Lane [Wed, 22 Oct 2003 03:50:27 +0000 (03:50 +0000)]
Another example-to-documentation difference. Maybe we can find a
better way to keep these in sync...
Tom Lane [Tue, 21 Oct 2003 23:28:42 +0000 (23:28 +0000)]
Ooops, missed updating this part of the complex-datatype example.
Tom Lane [Tue, 21 Oct 2003 22:51:14 +0000 (22:51 +0000)]
Update the complex-datatype example to V1 function calling conventions,
and add binary send/receive functions. Fix some other grottiness such
as failure to mark the C functions STRICT.
Tom Lane [Tue, 21 Oct 2003 22:47:54 +0000 (22:47 +0000)]
For some reason, the preface mentions just six of the seven major parts
of the book. Fix it.
Tom Lane [Tue, 21 Oct 2003 16:23:16 +0000 (16:23 +0000)]
Fix built-in SQL-language functions to ensure that referenced names
are properly schema-qualified.
Christopher Kings-Lynne
Bruce Momjian [Tue, 21 Oct 2003 15:51:41 +0000 (15:51 +0000)]
Remove:
< o Allow BINARY option to SELECT, just like DECLARE
Bruce Momjian [Tue, 21 Oct 2003 15:48:56 +0000 (15:48 +0000)]
Update:
< * Allow INET subnet tests to use indexes
> * Allow INET subnet tests using non-constants to be indexed
Tom Lane [Tue, 21 Oct 2003 15:34:34 +0000 (15:34 +0000)]
Cope with platforms that offer LONGLONG_MIN in place of the C99-spec
LLONG_MIN. One example is AIX, per report from Andreas.
Tom Lane [Tue, 21 Oct 2003 15:32:58 +0000 (15:32 +0000)]
Revert to 7.3-and-before practice of only including <fcntl.h> in c.h
on Windows; per complaint from Andreas that it breaks AIX build.
Tom Lane [Tue, 21 Oct 2003 04:46:28 +0000 (04:46 +0000)]
Fix findLastBuiltinOid_V70() to deliver correct result when running
against a 7.0 server.
Christopher Kings-Lynne
Bruce Momjian [Tue, 21 Oct 2003 02:48:09 +0000 (02:48 +0000)]
Update per Tom:
< * Allow INET subnet tests using non-constants
> * Allow INET subnet tests to use indexes
101a102
> o Allow MIN()/MAX() on arrays
144c145
< * Allow CREATE INDEX zman_index ON test (date_trunc( 'day', zman ) datetime_ops)
> * -Allow CREATE INDEX zman_index ON test (date_trunc( 'day', zman ) datetime_ops)
166c167
< * Improve handling of index scans for NULL
> * Allow use of indexes to search for NULLs
203a205
> * Add optional textual message to NOTIFY
252c254
< o Add SET SCHEMA
> o Add SET PATH for schemas
297a300
> * Allow fastpast to pass values in portable format
344a348
> * Allow statement-level triggers to access modified rows
526d529
< o Add optional textual message to NOTIFY
530d532
< o Allow fastpast to pass values in portable format
533c535
< o Special passing of binary values in platform-neutral format (bytea?)
> o -Special passing of binary values in platform-neutral format (bytea?)
Bruce Momjian [Tue, 21 Oct 2003 01:25:31 +0000 (01:25 +0000)]
Add release info about dollar signs to migration section:
<listitem><para> Dollar sign (<literal>$</>) is no longer allowed
in operator names</para></listitem>
<listitem><para> Dollar sign (<literal>$</>) can be a non-first
character in identifiers</para></listitem>
Peter Eisentraut [Mon, 20 Oct 2003 21:39:37 +0000 (21:39 +0000)]
Update catalog version after information schema changes.
Tom Lane [Mon, 20 Oct 2003 21:05:12 +0000 (21:05 +0000)]
Complain if pg_restore is given both -d and -f options; this suggests
the user is confused about whether -f is input or output file.
Tom Lane [Mon, 20 Oct 2003 20:01:59 +0000 (20:01 +0000)]
It is possible for ResolveNew to be used to insert a sublink into a
subquery that didn't previously have one. We have traditionally made
the caller of ResolveNew responsible for updating the hasSubLinks flag
of the outermost query, but this fails to account for hasSubLinks in
subqueries. Fix ResolveNew to handle this. We might later want to
change the calling convention of ResolveNew so that it can fix the
outer query too, simplifying callers. But I went with the localized
fix for now. Per bug report from J Smith, 20-Oct-03.
Tom Lane [Mon, 20 Oct 2003 17:25:42 +0000 (17:25 +0000)]
Improve error reporting in parseTypeString(), motivated by confusing
behavior reported by Martin Marques.
Michael Meskes [Mon, 20 Oct 2003 12:54:29 +0000 (12:54 +0000)]
Install dummy sqlda.h file since this is needed for compatibility.
Tom Lane [Mon, 20 Oct 2003 01:34:33 +0000 (01:34 +0000)]
When building shared libraries on HPUX with gcc, forcibly include -lgcc
to ensure any needed compiler support routines are included. This is
arguably appropriate on *every* gcc platform, but for the moment I'll take
the conservative approach of only doing it on a platform where it's
provably useful. Per complaint from Heiko Lehmann, 13-Feb-03, as well
as personal experience --- contrib/pgstattuple has never worked for me,
but it does now.
Tom Lane [Sun, 19 Oct 2003 23:43:51 +0000 (23:43 +0000)]
Save_r, Save_t should be static not global variables.
Tom Lane [Sun, 19 Oct 2003 22:15:32 +0000 (22:15 +0000)]
Update README file to show 7.4 oidjoins relationships. The regression
test was updated previously, but documentation is lagging.
Tom Lane [Sun, 19 Oct 2003 21:36:41 +0000 (21:36 +0000)]
Adjust libpq to avoid deadlock when both client and server want to send
data, and both have filled the transmission buffers. One scenario where
this can happen was illustrated here:
http://archives.postgresql.org/pgsql-hackers/2003-04/msg00979.php
Michael Meskes [Sun, 19 Oct 2003 13:22:33 +0000 (13:22 +0000)]
Check for both Informix modes when parsing include files.
Peter Eisentraut [Sat, 18 Oct 2003 22:59:09 +0000 (22:59 +0000)]
Cleanup on --help-config: Now called --describe-config, no further options,
machine readable, without headers, not sorted. Parameter descriptions
adjusted to fit first sentence + rest convention.
Tom Lane [Sat, 18 Oct 2003 19:06:10 +0000 (19:06 +0000)]
Further work on information_schema. _pg_keyissubset() wasn't quite
fully search-path-proof yet; also, element_types view did not work for
parameters and result types of functions, because it didn't generate
the object_name for the function the same way the data_type_privileges
view does. While at it, centralize dependencies on INDEX_MAX_KEYS/
FUNC_MAX_ARGS into a function returning setof int, so that it will be
easier to fix information_schema for nonstandard values of these
parameters.
Tom Lane [Sat, 18 Oct 2003 16:52:15 +0000 (16:52 +0000)]
Repair interaction between IN-join processing and subselect pullup that
I inadvertently broke a few days ago (per report from Sean Thomas).
Add regression test case to try to catch any similar breakage in future.
Tom Lane [Sat, 18 Oct 2003 15:38:06 +0000 (15:38 +0000)]
Simplify loop test to avoid bug in AIX compiler, per Andreas.
Peter Eisentraut [Sat, 18 Oct 2003 12:53:35 +0000 (12:53 +0000)]
Information schema fixes:
Use pg_get_constraintdef instead of pg_constraint.consrc
Use UNION ALL instread of UNION
Make use of regclass type for getting OID of system catalogs
Add schema qualifications where necessary
Fix typos
Tom Lane [Sat, 18 Oct 2003 05:02:06 +0000 (05:02 +0000)]
Must free the pgParameterStatus chain in freePGconn(). My fault,
well spotted by Neil Conway.
Tom Lane [Fri, 17 Oct 2003 22:38:20 +0000 (22:38 +0000)]
Document all the system views created by initdb (several of these were
never documented anywhere, sigh). Centralize the detailed documentation
of system views into catalogs.sgml, and provide cross-references.
Tom Lane [Fri, 17 Oct 2003 18:57:01 +0000 (18:57 +0000)]
Add a listing of our SQLSTATE error codes to the documentation.
Link to it from some appropriate places.
Tom Lane [Fri, 17 Oct 2003 18:29:55 +0000 (18:29 +0000)]
Fix busted markup.
Tom Lane [Fri, 17 Oct 2003 16:49:03 +0000 (16:49 +0000)]
Fix elog tab-insertion code to insert tabs only where wanted.
Peter Eisentraut [Fri, 17 Oct 2003 11:52:06 +0000 (11:52 +0000)]
Remove automatic '()' in other branch of UNION as well.
Tom Lane [Fri, 17 Oct 2003 01:14:26 +0000 (01:14 +0000)]
Adjust display of actual runtimes in EXPLAIN output to use three fractional
digits, and label it 'ms' not 'msec', for consistency with psql's \timing
display. Per recent discussions.
Tom Lane [Fri, 17 Oct 2003 00:57:04 +0000 (00:57 +0000)]
Use pg_get_constraintdef() rather than pg_constraint.consrc; this is
a portion of a patch recently submitted by Christopher Kings-Lynne.
Applied by agreement that this is a bug fix.
Tom Lane [Fri, 17 Oct 2003 00:55:17 +0000 (00:55 +0000)]
Add note deprecating use of consrc.
Peter Eisentraut [Thu, 16 Oct 2003 23:46:17 +0000 (23:46 +0000)]
Fix bugs in referential_constraints view.
Peter Eisentraut [Thu, 16 Oct 2003 23:45:29 +0000 (23:45 +0000)]
There should not be an automatic '()' after a function name when
tab-completing.
Tom Lane [Thu, 16 Oct 2003 22:52:22 +0000 (22:52 +0000)]
Set attstattarget to -1 for all system catalog columns. All but a few
of the entries used to be zero, which I think I had deliberately done in
the name of saving cycles during ANALYZE, but it was really a rather
foolish decision. Some of the more complex views in information_schema
were getting really bad plans for lack of statistics on the columns they
were joining over.
I'm not forcing an initdb for this, but I think there will be one soon
anyway to repair some bugs in the information_schema views.
Tom Lane [Thu, 16 Oct 2003 21:37:54 +0000 (21:37 +0000)]
Avoid division by zero in estimate_num_groups() when table has no rows.
Tom Lane [Thu, 16 Oct 2003 20:59:35 +0000 (20:59 +0000)]
Ensure that all places that are complaining about exhaustion of shared
memory say 'out of shared memory'; some were doing that and some just
said 'out of memory'. Also add a HINT about increasing max_locks_per_transaction
where relevant, per suggestion from Sean Chittenden. (The former change
does not break the strings freeze; the latter does, but I think it's
worth doing anyway.)
Tom Lane [Thu, 16 Oct 2003 20:03:09 +0000 (20:03 +0000)]
Cause tab completion to do something moderately reasonable with mixed-case
identifiers --- it will now complete these correctly with double quoting.
Fix a few other issues in passing.
Bruce Momjian [Thu, 16 Oct 2003 17:38:01 +0000 (17:38 +0000)]
Add mention of SIGHUP on the postmaster manual page.
Tom Lane [Thu, 16 Oct 2003 16:50:41 +0000 (16:50 +0000)]
Fix bad interaction between NOTIFY processing and V3 extended query
protocol, per report from Igor Shevchenko. NOTIFY thought it could
do its thing if transaction blockState is TBLOCK_DEFAULT, but in
reality it had better check the low-level transaction state is
TRANS_DEFAULT as well. Formerly it was not possible to wait for the
client in a state where the first is true and the second is not ...
but now we can have such a state. Minor cleanup in StartTransaction()
as well.
Tom Lane [Thu, 16 Oct 2003 04:52:21 +0000 (04:52 +0000)]
Minor copy-editing.
Bruce Momjian [Thu, 16 Oct 2003 04:12:53 +0000 (04:12 +0000)]
Add:
> * Allow pg_dump to dump CREATE CONVERSION (Christopher)
Bruce Momjian [Thu, 16 Oct 2003 04:11:53 +0000 (04:11 +0000)]
Fix SGML markup.
Update HISTORY file.
Bruce Momjian [Thu, 16 Oct 2003 03:55:31 +0000 (03:55 +0000)]
This patch adds another item to the "migration to 7.4" list in the
HISTORY file, and attributes the shared-buffer-alignment change to
Manfred Spraul.
Neil Conway
Bruce Momjian [Thu, 16 Oct 2003 03:47:28 +0000 (03:47 +0000)]
I have run pg_autovacuum on AIX, so that can, at least loosely, be
considered "tested."
And I have turned all of the 7.4 HISTORY material into DocBook for
release.sgml
Christopher Browne
Tom Lane [Wed, 15 Oct 2003 22:23:56 +0000 (22:23 +0000)]
Cause the default CFLAGS to be -O2 -fno-strict-aliasing when using gcc,
per recent pghackers discussions. Also ensure that explicitly setting
CFLAGS in the configure environment will be honored.
Peter Eisentraut [Wed, 15 Oct 2003 10:00:20 +0000 (10:00 +0000)]
Translation updates
Peter Eisentraut [Wed, 15 Oct 2003 09:49:07 +0000 (09:49 +0000)]
New translation
Peter Eisentraut [Wed, 15 Oct 2003 09:45:34 +0000 (09:45 +0000)]
Translation update
Peter Eisentraut [Wed, 15 Oct 2003 09:39:04 +0000 (09:39 +0000)]
New translation
Tom Lane [Tue, 14 Oct 2003 22:47:12 +0000 (22:47 +0000)]
Use PQescapeString to ensure that tab-completion queries are not messed
up by quotes or backslashes in words that are being matched to database
names (per gripe from Ian Barwick, though I didn't use his patch).
Also fix possible memory leakage if _complete_with_query isn't run to
completion (not clear if that can happen or not, but be safe).
Bruce Momjian [Tue, 14 Oct 2003 19:08:00 +0000 (19:08 +0000)]
Remove void* in MemSet until we understand the gcc 3.3.1 problem better.
Bruce Momjian [Tue, 14 Oct 2003 00:48:09 +0000 (00:48 +0000)]
Add compile -O flag only for non-debug mode, per Tom
Tom Lane [Mon, 13 Oct 2003 23:48:16 +0000 (23:48 +0000)]
pull_up_subqueries() should copy the subquery before starting to modify
it. Not sure why I'd thought it would be a good idea to do differently
way back when, but Greg Stark exposed the folly of doing so ...
Bruce Momjian [Mon, 13 Oct 2003 22:47:15 +0000 (22:47 +0000)]
Back out makeNode() patch to fix gcc 3.3.1 warning.