OSDN Git Service
Bruce Momjian [Sat, 13 Sep 2003 16:27:38 +0000 (16:27 +0000)]
pgindent C file, per patch request.
Bruce Momjian [Sat, 13 Sep 2003 16:26:18 +0000 (16:26 +0000)]
> OK, well as we wait on the fix for the stats system, let me submit my
> patch for pg_autovacuum. This patch assumes that the stats system will
> be fixed so that all inserts, updates and deletes performed on shared
> tables reguardless of what database those commands were executed from,
> will show up in the stats shown in each database.
I had to make a further change to this to take quotes off the 'last
ANALYZE' in order for it to not overquote the relation name, so
there's a _little_ work left to get it to play well.
I have deployed it onto several boxes that should be doing some
vacuuming over the weekend, and it is now certainly hitting pg_
tables.
I would like to present a CVS-oriented patch; unfortunately, I had to
change the indentation patterns when editing some of it :-(. The
following _may_ be good; not sure...
Matthew T. O'Connor
Christopher Browne
Bruce Momjian [Sat, 13 Sep 2003 14:49:51 +0000 (14:49 +0000)]
Attempt threading in this order:
* use non-*_r function names if they are all thread-safe
* (NEED_REENTRANT_FUNCS=no)
* use *_r functions if they exist (configure test)
* do our own locking and copying of non-threadsafe functions
New to this patch is the last option.
Barry Lind [Sat, 13 Sep 2003 04:02:16 +0000 (04:02 +0000)]
More SQLState updates from Kim Ho at Redhat.
Also a patch from Kris Jurka to correctly report SQLState support.
Modified Files:
jdbc/org/postgresql/Driver.java.in
jdbc/org/postgresql/core/QueryExecutor.java
jdbc/org/postgresql/fastpath/Fastpath.java
jdbc/org/postgresql/geometric/PGbox.java
jdbc/org/postgresql/geometric/PGcircle.java
jdbc/org/postgresql/geometric/PGline.java
jdbc/org/postgresql/geometric/PGlseg.java
jdbc/org/postgresql/geometric/PGpath.java
jdbc/org/postgresql/geometric/PGpoint.java
jdbc/org/postgresql/jdbc1/AbstractJdbc1Connection.java
jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSet.java
jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSetMetaData.java
jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java
jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java
jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSetMetaData.java
jdbc/org/postgresql/jdbc2/Array.java
jdbc/org/postgresql/jdbc3/AbstractJdbc3DatabaseMetaData.java
jdbc/org/postgresql/util/PGmoney.java
jdbc/org/postgresql/util/PSQLState.java
Tom Lane [Sat, 13 Sep 2003 00:19:43 +0000 (00:19 +0000)]
Marginal hacks to make tables format more nicely.
Tom Lane [Fri, 12 Sep 2003 23:04:46 +0000 (23:04 +0000)]
Mop-up for error-message updates in documentation.
Tom Lane [Fri, 12 Sep 2003 22:17:24 +0000 (22:17 +0000)]
Update obsolete examples of error messages; various other minor editing.
Tom Lane [Fri, 12 Sep 2003 20:18:51 +0000 (20:18 +0000)]
Revert to our pre-7.4 behavior of identifying Unix-socket connections in
ps status as '[local]', not as 'localhost' as the code has been doing
recently. That's too easily confused with TCP loopback connections,
and there is no good reason to change the behavior anyway.
Tom Lane [Fri, 12 Sep 2003 19:33:59 +0000 (19:33 +0000)]
Someone (possibly me) foolishly reduced the response for failing
to create a TCP/IP socket from FATAL to LOG. This was unwise;
historically we have expected socket conflicts to abort postmaster
startup. Conflicts on port numbers with another postmaster can only
be detected reliably at the TCP socket level.
Bruce Momjian [Fri, 12 Sep 2003 16:49:34 +0000 (16:49 +0000)]
Mark FreeBSD as non-thread-safe.
Tom Lane [Fri, 12 Sep 2003 16:34:28 +0000 (16:34 +0000)]
Fix incorrect pfree in to_tsquery_name(), per Nigel Andrews.
Bruce Momjian [Fri, 12 Sep 2003 16:10:27 +0000 (16:10 +0000)]
Implement compiler #error if spinlock code not found, add configure flag
to bypass the error, --without-spinlocks.
Bruce Momjian [Fri, 12 Sep 2003 15:49:34 +0000 (15:49 +0000)]
Enable Opteron/Itanium spinlocks.
Bruce Momjian [Fri, 12 Sep 2003 02:40:10 +0000 (02:40 +0000)]
Remove WIN32_CONSOLE support, at the request of the author.
Bruce Momjian [Fri, 12 Sep 2003 02:13:23 +0000 (02:13 +0000)]
Fix old mention of exec() in AttachSharedMemoryAndSemaphores comment.
Tom Lane [Fri, 12 Sep 2003 00:12:47 +0000 (00:12 +0000)]
More cleanup of Diagnostics sections.
Tom Lane [Thu, 11 Sep 2003 23:15:51 +0000 (23:15 +0000)]
Small typo.
Tom Lane [Thu, 11 Sep 2003 23:12:31 +0000 (23:12 +0000)]
Message in the other exit from acquire_sample_rows(), as per update
from Mark Kirkwood. Also show the sample size.
Tom Lane [Thu, 11 Sep 2003 22:59:28 +0000 (22:59 +0000)]
Try to make recently-added analyze log message look something like
the others in style.
Bruce Momjian [Thu, 11 Sep 2003 21:42:20 +0000 (21:42 +0000)]
This patch fixes a few missed GUC variables that were still upper case,
makes a few more small improvements to runtime.sgml, and makes some SGML
conventions more consistent.
Neil Conway
Bruce Momjian [Thu, 11 Sep 2003 19:01:18 +0000 (19:01 +0000)]
> It quotes table names for vacuum and analyze, and uppercases the
> keywords for clarity.
Yeah, this is basically what I meant, sorry I didn't get to it quicker.
However, I tested it out a little and the patch you made doesn't work
because it produces commands like:
VACUUM ANALYZE "public.FooBar"
Which doesn't work, so I made my own patch that creates commands like:
VACUUM ANALYZE "public"."FooBar"
This allows for mixed case schema names as well as tables.
Adam, can you please give this a test as you are the person who caught
the bug in the first place.
Thanks,
Matthew T. O'Connor
Bruce Momjian [Thu, 11 Sep 2003 18:30:39 +0000 (18:30 +0000)]
Consistenly lowercase GUC variable names, in docs and error messages.
Bruce Momjian [Thu, 11 Sep 2003 17:31:45 +0000 (17:31 +0000)]
This patch makes a few minor improvements to the docs: make the
<varname> conventions more consistent, and improve the ANALYZE ref page.
Neil Conway
Bruce Momjian [Thu, 11 Sep 2003 17:27:38 +0000 (17:27 +0000)]
This patch makes a number of improvements to the runtime config
documentation.
Neil Conway
Bruce Momjian [Thu, 11 Sep 2003 17:26:20 +0000 (17:26 +0000)]
Mention that pg_type_is_visible is used for domains as well.
Christopher Kings-Lynne
Bruce Momjian [Thu, 11 Sep 2003 17:25:14 +0000 (17:25 +0000)]
on my timetravel.c I find a bug: after the
ALTER TABLE mytable drop column last_column_of_table;
the timetravel trigger say on UPDATE/DELETE:
ERROR: parser: parse error at end of input
Here is the patch for this bug
B?jthe Zolt?n
Bruce Momjian [Thu, 11 Sep 2003 17:15:27 +0000 (17:15 +0000)]
Here is a patch that removes contrib/array, leaving only the README with
some examples of the new syntax and a reference to the documentation.
Joe Conway.
Bruce Momjian [Thu, 11 Sep 2003 16:22:42 +0000 (16:22 +0000)]
seemed like a typo in one of the appendix tables
Robert Treat
Tom Lane [Thu, 11 Sep 2003 02:40:13 +0000 (02:40 +0000)]
Fix missed message update, per Alvaro Herrera.
Bruce Momjian [Wed, 10 Sep 2003 21:35:55 +0000 (21:35 +0000)]
Update row count for \? output, used by pager.
Tom Lane [Wed, 10 Sep 2003 20:24:09 +0000 (20:24 +0000)]
Improve error message for cp or rm failur during create/drop database,
per recent discussions.
Bruce Momjian [Wed, 10 Sep 2003 20:17:21 +0000 (20:17 +0000)]
Add:
> * Issue NOTICE if foreign key data type doesn't match primary key
Bruce Momjian [Wed, 10 Sep 2003 20:14:42 +0000 (20:14 +0000)]
Add:
> * Have EXPLAIN ANALYZE highlight poor optimizer estimates
Bruce Momjian [Wed, 10 Sep 2003 20:13:45 +0000 (20:13 +0000)]
This patch fixes a trivial typo in the CREATE FUNCTION ref page.
Neil Conway
Tom Lane [Wed, 10 Sep 2003 20:12:01 +0000 (20:12 +0000)]
copydir() is supposed to return on failure, not elog(ERROR). Reduce
ERROR to WARNING so we keep control.
Bruce Momjian [Wed, 10 Sep 2003 19:59:23 +0000 (19:59 +0000)]
Add HINT if CREATE FUNCTION specifies a valid language, but the language
isn't loaded into the database.
Bruce Momjian [Wed, 10 Sep 2003 19:57:48 +0000 (19:57 +0000)]
Add quotes to vacuum/analyze for upper/lowercase table names, per
Matthew T. O'Connor.
Michael Meskes [Wed, 10 Sep 2003 18:03:08 +0000 (18:03 +0000)]
Some uppercase type definitions were left.
Bruce Momjian [Wed, 10 Sep 2003 03:56:33 +0000 (03:56 +0000)]
Here is a patch to make PostgreSQL use a full path in DT_SONAME for
UnixWare.
Larry Rosenman
Bruce Momjian [Wed, 10 Sep 2003 00:33:51 +0000 (00:33 +0000)]
Clean up printability test in dbase code.
Bruce Momjian [Wed, 10 Sep 2003 00:03:23 +0000 (00:03 +0000)]
Add:
> * Have pg_dump -c clear the database using dependency information
Peter Eisentraut [Tue, 9 Sep 2003 23:22:21 +0000 (23:22 +0000)]
Some "feature not supported" errors are better syntax errors, because the
feature they complain about isn't a feature or cannot be implemented without
definitional changes.
Bruce Momjian [Tue, 9 Sep 2003 22:43:06 +0000 (22:43 +0000)]
Improve wording of increasing page size.
Tom Lane [Tue, 9 Sep 2003 18:28:53 +0000 (18:28 +0000)]
Remove a bunch of content-free Diagnostics sections, as per previous
discussion. (Still have some work to do editing the remainder.)
Bruce Momjian [Tue, 9 Sep 2003 18:25:44 +0000 (18:25 +0000)]
Update max tasble size to 32TB.
Tom Lane [Tue, 9 Sep 2003 15:19:31 +0000 (15:19 +0000)]
Update comments about how locale settings are handled.
Barry Lind [Tue, 9 Sep 2003 11:24:04 +0000 (11:24 +0000)]
Clean up some unused import warnings in the example jdbc code
Michael Meskes [Tue, 9 Sep 2003 10:54:44 +0000 (10:54 +0000)]
Fixed a few bugs that came up on pgsql-interfaces.
Barry Lind [Tue, 9 Sep 2003 10:49:16 +0000 (10:49 +0000)]
Additional SQLState work for JDBC - thanks to Kim Ho at Redhat for input on this
Modified Files:
jdbc/build.xml jdbc/org/postgresql/core/QueryExecutor.java
jdbc/org/postgresql/jdbc1/AbstractJdbc1Connection.java
jdbc/org/postgresql/jdbc1/AbstractJdbc1DatabaseMetaData.java
jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSet.java
jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java
jdbc/org/postgresql/jdbc2/AbstractJdbc2Statement.java
jdbc/org/postgresql/util/PSQLState.java
Michael Meskes [Tue, 9 Sep 2003 10:46:42 +0000 (10:46 +0000)]
- Added Dave patch for Informix handling of numeric/int conversion.
- Changed all new datatypes to lowercase.
- Fixed rounding bug in numerical types.
Tom Lane [Mon, 8 Sep 2003 23:17:15 +0000 (23:17 +0000)]
Fix a couple minor typos.
Peter Eisentraut [Mon, 8 Sep 2003 23:02:28 +0000 (23:02 +0000)]
Update preface.
Use question marks rather than brackets to delimit optional elements in
Tcl synopses.
Fix stylesheet misfeature leading to excessively long cross-reference text
when linking to a different "part".
Remove <body> attributes -- CSS stylesheets should handle that.
Improve bibliography formatting.
Add fast-forward links for more convenient navigation.
Bruce Momjian [Mon, 8 Sep 2003 22:48:21 +0000 (22:48 +0000)]
Add:
o Allow ALTER TABLE to change constraint deferrability and actions
Tom Lane [Mon, 8 Sep 2003 22:33:13 +0000 (22:33 +0000)]
"statenebt" ?
Tom Lane [Mon, 8 Sep 2003 19:38:02 +0000 (19:38 +0000)]
Document a bunch of formerly-undocumented date/time operators,
including the SQL-spec OVERLAPS construct.
Barry Lind [Mon, 8 Sep 2003 17:45:35 +0000 (17:45 +0000)]
Opps, can't forget the new file. This is part of the last commit to apply
the redhat patch for SQLState support.
Added Files:
PSQLState.java
Barry Lind [Mon, 8 Sep 2003 17:30:22 +0000 (17:30 +0000)]
This set of changes applies a patch from KHO at redhat to add some SQLState
support to the jdbc driver.
That patch needed some work: it assumed the sqlcode in a server message was
fixed in its position, the patch lost the ability to pass exceptions, and the
patch missed a couple of places where server errors where being received.
In addition to fixing the above, I also added full support for the V3 protocol
error message syntax, I reversed the order of arguments in the PSQLException
constructor to more closely follow the constructors for SQLException, I changed
the new constructors that take PSQLState to take Object for additional
parameters as the old ones did.
Still todo are to add SQLState values to all existing exceptions thrown in the
driver and add support for parsing the V3 protocol format for notices.
Modified Files:
jdbc/build.xml jdbc/org/postgresql/Driver.java.in
jdbc/org/postgresql/errors.properties
jdbc/org/postgresql/core/Encoding.java
jdbc/org/postgresql/core/PGStream.java
jdbc/org/postgresql/core/QueryExecutor.java
jdbc/org/postgresql/fastpath/Fastpath.java
jdbc/org/postgresql/jdbc1/AbstractJdbc1Connection.java
jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSet.java
jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java
jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java
jdbc/org/postgresql/jdbc2/AbstractJdbc2Statement.java
jdbc/org/postgresql/util/MessageTranslator.java
jdbc/org/postgresql/util/PSQLException.java
Tom Lane [Mon, 8 Sep 2003 00:56:13 +0000 (00:56 +0000)]
Avoid using s_addr as a local variable name, to work around broken
system headers on Unixware.
Bruce Momjian [Sun, 7 Sep 2003 22:02:54 +0000 (22:02 +0000)]
Update URL.
Bruce Momjian [Sun, 7 Sep 2003 22:01:42 +0000 (22:01 +0000)]
Update URL to be momjian.postgresql.org.
Bruce Momjian [Sun, 7 Sep 2003 16:49:41 +0000 (16:49 +0000)]
autoconf run.
Bruce Momjian [Sun, 7 Sep 2003 16:38:05 +0000 (16:38 +0000)]
Add $srcdir for Win32 builds, from Peter.
Tom Lane [Sun, 7 Sep 2003 15:27:25 +0000 (15:27 +0000)]
Remove another useless, counterproductive srandom() call.
Tom Lane [Sun, 7 Sep 2003 15:26:54 +0000 (15:26 +0000)]
Remove geqo_random_seed parameter. Having geqo reset the global random()
sequence every time it's called is bogus --- it interferes with user
control over the seed, and actually decreases randomness overall
(because a seed based on time(NULL) is pretty predictable). If you really
want a reproducible result from geqo, do 'set seed = 0' before planning
a query.
Tom Lane [Sun, 7 Sep 2003 14:44:40 +0000 (14:44 +0000)]
Remove check on source address of a statistics packet. Check was broken
by recent IPv6 changes, and since it's redundant with a kernel-level check
anyway, it seems not worth trying to fix it. Per recent discussions.
Bruce Momjian [Sun, 7 Sep 2003 03:43:57 +0000 (03:43 +0000)]
Changes for MinGW/WIN32:
o allow configure to see include/port/win32 include files
o add matching Win32 accept() prototype
o allow pg_id to compile with native Win32 API
o fix invalide mbvalidate() function calls (existing bug)
o allow /scripts to compile with native Win32 API
o add win32.c to Win32 compiles (already in *.mak files)
Tom Lane [Sun, 7 Sep 2003 03:36:03 +0000 (03:36 +0000)]
Make the default pg_hba.conf include an entry for ::1 only if configure
set HAVE_IPV6. Per recent discussions.
Tom Lane [Sun, 7 Sep 2003 02:18:01 +0000 (02:18 +0000)]
load_file() has to remove pre-existing shlibs that match the new file
on either name or inode; otherwise load_external_function() won't do
anything. At least on Linux, it appears that recompiling a shlib leads
to a new file with a different inode, so the old code failed to detect
a match.
Peter Eisentraut [Sat, 6 Sep 2003 14:01:51 +0000 (14:01 +0000)]
Make all valid uses of the COLLATE clause yield the same result: a syntax
error. There is no point in providing some kind of forward compatibility
now, because no one can tell what a future implementation will look like.
Bruce Momjian [Sat, 6 Sep 2003 01:41:56 +0000 (01:41 +0000)]
Rename variables for clarity.
Tom Lane [Fri, 5 Sep 2003 23:07:21 +0000 (23:07 +0000)]
Second try at IPv4-to-v6 mapping code; avoid assuming that the struct
returned by getaddrinfo_all will have enough room for an IPv6 address.
Tom Lane [Fri, 5 Sep 2003 20:31:36 +0000 (20:31 +0000)]
Allow IPv4-format entries in pg_hba.conf to match IPv6 connections
that have IPv4-embedded-in-IPv6 addresses. Per idea of Andreas Pflug.
Bruce Momjian [Fri, 5 Sep 2003 19:52:10 +0000 (19:52 +0000)]
Done:
< * Allow psql to do table completion for SELECT * FROM schema_part and
> * -Allow psql to do table completion for SELECT * FROM schema_part and
Bruce Momjian [Fri, 5 Sep 2003 17:43:40 +0000 (17:43 +0000)]
ifdef out pqGetpwuid() because Win32 doesn't have struct passwd.
Needed for libpq builds, not just for native Win32 port, and probably
for cygwin too.
Bruce Momjian [Fri, 5 Sep 2003 16:43:13 +0000 (16:43 +0000)]
Add WIN32 URL.
Tom Lane [Fri, 5 Sep 2003 16:13:38 +0000 (16:13 +0000)]
Add missing space.
Bruce Momjian [Fri, 5 Sep 2003 03:57:13 +0000 (03:57 +0000)]
This fixes three minor typos in hba.c.
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
Bruce Momjian [Fri, 5 Sep 2003 02:54:09 +0000 (02:54 +0000)]
Update information about Linux's overcommit memory behavior.
Andrew Dunstan
Bruce Momjian [Fri, 5 Sep 2003 02:51:55 +0000 (02:51 +0000)]
Add:
> * Maintain a map of recently-expired of pages so vacuum can reclaim
> free space without a sequential scan
Bruce Momjian [Fri, 5 Sep 2003 02:31:10 +0000 (02:31 +0000)]
Clean up WIN32_CONSOLE code.
Bruce Momjian [Fri, 5 Sep 2003 02:20:50 +0000 (02:20 +0000)]
Update as done:
> * -Improve concurrency of hash indexes (Tom)
Bruce Momjian [Fri, 5 Sep 2003 02:08:36 +0000 (02:08 +0000)]
Enable Win32 to compile libpq again, and enable SSL compiles on that
platform.
Andreas Pflug
Bruce Momjian [Fri, 5 Sep 2003 01:53:41 +0000 (01:53 +0000)]
Improve prototype casting for thread calls.
Bruce Momjian [Fri, 5 Sep 2003 01:10:07 +0000 (01:10 +0000)]
Add:
> o Allow ALTER TABLE ... ALTER CONSTRAINT ... RENAME
Bruce Momjian [Fri, 5 Sep 2003 00:50:40 +0000 (00:50 +0000)]
Add:
<
> * Print table names with constraint names in error messages, or make constraint
> names unique within a schema
Tom Lane [Thu, 4 Sep 2003 22:06:27 +0000 (22:06 +0000)]
Reimplement hash index locking algorithms, per my recent proposal to
pghackers. This fixes the problem recently reported by Markus KrÌutner
(hash bucket split corrupts the state of scans being done concurrently),
and I believe it also fixes all the known problems with deadlocks in
hash index operations. Hash indexes are still not really ready for prime
time (since they aren't WAL-logged), but this is a step forward.
Tom Lane [Thu, 4 Sep 2003 15:53:04 +0000 (15:53 +0000)]
Avoid consuming unreasonable amounts of memory when GRANT has many
grantees.
Tom Lane [Thu, 4 Sep 2003 15:16:39 +0000 (15:16 +0000)]
Looks like plperl has same bug as pltcl.
Tom Lane [Thu, 4 Sep 2003 15:10:10 +0000 (15:10 +0000)]
Fix some problems with dropped columns in pltcl functions.
Bruce Momjian [Thu, 4 Sep 2003 05:11:20 +0000 (05:11 +0000)]
Allow non-super users to set log_duration to true, then false, when the
administrator has not turned it on, and fix other PGC_USERLIMIT
variables.
Bruce Momjian [Thu, 4 Sep 2003 03:38:55 +0000 (03:38 +0000)]
Re-upper case CHECKPOINT_SEGMENTS.
Bruce Momjian [Thu, 4 Sep 2003 00:36:46 +0000 (00:36 +0000)]
Lowercase CHECKPOINT_SEGMENTS.
Bruce Momjian [Wed, 3 Sep 2003 23:01:47 +0000 (23:01 +0000)]
Add:
> * Allow to_char to print localized month names (Karel)
Bruce Momjian [Wed, 3 Sep 2003 22:34:08 +0000 (22:34 +0000)]
Tighten casting of function call pointers for threads.
Peter Eisentraut [Wed, 3 Sep 2003 22:17:07 +0000 (22:17 +0000)]
Add note that a for loop where the lower bound is greater than the upper
bound is valid but does nothing.
suggested by Richard Huxton <dev@archonet.com>
Peter Eisentraut [Wed, 3 Sep 2003 22:05:09 +0000 (22:05 +0000)]
Pass session_authorization to the client and make psql update its prompt
accordingly.
Bruce Momjian [Wed, 3 Sep 2003 21:27:21 +0000 (21:27 +0000)]
Done:
* -Have standalone backend read postgresql.conf (Tom)
Bruce Momjian [Wed, 3 Sep 2003 20:54:21 +0000 (20:54 +0000)]
Mark unixware as verified.
Bruce Momjian [Wed, 3 Sep 2003 20:51:40 +0000 (20:51 +0000)]
Add Unixware as verified.
Bruce Momjian [Wed, 3 Sep 2003 20:28:14 +0000 (20:28 +0000)]
Update German FAQ.
Ian Barwick