OSDN Git Service
Bruce Momjian [Mon, 2 Sep 2002 06:13:31 +0000 (06:13 +0000)]
Attached is a fairly sizeable update to contrib/dblink. I'd love to get
review/feedback if anyone is interested and can spend the time. But I'd
also love to get this committed and address changes as incremental
patches ;-), so if there are no objections, please apply.
Below I'll give a synopsis of the changes. More detailed descriptions
are now in a new doc directory under contrib/dblink. There is also a new
dblink.test.sql file which will give a pretty good overview of the
functions and their use.
Joe Conway
Bruce Momjian [Mon, 2 Sep 2002 06:11:43 +0000 (06:11 +0000)]
I checked all the previous string handling errors and most of them were
already fixed by You. However there were a few left and attached patch
should fix the rest of them.
I used StringInfo only in 2 places and both of them are inside debug
ifdefs. Only performance penalty will come from using strlen() like all
the other code does.
I also modified some of the already patched parts by changing
snprintf(buf, 2 * BUFSIZE, ... style lines to
snprintf(buf, sizeof(buf), ... where buf is an array.
Jukka Holappa
Bruce Momjian [Mon, 2 Sep 2002 06:05:16 +0000 (06:05 +0000)]
I guess the intention was to test incomplete SELECT statements, not
missing semicolons.
I also added a SELECT statement without a target list.
Manfred Koizar
Bruce Momjian [Mon, 2 Sep 2002 05:55:43 +0000 (05:55 +0000)]
Okay, attached is a patch that moves the alter table regression test
into a separate parallel group. I can't confirm that this fixes the
problem for me (since it only occurs about one in ten or one in twenty
runs), but I think it's a good bet that it does...
Neil Conway
Bruce Momjian [Mon, 2 Sep 2002 05:53:23 +0000 (05:53 +0000)]
Here's a doc patch for the new string functions recently committed --
replace, split, and to_hex. The patch also moves encode and decode into
alphabetical order (since everything else in the table was).
Joe Conway
Bruce Momjian [Mon, 2 Sep 2002 05:52:34 +0000 (05:52 +0000)]
Move pg_settings doc into the right section.
Bruce Momjian [Mon, 2 Sep 2002 05:44:43 +0000 (05:44 +0000)]
Here is a documentation patch for the pg_settings virtual table. If
there are no objections, please apply.
Joe Conway
Bruce Momjian [Mon, 2 Sep 2002 05:44:05 +0000 (05:44 +0000)]
Attached is an update to contrib/tablefunc. It introduces a new
function, connectby(), which can serve as a reference implementation for
the changes made in the last few days -- namely the ability of a
function to return an entire tuplestore, and the ability of a function
to make use of the query provided "expected" tuple description.
Description:
connectby(text relname, text keyid_fld, text parent_keyid_fld,
text start_with, int max_depth [, text branch_delim])
- returns keyid, parent_keyid, level, and an optional branch string
- requires anonymous composite type syntax in the FROM clause. See
the instructions in the documentation below.
Joe Conway
Bruce Momjian [Mon, 2 Sep 2002 05:42:54 +0000 (05:42 +0000)]
Add GUC variable to print original query to the server logs when there
is an error, warning, etc.
Gavin Sherry
Bruce Momjian [Mon, 2 Sep 2002 05:25:37 +0000 (05:25 +0000)]
Remove documentation that says debug_query_string is only used by
pgmonitor.
Now log_min_error_statement uses it.
Bruce Momjian [Mon, 2 Sep 2002 05:20:56 +0000 (05:20 +0000)]
Fix ordering regression problem on freebsd/alpha by adding ORDER BY.
Bruce Momjian [Mon, 2 Sep 2002 04:43:17 +0000 (04:43 +0000)]
Removed because we don't use cs() anymore on AIX:
< * Evaluate AIX cs() spinlock macro for performance optimizations (Tatsuo)
Bruce Momjian [Mon, 2 Sep 2002 04:42:52 +0000 (04:42 +0000)]
I tried to build PostgreSQL with the following step to see backends hung
during the regression test. The problem has been reproduced on two machine
but both of these are the same type of hardware and software. I also tried
to recreate the problem on other machines, on older version of AIX but I
couldn't.
After looked through pgsql-hackers mailing list, I focused on spin lock
issue to solve the problem. The easiest and may not be the best solution
for the problem is to give up HAS_TEST_AND_SET. This actually works.
One another and better solution for the problem is to use _check_lock() and
_clear_lock() as spin lock. Important thing here is to define S_UNLOCK()
with _clear_lock(). This will solve the so called "Compiler bug" issue
someone wrote on the mailing list.
We have some other API such as cs(), compare_and_swap() and fetch_and_or()
to do test and set on AIX, but any of these didn't solve my problem. I
wrote tiny testing program to see if we have any bug of these API of AIX,
but I couldn't see any problem except for compare_and_swap(). It seems that
you can not use compare_and_swap() for the purpose, as it would not work as
spin lock on any SMP machines I tested. I don't know the reason why cs()
nor fetch_and_or()/fetch_and_and() will not work with PostgreSQL on p690.
These worked with my testing program on all machines I tested.
Tomoyuki Niijima
Barry Lind [Mon, 2 Sep 2002 03:07:36 +0000 (03:07 +0000)]
JDBC checkin fixing the following bugs:
Fixed support in the driver for notifications (added PGConnection.getNotifications()) - problem reported by Benjamin.Feinstein@guardent.com
Worked around server problems with int8/int2 and constants; quote values when they are intended to bind to an int8/int2 column - reported by many
Fixed bug in the Array interface with string parsing not handling escaped characters correctly - reported by devajx@yahoo.com
Added workaround to support 'infinity' and '-infinity' for dates - reported bydmitry@openratings.com
Fixed some performance issues with setBlob - reported by d.wall@computer.org
Added support for using new prepared statements functionality in 7.3 (added PGStatement.setUseServerPrepare() and isUseServerPrepare() methods)
Modified Files:
jdbc/org/postgresql/PGConnection.java
jdbc/org/postgresql/PGStatement.java
jdbc/org/postgresql/core/QueryExecutor.java
jdbc/org/postgresql/jdbc1/AbstractJdbc1Connection.java
jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSet.java
jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java
jdbc/org/postgresql/jdbc2/AbstractJdbc2Statement.java
jdbc/org/postgresql/jdbc2/Array.java
Added Files:
jdbc/org/postgresql/PGNotification.java
jdbc/org/postgresql/core/Notification.java
Bruce Momjian [Mon, 2 Sep 2002 02:47:07 +0000 (02:47 +0000)]
Remove sys/types.h in files that include postgres.h, and hence c.h,
because c.h has sys/types.h.
Tom Lane [Mon, 2 Sep 2002 02:13:02 +0000 (02:13 +0000)]
CREATE OR REPLACE VIEW, CREATE OR REPLACE RULE.
Gavin Sherry, Neil Conway, and Tom Lane all got their hands dirty
on this one ...
Tom Lane [Mon, 2 Sep 2002 01:05:06 +0000 (01:05 +0000)]
Code review for HeapTupleHeader changes. Add version number to page headers
(overlaying low byte of page size) and add HEAP_HASOID bit to t_infomask,
per earlier discussion. Simplify scheme for overlaying fields in tuple
header (no need for cmax to live in more than one place). Don't try to
clear infomask status bits in tqual.c --- not safe to do it there. Don't
try to force output table of a SELECT INTO to have OIDs, either. Get rid
of unnecessarily complex three-state scheme for TupleDesc.tdhasoids, which
has already caused one recent failure. Improve documentation.
Dave Cramer [Sun, 1 Sep 2002 23:56:13 +0000 (23:56 +0000)]
patch from Thomas O'Dowd to ensure that connections are closed
Dave Cramer [Sun, 1 Sep 2002 23:45:20 +0000 (23:45 +0000)]
testing for insertRow
Bruce Momjian [Sun, 1 Sep 2002 23:41:47 +0000 (23:41 +0000)]
Update MEMSET_LOOP_LIMIT to 1024 because it is the best value for most
platforms.
Dave Cramer [Sun, 1 Sep 2002 23:40:36 +0000 (23:40 +0000)]
patch to allow insertRow on an empty resultSet
Dave Cramer [Sun, 1 Sep 2002 23:38:53 +0000 (23:38 +0000)]
Changed to reflect the current reality, ie we do support updateable resultsets
Bruce Momjian [Sun, 1 Sep 2002 23:30:46 +0000 (23:30 +0000)]
Improve footer length computation for psql.
Greg Sabino Mullan
Bruce Momjian [Sun, 1 Sep 2002 23:26:06 +0000 (23:26 +0000)]
Add log_duration to GUC/postgresql.conf.
Rename debug_print_query to log_statement and rename show_query_stats to
show_statement_stats.
Bruce Momjian [Sun, 1 Sep 2002 22:36:11 +0000 (22:36 +0000)]
Add:
> o Add table function support to pltcl, plperl, plpython
Tom Lane [Sun, 1 Sep 2002 16:28:06 +0000 (16:28 +0000)]
plpgsql functions can return RECORD, per Neil Conway.
Tom Lane [Sun, 1 Sep 2002 02:37:02 +0000 (02:37 +0000)]
Minor copy-editing.
Tom Lane [Sun, 1 Sep 2002 02:27:32 +0000 (02:27 +0000)]
Code cleanups: make non-implicit WITHOUT FUNCTION casts work, avoid
redundant pg_cast searches, fix obsolete comments.
Bruce Momjian [Sun, 1 Sep 2002 01:59:48 +0000 (01:59 +0000)]
Remove mention of wal_files in a SHOW example.
Bruce Momjian [Sun, 1 Sep 2002 01:58:42 +0000 (01:58 +0000)]
Remove code that suggested increasing wal_files.
Bruce Momjian [Sun, 1 Sep 2002 01:32:21 +0000 (01:32 +0000)]
Done:
> o -SELECT col FROM tab WHERE numeric_col = 10.1 fails, requires quotes
Tom Lane [Sun, 1 Sep 2002 00:58:07 +0000 (00:58 +0000)]
Mark the float8 -> int8 cast as implicit. This resolves the problem
pointed out by Barry Lind: UPDATE bigintcol =
10000000000 fails because
the constant is initially taken as float8. We really need a better way,
but it's not gonna happen for 7.3.
Also, remove int4reltime() function, which is redundant with the
existing binary-compatibility coercion path from int4 to reltime,
and probably has been unreachable code for a long while.
Tom Lane [Sat, 31 Aug 2002 22:10:48 +0000 (22:10 +0000)]
Code review for domain-constraints patch. Use a new ConstraintTest node
type for runtime constraint checks, instead of misusing the parse-time
Constraint node for the purpose. Fix some damage introduced into type
coercion logic; in particular ensure that a coerced expression tree will
read out the correct result type when inspected (patch had broken some
RelabelType cases). Enforce domain NOT NULL constraints against columns
that are omitted from an INSERT.
Tom Lane [Sat, 31 Aug 2002 19:10:08 +0000 (19:10 +0000)]
Wups, didn't mean to commit that just yet.
Tom Lane [Sat, 31 Aug 2002 19:09:27 +0000 (19:09 +0000)]
The UNDEFOID later causes an assertion failure in heap_formtuple when
you try to use the tupdesc to build a tuple.
Joe Conway
Tom Lane [Sat, 31 Aug 2002 17:14:28 +0000 (17:14 +0000)]
Code review for pg_locks feature. Make shmemoffset of PROCLOCK structs
available (else there's no way to interpret the list links). Change
pg_locks view to show transaction ID locks separately from ordinary
relation locks. Avoid showing N duplicate rows when the same lock is
held multiple times (seems unlikely that users care about exact hold
count). Improve documentation.
Bruce Momjian [Sat, 31 Aug 2002 01:36:33 +0000 (01:36 +0000)]
*** empty log message ***
Tom Lane [Fri, 30 Aug 2002 23:59:46 +0000 (23:59 +0000)]
Add expected tuple descriptor to ReturnSetInfo information for table
functions, per suggestion from John Gray and Joe Conway. Also, fix
plpgsql RETURN NEXT to verify that returned values match the expected
tupdesc.
Tom Lane [Fri, 30 Aug 2002 22:45:25 +0000 (22:45 +0000)]
Updates to reflect availability of autocommit option.
Tom Lane [Fri, 30 Aug 2002 22:18:07 +0000 (22:18 +0000)]
AUTOCOMMIT mode is now an available backend GUC variable; setting it
to false provides more SQL-spec-compliant behavior than we had before.
I am not sure that setting it false is actually a good idea yet; there
is a lot of client-side code that will probably be broken by turning
autocommit off. But it's a start.
Loosely based on a patch by David Van Wie.
Tom Lane [Fri, 30 Aug 2002 19:56:49 +0000 (19:56 +0000)]
Fix for breakage of C-coded SRFs, from Joe Conway.
Tom Lane [Fri, 30 Aug 2002 19:23:20 +0000 (19:23 +0000)]
Add attisinherited column to pg_attribute; use it to guard against
column additions, deletions, and renames that would let a child table
get out of sync with its parent. Patch by Alvaro Herrera, with some
kibitzing by Tom Lane.
Bruce Momjian [Fri, 30 Aug 2002 18:15:23 +0000 (18:15 +0000)]
Back out unintented tab change.
Bruce Momjian [Fri, 30 Aug 2002 18:14:21 +0000 (18:14 +0000)]
Remove pgaccess from Makefile.
Bruce Momjian [Fri, 30 Aug 2002 17:16:42 +0000 (17:16 +0000)]
Run autoconf.
Bruce Momjian [Fri, 30 Aug 2002 17:14:30 +0000 (17:14 +0000)]
Update documentation for --with-perl.
Bruce Momjian [Fri, 30 Aug 2002 16:53:34 +0000 (16:53 +0000)]
Improve wording after wal_files removal.
Bruce Momjian [Fri, 30 Aug 2002 16:50:50 +0000 (16:50 +0000)]
Complete TODO item:
* Remove wal_files postgresql.conf option because WAL files are
now recycled
Bruce Momjian [Fri, 30 Aug 2002 16:48:44 +0000 (16:48 +0000)]
Remove pgaccess from CVS. It has its own home now.
Bruce Momjian [Fri, 30 Aug 2002 16:23:21 +0000 (16:23 +0000)]
Re-enable perl configure tests for psql help file generation.
Bruce Momjian [Fri, 30 Aug 2002 16:00:41 +0000 (16:00 +0000)]
Back out password packet length check.
Improve wording of pre-7.3 syntax mention.
Marc G. Fournier [Fri, 30 Aug 2002 13:06:22 +0000 (13:06 +0000)]
perl5 interface moved to gborg
Marc G. Fournier [Fri, 30 Aug 2002 13:03:11 +0000 (13:03 +0000)]
libpgeasy moved to gborg ...
Tom Lane [Fri, 30 Aug 2002 05:28:50 +0000 (05:28 +0000)]
Fix off-by-one allocation error in PasswordFromFile(), per Gordon Runkle.
Bruce Momjian [Fri, 30 Aug 2002 03:18:23 +0000 (03:18 +0000)]
Add comment on old sytax for SELECT FOR UPDATE/LIMIT and COPY.
Tom Lane [Fri, 30 Aug 2002 02:01:34 +0000 (02:01 +0000)]
Revert _LARGEFILE64_SOURCE addition; good try but doesn't work,
at least not on HPUX 10.20, and there's no reason to think it
is needed on later versions.
Tom Lane [Fri, 30 Aug 2002 01:44:00 +0000 (01:44 +0000)]
intagg subdirectory was missing.
Tom Lane [Fri, 30 Aug 2002 01:01:02 +0000 (01:01 +0000)]
Group-manipulating code neglected to fill in array element type,
which is now required.
Tom Lane [Fri, 30 Aug 2002 00:28:41 +0000 (00:28 +0000)]
PL/pgSQL functions can return sets. Neil Conway's patch, modified so
that the functionality is available to anyone via ReturnSetInfo, rather
than hard-wiring it to PL/pgSQL.
Hiroshi Inoue [Thu, 29 Aug 2002 23:39:05 +0000 (23:39 +0000)]
Fix a bug introduced in 7.2.
Bruce Momjian [Thu, 29 Aug 2002 23:06:32 +0000 (23:06 +0000)]
> > > > If you want to put in security restrictions that are actually useful,
> > > > where is the code to verify that PGPASSWORDFILE points at a
> > > > non-world-readable file? That needs to be there now, not later, or
> > > > we'll have people moaning about backward compatibility when we finally
> > > > do plug that hole.
Alvaro Herrera
Bruce Momjian [Thu, 29 Aug 2002 23:05:44 +0000 (23:05 +0000)]
Sir Mordred The Traitor <mordred@s-mail.com> writes:
> Upon invoking a polygon(integer, circle) function a
> src/backend/utils/adt/geo_ops.c:circle_poly() function will gets
> called, which suffers from a buffer overflow.
>
> 2) A src/backend/adt/utils/geo_ops.c:path_encode() fails to detect a
> buffer overrun condition. It is called in multiple places, the most
> interesting are path_out() and poly_out() functions.
> 5) A src/backend/utils/adt/geo_ops.c:path_add() also fails to detect
> a simple buffer overrun.
I've attached a patch which should fix these problems.
Neil Conway
Bruce Momjian [Thu, 29 Aug 2002 23:05:03 +0000 (23:05 +0000)]
Add cube changes file.
Bruce Momjian [Thu, 29 Aug 2002 23:03:58 +0000 (23:03 +0000)]
The changes I have made are described in CHANGES. This was based on
diffs to 7.3-devel and may not be applicable to 7.2. I have included a
change covered by a previous bugfix patch I submitted (the problem with
-.1 not being accepted by cube_in). It does not include a fix for the
potential buffer overrun issue I reported for cube_yyerror in
cubeparse.y.
Bruno Wolff III
Peter Eisentraut [Thu, 29 Aug 2002 22:19:03 +0000 (22:19 +0000)]
Make pg_resetxlog options parsing more standard and prepare messages for
translation.
Peter Eisentraut [Thu, 29 Aug 2002 22:13:01 +0000 (22:13 +0000)]
Create "po" subdirectory before writing there.
Peter Eisentraut [Thu, 29 Aug 2002 22:09:22 +0000 (22:09 +0000)]
Workaround for broken large file support on HP-UX
Bruce Momjian [Thu, 29 Aug 2002 21:50:36 +0000 (21:50 +0000)]
Prevent problem with extra-long password packets from allocating lots of
memory.
Neil Conway
Bruce Momjian [Thu, 29 Aug 2002 21:02:12 +0000 (21:02 +0000)]
This patch reserves the last superuser_reserved_connections slots for
connections by the superuser only.
This patch replaces the last patch I sent a couple of days ago.
It closes a connection that has not been authorised by a superuser if it would
leave less than the GUC variable ReservedBackends
(superuser_reserved_connections in postgres.conf) backend process slots free
in the SISeg. This differs to the first patch which only reserved the last
ReservedBackends slots in the procState array. This has made the free slot
test more expensive due to the use of a lock.
After thinking about a comment on the first patch I've also made it a fatal
error if the number of reserved slots is not less than the maximum number of
connections.
Nigel J. Andrews
Bruce Momjian [Thu, 29 Aug 2002 19:55:26 +0000 (19:55 +0000)]
please apply small patch for README.tsearch.
I've documented space usage and using CLUSTER command
Oleg Bartunov
Bruce Momjian [Thu, 29 Aug 2002 19:53:58 +0000 (19:53 +0000)]
The unit for statement_timeout is s/1000, not s/
1000000
Manfred Koizar
Bruce Momjian [Thu, 29 Aug 2002 19:35:47 +0000 (19:35 +0000)]
Back out patch, that was alpha, which I think still needs just -O.
Bruce Momjian [Thu, 29 Aug 2002 19:35:07 +0000 (19:35 +0000)]
Change FreeBSD to use -O2, important for MemSet.
Tom Lane [Thu, 29 Aug 2002 17:14:33 +0000 (17:14 +0000)]
Adjust nodeFunctionscan.c to reset transient memory context between calls
to the table function, thus preventing memory leakage accumulation across
calls. This means that SRFs need to be careful to distinguish permanent
and local storage; adjust code and documentation accordingly. Patch by
Joe Conway, very minor tweaks by Tom Lane.
Tom Lane [Thu, 29 Aug 2002 16:03:49 +0000 (16:03 +0000)]
Push down outer qualification clauses into UNION and INTERSECT subqueries.
Per pghackers discussion from back around 1-August.
Tom Lane [Thu, 29 Aug 2002 15:56:20 +0000 (15:56 +0000)]
Cause REINDEX to regard TOAST tables as regular relations, not system
tables that need special defenses. I believe this is okay even for
TOAST tables that belong to system tables.
D'Arcy J.M. Cain [Thu, 29 Aug 2002 12:18:20 +0000 (12:18 +0000)]
chkpass_rout returns text so change PG_RETURN_CSTRING to PG_RETURN_TEXT_P.
This is currently a cosmetic difference but I make the change now in case
the macros diverge one day.
Tatsuo Ishii [Thu, 29 Aug 2002 08:03:22 +0000 (08:03 +0000)]
Remove MULTIBYTE
Tatsuo Ishii [Thu, 29 Aug 2002 07:22:30 +0000 (07:22 +0000)]
Remove #ifdef MULTIBYTE per hackers list discussion.
Tom Lane [Thu, 29 Aug 2002 06:05:27 +0000 (06:05 +0000)]
Rephrase 'Cannot insert into a view' and related messages, per
pghackers discussion around 31-Jul-02.
Tom Lane [Thu, 29 Aug 2002 05:17:55 +0000 (05:17 +0000)]
A few more fixes for the <replaceable>able> fiasco.
Tatsuo Ishii [Thu, 29 Aug 2002 04:43:55 +0000 (04:43 +0000)]
update mbregress expected files
Tom Lane [Thu, 29 Aug 2002 04:38:04 +0000 (04:38 +0000)]
Produce a somewhat-useful error message, namely
ERROR: Cannot display a value of type RECORD
rather than a random integer when someone tries to SELECT a tuple
value. Per pghackers discussion around 26-May-02.
Tom Lane [Thu, 29 Aug 2002 04:12:03 +0000 (04:12 +0000)]
FOUND patch was a bit over-enthusiastic: SQL commands that are not
INSERT, UPDATE, or DELETE shouldn't change FOUND. IMHO anyway.
Also, try to make documentation a little clearer.
Tom Lane [Thu, 29 Aug 2002 03:22:01 +0000 (03:22 +0000)]
Remove support for version-0 FE/BE protocol, per pghackers discussion.
This breaks support for 6.2 or older client libraries.
Tom Lane [Thu, 29 Aug 2002 01:19:41 +0000 (01:19 +0000)]
Fix ruleutils to dump column definition lists for anonymous record types
defined in the FROM clause. From Joe Conway, with some tweaks.
Tom Lane [Thu, 29 Aug 2002 00:17:06 +0000 (00:17 +0000)]
Code review for standalone composite types, query-specified composite
types, SRFs. Not happy with memory management yet, but I'll commit these
other changes.
Tom Lane [Wed, 28 Aug 2002 22:05:46 +0000 (22:05 +0000)]
Improve description of tablefunc.
Peter Eisentraut [Wed, 28 Aug 2002 21:01:14 +0000 (21:01 +0000)]
Initial Spanish translation from Karim Mribti <karim@inlosa.com>
Peter Eisentraut [Wed, 28 Aug 2002 20:58:45 +0000 (20:58 +0000)]
Updates from Dennis Bjorklund
Peter Eisentraut [Wed, 28 Aug 2002 20:57:22 +0000 (20:57 +0000)]
Break up the long usage messages in pg_dump and pg_restore and
unify the wording, to make life easier for translators.
from Dennis Bjorklund
Bruce Momjian [Wed, 28 Aug 2002 20:55:23 +0000 (20:55 +0000)]
Remove TIOGA files from CVS current; they remain in repositiry.
Bruce Momjian [Wed, 28 Aug 2002 20:46:47 +0000 (20:46 +0000)]
This trivial patches fixes the error message returned by CREATE INDEX
when it finds an existing relation with the same name as the
to-be-created index.
Old error message:
nconway=# create table foo (a int);
CREATE TABLE
nconway=# create index foo on foo (a);
ERROR: index named "foo" already exists
I replaced 'index' with 'relation' in the error message.
Neil Conway
Bruce Momjian [Wed, 28 Aug 2002 20:46:24 +0000 (20:46 +0000)]
backend where a statically sized buffer is written to. Most of these
should be pretty safe in practice, but it's probably better to be safe
than sorry.
I was actually looking for cases where NAMEDATALEN is assumed to be
32, but only found one. That's fixed too, as well as a few bits of
code cleanup.
Neil Conway
Bruce Momjian [Wed, 28 Aug 2002 20:18:58 +0000 (20:18 +0000)]
This is a quick patch to fix a crash in pgquery_dictresult() introduced
recently. I just ran into it while running a set of python test scripts,
and I'm not sure who the normal maintainer is for interfaces/python.
John Nield
Bruce Momjian [Wed, 28 Aug 2002 20:18:29 +0000 (20:18 +0000)]
The following small patch provides a couple of minor updates (against
CVS HEAD):
Amended "strings" regression test. TOAST tests now insert two values
with storage set to "external", to exercise properly the TOAST slice
routines which fetch only a subset of the chunks.
Changed now-misleading comment on AlterTableCreateToastTable in
tablecmds.c, because both columns of the index on a toast table are now
used.
John Gray
Bruce Momjian [Wed, 28 Aug 2002 20:17:44 +0000 (20:17 +0000)]
Add mention of foreign key dependency and SERIAL in 7.2 data restores.
Note can probably be removed after a couple of releases.
Rod Taylor
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.