]> granicus.if.org Git - postgresql/log
postgresql
22 years agoAdd initdb code to set up initial contents of pg_depend, pinning all
Tom Lane [Tue, 16 Jul 2002 17:48:46 +0000 (17:48 +0000)]
Add initdb code to set up initial contents of pg_depend, pinning all
objects created during initdb (except for the system views, which I
think do not need to be pinned).

22 years ago> pgsql-bugs@postgresql.org wrote:
Bruce Momjian [Tue, 16 Jul 2002 17:05:46 +0000 (17:05 +0000)]
> pgsql-bugs@postgresql.org wrote:
>  > David Clark (dclarknospam@opsi.co.za) reports a bug with a severity
>  > Table 3-7 SQL Literal escaped octets shows the input escape
>  > representation for a single quote as '\\'' , but the third paragraph
>  > below table 3-8 SQL Output Escaped Octets says that the single quote
>  > must be input as '\''
>
> Nice catch. '\'' is correct as shown in the example in Table 3-7.
>
>  >
>  > Also in the same paragraph mentioned above it says input for the
>  > single quote must be '\'' (or '\\134') shouldn't this be (or '\\047')
>
> Also a bug. Should be '\\047', as you pointed out.
>

Here's a patch to fix the binary string doc errors.

Joe Conway

22 years agoAdd conversion procs for CREATE CONVERSION
Tatsuo Ishii [Tue, 16 Jul 2002 09:25:06 +0000 (09:25 +0000)]
Add conversion procs for CREATE CONVERSION

22 years agoFix typo
Tatsuo Ishii [Tue, 16 Jul 2002 06:58:44 +0000 (06:58 +0000)]
Fix typo

22 years agoAdd FindDefaultConversionProc
Tatsuo Ishii [Tue, 16 Jul 2002 06:58:14 +0000 (06:58 +0000)]
Add FindDefaultConversionProc

22 years agoAdd code to extract dependencies from an expression tree, and use it
Tom Lane [Tue, 16 Jul 2002 05:53:34 +0000 (05:53 +0000)]
Add code to extract dependencies from an expression tree, and use it
to build dependencies for rules, constraint expressions, and default
expressions.  Repair some problems in the original design of
recursiveDeletion() exposed by more complex dependency sets.  Fix
regression tests that were deleting things in illegal sequences.

22 years agoAdd DLLINIT mention in port/Makefile.
Bruce Momjian [Tue, 16 Jul 2002 05:49:38 +0000 (05:49 +0000)]
Add DLLINIT mention in port/Makefile.

22 years agoMove few remaining src/utils files to backend/port so everything is in
Bruce Momjian [Tue, 16 Jul 2002 05:46:36 +0000 (05:46 +0000)]
Move few remaining src/utils files to backend/port so everything is in
one place.  Everything may be moved to src/utils eventually.

Add DLLINIT variable to simplify makfiles.

22 years agoAdd mention of TOAST storage for character columns.
Bruce Momjian [Tue, 16 Jul 2002 04:45:59 +0000 (04:45 +0000)]
Add mention of TOAST storage for character columns.

22 years agoMark 'line' as 'not implemented' in SGML and psql \dT, per Thomas
Bruce Momjian [Tue, 16 Jul 2002 03:30:27 +0000 (03:30 +0000)]
Mark 'line' as 'not implemented' in SGML and psql \dT, per Thomas
Lockhart.  initdb not forced.

22 years agoThis fixes 2 inaccuracies in the recently added SQL99 feature list docs.
Bruce Momjian [Tue, 16 Jul 2002 00:51:37 +0000 (00:51 +0000)]
This fixes 2 inaccuracies in the recently added SQL99 feature list docs.
UNIQUE and DISTINCT predicates are both listed as implemented -- AFAIK,
neither is.

I also included another trivial patch which adds the default location
of the DSSSL stylesheets on my system (Debian unstable, docbook-dsssl
1.76) to the list of paths that configure looks for.

