OSDN Git Service
Bruce Momjian [Sat, 13 Jul 2002 02:21:15 +0000 (02:21 +0000)]
Both done:
o -Add SET or BEGIN timeout parameter to cancel query
> * -Add pg_depend table for dependency recording; use sysrelid, oid,
Bruce Momjian [Sat, 13 Jul 2002 01:02:14 +0000 (01:02 +0000)]
Add SET statement_timeout capability. Timeout is in ms. A value of
zero turns off the timer.
Bruce Momjian [Sat, 13 Jul 2002 00:55:53 +0000 (00:55 +0000)]
Re-add -I documentation, per Tom.
Tom Lane [Fri, 12 Jul 2002 18:43:19 +0000 (18:43 +0000)]
Second phase of committing Rod Taylor's pg_depend/pg_constraint patch.
pg_relcheck is gone; CHECK, UNIQUE, PRIMARY KEY, and FOREIGN KEY
constraints all have real live entries in pg_constraint. pg_depend
exists, and RESTRICT/CASCADE options work on most kinds of DROP;
however, pg_depend is not yet very well populated with dependencies.
(Most of the ones that are present at this point just replace formerly
hardwired associations, such as the implicit drop of a relation's pg_type
entry when the relation is dropped.) Need to add more logic to create
dependency entries, improve pg_dump to dump constraints in place of
indexes and triggers, and add some regression tests.
Dave Cramer [Fri, 12 Jul 2002 13:07:48 +0000 (13:07 +0000)]
Changed getCrossReference to return information about each composite key seperately
It used to return them as a,b in one row, and now returns
a in one row, and b in one row
Hiroshi Inoue [Fri, 12 Jul 2002 02:02:26 +0000 (02:02 +0000)]
An improvement of User Interface(Setup dialog) by Dave Page.
Hiroshi Inoue [Fri, 12 Jul 2002 01:41:25 +0000 (01:41 +0000)]
1) Fix a memory leak in use declare/fetch mode.
2) Change default build mode to multibyte(Windows).
Bruce Momjian [Thu, 11 Jul 2002 21:41:25 +0000 (21:41 +0000)]
Not a valid item:
< * Add version file format stamp to heap and other table types
Bruce Momjian [Thu, 11 Jul 2002 21:40:20 +0000 (21:40 +0000)]
Remove duplicate:
< * Use BlockNumber rather than int where appropriate
Bruce Momjian [Thu, 11 Jul 2002 21:36:20 +0000 (21:36 +0000)]
Change error messages ExecAppend->ExecInsert and ExecReplace->ExecUpdate
as discussed on hackers.
Bruce Momjian [Thu, 11 Jul 2002 16:38:08 +0000 (16:38 +0000)]
Remove references to pre-7.1; too old.
Bruce Momjian [Thu, 11 Jul 2002 16:35:56 +0000 (16:35 +0000)]
Update FAQ.
Tatsuo Ishii [Thu, 11 Jul 2002 07:39:28 +0000 (07:39 +0000)]
Add new CREATE CONVERSION/DROP CONVERSION command.
This is the first cut toward CREATE CONVERSION/DROP CONVERSION implementaion.
The commands can now add/remove tuples to the new pg_conversion system
catalog, but that's all. Still need work to make them actually working.
Documentations, regression tests also need work.
Bruce Momjian [Thu, 11 Jul 2002 02:56:49 +0000 (02:56 +0000)]
Done, according to Rod Taylor:
> * -Add ALTER TRIGGER ... RENAME
Bruce Momjian [Thu, 11 Jul 2002 02:00:14 +0000 (02:00 +0000)]
Fix getopt flags. Man thing thing was messed up.
Bruce Momjian [Thu, 11 Jul 2002 01:57:12 +0000 (01:57 +0000)]
Fix another --help typo in pg_restore.
Hiroshi Inoue [Thu, 11 Jul 2002 01:52:46 +0000 (01:52 +0000)]
Make NAMEDATALEN changeable at compile time.
Bruce Momjian [Wed, 10 Jul 2002 02:57:31 +0000 (02:57 +0000)]
Fix pg_restore flags in documentation.
Barry Lind [Wed, 10 Jul 2002 00:51:36 +0000 (00:51 +0000)]
fix bug in getTime() with fractional seconds reported by Laurette Cisneros (laurette@nextbus.com)
Bruce Momjian [Tue, 9 Jul 2002 13:52:14 +0000 (13:52 +0000)]
Oops, proper initialization for domainTypMod was none at all, not 0.
Bruce Momjian [Tue, 9 Jul 2002 05:21:35 +0000 (05:21 +0000)]
Fix compiler warning:
int32 domainTypMod = NULL;
should be:
int32 domainTypMod = 0;
Bruce Momjian [Tue, 9 Jul 2002 04:47:07 +0000 (04:47 +0000)]
Fix typo mentioned by Rich Morin.
Bruce Momjian [Mon, 8 Jul 2002 02:01:02 +0000 (02:01 +0000)]
Done:
> * -Make one version of simple_prompt() in code (Bruce, Tom)
Bruce Momjian [Mon, 8 Jul 2002 01:54:30 +0000 (01:54 +0000)]
Fix case syntax for freebsd template.
Bruce Momjian [Mon, 8 Jul 2002 01:52:23 +0000 (01:52 +0000)]
Fix typo in xl_heaptid comment
Manfred Koizar
Bruce Momjian [Sun, 7 Jul 2002 20:28:25 +0000 (20:28 +0000)]
Move CXX platform-specific stuff into template files.
Bruce Momjian [Sun, 7 Jul 2002 14:24:13 +0000 (14:24 +0000)]
Convert expr to case, for Peter E.
Bruce Momjian [Sat, 6 Jul 2002 20:16:36 +0000 (20:16 +0000)]
I've fixed up the way domain constraints (not null and type length)
are managed as per request.
Moved from merging with table attributes to applying themselves during
coerce_type() and coerce_type_typmod.
Regression tests altered to test the cast() scenarios.
Rod Taylor
Bruce Momjian [Sat, 6 Jul 2002 20:14:58 +0000 (20:14 +0000)]
Add comments about sharing.
Bruce Momjian [Sat, 6 Jul 2002 20:12:30 +0000 (20:12 +0000)]
Move simple_prompt() into its own file to be shared with psql and pg_dump.
Bruce Momjian [Fri, 5 Jul 2002 19:06:11 +0000 (19:06 +0000)]
Don't document that UNDO is certain to be added in the future.
Barry Lind [Fri, 5 Jul 2002 18:50:27 +0000 (18:50 +0000)]
fixed bug reported by Michael, Dietrich (mdt@emdete.de) where a large object handle was being used after the end of the transaction and thus resulting in an error.
Thomas G. Lockhart [Fri, 5 Jul 2002 15:31:16 +0000 (15:31 +0000)]
Add a few new lines to display recently added fields in the ControlFile
structure.
Now includes the following new fields:
integer/float date/time storage
maximum length of names (+1; they must also include a null termination)
maximum number of function arguments
maximum length of locale name
Bruce Momjian [Fri, 5 Jul 2002 02:10:17 +0000 (02:10 +0000)]
Mark person:
> * -Allow psql \d to show temporary table structure (Tom)
Bruce Momjian [Fri, 5 Jul 2002 02:09:52 +0000 (02:09 +0000)]
Done
> * -Allow psql \d to show temporary table structure
Hiroshi Inoue [Fri, 5 Jul 2002 01:31:41 +0000 (01:31 +0000)]
Fix a bug reported by Zhou Han.
Bruce Momjian [Fri, 5 Jul 2002 01:17:20 +0000 (01:17 +0000)]
Add explanation of the various *_min_messages elog() values.
Bruce Momjian [Fri, 5 Jul 2002 00:29:34 +0000 (00:29 +0000)]
Cleanup.
Bruce Momjian [Fri, 5 Jul 2002 00:14:16 +0000 (00:14 +0000)]
Fix capitalization.
Bruce Momjian [Thu, 4 Jul 2002 19:26:10 +0000 (19:26 +0000)]
Add NULL space mention.
Bruce Momjian [Thu, 4 Jul 2002 16:44:08 +0000 (16:44 +0000)]
Fix compile error in assert coded added by new DISTINCT ON patch.
Bruce Momjian [Thu, 4 Jul 2002 15:35:07 +0000 (15:35 +0000)]
More clearly document in pg_dump when we are dealing with an object name
as it appears in the schema dump, and index tags.
Thomas G. Lockhart [Thu, 4 Jul 2002 15:24:11 +0000 (15:24 +0000)]
Implement the IS DISTINCT FROM operator per SQL99.
Reused the Expr node to hold DISTINCT which strongly resembles
the existing OP info. Define DISTINCT_EXPR which strongly resembles
the existing OPER_EXPR opType, but with handling for NULLs required
by SQL99.
We have explicit support for single-element DISTINCT comparisons
all the way through to the executor. But, multi-element DISTINCTs
are handled by expanding into a comparison tree in gram.y as is done for
other row comparisons. Per discussions, it might be desirable to move
this into one or more purpose-built nodes to be handled in the backend.
Define the optional ROW keyword and token per SQL99.
This allows single-element row constructs, which were formerly disallowed
due to shift/reduce conflicts with parenthesized a_expr clauses.
Define the SQL99 TREAT() function. Currently, use as a synonym for CAST().
Thomas G. Lockhart [Thu, 4 Jul 2002 15:10:43 +0000 (15:10 +0000)]
Move INTERSECT DISTINCT to the supported category. Error in docs.
Bruce Momjian [Thu, 4 Jul 2002 03:04:55 +0000 (03:04 +0000)]
Document function args are required for pg_restore -P.
Fix pg_dump to not quote the function name in the storage tag.
Fix pg_dump so GRANT/REVOKE(ACL) tag entries are not quoted, for
consistency.
Fix pg_restore to properly handle quotes and some spaces in -P.
Bruce Momjian [Wed, 3 Jul 2002 19:48:26 +0000 (19:48 +0000)]
Update FreeBSD template to properly compile c++ on alpha.
Bruce Momjian [Wed, 3 Jul 2002 16:57:08 +0000 (16:57 +0000)]
Add missing pgaccess copyright file, same as ours.
Bruce Momjian [Wed, 3 Jul 2002 16:55:40 +0000 (16:55 +0000)]
Done:
> o -Add support for CallableStatements
Tom Lane [Wed, 3 Jul 2002 16:47:46 +0000 (16:47 +0000)]
Fix some more boundary-case errors in psql variable substitution:
wasn't really right for case where :var is at the end of the line,
was definitely not right if var expanded to empty in that case,
and failed to recalculate thislen before jumping back to rescan.
Bruce Momjian [Wed, 3 Jul 2002 14:38:19 +0000 (14:38 +0000)]
Disable pg_upgrade for 7.3.
Bruce Momjian [Tue, 2 Jul 2002 17:45:52 +0000 (17:45 +0000)]
Allow make_ctags to work with exuberant tags.
Bruce Momjian [Tue, 2 Jul 2002 16:32:19 +0000 (16:32 +0000)]
Indent libpq++ as mentioned in email. Format was terrible, and this
will make fixing things easier.
Bruce Momjian [Tue, 2 Jul 2002 06:18:57 +0000 (06:18 +0000)]
>the extra level of struct naming for pd_opaque has no obvious
>usefulness.
>
>> [...] should I post a patch that puts pagesize directly into
>> PageHeaderData?
>
>If you're so inclined. Given that pd_opaque is hidden in those macros,
>there wouldn't be much of any gain in readability either, so I haven't
>worried about changing the declaration.
Thanks for the clarification. Here is the patch. Not much gain, but at
least it saves the next junior hacker from scratching his head ...
Manfred Koizar
Bruce Momjian [Tue, 2 Jul 2002 06:11:23 +0000 (06:11 +0000)]
Update to pgaccess 0.91.
Bruce Momjian [Tue, 2 Jul 2002 05:49:52 +0000 (05:49 +0000)]
The attached patch fixes 2 memory leaks in pg_dump, as well as corrects
a spelling mistake and deletes an antiquated comment.
Neil Conway
Bruce Momjian [Tue, 2 Jul 2002 05:49:18 +0000 (05:49 +0000)]
The attached patch fixes a minor memory leak in psql.
Neil Conway
Bruce Momjian [Tue, 2 Jul 2002 05:48:44 +0000 (05:48 +0000)]
There already was a macro PageGetItemId; this is now used in (almost)
all places, where pd_linp is accessed. Also introduce new macros
SizeOfPageHeaderData and BTMaxItemSize. This is just source code
cosmetic, no behaviour changed.
Manfred Koizar
Bruce Momjian [Tue, 2 Jul 2002 05:47:37 +0000 (05:47 +0000)]
Minor code cleanup in bufmgr.c and bufmgr.h, mainly by moving repeated
lines of code into internal routines (drop_relfilenode_buffers,
release_buffer) and by hiding unused routines (PrintBufferDescs,
PrintPinnedBufs) behind #ifdef NOT_USED. Remove AbortBufferIO()
declaration from bufmgr.c (already declared in bufmgr.h)
Manfred Koizar
Bruce Momjian [Tue, 2 Jul 2002 05:46:14 +0000 (05:46 +0000)]
This patch, which is built upon the "HeapTupleHeader accessor macros"
patch from 2002-06-10, is supposed to reduce the heap tuple header size
by four bytes on most architectures. Of course it changes the on-disk
tuple format and therefore requires initdb.
This overlays cmin/cmax/xmax fields into only two fields.
Manfred Koizar
Bruce Momjian [Tue, 2 Jul 2002 05:43:34 +0000 (05:43 +0000)]
Back out regress/results changes. Real CVS problem worked-around.
Bruce Momjian [Tue, 2 Jul 2002 04:53:52 +0000 (04:53 +0000)]
Fix removal of results directory on 'make clean'. Just remove *.out
files. Was causing CVS problems.
Tom Lane [Mon, 1 Jul 2002 15:27:56 +0000 (15:27 +0000)]
First phase of applying Rod Taylor's pg_depend patch. This just adds
RESTRICT/CASCADE syntax to the DROP commands that need it, and propagates
the behavioral option through the parser to the routines that execute
drops. Doesn't do anything useful yet, but I figured I'd commit these
changes so I could get out of the parser area while working on the rest.
Michael Meskes [Mon, 1 Jul 2002 06:56:10 +0000 (06:56 +0000)]
Commit old versions into main branch again.
Michael
Michael Meskes [Sun, 30 Jun 2002 09:34:14 +0000 (09:34 +0000)]
Committing parser changes. Note, however, that the development bison seems ot have a problem on my home machine. So these go in untested for the time being. But at least I have them in the archive.
Michael
Bruce Momjian [Fri, 28 Jun 2002 19:28:30 +0000 (19:28 +0000)]
Not done:
> * Add the functionality for WITH CHECK OPTION clause of CREATE VIEW
Bruce Momjian [Fri, 28 Jun 2002 18:57:35 +0000 (18:57 +0000)]
Done:
> * -Add the functionality for WITH CHECK OPTION clause of CREATE VIEW
Hiroshi Inoue [Fri, 28 Jun 2002 02:44:15 +0000 (02:44 +0000)]
1) prevent setting of KSQO on 7.3+ servers(Thanks to Dave Page).
2) Allow LF->CR/LF conversion under UNICODE driver.
Barry Lind [Thu, 27 Jun 2002 04:38:01 +0000 (04:38 +0000)]
fixed build.xml to echo correct jdbc version under ant1.6
Barry Lind [Thu, 27 Jun 2002 03:37:30 +0000 (03:37 +0000)]
general cleanup of jdbc code
Bruce Momjian [Wed, 26 Jun 2002 22:16:54 +0000 (22:16 +0000)]
Restore error message I accidentally changed.
Bruce Momjian [Wed, 26 Jun 2002 21:58:56 +0000 (21:58 +0000)]
The attached patch fixes some spelling mistakes, makes the
comments on one of the optimizer functions a lot more
clear, adds a summary of the recent KSQO discussion to the
comments in the code, adds regression tests for the bug with
sequence state Tom fixed recently and another reg. test, and
removes some PostQuel legacy stuff: ExecAppend -> ExecInsert,
ExecRetrieve -> ExecSelect, etc.
Error messages remain unchanged until a vote.
Neil Conway
Tom Lane [Wed, 26 Jun 2002 14:52:08 +0000 (14:52 +0000)]
Treat \r as white space when parsing pg_hba and related files.
Should make life easier for DBAs who insist on editing files with
Windoze tools.
Barry Lind [Wed, 26 Jun 2002 03:21:27 +0000 (03:21 +0000)]
translation patch submitted by Zhenbang Wei forth@mail.net.tw
Barry Lind [Wed, 26 Jun 2002 03:16:57 +0000 (03:16 +0000)]
patch submitted by Jason Davies jason@netspade.com to provide proper java class name for a byte[]
Bruce Momjian [Tue, 25 Jun 2002 17:58:10 +0000 (17:58 +0000)]
Back out cleanup patch. Got old version and needs work.
Neil Conway
Bruce Momjian [Tue, 25 Jun 2002 17:27:20 +0000 (17:27 +0000)]
The attached patch fixes some spelling mistakes, makes the
comments on one of the optimizer functions a lot more
clear, adds a summary of the recent KSQO discussion to the
comments in the code, adds regression tests for the bug with
sequence state Tom fixed recently and another reg. test, and
removes some PostQuel legacy stuff: ExecAppend -> ExecInsert,
ExecRetrieve -> ExecSelect, etc. This was changed because the
elog() messages from this routine are user-visible, so we
should be using the SQL terms.
Neil Conway
Bruce Momjian [Tue, 25 Jun 2002 17:26:11 +0000 (17:26 +0000)]
Here is a patch for a memory leak in rtree.c, version 7.2.1 (in code
that I submitted last year, alas).
Kenneth Been
Dave Cramer [Tue, 25 Jun 2002 16:30:49 +0000 (16:30 +0000)]
fixed retrieval of foreign/primary keys in imported/exported keys
Bruce Momjian [Tue, 25 Jun 2002 03:35:13 +0000 (03:35 +0000)]
Update FAQ.
Bruce Momjian [Tue, 25 Jun 2002 03:32:31 +0000 (03:32 +0000)]
Add more info on regex's using INDEX.
Hiroshi Inoue [Tue, 25 Jun 2002 01:54:19 +0000 (01:54 +0000)]
1) Add support for GB18030.
2) Fix a bug about the handling of large objects.
Bruce Momjian [Tue, 25 Jun 2002 01:45:58 +0000 (01:45 +0000)]
Update FAQ.
Tom Lane [Mon, 24 Jun 2002 23:12:06 +0000 (23:12 +0000)]
plpgsql's PERFORM statement now sets FOUND depending on whether any
rows were returned by the performed query. Per recent pgsql-general
discussion.
Tom Lane [Mon, 24 Jun 2002 22:17:01 +0000 (22:17 +0000)]
Document quote_ident and quote_literal in the main list of string functions,
as suggested by Josh Berkus.
Barry Lind [Mon, 24 Jun 2002 06:16:27 +0000 (06:16 +0000)]
patch to add support for callable statements to the jdbc driver. The patch was submitted by Paul Bethe pmbethe@yahoo.com
Barry Lind [Mon, 24 Jun 2002 05:14:26 +0000 (05:14 +0000)]
patch to update zh_TW message file for jdbc submitted by Zhenband Wei (forth@mail.net.tw)
Barry Lind [Mon, 24 Jun 2002 05:09:29 +0000 (05:09 +0000)]
patch submitted by Jason Davies jason@netspade.com to improve ResultSetMetaData.getColumnClassName() support
Barry Lind [Mon, 24 Jun 2002 04:53:05 +0000 (04:53 +0000)]
fixed bug reported by Wolfgang Winter w.winter@logitags.com where historic timestamps which do not have timezone info were being interpreted in local timezone instead of GMT. Also added a check to support timestamp vs. timestamptz in this code
Bruce Momjian [Sun, 23 Jun 2002 22:15:04 +0000 (22:15 +0000)]
Link dbmirror into /contrib system.
Bruce Momjian [Sun, 23 Jun 2002 21:58:08 +0000 (21:58 +0000)]
Add dbmirror to /contrib. Minor C cleanups and Makefile.
Steven Singer
Bruce Momjian [Sun, 23 Jun 2002 21:29:32 +0000 (21:29 +0000)]
It seems that ExecInit/EndIndexScan is leaking some memory...
For example, if I run a query, that uses an index scan, and call
MemoryContextSt ats (CurrentMemoryContext) before ExecutorStart() and
after ExecutorEnd() in ProcessQuery(), I am consistently see ing that
the 'after' call shows 256 bytes more used, then 'before'...
The problem seems to be in ExecEndIndexScan - it does not release
scanstate, ind exstate, indexstate->iss_RelationDescs and indexstate ->
iss_ScanDescs...
Dmitry Tkach
Bruce Momjian [Sun, 23 Jun 2002 21:20:38 +0000 (21:20 +0000)]
Add indexing for isbn and issn.
Dan Weston
Bruce Momjian [Sun, 23 Jun 2002 21:16:29 +0000 (21:16 +0000)]
Add MIN/MAX LIMIT/OFFSET mention.
Bruce Momjian [Sun, 23 Jun 2002 20:30:48 +0000 (20:30 +0000)]
Remove unused INET6 variable.
Bruce Momjian [Sun, 23 Jun 2002 20:09:23 +0000 (20:09 +0000)]
Update dbsize documentation with:
Copy this directory to contrib/dbsize in your PostgreSQL source tree.
Then just run make; make install. Finally, load the functions into any
database using dbsize.sql.
When computing the size of a table, it does not include TOAST or index
disk space.
Bruce Momjian [Sun, 23 Jun 2002 14:56:16 +0000 (14:56 +0000)]
Remove INET6 from SSL. We don't support INET6 yet.
Bruce Momjian [Sun, 23 Jun 2002 03:51:55 +0000 (03:51 +0000)]
Rename command to reindexdb, for consistency.
Bruce Momjian [Sun, 23 Jun 2002 03:45:15 +0000 (03:45 +0000)]
Mention REINDEX can be used for disk space reclaimation too.
Bruce Momjian [Sun, 23 Jun 2002 03:37:12 +0000 (03:37 +0000)]
Handle mixed-case names in reindex script.
Document need for reindex in SGML docs.
Bruce Momjian [Sat, 22 Jun 2002 04:08:07 +0000 (04:08 +0000)]
uint -> uint32, portability.