OSDN Git Service
Bruce Momjian [Fri, 23 Aug 2002 02:56:36 +0000 (02:56 +0000)]
Patch resolve ERROR problem for non-goog query_txt.
Teodor Sigaev
Bruce Momjian [Fri, 23 Aug 2002 02:54:18 +0000 (02:54 +0000)]
This patch updates the CREATE OPERATOR sgml docs for the new default
settings of NAMEDATALEN. I looked through the docs for other
references to NAMEDATALEN, but this is the only one I could find.
Neil Conway
Bruce Momjian [Fri, 23 Aug 2002 02:53:20 +0000 (02:53 +0000)]
Update Russian FAQ.
Bruce Momjian [Fri, 23 Aug 2002 02:46:39 +0000 (02:46 +0000)]
Add:
> * Add GUC parameter to print queries that generate errors
Tom Lane [Fri, 23 Aug 2002 01:28:17 +0000 (01:28 +0000)]
Very minor copy-editing.
Tom Lane [Fri, 23 Aug 2002 01:27:44 +0000 (01:27 +0000)]
Add note that explains that \df omits functions it thinks are I/O functions.
Tom Lane [Fri, 23 Aug 2002 00:33:24 +0000 (00:33 +0000)]
Update reference to value of NAMEDATALEN. Someone needs to troll the
docs and find the other obsolete statements that no doubt lurk.
Tom Lane [Fri, 23 Aug 2002 00:04:52 +0000 (00:04 +0000)]
Update contrib regression tests for OPAQUE datatype changes.
Tom Lane [Thu, 22 Aug 2002 23:33:43 +0000 (23:33 +0000)]
Since the plpgsql test has been part of the standard regression tests
for a good long while, I see no reason to maintain this original copy.
Tom Lane [Thu, 22 Aug 2002 23:31:48 +0000 (23:31 +0000)]
Transpose info from src/pl/plpgsql/test/README into standard regression test file.
Bruce Momjian [Thu, 22 Aug 2002 23:20:52 +0000 (23:20 +0000)]
Mark 7.2.2 as newest release.
Bruce Momjian [Thu, 22 Aug 2002 23:20:25 +0000 (23:20 +0000)]
Update FAQ.
Marc G. Fournier [Thu, 22 Aug 2002 22:43:14 +0000 (22:43 +0000)]
Remove all traces of the ODBC driver, which is now on GBorg as the psqlodbc
project ...
Tom Lane [Thu, 22 Aug 2002 21:35:50 +0000 (21:35 +0000)]
Fix bit rot in pg_dump's ability to dump from 7.2 and 7.1 servers.
Tom Lane [Thu, 22 Aug 2002 21:29:34 +0000 (21:29 +0000)]
Fixed-size buffer in dumpClasses is not big enough anymore given the
addition of a column list clause to the COPY command. Spotted by
Martin Renters.
Bruce Momjian [Thu, 22 Aug 2002 15:31:07 +0000 (15:31 +0000)]
Improve wording of upgrade section.
Tom Lane [Thu, 22 Aug 2002 14:23:36 +0000 (14:23 +0000)]
Code review for recent TRUNCATE changes. Tighten relation-kind check,
tighten foreign-key check (a self-reference should not prevent TRUNCATE),
improve error message, cause a relation's TOAST table to be truncated
along with the relation.
Bruce Momjian [Thu, 22 Aug 2002 05:05:19 +0000 (05:05 +0000)]
Commit updated repeat() patch, from Neil Conway
Bruce Momjian [Thu, 22 Aug 2002 04:56:44 +0000 (04:56 +0000)]
Fix for documention:
>>" It's also possible to select no escape character by writing ESCAPE ''.
>>In this case there is no way to turn off the special meaning of
>>underscore and percent signs in the pattern."
Joe Conway
Bruce Momjian [Thu, 22 Aug 2002 04:55:05 +0000 (04:55 +0000)]
This patch should fix the problem. Doesn't include my previous patch
for repeat(). Again, somewhat off-the-cuff, so I might have missed
something...
test=# select lpad('xxxxx',
1431655765,'yyyyyyyyyyyyyyyy');
ERROR: Requested length too large
test=# select rpad('xxxxx',
1431655765,'yyyyyyyyyyyyyyyy');
ERROR: Requested length too large
(That's on a Unicode DB, haven't tested other encodings but AFAICT
this fix should still work.)
Neil Conway
Bruce Momjian [Thu, 22 Aug 2002 04:54:20 +0000 (04:54 +0000)]
repeat() fix:
> Neil Conway <neilc@samurai.com> writes:
> > + /* Check for integer overflow */
> > + if (tlen / slen != count)
> > + elog(ERROR, "Requested buffer is too large.");
>
> What about slen == 0?
Good point -- that wouldn't cause incorrect results or a security
problem, but it would reject input that we should really accept.
Revised patch is attached.
Neil Conway
Bruce Momjian [Thu, 22 Aug 2002 04:52:17 +0000 (04:52 +0000)]
> > I had great difficulty in finding how to change the search path, so here
> > is a patch to add some cross-referencing.
Oliver Elphick
Bruce Momjian [Thu, 22 Aug 2002 04:51:06 +0000 (04:51 +0000)]
# Disallow TRUNCATE on tables that are involved in referential
constraints
The issue with finding and removing foreign key constraints is no longer
an issue, so please apply the attached.
It does NOT check for rules or on delete triggers (old style foreign
keys) as those are difficult to deal with (remove, truncate, re-add).
Rod Taylor
Bruce Momjian [Thu, 22 Aug 2002 04:47:31 +0000 (04:47 +0000)]
Add:
> * Allow bytea to handle LIKE with non-TEXT patterns
Bruce Momjian [Thu, 22 Aug 2002 04:45:11 +0000 (04:45 +0000)]
As suggested by Tom, this patch restricts the right-hand argument of
bytealike to TEXT.
This leaves like_escape_bytea() without anything to do, but I left it in
place in anticipation of the eventual bytea pattern selectivity
functions. If there is agreement that this would be the best long term
solution, I'll take it as a TODO for 7.4.
Joe Conway
Bruce Momjian [Thu, 22 Aug 2002 04:41:06 +0000 (04:41 +0000)]
Oops, we got duplicate oids from patches again; pick a unique one.
Bruce Momjian [Thu, 22 Aug 2002 03:24:01 +0000 (03:24 +0000)]
Add:
replace(string, from, to)
-- replaces all occurrences of "from" in "string" to "to"
split(string, fldsep, column)
-- splits "string" on "fldsep" and returns "column" number piece
to_hex(int32_num) & to_hex(int64_num)
-- takes integer number and returns as hex string
Joe Conway
Bruce Momjian [Thu, 22 Aug 2002 03:17:38 +0000 (03:17 +0000)]
Remove libpq++ SGML documentation.
Bruce Momjian [Thu, 22 Aug 2002 02:18:45 +0000 (02:18 +0000)]
Remove erroneous character from Makefile due to editor error.
Marc G. Fournier [Thu, 22 Aug 2002 00:15:14 +0000 (00:15 +0000)]
Okay, libpq++ is moved to GBorg, and all traces of it have been removed
from the core repository ... I haven't *moved* the libpq++ files out of the
tree, mainly as we want to keep them in place for past branches ...
Peter, I think I've covered all the files I need, and re-ran autoconf to make
sure the configure file is in place properly ...
Tom Lane [Thu, 22 Aug 2002 00:01:51 +0000 (00:01 +0000)]
Add a bunch of pseudo-types to replace the behavior formerly associated
with OPAQUE, as per recent pghackers discussion. I still want to do some
more work on the 'cstring' pseudo-type, but I'm going to commit the bulk
of the changes now before the tree starts shifting under me ...
Peter Eisentraut [Wed, 21 Aug 2002 22:24:34 +0000 (22:24 +0000)]
Add --help and --version options. Message cleanup. NLS.
Bruce Momjian [Wed, 21 Aug 2002 21:33:55 +0000 (21:33 +0000)]
Changes made so new conversion Makefiles will build out of the source tree.
Peter Eisentraut [Wed, 21 Aug 2002 20:42:27 +0000 (20:42 +0000)]
Move PO files into subdirectories separate from the source code.
Peter Eisentraut [Wed, 21 Aug 2002 17:20:58 +0000 (17:20 +0000)]
Add sys/types.h to common includes.
Bruce Momjian [Wed, 21 Aug 2002 16:08:19 +0000 (16:08 +0000)]
Fix bad markup detected by Alvaro Herrera
Bruce Momjian [Wed, 21 Aug 2002 05:25:49 +0000 (05:25 +0000)]
Fix markup, Alvaro Herrera.
Tom Lane [Tue, 20 Aug 2002 19:23:07 +0000 (19:23 +0000)]
Use a non-duplicate OID for pg_lock_status.
Peter Eisentraut [Tue, 20 Aug 2002 17:54:45 +0000 (17:54 +0000)]
Enable large file support.
Use off_t and size_t in pg_dump to handle file offset arithmetic correctly.
Tom Lane [Tue, 20 Aug 2002 16:46:29 +0000 (16:46 +0000)]
Increase buffer size in cash_words(). Pure paranoia; I don't think the
code is broken, but any small change in the output format might overrun
the buffer with the old size.
Tom Lane [Tue, 20 Aug 2002 16:37:03 +0000 (16:37 +0000)]
Update expected files for recent changes of domain tests.
From Rod Taylor.
Bruce Momjian [Tue, 20 Aug 2002 05:28:24 +0000 (05:28 +0000)]
This patch improves the behavior of FOUND in PL/PgSQL. In Oracle,
FOUND is set whenever a SELECT INTO returns > 0 rows, *or* when an
INSERT, UPDATE, or DELETE affects > 0 rows. We implemented the first
part of this behavior, but not the second.
I also improved the documentation on the various situations in which
FOUND can be set (excluding inside FOR loops, which I still need to
think about), and added some regression tests for this behavior.
Neil Conway
Bruce Momjian [Tue, 20 Aug 2002 05:12:48 +0000 (05:12 +0000)]
Cleanup.
Bruce Momjian [Tue, 20 Aug 2002 04:48:36 +0000 (04:48 +0000)]
- test for indexes on a domain
- don't fail type-sanity checks if a domain exists
Rod Taylor
Bruce Momjian [Tue, 20 Aug 2002 04:47:52 +0000 (04:47 +0000)]
Allow pg_statistics to be reset by calling pg_stat_reset().
Christopher Kings-Lynne
Bruce Momjian [Tue, 20 Aug 2002 04:46:00 +0000 (04:46 +0000)]
Add current_database().
> Quick system function to pull out the current database.
>
> I've used this a number of times to allow stored procedures to find out
> where they are. Especially useful for those that do logging or hit a
> remote server.
>
> It's called current_database() to match with current_user().
It's also a necessity for an informational schema. The catalog
(database) name is required in a number of places.
Rod Taylor
Barry Lind [Tue, 20 Aug 2002 04:26:02 +0000 (04:26 +0000)]
Removed code that is no longer used and has been commented out
for the last two releases.
Modified Files:
jdbc/org/postgresql/Driver.java.in
jdbc/org/postgresql/PG_Stream.java
Removed Files:
jdbc/org/postgresql/core/BytePoolDim1.java
jdbc/org/postgresql/core/BytePoolDim2.java
jdbc/org/postgresql/core/MemoryPool.java
jdbc/org/postgresql/core/ObjectPool.java
jdbc/org/postgresql/core/SimpleObjectPool.java
Bruce Momjian [Tue, 20 Aug 2002 02:20:48 +0000 (02:20 +0000)]
Add mention of -F not supported by pg_dumpall. Code already disallows it.
Bruce Momjian [Tue, 20 Aug 2002 02:16:38 +0000 (02:16 +0000)]
Done by Rod:
> * -Make other constraints clearer in dump file
Tom Lane [Mon, 19 Aug 2002 19:33:36 +0000 (19:33 +0000)]
Fix pg_dump to dump serial columns as serials. Per pghackers discussion,
cause SERIAL column declaration not to imply UNIQUE, so that this can be
done without creating an extra index.
Tom Lane [Mon, 19 Aug 2002 15:08:47 +0000 (15:08 +0000)]
Remove Ident nodetype in favor of using String nodes; this fixes some
latent wrong-struct-type bugs and makes the coding style more uniform,
since the majority of places working with lists of column names were
already using Strings not Idents. While at it, remove vestigial
support for Stream node type, and otherwise-unreferenced nodes.h entries
for T_TupleCount and T_BaseNode.
NB: full recompile is recommended due to changes of Node type numbers.
This shouldn't force an initdb though.
Tatsuo Ishii [Mon, 19 Aug 2002 04:08:08 +0000 (04:08 +0000)]
Fix bug in pg_convert() per report from MaC.Yui.
It pfree() wrong pointer.
Tatsuo Ishii [Mon, 19 Aug 2002 04:05:00 +0000 (04:05 +0000)]
Fix broken tag.
Tom Lane [Mon, 19 Aug 2002 00:40:15 +0000 (00:40 +0000)]
Clean up leftover bugs from recent COPY feature patch --- missed
required changes to copyfuncs/equalfuncs.
Tom Lane [Mon, 19 Aug 2002 00:11:53 +0000 (00:11 +0000)]
Add missing copyfuncs/equalfuncs entries, including T_Null which has
been missing forever; surprising it wasn't noticed before. The other
additions are, um, sloppiness in certain recent feature additions.
Tom Lane [Mon, 19 Aug 2002 00:10:03 +0000 (00:10 +0000)]
Improve obsolete comment.
Tom Lane [Sun, 18 Aug 2002 21:05:32 +0000 (21:05 +0000)]
Fix small copy-and-pasteo.
Tom Lane [Sun, 18 Aug 2002 20:15:52 +0000 (20:15 +0000)]
Fix potential buffer overrun in cube_out(), per report from
Bruno Wolff.
Tom Lane [Sun, 18 Aug 2002 18:46:15 +0000 (18:46 +0000)]
Remove optimization whereby parser would make only one sort-list entry
when two equal() targetlist items were to be added to an ORDER BY or
DISTINCT list. Although indeed this would make sorting fractionally
faster by sometimes saving a comparison, it confuses the heck out of
later stages of processing, because it makes it look like the user
wrote DISTINCT ON rather than DISTINCT. Bug reported by joe@piscitella.com.
Peter Eisentraut [Sun, 18 Aug 2002 11:20:05 +0000 (11:20 +0000)]
Make CREATE CONSTRAINT TRIGGER check for REFERENCES privilege on both
master and slave tables.
Peter Eisentraut [Sun, 18 Aug 2002 09:36:26 +0000 (09:36 +0000)]
Make pg_dump output more portable and more pleasing to look at.
The -n and -N options were removed. Quoting is now smart enough to
supply quotes if and only if necessary.
Numerical types are now printed without quotes, except in cases of
special values such as NaN.
Boolean values printed as true and false.
Most string literals now do not escape whitespace characters (newlines,
etc.) for portability.
SET SESSION AUTHORIZATION argument is a string literal, to follow SQL.
Made commands output by pg_dump use consistent spacing and indentation.
Tom Lane [Sun, 18 Aug 2002 03:47:08 +0000 (03:47 +0000)]
Add #include <sys/time.h>.
Tom Lane [Sun, 18 Aug 2002 03:35:08 +0000 (03:35 +0000)]
Code review for 'at character n' patch --- point at proper end of
a token scanned by multiple lex rules.
Bruce Momjian [Sun, 18 Aug 2002 03:03:26 +0000 (03:03 +0000)]
Add db-local user names, per discussion on hackers.
Bruce Momjian [Sun, 18 Aug 2002 03:00:17 +0000 (03:00 +0000)]
More changes to match new error format.
Tom Lane [Sun, 18 Aug 2002 02:48:41 +0000 (02:48 +0000)]
Use variable for format to suppress overly-anal-retentive gcc warning
about %c
Bruce Momjian [Sun, 18 Aug 2002 02:48:29 +0000 (02:48 +0000)]
Modify regression tests to match new error reporting format from Gavin.
Bruce Momjian [Sun, 18 Aug 2002 01:39:43 +0000 (01:39 +0000)]
Back out tcl patch, per Tom Lane:
Everytime if I do PQconsumeInput (when the backend channel gets
readable) I check for the return value. (0 == error) and generate a
notification manually, e.g. fixed string connection_closed) and pass it to the
Bruce Momjian [Sun, 18 Aug 2002 01:35:40 +0000 (01:35 +0000)]
Add includes for prototype using timeval.
Bruce Momjian [Sun, 18 Aug 2002 00:06:01 +0000 (00:06 +0000)]
Clean up compile warnings.
Tom Lane [Sat, 17 Aug 2002 20:24:51 +0000 (20:24 +0000)]
Fix typo.
Bruce Momjian [Sat, 17 Aug 2002 15:12:07 +0000 (15:12 +0000)]
Reverse out XLogDir/-X write-ahead log handling, per discussion.
Original patch from Thomas.
Bruce Momjian [Sat, 17 Aug 2002 15:09:41 +0000 (15:09 +0000)]
Add:
> * Use dependency information to dump data in proper order
Bruce Momjian [Sat, 17 Aug 2002 13:14:07 +0000 (13:14 +0000)]
Done:
> o -Add command to display locks
Bruce Momjian [Sat, 17 Aug 2002 13:11:43 +0000 (13:11 +0000)]
Add lock file.
Bruce Momjian [Sat, 17 Aug 2002 13:06:50 +0000 (13:06 +0000)]
In that case, attached is a patch which locates the beginning of the
offending token more efficiently (per your suggestion of using
scanbuf). The new patch does the same as before:
template1=# select * frum pg_class;
ERROR: parser: parse error at or near "frum" at character 10
It also implement's Tom's suggestion:
template1=# select * from pg_class where\g
ERROR: parse: parse error at end of input
Gavin Sherry
Bruce Momjian [Sat, 17 Aug 2002 13:04:19 +0000 (13:04 +0000)]
[ Newest version of patch applied.]
This patch is an updated version of the lock listing patch. I've made
the following changes:
- write documentation
- wrap the SRF in a view called 'pg_locks': all user-level
access should be done through this view
- re-diff against latest CVS
One thing I chose not to do is adapt the SRF to use the anonymous
composite type code from Joe Conway. I'll probably do that eventually,
but I'm not really convinced it's a significantly cleaner way to
bootstrap SRF builtins than the method this patch uses (of course, it
has other uses...)
Neil Conway
Bruce Momjian [Sat, 17 Aug 2002 12:33:18 +0000 (12:33 +0000)]
Add libpq connection timeout parameter.
Denis A Ustimenko
Bruce Momjian [Sat, 17 Aug 2002 12:19:31 +0000 (12:19 +0000)]
What I have done for libpgtcl:
Everytime if I do PQconsumeInput (when the backend channel gets
readable) I check for the return value. (0 == error) and generate a
notification manually, e.g. fixed string connection_closed) and pass it to the
TCL event queue. The only other thing I had to do is to comment out removing
all pending events in PgStopNotifyEventSource whenever the connection was
unexpectedly closed (so the manually generated event will not be deleted).
A broken backend connection triggers a notify event to the client (fixed
notification string "connection_closed") so proper action can be taken to switch
to another database server etc. Remember that this is event driven. If you have
applications, that have idle database connections most of the time, you'll get
immediate feedback of a dying server. Upon connection to the server issue a
pg_notify for notify event "connection_closed" and whenever the backend crashes
(which it does do in very very rare cases) you get an event driven recovery. (of
course the Tcl-Event loop has to be processed). Issuing a notification
"connection_closed" on a still working database could be used for switching to
another db-server (which I've actually impelemented right now).
Gerhard Hintermayer
Bruce Momjian [Sat, 17 Aug 2002 12:15:49 +0000 (12:15 +0000)]
Improve documentation of trigger firing queue handling, cleanup.
Neil Conway
Tom Lane [Sat, 17 Aug 2002 05:07:18 +0000 (05:07 +0000)]
Editorial corrections.
Tom Lane [Sat, 17 Aug 2002 04:09:18 +0000 (04:09 +0000)]
Broken markup.
Tom Lane [Sat, 17 Aug 2002 04:06:48 +0000 (04:06 +0000)]
Cleanup.
Tom Lane [Sat, 17 Aug 2002 04:03:36 +0000 (04:03 +0000)]
Fix broken Makefiles.
Tom Lane [Sat, 17 Aug 2002 03:38:43 +0000 (03:38 +0000)]
Add missing links.
Bruce Momjian [Sat, 17 Aug 2002 02:45:29 +0000 (02:45 +0000)]
Add doc file for pg_resetxlog.
Bruce Momjian [Sat, 17 Aug 2002 02:44:24 +0000 (02:44 +0000)]
Add files for pg_resetxlog.
Bruce Momjian [Sat, 17 Aug 2002 02:43:08 +0000 (02:43 +0000)]
Move pg_controldata to /bin.
Tom Lane [Fri, 16 Aug 2002 23:01:21 +0000 (23:01 +0000)]
Modify pg_dump to dump foreign-key constraints as constraints, not as
sets of triggers. Also modify psql \d command to show foreign key
constraints as such and hide the triggers. pg_get_constraintdef()
function added to backend to support these. From Rod Taylor, code
review and some editorialization by Tom Lane.
Tom Lane [Fri, 16 Aug 2002 21:03:42 +0000 (21:03 +0000)]
Code review for patch to dump primary and unique constraints as
constraints, rather than as CREATE INDEX commands.
Tom Lane [Fri, 16 Aug 2002 20:55:09 +0000 (20:55 +0000)]
Make domain types indexable. Rod Taylor & Tom Lane.
Bruce Momjian [Fri, 16 Aug 2002 20:36:25 +0000 (20:36 +0000)]
Improve wording.
Bruce Momjian [Fri, 16 Aug 2002 20:34:06 +0000 (20:34 +0000)]
Move pg_controldata from /contrib to src/bin.
Dave Cramer [Fri, 16 Aug 2002 19:37:57 +0000 (19:37 +0000)]
removed duplicate code from jdbc2 classes
Dave Cramer [Fri, 16 Aug 2002 19:35:46 +0000 (19:35 +0000)]
applied patch to fix encoding bug supplied by Jun Kawai
Dave Cramer [Fri, 16 Aug 2002 19:34:57 +0000 (19:34 +0000)]
Applied patch for MD5 bug submitted by Jun Kawai
Barry Lind [Fri, 16 Aug 2002 17:51:38 +0000 (17:51 +0000)]
Performance tweaks to StringBuffer suggested by hhaag@gmx.de
Modified Files:
jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSet.java
jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java
jdbc/org/postgresql/util/PGbytea.java
Bruce Momjian [Fri, 16 Aug 2002 17:05:18 +0000 (17:05 +0000)]
Add "few":
> * Reserve last few process slots for super-user if max_connections reached
Bruce Momjian [Fri, 16 Aug 2002 15:13:13 +0000 (15:13 +0000)]
Add blank line.
Bruce Momjian [Fri, 16 Aug 2002 15:12:43 +0000 (15:12 +0000)]
Add:
<
> * Reserve last process slot for super-user if max_connections reached