Neil Conway

22 years agoAdd comment for isbn,issn data type, from Pete St. Onge
Bruce Momjian [Tue, 16 Jul 2002 00:48:30 +0000 (00:48 +0000)]
Add comment for isbn,issn data type, from Pete St. Onge

22 years agoItem not needed:
Bruce Momjian [Mon, 15 Jul 2002 23:34:34 +0000 (23:34 +0000)]
Item not needed:

< * Use our own getopt() for FreeBSD/OpenBSD to allow --xxx flags (Bruce)

22 years agoRemove indenting of Makefile comments, per Peter.\
Bruce Momjian [Mon, 15 Jul 2002 23:32:28 +0000 (23:32 +0000)]
Remove indenting of Makefile comments, per Peter.\

22 years agoRemove utils/getopt.c file, not needed, it only allowed "--flag"
Bruce Momjian [Mon, 15 Jul 2002 22:48:54 +0000 (22:48 +0000)]
Remove utils/getopt.c file, not needed, it only allowed "--flag"
warnings, and we now look for getopt_long in libgetopt.a.

22 years agoAdd search for libgetopt.a in hopes of finding getopt_long().
Bruce Momjian [Mon, 15 Jul 2002 22:41:45 +0000 (22:41 +0000)]
Add search for libgetopt.a in hopes of finding getopt_long().

22 years agoRemove certain Makefile dependencies by using full pathnames in
Bruce Momjian [Mon, 15 Jul 2002 21:34:05 +0000 (21:34 +0000)]
Remove certain Makefile dependencies by using full pathnames in
configure.in.

22 years agoUse the dependency mechanism to manage column defaults. We need this
Tom Lane [Mon, 15 Jul 2002 16:33:32 +0000 (16:33 +0000)]
Use the dependency mechanism to manage column defaults.  We need this
so that dependencies in default expressions (on operators, functions,
etc) can be expressed properly.

22 years agoFix make_ctags for exhuberant tags.
Bruce Momjian [Mon, 15 Jul 2002 14:45:51 +0000 (14:45 +0000)]
Fix make_ctags for exhuberant tags.

22 years agoFix a bug about the handling of '.' in parse.c.
Hiroshi Inoue [Mon, 15 Jul 2002 02:56:39 +0000 (02:56 +0000)]
Fix a bug about the handling of '.' in parse.c.

22 years agoImprove relcache.c error reporting for the next guy who has to debug
Bruce Momjian [Mon, 15 Jul 2002 01:57:51 +0000 (01:57 +0000)]
Improve relcache.c error reporting for the next guy who has to debug
this thing.

22 years agoFix \? and \pset pager handling. \? wasn't honoring pager before.
Bruce Momjian [Mon, 15 Jul 2002 01:56:25 +0000 (01:56 +0000)]
Fix \? and \pset pager handling.  \? wasn't honoring pager before.

