OSDN Git Service
Bruce Momjian [Wed, 4 Sep 2002 20:26:08 +0000 (20:26 +0000)]
Update:
Improvements to /contrib/intarray (Oleg, Teodor Sigaev, Andrey
Oktyabrski)
Bruce Momjian [Wed, 4 Sep 2002 20:06:23 +0000 (20:06 +0000)]
Add Joe's table functions description.
Bruce Momjian [Wed, 4 Sep 2002 19:11:06 +0000 (19:11 +0000)]
Update symbols for 7.3.
Bruce Momjian [Wed, 4 Sep 2002 19:07:43 +0000 (19:07 +0000)]
Update wording for Tom.
Bruce Momjian [Wed, 4 Sep 2002 19:00:01 +0000 (19:00 +0000)]
Update for 7.3 typedefs.
Bruce Momjian [Wed, 4 Sep 2002 18:45:52 +0000 (18:45 +0000)]
Update to reflect Tom's suggestions.
Peter Eisentraut [Wed, 4 Sep 2002 18:04:57 +0000 (18:04 +0000)]
Remove sh -x option that snuck in somehow.
Bruce Momjian [Wed, 4 Sep 2002 17:27:13 +0000 (17:27 +0000)]
Reorder items.
Bruce Momjian [Wed, 4 Sep 2002 17:25:08 +0000 (17:25 +0000)]
More HISTORY improvements from Joe.
Bruce Momjian [Wed, 4 Sep 2002 17:11:47 +0000 (17:11 +0000)]
Update HISTORY wording.
Tom Lane [Wed, 4 Sep 2002 15:45:50 +0000 (15:45 +0000)]
Avoid multiple scans of utils/mb/conversion_procs/ subdirectories during
'make install'; there are enough of 'em that this slowed down the make
noticeably. Ensure that 'all' is the default make target in all these
directories (defaulting to 'make install' is surprising and dangerous
IMHO). Fix a couple small typos.
Bruce Momjian [Wed, 4 Sep 2002 08:08:29 +0000 (08:08 +0000)]
Stamp configure.in with 7.3b1, not just 7.3. Seems Marc does that
usually anyway.
Bruce Momjian [Wed, 4 Sep 2002 07:42:24 +0000 (07:42 +0000)]
Update based on TODO file contents.
Bruce Momjian [Wed, 4 Sep 2002 07:31:59 +0000 (07:31 +0000)]
File list cleanup.
Bruce Momjian [Wed, 4 Sep 2002 07:30:33 +0000 (07:30 +0000)]
Spellcheck of HISTORY.
Bruce Momjian [Wed, 4 Sep 2002 07:26:37 +0000 (07:26 +0000)]
Update files to be changed.
Bruce Momjian [Wed, 4 Sep 2002 07:23:04 +0000 (07:23 +0000)]
Brand 7.3. Ready for beta!
Bruce Momjian [Wed, 4 Sep 2002 07:16:32 +0000 (07:16 +0000)]
Update new HISTORY file for 7.3!
Tatsuo Ishii [Wed, 4 Sep 2002 02:54:59 +0000 (02:54 +0000)]
Refrect changes made by Tom Lane
Tatsuo Ishii [Wed, 4 Sep 2002 02:42:34 +0000 (02:42 +0000)]
Refrect the changes to src/test/regress/sql/conversion.sql By Tom.
Bruce Momjian [Tue, 3 Sep 2002 23:39:04 +0000 (23:39 +0000)]
Add:
> * Gavin Sherry <swm@linuxworld.com.au>
Tom Lane [Tue, 3 Sep 2002 22:55:54 +0000 (22:55 +0000)]
EXTRACT(EPOCH FROM timestamp) gave wrong answers in the int64-timestamp
case for timestamptz input, and differently wrong answers in the float-
timestamp case for timestamp input.
Tom Lane [Tue, 3 Sep 2002 22:17:35 +0000 (22:17 +0000)]
Arrange for the default permissions on a database to allow temp table
creation to world, but disallow temp table creation in template1. Per
latest round of pghackers discussion.
I did not force initdb, but the permissions lockdown on template1 will
not take effect unless you do one (or manually REVOKE TEMP ON DATABASE template1 FROM public).
Tom Lane [Tue, 3 Sep 2002 22:06:19 +0000 (22:06 +0000)]
conversion test fails if there is an existing user named foo. Choose a name
somewhat less likely to provoke a conflict.
Peter Eisentraut [Tue, 3 Sep 2002 21:45:44 +0000 (21:45 +0000)]
Remove all traces of multibyte and locale options. Clean up comments
referring to "multibyte" where it really means character encoding.
Tom Lane [Tue, 3 Sep 2002 19:46:32 +0000 (19:46 +0000)]
Work around mktime() brain damage in recent versions of glibc by using
a series of localtime() calls to determine the local timezone offset
when mktime() fails. This eliminates regression failures on RHL 7.3,
and should continue to work until it occurs to the glibc boys to break
localtime() as well. By then I hope we'll have our own timezone code...
Tom Lane [Tue, 3 Sep 2002 19:41:28 +0000 (19:41 +0000)]
Eliminate unnecessary dependency on mktime(), and consequent 'Unable to
convert date to tm' failures, by using DetermineLocalTimeZone() instead.
Peter Eisentraut [Tue, 3 Sep 2002 18:50:54 +0000 (18:50 +0000)]
Workaround for format strings that are concatenated from macros
(INT64_FORMAT), which gettext cannot handle.
Bruce Momjian [Tue, 3 Sep 2002 17:17:24 +0000 (17:17 +0000)]
AIX shlib fix for building libpq.so from Tomoyuki Niijima
Bruce Momjian [Tue, 3 Sep 2002 17:09:49 +0000 (17:09 +0000)]
Add:
> * to_char(0,'FM999.99') returns a period, to_char(1,'FM999.99') does not
Bruce Momjian [Tue, 3 Sep 2002 16:21:23 +0000 (16:21 +0000)]
Fix SGML build failure.
Tom Lane [Tue, 3 Sep 2002 16:00:02 +0000 (16:00 +0000)]
I think reindex_index had better get AccessExclusiveLock on the parent
heap, not just ExclusiveLock.
Tom Lane [Tue, 3 Sep 2002 04:01:05 +0000 (04:01 +0000)]
Clean out cruft left by nonstandard test procedure.
Tom Lane [Tue, 3 Sep 2002 04:00:37 +0000 (04:00 +0000)]
last-minute CreateTemplateTupleDesc fixes.
Bruce Momjian [Tue, 3 Sep 2002 01:40:05 +0000 (01:40 +0000)]
Change ownership:
< o -ALTER TABLE ADD PRIMARY KEY (Christopher)
< o -ALTER TABLE ADD UNIQUE (Christopher)
> o -ALTER TABLE ADD PRIMARY KEY (Tom)
> o -ALTER TABLE ADD UNIQUE (Tom)
Tom Lane [Tue, 3 Sep 2002 01:11:37 +0000 (01:11 +0000)]
Documentation improvements.
Tom Lane [Tue, 3 Sep 2002 01:04:41 +0000 (01:04 +0000)]
Code review and documentation updates for indisclustered patch.
Tom Lane [Mon, 2 Sep 2002 23:41:17 +0000 (23:41 +0000)]
Partial solution for 'unexpected EOF' problem with pg_disconnect: it
seems we have a choice between annoying messages and leaking memory
(or dumping core, but that's right out). Patch also fixes several
other problems in pg_disconnect, such as being willing to close a
channel that isn't a PG channel.
Peter Eisentraut [Mon, 2 Sep 2002 22:22:12 +0000 (22:22 +0000)]
Translation updates
Peter Eisentraut [Mon, 2 Sep 2002 22:19:42 +0000 (22:19 +0000)]
Avoid shell syntax error if list of languages is empty.
Peter Eisentraut [Mon, 2 Sep 2002 22:18:56 +0000 (22:18 +0000)]
Fix typos.
Peter Eisentraut [Mon, 2 Sep 2002 22:18:26 +0000 (22:18 +0000)]
Convert control status codes to human-readable strings.
Tom Lane [Mon, 2 Sep 2002 21:51:47 +0000 (21:51 +0000)]
pg_on_connection_loss command for libpgtcl. Patch from
Gerhard Hintermayer, revised and documented by Tom Lane.
This patch also fixes a 'must fix' bug: libpgtcl's LISTEN/NOTIFY
support was broken by the recent changes to the PGnotify structure.
Guess that change wasn't quite so safe as we thought.
Tom Lane [Mon, 2 Sep 2002 20:21:32 +0000 (20:21 +0000)]
Fix obsolete description of PGnotify struct.
Tom Lane [Mon, 2 Sep 2002 20:04:40 +0000 (20:04 +0000)]
Department of second thoughts: make checks for replacing a view slightly
more flexible, and improve the error reporting. Also, add documentation
for REPLACE RULE/VIEW.
Bruce Momjian [Mon, 2 Sep 2002 19:02:02 +0000 (19:02 +0000)]
No more need for 'privileges' file.
Bruce Momjian [Mon, 2 Sep 2002 17:34:57 +0000 (17:34 +0000)]
Improve CVS log grouping.
Bruce Momjian [Mon, 2 Sep 2002 16:21:30 +0000 (16:21 +0000)]
Updated from Tom:
< o -ALTER TABLE ALTER COLUMN SET/DROP NOT NULL (Christopher Kings-Lynne)
< o ALTER TABLE ADD COLUMN column SERIAL doesn't create sequence
> o -ALTER TABLE ALTER COLUMN SET/DROP NOT NULL (Christopher)
200a200,201
> o ALTER TABLE ADD COLUMN column SERIAL doesn't create sequence because
> of the item above
232c233
< o -Disallow missing columns in INSERT ... VALUES, per ANSI
> o -Disallow missing columns in INSERT ... (col) VALUES, per ANSI
335,
336d335
< * Have SERIAL generate non-colliding sequence names when we have
< auto-destruction
Bruce Momjian [Mon, 2 Sep 2002 16:14:01 +0000 (16:14 +0000)]
Add check for Ant version >= 1.5.
Bruce Momjian [Mon, 2 Sep 2002 15:30:50 +0000 (15:30 +0000)]
Updates from Tom:
< * Allow logging of query durations
> * -Allow logging of query durations
51,52d50
< * Make single-user local access permissions the default by limiting
< permissions on the socket file (Peter E)
72,73c70,71
< * Reserve last few process slots for super-user if max_connections reached
< * Add GUC parameter to print queries that generate errors
> * -Reserve last few process slots for super-user if max_connections reached
> * -Add GUC parameter to print queries that generate errors
82,83c80,81
< * Declare typein/out functions in pg_proc with a special "C string" data type
< * Functions returning sets do not totally work
> * -Declare typein/out functions in pg_proc with a special "C string" data type
> * -Functions returning sets do not totally work
90c88
< * Allow bytea to handle LIKE with non-TEXT patterns
> * -Allow bytea to handle LIKE with non-TEXT patterns
94c92
< o Store binary-compatible type information in the system
> o -Store binary-compatible type information in the system
97d94
< o -SELECT col FROM tab WHERE numeric_col = 10.1 fails, requires quotes
102c99
< o Ensure we have array-eq operators for every built-in array type
> o -Ensure we have array-eq operators for every built-in array type
119d115
< * Allow setting database character set without multibyte enabled
152d147
< * Have UPDATE/DELETE clean out indexes
198,
199d192
< o ALTER TABLE ADD COLUMN to inherited table put column in wrong place
< [inheritance]
201d193
< o Add ALTER FUNCTION
203,
204c195,196
< o -ALTER TABLE ADD PRIMARY KEY (Tom)
< o -ALTER TABLE ADD UNIQUE (Tom)
> o -ALTER TABLE ADD PRIMARY KEY (Christopher)
> o -ALTER TABLE ADD UNIQUE (Christopher)
248c240
< o -Remove SET KSQO option now that OR processing is improved (Tom)
> o -Remove SET KSQO option now that OR processing is improved (Bruce)
280c272
< * Have pg_dump use LEFT OUTER JOIN in multi-table SELECTs
> * -Have pg_dump use LEFT OUTER JOIN in multi-table SELECTs
287d278
< * Add config file check for $ODBCINI, $HOME/.odbc.ini, installpath/etc/odbc.ini
318,
322d308
< * ODBC
< o ODBC 3.0 support
< o Unicode(UCS-2) support
< o Updatable cursors support
<
337c323
< * Fix foreign key constraints to not error on intermediate db states (Stephan)
> * -Fix foreign key constraints to not error on intermediate db states (Stephan)
352c338
< * Propagate column or table renaming to foreign key constraints
> * -Propagate column or table renaming to foreign key constraints
447c433
< * Remove wal_files postgresql.conf option because WAL files are now recycled
> * -Remove wal_files postgresql.conf option because WAL files are now recycled
460c446
< * Improve dynamic memory allocation by introducing tuple-context memory
> * -Improve dynamic memory allocation by introducing tuple-context memory
463c449
< * Nested FULL OUTER JOINs don't work (Tom)
> * -Nested FULL OUTER JOINs don't work (Tom)
Tom Lane [Mon, 2 Sep 2002 14:43:14 +0000 (14:43 +0000)]
Fix breakage introduced by evidently-completely-untested snprintf patch.
Tom Lane [Mon, 2 Sep 2002 13:45:30 +0000 (13:45 +0000)]
Fix broken markup.
Tatsuo Ishii [Mon, 2 Sep 2002 13:27:20 +0000 (13:27 +0000)]
Fix conversion regressin test failure.
Bruce Momjian [Mon, 2 Sep 2002 06:44:22 +0000 (06:44 +0000)]
Done:
> * -Add OR REPLACE clauses to non-FUNCTION object creation
> * -Allow autocommit so always in a transaction block
> * -Cache most recent query plan(s) (Neil) [prepare]
Bruce Momjian [Mon, 2 Sep 2002 06:32:41 +0000 (06:32 +0000)]
Add missing dblink files.
Bruce Momjian [Mon, 2 Sep 2002 06:28:06 +0000 (06:28 +0000)]
Fixes for intagg regression tests to match new array internal handling.
mlw
Bruce Momjian [Mon, 2 Sep 2002 06:27:04 +0000 (06:27 +0000)]
In case Florian and I don't finish his changes to this contrib before
beta, at least get this stuff in.
ftipatch.txt - Updates to docs and scripts. Run in the fulltextindexdir
WARNING - Add to fulltextindex dir
uninstall.sql - Add to fulltextindex dir
Bruce Momjian [Mon, 2 Sep 2002 06:24:15 +0000 (06:24 +0000)]
Update catversion so we are sure everyone gets the bytea LIKE fix.
Bruce Momjian [Mon, 2 Sep 2002 06:22:20 +0000 (06:22 +0000)]
> Okay. When you get back to the original issue, the gold is hidden in
> src/backend/optimizer/path/indxpath.c; see the "special indexable
> operators" stuff near the bottom of that file. (It's a bit of a crock
> that this code is hardwired there, and not somehow accessed through a
> system catalog, but it's what we've got at the moment.)
The attached patch re-enables a bytea right hand argument (as compared
to a text right hand argument), and enables index usage, for bytea LIKE
Joe Conway
Bruce Momjian [Mon, 2 Sep 2002 06:20:53 +0000 (06:20 +0000)]
This patch fixes a minor inaccuracy in the documentation: NOT NULL is
not synonymous with CHECK (xxx IS NOT NULL) -- for example, consider
ALTER TABLE ADD PRIMARY KEY, which checks for 'NOT NULL', not a check
constraint.
Neil Conway
Bruce Momjian [Mon, 2 Sep 2002 06:19:38 +0000 (06:19 +0000)]
Tab completion in psql is missing the REINDEX command.
Alvaro Herrera
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.