OSDN Git Service
Teodor Sigaev [Thu, 28 Aug 2003 12:23:24 +0000 (12:23 +0000)]
More accuracy works with stopwords in queries
Tom Lane [Wed, 27 Aug 2003 23:29:29 +0000 (23:29 +0000)]
Adjust date/time input parsing code to correctly distinguish the four
SQLSTATE error codes required by SQL99 (invalid format, datetime field
overflow, interval field overflow, invalid time zone displacement value).
Also emit a HINT about DateStyle in cases where it seems appropriate.
Per recent gripes.
Peter Eisentraut [Wed, 27 Aug 2003 22:58:54 +0000 (22:58 +0000)]
Add "override" for make variable JADEFLAGS, since upper directory passes
this variable on the command line.
Peter Eisentraut [Wed, 27 Aug 2003 22:13:35 +0000 (22:13 +0000)]
Major cleanup of SPI chapter
Tom Lane [Wed, 27 Aug 2003 12:44:12 +0000 (12:44 +0000)]
Department of second thoughts: can't reorder merge-join clauses.
Bruce Momjian [Wed, 27 Aug 2003 03:35:35 +0000 (03:35 +0000)]
Update URL for 7.3 changes:
http://developer.postgresql.org/~momjian/upgrade_tips_7.3
PostgreSQL Daemon [Wed, 27 Aug 2003 02:35:38 +0000 (02:35 +0000)]
update to beta2
Peter Eisentraut [Wed, 27 Aug 2003 00:33:34 +0000 (00:33 +0000)]
Share PG_DIAG_* macros between client and server and use them internally.
Tom Lane [Tue, 26 Aug 2003 22:56:51 +0000 (22:56 +0000)]
Push subplan clauses to the back in qual lists for join plans, not
only scan plans. Per observation from Rod Taylor.
Bruce Momjian [Tue, 26 Aug 2003 21:31:11 +0000 (21:31 +0000)]
Call it Linux, not GNU/Linux.
Tom Lane [Tue, 26 Aug 2003 21:15:27 +0000 (21:15 +0000)]
Use separate SQLSTATE codes for file not found/file exists, rather than
lumping them into ERRCODE_UNDEFINED_OBJECT/ERRCODE_DUPLICATE_OBJECT.
This seems reasonable since 'object' was meant to refer to 'object in the
database' and a file is outside the database. Per request from Dave
Cramer.
Bruce Momjian [Tue, 26 Aug 2003 18:35:31 +0000 (18:35 +0000)]
psql's HISTSIZE from .psqlrc do not want to be set so I did it for psql
that HISTSIZE might take effect from my .psqlrc
Andriy Tkachuk
Bruce Momjian [Tue, 26 Aug 2003 18:32:23 +0000 (18:32 +0000)]
This patch adds a new regression test for the UPDATE command. Right
now all that is tested is Rod Taylor's recent addition to allow
this syntax:
UPDATE ... SET <col> = DEFAULT;
If anyone else would like to add more UPDATE tests, go ahead --
I just wanted to write a test for the above functionality, and
couldn't see an existing test that it would be appropriate
to add to.
Neil Conway
Michael Meskes [Tue, 26 Aug 2003 16:09:02 +0000 (16:09 +0000)]
Fixed connect statement with username in variable.
Bruce Momjian [Tue, 26 Aug 2003 15:38:42 +0000 (15:38 +0000)]
Attached is a (very small) patch to make analyze display some
interesting info in verbose mode about the analyzed relation (pages,
rows per block and rows).
Mark Kirkwood
Tom Lane [Tue, 26 Aug 2003 15:38:25 +0000 (15:38 +0000)]
Mop-up for previous change to determine default shared_buffers and
max_connections at initdb time. Get rid of DEF_NBUFFERS and DEF_MAXBACKENDS
macros, which aren't doing anything useful anymore, and put more likely
defaults into postgresql.conf.sample.
Teodor Sigaev [Tue, 26 Aug 2003 10:01:02 +0000 (10:01 +0000)]
fix module name in MODULE_PATHNAME substitution
Barry Lind [Tue, 26 Aug 2003 06:50:39 +0000 (06:50 +0000)]
Attempt to fix setMaxFieldSize() logic that was checked in yesterday.
I think this should fix the problem, but since I don't have a reproducable test
case, I can't be sure. This problem is reported by Kim Ho of redhat, who will
test this fix. This also includes a test case for the original functionality.
Modified Files:
jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java
jdbc/org/postgresql/test/jdbc2/ResultSetTest.java
Tom Lane [Mon, 25 Aug 2003 23:30:27 +0000 (23:30 +0000)]
Add the Brazilian time zone abbreviations BRT, BRST, FNT, FNST.
ACT and ACST were already present. AMT and AMST conflict with the
existing entries for Armenia; no change there for the moment.
Tom Lane [Mon, 25 Aug 2003 22:47:34 +0000 (22:47 +0000)]
Allow parsing of time and timetz inputs to accept the documented input
syntax '040506' for '04:05:06', as well as '0405' for '04:05:00'. This
has been broken since 7.2 but was only recently complained of.
Peter Eisentraut [Mon, 25 Aug 2003 21:29:53 +0000 (21:29 +0000)]
Translation updates
Tom Lane [Mon, 25 Aug 2003 16:13:27 +0000 (16:13 +0000)]
Refactor code so that to_date() does not call to_timestamp() and then
perform a timestamp-to-date coercion. Instead both routines share a
subroutine that delivers the parsing result as a struct tm. This avoids
problems with timezone dependency of to_date's result, and should be
at least marginally faster too.
Michael Meskes [Mon, 25 Aug 2003 13:44:00 +0000 (13:44 +0000)]
Synced parser and fixed a bug in error output to log file.
Bruce Momjian [Mon, 25 Aug 2003 04:10:59 +0000 (04:10 +0000)]
Add:
> * Add a libpq function to support Parse/DescribeStatement capability
Bruce Momjian [Mon, 25 Aug 2003 02:48:25 +0000 (02:48 +0000)]
Fix unixware thread test.
Tatsuo Ishii [Mon, 25 Aug 2003 01:46:16 +0000 (01:46 +0000)]
Fix GB18030 to UTF-8 mapping table
Bruce Momjian [Sun, 24 Aug 2003 23:21:05 +0000 (23:21 +0000)]
Add quotes to += of unixware threads define.
Bruce Momjian [Sun, 24 Aug 2003 22:57:21 +0000 (22:57 +0000)]
Add:
* Allow TRUNCATE ... CASCADE/RESTRICT
Barry Lind [Sun, 24 Aug 2003 22:10:09 +0000 (22:10 +0000)]
Applied patches from Oliver Jowett to fix the following bugs:
- adds a finalizer method to AbstractJdbc1Statement to clean up in the case of
poor user code which fails to close the statement object
- fix ant build file to correctly detect dependencies across jdbc1/jdbc2/jdbc3
- fix a coupld of server prepared statement bugs and added regression test for
them
Applied patch from Kim Ho:
- adds support for get/setMaxFieldSize().
Also fixed build.xml to provide a better error message in the event that an
older version of the driver exists in the classpath when trying to build.
Peter Eisentraut [Sun, 24 Aug 2003 21:26:34 +0000 (21:26 +0000)]
Fix translation mistake.
Peter Eisentraut [Sun, 24 Aug 2003 21:18:53 +0000 (21:18 +0000)]
Translation updates
Peter Eisentraut [Sun, 24 Aug 2003 21:02:43 +0000 (21:02 +0000)]
Change warnings for non-existing or pre-existing cursors to errors.
Peter Eisentraut [Sun, 24 Aug 2003 18:36:38 +0000 (18:36 +0000)]
Add macros for error result fields to libpq.
Tatsuo Ishii [Sun, 24 Aug 2003 05:18:04 +0000 (05:18 +0000)]
Fix GB18030 to UTF-8 mapping table
Peter Eisentraut [Sat, 23 Aug 2003 04:25:29 +0000 (04:25 +0000)]
Bring the makefiles up to our conventions.
Peter Eisentraut [Sat, 23 Aug 2003 04:23:38 +0000 (04:23 +0000)]
Enable uninstalling data files that were installed from a subdirectory of
the source tree.
Peter Eisentraut [Sat, 23 Aug 2003 04:22:34 +0000 (04:22 +0000)]
Fix uninstall target.
Peter Eisentraut [Sat, 23 Aug 2003 04:21:59 +0000 (04:21 +0000)]
Correct uninstall target.
Tom Lane [Fri, 22 Aug 2003 20:34:33 +0000 (20:34 +0000)]
Tweak grammar to use FastAppend rather than lappend when constructing
expr_lists. This appears to be the only remaining O(N^2) bottleneck
in processing many-way 'x IN (a,b,c,...)' conditions.
Tom Lane [Fri, 22 Aug 2003 20:26:43 +0000 (20:26 +0000)]
Tweak processing of multiple-index-scan plans to reduce overhead when
handling many-way scans: instead of re-evaluating all prior indexscan
quals to see if a tuple has been fetched more than once, use a hash table
indexed by tuple CTID. But fall back to the old way if the hash table
grows to exceed SortMem.
Teodor Sigaev [Thu, 21 Aug 2003 15:53:21 +0000 (15:53 +0000)]
ISpell info updated
Peter Eisentraut [Wed, 20 Aug 2003 21:10:01 +0000 (21:10 +0000)]
Translation updates
Tom Lane [Tue, 19 Aug 2003 06:06:48 +0000 (06:06 +0000)]
Updates for array documentation, from Joe Conway.
Tom Lane [Tue, 19 Aug 2003 01:13:41 +0000 (01:13 +0000)]
Improve dynahash.c's API so that caller can specify the comparison function
as well as the hash function (formerly the comparison function was hardwired
as memcmp()). This makes it possible to eliminate the special-purpose
hashtable management code in execGrouping.c in favor of using dynahash to
manage tuple hashtables; which is a win because dynahash knows how to expand
a hashtable when the original size estimate was too small, whereas the
special-purpose code was too stupid to do that. (See recent gripe from
Stephan Szabo about poor performance when hash table size estimate is way
off.) Free side benefit: when using string_hash, the default comparison
function is now strncmp() instead of memcmp(). This should eliminate some
part of the overhead associated with larger NAMEDATALEN values.
Tom Lane [Mon, 18 Aug 2003 19:16:02 +0000 (19:16 +0000)]
When compiling a plpgsql trigger function, include the OID of the table
the trigger is attached to in the hashkey. This ensures that we will
create separate compiled trees for each table the trigger is used with,
avoiding possible datatype-mismatch problems if the tables have different
rowtypes. This is essentially the same bug recently identified in plpython
--- though plpgsql doesn't seem as prone to crash when the rowtype changes
underneath it. But failing robustly is no substitute for just working.
Bruce Momjian [Mon, 18 Aug 2003 02:52:45 +0000 (02:52 +0000)]
Done:
> * -Add btree index support for reltime, tinterval, regproc (Tom)
Tom Lane [Sun, 17 Aug 2003 23:43:27 +0000 (23:43 +0000)]
Fix ARRAY[] construct so that in multidimensional case, elements can
be anything yielding an array of the proper kind, not only sub-ARRAY[]
constructs; do subscript checking at runtime not parse time. Also,
adjust array_cat to make array || array comply with the SQL99 spec.
Joe Conway
Tom Lane [Sun, 17 Aug 2003 22:41:12 +0000 (22:41 +0000)]
Clean up locktable init code per recent gripe from Kurt Roeckx.
No change in behavior, but old code would have failed to detect
overrun of MAX_LOCKMODES.
Tom Lane [Sun, 17 Aug 2003 22:19:15 +0000 (22:19 +0000)]
Somebody forgot to include any actual documentation for ADD_MISSING_FROM.
Tom Lane [Sun, 17 Aug 2003 22:09:00 +0000 (22:09 +0000)]
Update documentation to reflect the fact that ORDER BY, GROUP BY, etc
are now driven by the default btree opclass, rather than assuming that
particular operator names have the needed semantics.
Tom Lane [Sun, 17 Aug 2003 22:05:13 +0000 (22:05 +0000)]
Fix broken markup.
Tom Lane [Sun, 17 Aug 2003 19:58:06 +0000 (19:58 +0000)]
Create a 'type cache' that keeps track of the data needed for any particular
datatype by array_eq and array_cmp; use this to solve problems with memory
leaks in array indexing support. The parser's equality_oper and ordering_oper
routines also use the cache. Change the operator search algorithms to look
for appropriate btree or hash index opclasses, instead of assuming operators
named '<' or '=' have the right semantics. (ORDER BY ASC/DESC now also look
at opclasses, instead of assuming '<' and '>' are the right things.) Add
several more index opclasses so that there is no regression in functionality
for base datatypes. initdb forced due to catalog additions.
Bruce Momjian [Sun, 17 Aug 2003 05:24:52 +0000 (05:24 +0000)]
Add to release notes.
Bruce Momjian [Sun, 17 Aug 2003 05:23:13 +0000 (05:23 +0000)]
Add:
> * Allow PREPARE of cursors
Bruce Momjian [Sun, 17 Aug 2003 04:52:41 +0000 (04:52 +0000)]
I almost forgot mark in docs "to_char(interval)" as deprecated function.
This useless routine will removed in 7.5. It's already discussed (see
hackers list archive).
Karel Zak
Bruce Momjian [Sun, 17 Aug 2003 04:50:57 +0000 (04:50 +0000)]
Add:
> * Fix upper()/lower() to work for multibyte encodings
>
Bruce Momjian [Sun, 17 Aug 2003 04:46:59 +0000 (04:46 +0000)]
This patch makes two minor fixes to the docs: (1) fixes a
spelling mistake in the PREPARE ref page (2) Makes some
English more consistent, in the ref pages for some of the
client apps (3) Adds a link to the libpq docs in the
vacuumdb ref page.
Neil Conway
Bruce Momjian [Sun, 17 Aug 2003 04:46:00 +0000 (04:46 +0000)]
There is a misstatement in the CLOSE reference page, now that we
have cursors that might outlive their creating transactions. A
patch is attached that fixes this (suggestions on better wording
are welcome).
Neil Conway
Bruce Momjian [Sun, 17 Aug 2003 04:43:48 +0000 (04:43 +0000)]
Add:
> * Allow pooled connections to query prepared queries
> * Allow pooled connections to close all open WITH HOLD cursors
Bruce Momjian [Sun, 17 Aug 2003 04:39:11 +0000 (04:39 +0000)]
I just noticed that the sample pg_hba.conf in the docs doesn't contain
any use of CIDR masks - here's a patch that adds a couple of sample
lines and associated comments.
Andrew Dunstan
Bruce Momjian [Sun, 17 Aug 2003 04:33:02 +0000 (04:33 +0000)]
The attached patch adds some clarification to the documentation of the
binary format read/created by COPY BINARY. It also mentions the
contrib/binarycopy module.
Lee Kindness.
Bruce Momjian [Sun, 17 Aug 2003 04:28:15 +0000 (04:28 +0000)]
Add:
> * Add ALTER DOMAIN, AGGREGATE, CONVERSION, SEQUENCE ... OWNER TO
>
Bruce Momjian [Sun, 17 Aug 2003 04:18:01 +0000 (04:18 +0000)]
Add:
> * Add TRUNCATE ... CASCADE
Bruce Momjian [Sun, 17 Aug 2003 03:56:16 +0000 (03:56 +0000)]
Add:
> * Add pg_get_acldef(), pg_get_typedefault(), and pg_get_attrdef()
Bruce Momjian [Sun, 17 Aug 2003 03:17:22 +0000 (03:17 +0000)]
(I always forget what the magic numbers 0 through 2 means for the
"syslog" option.)
By the way: The "virtual_host" parameter is a bad name for that
particular option, I think. "Virtual host" signals that PostgreSQL will
behave differently according to which IP address it's contacted (like
Apache's virtual host support which makes the web-server serve different
sites according to different criteria). A better word for the options
would be "tcpip_listen_addr" or something like that.
Troels Arvin
Bruce Momjian [Sun, 17 Aug 2003 03:14:26 +0000 (03:14 +0000)]
Add mention of sort_mem in the restore docs.
Bruce Momjian [Sun, 17 Aug 2003 00:41:46 +0000 (00:41 +0000)]
Update for 7.3 tips URL.
Bruce Momjian [Sun, 17 Aug 2003 00:20:21 +0000 (00:20 +0000)]
Add to libpq changes made by Tom for new protocol.
Bruce Momjian [Sun, 17 Aug 2003 00:14:13 +0000 (00:14 +0000)]
Not needed, already in CVS.
Bruce Momjian [Sat, 16 Aug 2003 23:53:54 +0000 (23:53 +0000)]
Add description of error style.
Bruce Momjian [Sat, 16 Aug 2003 23:33:49 +0000 (23:33 +0000)]
Add mention that Kerberos 4 isn't recommended.
Bruce Momjian [Sat, 16 Aug 2003 15:35:51 +0000 (15:35 +0000)]
Make NEED_REENTRANT_FUNC_NAMES _require_ *_r functions, and add tests to
configure to report if they are not found.
Barry Lind [Fri, 15 Aug 2003 18:45:11 +0000 (18:45 +0000)]
Updated the blob regression test to actually use the getBlob/getClob methods
and test them, in addition to testing the underlying LargeObject API methods.
Modified Files:
jdbc/build.xml jdbc/org/postgresql/test/jdbc2/BlobTest.java
Barry Lind [Fri, 15 Aug 2003 18:36:58 +0000 (18:36 +0000)]
Fixed improper message length for the connection termination message 'X' when
using the V3 protocol.
Modified Files:
jdbc1/AbstractJdbc1Connection.java
Teodor Sigaev [Fri, 15 Aug 2003 13:44:35 +0000 (13:44 +0000)]
Eliminate function start_parse_fh and macro YY_INPUT
Tom Lane [Fri, 15 Aug 2003 00:22:26 +0000 (00:22 +0000)]
Rewrite array_cmp to not depend on deconstruct_array. Should be a little
faster, but more importantly does not leak memory. Still needs more work
though, per my recent note to pgsql-hackers.
Bruce Momjian [Thu, 14 Aug 2003 23:13:42 +0000 (23:13 +0000)]
Add disk rotation idea to WAL todo emails.
Tom Lane [Thu, 14 Aug 2003 23:13:27 +0000 (23:13 +0000)]
Minor copy-editing.
Bruce Momjian [Thu, 14 Aug 2003 21:24:38 +0000 (21:24 +0000)]
Adjustment for unixware threading.
Bruce Momjian [Thu, 14 Aug 2003 21:14:17 +0000 (21:14 +0000)]
Mark unixware as having threaded support.
Tom Lane [Thu, 14 Aug 2003 20:09:31 +0000 (20:09 +0000)]
Fix longstanding thinko in SSL protocol documentation: the server's
initial response is 'S', not 'Y', when it is willing to do SSL.
Tom Lane [Thu, 14 Aug 2003 18:56:41 +0000 (18:56 +0000)]
Add missing quotes.
Tom Lane [Thu, 14 Aug 2003 18:49:42 +0000 (18:49 +0000)]
Someone moved PageOutput here from common.c, but forgot to move all
the #includes it depends on.
Tom Lane [Thu, 14 Aug 2003 18:48:35 +0000 (18:48 +0000)]
Remove unnecessary #include's (see c.h).
Tom Lane [Thu, 14 Aug 2003 18:32:55 +0000 (18:32 +0000)]
Workaround for platforms that have getaddrinfo() without AI_NUMERICHOST.
We don't actually need the flag, so just #define it as zero in such cases.
Tom Lane [Thu, 14 Aug 2003 14:19:11 +0000 (14:19 +0000)]
Handle double-quotes correctly in user names in ACL lists.
Christopher Kings-Lynne
Bruce Momjian [Thu, 14 Aug 2003 05:27:18 +0000 (05:27 +0000)]
Document threading status.
Update to POSIX getpwuid_r() function.
Bruce Momjian [Wed, 13 Aug 2003 23:59:49 +0000 (23:59 +0000)]
Adjust for compiler options for compiler bug.
Larry Rosenman
Tom Lane [Wed, 13 Aug 2003 18:56:21 +0000 (18:56 +0000)]
libpq failed to cope with COPY FROM STDIN if the command was issued
via extended query protocol, because it sends Sync right after Execute
without realizing that the command to be executed is COPY. There seems
to be no reasonable way for it to realize that, either, so the best fix
seems to be to make the backend ignore Sync during copy-in mode. Bit of
a wart on the protocol, but little alternative. Also, libpq must send
another Sync after terminating the COPY, if the command was issued via
Execute.
Tom Lane [Wed, 13 Aug 2003 16:29:03 +0000 (16:29 +0000)]
Add PQexecPrepared() and PQsendQueryPrepared() functions, to allow
libpq users to perform Bind/Execute of previously prepared statements.
Per yesterday's discussion, this offers enough performance improvement
to justify bending the 'no new features during beta' rule.
Tom Lane [Wed, 13 Aug 2003 16:16:23 +0000 (16:16 +0000)]
Move MemoryContextCheck() call from bottom of PostgresMain loop to
just before CommitTransactionCommand(). This is a more sensible place
to put it since commit discards a lot of contexts, and we'd not find
out about stomps affecting only transaction-local contexts.
Teodor Sigaev [Wed, 13 Aug 2003 14:41:59 +0000 (14:41 +0000)]
Correct error messages
Teodor Sigaev [Wed, 13 Aug 2003 14:37:55 +0000 (14:37 +0000)]
More accuracy work with MinWords option of headline function
Bruce Momjian [Wed, 13 Aug 2003 03:12:04 +0000 (03:12 +0000)]
I'm quite fond of doing VPATH builds, i.e. building outside the source
tree. This also catches lots of little Makefile bugs, so here's a small
patch for one of them (replacing an explicit reference to thread.c with
a reference to it as the first prerequsite of the rule makes make look
for it in the place where it was found (the source tree) rather than in
the build tree. (using GNU make 3.79.1)
John Gray
Tom Lane [Tue, 12 Aug 2003 22:42:01 +0000 (22:42 +0000)]
Include 'IPv4', 'IPv6', or 'Unix' in socket-creation failure messages,
in hopes of soothing fears of those with partial IPv6 support. Still an
open question whether we should report EAFNOSUPPORT errors at all,
though.
Tom Lane [Tue, 12 Aug 2003 21:34:44 +0000 (21:34 +0000)]
Cope with NoData message from backend. Needed for case where
PQexecParams is used with a statement that doesn't return data.
Tom Lane [Tue, 12 Aug 2003 18:52:38 +0000 (18:52 +0000)]
Marginal hacks to move some processing out of the per-client-message
processing loop; avoids extra overhead when using parse/bind/execute
messages instead of single Query message.
Tom Lane [Tue, 12 Aug 2003 18:23:21 +0000 (18:23 +0000)]
Change some frequently-reached elog(DEBUG...) calls to ereport(DEBUG...)
for speed reasons. (ereport falls out much more quickly when no output
is needed than elog does.)
Tom Lane [Tue, 12 Aug 2003 16:21:18 +0000 (16:21 +0000)]
Avoid unnecessary work when stats collection is disabled. Tighten
search loop in pgstat_initstats. Per report from Gavin Sherry.
Barry Lind [Mon, 11 Aug 2003 23:42:04 +0000 (23:42 +0000)]
Applied patch from Oliver Jowett to clean up the jdbc regression test build
Modified Files:
jdbc/build.xml
jdbc/org/postgresql/test/jdbc3/Jdbc3TestSuite.java