22 years agoAdd COMMENT ON CONSTRAINT facility (from Rod Taylor's pg_constraint patch).
Tom Lane [Sun, 14 Jul 2002 23:38:13 +0000 (23:38 +0000)]
Add COMMENT ON CONSTRAINT facility (from Rod Taylor's pg_constraint patch).
Fix comment.c to not depend on parser token values, per discussion awhile
back.

22 years agoRemove no-longer-appropriate notes about lack of CASCADE/RESTRICT behavior.
Tom Lane [Sun, 14 Jul 2002 22:47:56 +0000 (22:47 +0000)]
Remove no-longer-appropriate notes about lack of CASCADE/RESTRICT behavior.

22 years agoIn DeleteAttributeTuples, use a single indexscan instead of the multiple
Tom Lane [Sun, 14 Jul 2002 21:08:08 +0000 (21:08 +0000)]
In DeleteAttributeTuples, use a single indexscan instead of the multiple
scans that will most likely be caused by SearchSysCache probes.  Also,
share some code between index deletion and table deletion.

22 years agoFix testing of partial-index predicates to work correctly in cases where
Tom Lane [Sat, 13 Jul 2002 19:20:34 +0000 (19:20 +0000)]
Fix testing of partial-index predicates to work correctly in cases where
varno of index's relation is not 1.  This embarrassing oversight pointed
out by Dmitry Tkach 12-Jul-02.

22 years agoMark as done, per Rod:
Bruce Momjian [Sat, 13 Jul 2002 02:42:16 +0000 (02:42 +0000)]
Mark as done, per Rod:

> o -Add ALTER TABLE DROP non-CHECK CONSTRAINT
> * -Allow psql \d to show foreign keys
> * -Auto-destroy sequence on DROP of table with SERIAL; perhaps a separate
> * -Prevent column dropping if column is used by foreign key
> * -Automatically drop constraints/functions when object is dropped
> * -Make foreign key constraints clearer in dump file
> * -Make foreign keys easier to identify

22 years agoBoth done:
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,

22 years agoAdd SET statement_timeout capability. Timeout is in ms. A value of
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.

22 years agoRe-add -I documentation, per Tom.
Bruce Momjian [Sat, 13 Jul 2002 00:55:53 +0000 (00:55 +0000)]
Re-add -I documentation, per Tom.

22 years agoSecond phase of committing Rod Taylor's pg_depend/pg_constraint patch.
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.

22 years agoChanged getCrossReference to return information about each composite key seperately
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

22 years agoAn improvement of User Interface(Setup dialog) by Dave Page.
Hiroshi Inoue [Fri, 12 Jul 2002 02:02:26 +0000 (02:02 +0000)]
An improvement of User Interface(Setup dialog) by Dave Page.

22 years ago1) Fix a memory leak in use declare/fetch mode.
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).

22 years agoNot a valid item:
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

22 years agoRemove duplicate:
Bruce Momjian [Thu, 11 Jul 2002 21:40:20 +0000 (21:40 +0000)]
Remove duplicate:

< * Use BlockNumber rather than int where appropriate

22 years agoChange error messages ExecAppend->ExecInsert and ExecReplace->ExecUpdate
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.

22 years agoRemove references to pre-7.1; too old.
Bruce Momjian [Thu, 11 Jul 2002 16:38:08 +0000 (16:38 +0000)]
Remove references to pre-7.1;  too old.

22 years agoUpdate FAQ.
Bruce Momjian [Thu, 11 Jul 2002 16:35:56 +0000 (16:35 +0000)]
Update FAQ.

22 years agoAdd new CREATE CONVERSION/DROP CONVERSION command.
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.

22 years agoDone, according to Rod Taylor:
Bruce Momjian [Thu, 11 Jul 2002 02:56:49 +0000 (02:56 +0000)]
Done, according to Rod Taylor:

> * -Add ALTER TRIGGER ... RENAME

22 years agoFix getopt flags. Man thing thing was messed up.
Bruce Momjian [Thu, 11 Jul 2002 02:00:14 +0000 (02:00 +0000)]
Fix getopt flags.  Man thing thing was messed up.

22 years agoFix another --help typo in pg_restore.
Bruce Momjian [Thu, 11 Jul 2002 01:57:12 +0000 (01:57 +0000)]
Fix another --help typo in pg_restore.

22 years agoMake NAMEDATALEN changeable at compile time.
Hiroshi Inoue [Thu, 11 Jul 2002 01:52:46 +0000 (01:52 +0000)]
Make NAMEDATALEN changeable at compile time.

22 years agoFix pg_restore flags in documentation.
Bruce Momjian [Wed, 10 Jul 2002 02:57:31 +0000 (02:57 +0000)]
Fix pg_restore flags in documentation.

22 years agofix bug in getTime() with fractional seconds reported by Laurette Cisneros (laurette...
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)

22 years agoOops, proper initialization for domainTypMod was none at all, not 0.
Bruce Momjian [Tue, 9 Jul 2002 13:52:14 +0000 (13:52 +0000)]
Oops, proper initialization for domainTypMod was none at all, not 0.

