OSDN Git Service
Peter Eisentraut [Wed, 28 Aug 2002 18:25:05 +0000 (18:25 +0000)]
Dump ALTER DATABASE/USER ... SET ...
Bruce Momjian [Wed, 28 Aug 2002 16:45:11 +0000 (16:45 +0000)]
Remove:
< * Remove PGPASSWORD because it is insecure on some OS's, in 7.4
Tom Lane [Wed, 28 Aug 2002 15:02:55 +0000 (15:02 +0000)]
Update info about relkind and pg_type entries for composite-types patch.
Bruce Momjian [Wed, 28 Aug 2002 14:35:37 +0000 (14:35 +0000)]
Allow FOR UPDATE to appear after LIMIT/OFFSET to match MySQL syntax and as
a more logical ordering.
Tom Lane [Tue, 27 Aug 2002 21:50:23 +0000 (21:50 +0000)]
Fix compile warning.
Peter Eisentraut [Tue, 27 Aug 2002 21:33:41 +0000 (21:33 +0000)]
Flush output streams before calling pg_dump subprocess.
Bruce Momjian [Tue, 27 Aug 2002 21:16:13 +0000 (21:16 +0000)]
Add:
> o Add SET SCHEMA
Bruce Momjian [Tue, 27 Aug 2002 21:04:58 +0000 (21:04 +0000)]
Disable use of -c and -a together in pg_dump; they don't make sense together.
Tom Lane [Tue, 27 Aug 2002 20:54:47 +0000 (20:54 +0000)]
Bring comments back in sync with code.
Bruce Momjian [Tue, 27 Aug 2002 20:29:11 +0000 (20:29 +0000)]
Throw error on pg_atoi(''), regression adjustments.
Peter Eisentraut [Tue, 27 Aug 2002 20:16:49 +0000 (20:16 +0000)]
Enable locale, so case conversion (identifier processing) and number
formatting (\timing) works correctly. Change "Total time" to "Time"
since there is nothing that "total" refers to. Remove non-multibyte
code.
Peter Eisentraut [Tue, 27 Aug 2002 18:57:26 +0000 (18:57 +0000)]
Reimplement pg_dumpall in C. Currently no change in functionality,
except that it's more robust, reconnects less often, and is NLS'ed.
Bruce Momjian [Tue, 27 Aug 2002 18:28:29 +0000 (18:28 +0000)]
Add '+' mention in \? help. More clean of \? to do.
Bruce Momjian [Tue, 27 Aug 2002 18:06:00 +0000 (18:06 +0000)]
Make change for pg_locks table.
Bruce Momjian [Tue, 27 Aug 2002 16:21:51 +0000 (16:21 +0000)]
The attached patch implements the password packet length sanity check
(using an elog(LOG) ), as well as includes a few more comment fixes.
Neil Conway
Bruce Momjian [Tue, 27 Aug 2002 16:19:46 +0000 (16:19 +0000)]
Add:
> * Allow free space map to be auto-sized or warn when it is too small
Bruce Momjian [Tue, 27 Aug 2002 15:31:32 +0000 (15:31 +0000)]
Add error code emails.
Bruce Momjian [Tue, 27 Aug 2002 15:15:23 +0000 (15:15 +0000)]
Add most of Neil Conway's cleanups.
Bruce Momjian [Tue, 27 Aug 2002 15:02:50 +0000 (15:02 +0000)]
More connection timeout cleanups.
Bruce Momjian [Tue, 27 Aug 2002 14:49:52 +0000 (14:49 +0000)]
Cleanup of libpq connection timeout code.
Bruce Momjian [Tue, 27 Aug 2002 14:17:14 +0000 (14:17 +0000)]
Add:
> * Allow REINDEX to rebuild all indexes, remove /contrib/reindex
> o Allow CLUSTER to cluster all tables, remove clusterdb
Bruce Momjian [Tue, 27 Aug 2002 14:06:05 +0000 (14:06 +0000)]
Add fsm sizes.
Tom Lane [Tue, 27 Aug 2002 04:55:12 +0000 (04:55 +0000)]
PREPARE/EXECUTE statements. Patch by Neil Conway, some kibitzing
from Tom Lane.
Bruce Momjian [Tue, 27 Aug 2002 04:30:24 +0000 (04:30 +0000)]
Done:
> o -Cluster all tables at once using pg_index.indisclustered set during
Bruce Momjian [Tue, 27 Aug 2002 04:09:01 +0000 (04:09 +0000)]
Add to mmap discussion.
Bruce Momjian [Tue, 27 Aug 2002 04:00:28 +0000 (04:00 +0000)]
This patch updates the lock listing code to use Joe Conway's new
anonymous return type SRF code. It gets rid of the superflous
'pg_locks_result' that Bruce/Tom had commented on. Otherwise, no
changes in functionality.
Neil Conway
Bruce Momjian [Tue, 27 Aug 2002 03:57:11 +0000 (03:57 +0000)]
This is a 2 line patch to src/interfaces/perl5/GNUMakefile that fixes
the 'override CPPFLAGS' to include the source directory during compile,
and makes the install target look in the proper place for the man page.
Changes are only required when building outside the source directory.
J. R. Nield
Bruce Momjian [Tue, 27 Aug 2002 03:56:35 +0000 (03:56 +0000)]
This patches replaces a few more usages of strcpy() and sprintf() when
copying into a fixed-size buffer (in this case, a buffer of
NAMEDATALEN bytes). AFAICT nothing to worry about here, but worth
fixing anyway...
Neil Conway
Bruce Momjian [Tue, 27 Aug 2002 03:55:17 +0000 (03:55 +0000)]
Cleanup of SGML
Bruce Momjian [Tue, 27 Aug 2002 03:38:28 +0000 (03:38 +0000)]
I attach a little patch to make CLUSTER set and reset the indisclustered
bit on the indexes.
I also attach clusterdb and clusterdb.sgml; both of them are blatant
rips of vacuumdb and vacuumdb.sgml, but get the job done. Please review
them, as I'm probably making a lot of mistakes with SGML and I can't
compile it here.
vacuumdb itself is not very comfortable to use when the databases have
passwords, because it has to connect once for each table (I can probably
make it connect only once for each database; should I?). Because of
this I added a mention of PGPASSWORDFILE in the documentation, but I
don't know if that is the correct place for that.
Alvaro Herrera
Bruce Momjian [Tue, 27 Aug 2002 03:06:16 +0000 (03:06 +0000)]
Add to skip list in check_guc
Bruce Momjian [Tue, 27 Aug 2002 03:02:31 +0000 (03:02 +0000)]
Comment cleanup.
Bruce Momjian [Tue, 27 Aug 2002 03:01:13 +0000 (03:01 +0000)]
Script cleanups.
Bruce Momjian [Tue, 27 Aug 2002 02:54:39 +0000 (02:54 +0000)]
Clean up script.
Bruce Momjian [Tue, 27 Aug 2002 02:52:42 +0000 (02:52 +0000)]
Add check_guc utility to compare guc.c and postgresql.conf.sample.
Bruce Momjian [Tue, 27 Aug 2002 02:50:41 +0000 (02:50 +0000)]
Fix units in postgresql.conf.
Bruce Momjian [Mon, 26 Aug 2002 23:22:47 +0000 (23:22 +0000)]
Add OS X link line example for external functions.
Bruce Momjian [Mon, 26 Aug 2002 23:14:15 +0000 (23:14 +0000)]
Add discussion of pre-write pages to WAL.
Bruce Momjian [Mon, 26 Aug 2002 23:13:37 +0000 (23:13 +0000)]
Add:
> partial page writes [wal]
Bruce Momjian [Mon, 26 Aug 2002 23:02:21 +0000 (23:02 +0000)]
Add:
> * Add CORRESPONDING BY to UNION/INTERSECT/EXCEPT
Bruce Momjian [Mon, 26 Aug 2002 22:23:07 +0000 (22:23 +0000)]
Add units to postgresql.conf file.
Bruce Momjian [Mon, 26 Aug 2002 22:02:20 +0000 (22:02 +0000)]
Remove:
< o Add plsh server-side shell language (Peter E)
Bruce Momjian [Mon, 26 Aug 2002 22:01:50 +0000 (22:01 +0000)]
*** empty log message ***
Bruce Momjian [Mon, 26 Aug 2002 21:52:00 +0000 (21:52 +0000)]
Add to selfjoin DELETE todo.
Bruce Momjian [Mon, 26 Aug 2002 21:35:32 +0000 (21:35 +0000)]
Add:
> * Allow DELETE to handle table aliases for self-joins [delete]
Bruce Momjian [Mon, 26 Aug 2002 21:35:01 +0000 (21:35 +0000)]
Add delete selfjoin item.
Bruce Momjian [Mon, 26 Aug 2002 20:03:10 +0000 (20:03 +0000)]
Add info on disabled triggers.
Bruce Momjian [Mon, 26 Aug 2002 20:02:45 +0000 (20:02 +0000)]
Add:
> * Allow triggers to be disabled [trigger]
Tom Lane [Mon, 26 Aug 2002 18:45:57 +0000 (18:45 +0000)]
Increase WIDTH_THRESHOLD from 256 to 1K. This addresses recent observation
that ANALYZE would not gather any stats for a CHAR(255) column. I still
think a width threshold is appropriate for the reasons mentioned in the
code, but we can loosen it at least.
Tom Lane [Mon, 26 Aug 2002 17:54:02 +0000 (17:54 +0000)]
Modify array operations to include array's element type OID in the
array header, and to compute sizing and alignment of array elements
the same way normal tuple access operations do --- viz, using the
tupmacs.h macros att_addlength and att_align. This makes the world
safe for arrays of cstrings or intervals, and should make it much
easier to write array-type-polymorphic functions; as examples see
the cleanups of array_out and contrib/array_iterator. By Joe Conway
and Tom Lane.
Bruce Momjian [Mon, 26 Aug 2002 17:40:27 +0000 (17:40 +0000)]
Add 'return' file.
Bruce Momjian [Mon, 26 Aug 2002 17:40:00 +0000 (17:40 +0000)]
Add return tuple count item to TODO.
Bruce Momjian [Mon, 26 Aug 2002 17:39:31 +0000 (17:39 +0000)]
Add:
> * Return proper effected tuple count from complex commands [return]
Bruce Momjian [Mon, 26 Aug 2002 17:14:29 +0000 (17:14 +0000)]
Add anther sequential scan email.
Bruce Momjian [Mon, 26 Aug 2002 01:05:43 +0000 (01:05 +0000)]
Add mention of 1 terrabyte databases.
Bruce Momjian [Mon, 26 Aug 2002 01:04:44 +0000 (01:04 +0000)]
*** empty log message ***
Bruce Momjian [Mon, 26 Aug 2002 01:04:13 +0000 (01:04 +0000)]
Add raw file discussion to performance TODO.detail.
Bruce Momjian [Mon, 26 Aug 2002 00:52:40 +0000 (00:52 +0000)]
Done:
> * -Disallow TRUNCATE on tables that are involved in referential constraints
Bruce Momjian [Mon, 26 Aug 2002 00:22:53 +0000 (00:22 +0000)]
Add to tablespaces discussion.
Bruce Momjian [Mon, 26 Aug 2002 00:19:33 +0000 (00:19 +0000)]
Add to tablespaces file.
Bruce Momjian [Sun, 25 Aug 2002 22:39:37 +0000 (22:39 +0000)]
Add Bob Devine's name to the optimizer README.
Bruce Momjian [Sun, 25 Aug 2002 20:36:14 +0000 (20:36 +0000)]
Add file describing error message format.
Bruce Momjian [Sun, 25 Aug 2002 20:30:30 +0000 (20:30 +0000)]
Add:
> * Make error messages more consistent [error]
Tom Lane [Sun, 25 Aug 2002 17:20:01 +0000 (17:20 +0000)]
Clean up comments to be careful about the distinction between variable-
width types and varlena types, since with the introduction of CSTRING as
a more-or-less-real type, these concepts aren't identical. I've tried to
use varlena consistently to denote datatypes with typlen = -1, ie, they
have a length word and are potentially TOASTable; while the term variable
width covers both varlena and cstring (and, perhaps, someday other types
with other rules for computing the actual width). No code changes in this
commit except for renaming a couple macros.
Bruce Momjian [Sun, 25 Aug 2002 14:34:24 +0000 (14:34 +0000)]
Update docs for 7.2.2 release info.
Bruce Momjian [Sun, 25 Aug 2002 12:58:44 +0000 (12:58 +0000)]
Update Japanese FAQ, from Jun Kuwamura
Tom Lane [Sat, 24 Aug 2002 15:00:47 +0000 (15:00 +0000)]
The cstring datatype can now be copied, passed around, etc. The typlen
value '-2' is used to indicate a variable-width type whose width is
computed as strlen(datum)+1. Everything that looks at typlen is updated
except for array support, which Joe Conway is working on; at the moment
it wouldn't work to try to create an array of cstring.
Bruce Momjian [Sat, 24 Aug 2002 11:24:58 +0000 (11:24 +0000)]
Done:
> * -SELECT cash_out(2) crashes because of opaque
Barry Lind [Fri, 23 Aug 2002 20:45:49 +0000 (20:45 +0000)]
Enhancements to how queries with bind values are stored internally and sent to
the server. Previously we allocated a new String object for the entire final
query we were sending to the database. If you had a big query, or especially
if you had large bind values you ended up with essentially two copies in memory.
This change will reuse the existing objects and therefore should take 1/2 the
memory it does today for a given query. This restructuring will also allow
in the future the ability to stream bytea data to the server instead of the current approach of pulling it all into memory.
I also fixed a test that was failing on a 7.2 database.
Also renamed some internal variables and some minor cleanup.
Modified Files:
jdbc/org/postgresql/core/QueryExecutor.java
jdbc/org/postgresql/jdbc1/AbstractJdbc1Connection.java
jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java
jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java
jdbc/org/postgresql/jdbc2/AbstractJdbc2Statement.java
jdbc/org/postgresql/test/jdbc2/DatabaseMetaDataTest.java
Tom Lane [Fri, 23 Aug 2002 16:41:38 +0000 (16:41 +0000)]
Further cleanup around the edges of OPAQUE/pseudotype changes. Correct
the declarations of some index access method support functions. Support
SQL functions returning VOID.
Tatsuo Ishii [Fri, 23 Aug 2002 08:19:49 +0000 (08:19 +0000)]
Adapt for SRF(Set Returning Function).
Bruce Momjian [Fri, 23 Aug 2002 04:27:19 +0000 (04:27 +0000)]
Not sure how I fixed it the first time, but here's a fix for another
instance in which the docs mention that 'NAMEDATALEN == 32".
Neil Conway
Bruce Momjian [Fri, 23 Aug 2002 03:10:44 +0000 (03:10 +0000)]
Add space.k>
Bruce Momjian [Fri, 23 Aug 2002 03:10:15 +0000 (03:10 +0000)]
Add:
> * Allow xlog directory location to be specified during initdb, perhaps
> using symlinks
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.