22 years agoFix compiler warning:
Bruce Momjian [Tue, 9 Jul 2002 05:21:35 +0000 (05:21 +0000)]
Fix compiler warning:

int32           domainTypMod = NULL;

should be:

int32           domainTypMod = 0;

22 years agoFix typo mentioned by Rich Morin.
Bruce Momjian [Tue, 9 Jul 2002 04:47:07 +0000 (04:47 +0000)]
Fix typo mentioned by Rich Morin.

22 years agoDone:
Bruce Momjian [Mon, 8 Jul 2002 02:01:02 +0000 (02:01 +0000)]
Done:

> * -Make one version of simple_prompt() in code (Bruce, Tom)

22 years agoFix case syntax for freebsd template.
Bruce Momjian [Mon, 8 Jul 2002 01:54:30 +0000 (01:54 +0000)]
Fix case syntax for freebsd template.

22 years agoFix typo in xl_heaptid comment
Bruce Momjian [Mon, 8 Jul 2002 01:52:23 +0000 (01:52 +0000)]
Fix typo in xl_heaptid comment

Manfred Koizar

22 years agoMove CXX platform-specific stuff into template files.
Bruce Momjian [Sun, 7 Jul 2002 20:28:25 +0000 (20:28 +0000)]
Move CXX platform-specific stuff into template files.

22 years agoConvert expr to case, for Peter E.
Bruce Momjian [Sun, 7 Jul 2002 14:24:13 +0000 (14:24 +0000)]
Convert expr to case, for Peter E.

22 years agoI've fixed up the way domain constraints (not null and type length)
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

22 years agoAdd comments about sharing.
Bruce Momjian [Sat, 6 Jul 2002 20:14:58 +0000 (20:14 +0000)]
Add comments about sharing.

22 years agoMove simple_prompt() into its own file to be shared with psql and pg_dump.
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.

22 years agoDon't document that UNDO is certain to be added in the future.
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.

22 years agofixed bug reported by Michael, Dietrich (mdt@emdete.de) where a large object handle...
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.

22 years agoAdd a few new lines to display recently added fields in the ControlFile
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

22 years agoMark person:
Bruce Momjian [Fri, 5 Jul 2002 02:10:17 +0000 (02:10 +0000)]
Mark person:

> * -Allow psql \d to show temporary table structure (Tom)

22 years agoDone
Bruce Momjian [Fri, 5 Jul 2002 02:09:52 +0000 (02:09 +0000)]
Done

> * -Allow psql \d to show temporary table structure

22 years agoFix a bug reported by Zhou Han.
Hiroshi Inoue [Fri, 5 Jul 2002 01:31:41 +0000 (01:31 +0000)]
Fix a bug reported by Zhou Han.

22 years agoAdd explanation of the various *_min_messages elog() values.
Bruce Momjian [Fri, 5 Jul 2002 01:17:20 +0000 (01:17 +0000)]
Add explanation of the various *_min_messages elog() values.

22 years agoCleanup.
Bruce Momjian [Fri, 5 Jul 2002 00:29:34 +0000 (00:29 +0000)]
Cleanup.

22 years agoFix capitalization.
Bruce Momjian [Fri, 5 Jul 2002 00:14:16 +0000 (00:14 +0000)]
Fix capitalization.

22 years agoAdd NULL space mention.
Bruce Momjian [Thu, 4 Jul 2002 19:26:10 +0000 (19:26 +0000)]
Add NULL space mention.

22 years agoFix compile error in assert coded added by new DISTINCT ON patch.
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.

22 years agoMore clearly document in pg_dump when we are dealing with an object name
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.

22 years agoImplement the IS DISTINCT FROM operator per SQL99.
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().

22 years agoMove INTERSECT DISTINCT to the supported category. Error in docs.
Thomas G. Lockhart [Thu, 4 Jul 2002 15:10:43 +0000 (15:10 +0000)]
Move INTERSECT DISTINCT to the supported category. Error in docs.

22 years agoDocument function args are required for pg_restore -P.
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.

22 years agoUpdate FreeBSD template to properly compile c++ on alpha.
Bruce Momjian [Wed, 3 Jul 2002 19:48:26 +0000 (19:48 +0000)]
Update FreeBSD template to properly compile c++ on alpha.

22 years agoAdd missing pgaccess copyright file, same as ours.
Bruce Momjian [Wed, 3 Jul 2002 16:57:08 +0000 (16:57 +0000)]
Add missing pgaccess copyright file, same as ours.

22 years agoDone:
Bruce Momjian [Wed, 3 Jul 2002 16:55:40 +0000 (16:55 +0000)]
Done:

>         o -Add support for CallableStatements

22 years agoFix some more boundary-case errors in psql variable substitution:
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.

22 years agoDisable pg_upgrade for 7.3.
Bruce Momjian [Wed, 3 Jul 2002 14:38:19 +0000 (14:38 +0000)]
Disable pg_upgrade for 7.3.

22 years agoAllow make_ctags to work with exuberant tags.
Bruce Momjian [Tue, 2 Jul 2002 17:45:52 +0000 (17:45 +0000)]
Allow make_ctags to work with exuberant tags.

22 years agoIndent libpq++ as mentioned in email. Format was terrible, and this
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.

22 years ago>the extra level of struct naming for pd_opaque has no obvious
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

22 years agoUpdate to pgaccess 0.91.
Bruce Momjian [Tue, 2 Jul 2002 06:11:23 +0000 (06:11 +0000)]
Update to pgaccess 0.91.

22 years agoThe attached patch fixes 2 memory leaks in pg_dump, as well as corrects
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

22 years agoThe attached patch fixes a minor memory leak in psql.
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

22 years agoThere already was a macro PageGetItemId; this is now used in (almost)
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

22 years agoMinor code cleanup in bufmgr.c and bufmgr.h, mainly by moving repeated
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

22 years agoThis patch, which is built upon the "HeapTupleHeader accessor macros"
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

22 years agoBack out regress/results changes. Real CVS problem worked-around.
Bruce Momjian [Tue, 2 Jul 2002 05:43:34 +0000 (05:43 +0000)]
Back out regress/results changes.  Real CVS problem worked-around.

22 years agoFix removal of results directory on 'make clean'. Just remove *.out
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.

22 years agoFirst phase of applying Rod Taylor's pg_depend patch. This just adds
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.

22 years agoCommit old versions into main branch again.
Michael Meskes [Mon, 1 Jul 2002 06:56:10 +0000 (06:56 +0000)]
Commit old versions into main branch again.

Michael

22 years agoCommitting parser changes. Note, however, that the development bison seems ot have...
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

22 years agoNot done:
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

22 years agoDone:
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

22 years ago1) prevent setting of KSQO on 7.3+ servers(Thanks to Dave Page).
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.

22 years agofixed build.xml to echo correct jdbc version under ant1.6
Barry Lind [Thu, 27 Jun 2002 04:38:01 +0000 (04:38 +0000)]
fixed build.xml to echo correct jdbc version under ant1.6

22 years agogeneral cleanup of jdbc code
Barry Lind [Thu, 27 Jun 2002 03:37:30 +0000 (03:37 +0000)]
general cleanup of jdbc code

22 years agoRestore error message I accidentally changed.
Bruce Momjian [Wed, 26 Jun 2002 22:16:54 +0000 (22:16 +0000)]
Restore error message I accidentally changed.

22 years agoThe attached patch fixes some spelling mistakes, makes the
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

22 years agoTreat \r as white space when parsing pg_hba and related files.
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.

22 years agotranslation patch submitted by Zhenbang Wei forth@mail.net.tw
Barry Lind [Wed, 26 Jun 2002 03:21:27 +0000 (03:21 +0000)]
translation patch submitted by Zhenbang Wei forth@mail.net.tw