OSDN Git Service

pg-rex/syncrep.git
22 years agoUpdate TODO list.
Bruce Momjian [Fri, 16 Nov 2001 17:43:25 +0000 (17:43 +0000)]
Update TODO list.

22 years agoOnce again, Michael has overwritten someone else's patch ...
Tom Lane [Fri, 16 Nov 2001 17:01:48 +0000 (17:01 +0000)]
Once again, Michael has overwritten someone else's patch ...

22 years agoMake the yacc rules safe for parallel make. See discussion on pgsql-patches
Peter Eisentraut [Fri, 16 Nov 2001 16:32:33 +0000 (16:32 +0000)]
Make the yacc rules safe for parallel make.  See discussion on pgsql-patches
and comment in src/backend/parser/Makefile for the technical details.

22 years agoRemove 'triggered data change violation' error check, per recent
Tom Lane [Fri, 16 Nov 2001 16:31:16 +0000 (16:31 +0000)]
Remove 'triggered data change violation' error check, per recent
discussions in pghackers.

22 years agoUse -f for rm.
Peter Eisentraut [Fri, 16 Nov 2001 16:29:56 +0000 (16:29 +0000)]
Use -f for rm.

22 years agoCommitted again to add the missing files/patches.
Michael Meskes [Fri, 16 Nov 2001 08:36:37 +0000 (08:36 +0000)]
Committed again to add the missing files/patches.

22 years agoChange SQLDescribeCol so that it returns alias name properly.
Hiroshi Inoue [Fri, 16 Nov 2001 05:55:10 +0000 (05:55 +0000)]
Change SQLDescribeCol so that it returns alias name properly.

22 years agoUpdate keyword lists per suggestions by Peter. There are now four
Tom Lane [Fri, 16 Nov 2001 04:08:33 +0000 (04:08 +0000)]
Update keyword lists per suggestions by Peter.  There are now four
mutually exclusive keyword lists spanning all known keywords ---
including AS.  Moved COALESCE and a few other ColLabels into the
can-be-ColId list.

22 years agoFix silly error in plpgsql example.
Tom Lane [Fri, 16 Nov 2001 00:40:11 +0000 (00:40 +0000)]
Fix silly error in plpgsql example.

22 years agoAdd documentation for new plpgsql cursor operations. Also, another
Tom Lane [Thu, 15 Nov 2001 23:32:39 +0000 (23:32 +0000)]
Add documentation for new plpgsql cursor operations.  Also, another
round of editorial effort.

22 years agoFix some problems in new plpgsql cursor operations, found while trying
Tom Lane [Thu, 15 Nov 2001 23:31:09 +0000 (23:31 +0000)]
Fix some problems in new plpgsql cursor operations, found while trying
to reverse-engineer documentation for them.

22 years agoRead getopt() into an int, not char.
Bruce Momjian [Thu, 15 Nov 2001 18:40:52 +0000 (18:40 +0000)]
Read getopt() into an int, not char.

22 years agoAutoconf.
Tom Lane [Thu, 15 Nov 2001 17:31:44 +0000 (17:31 +0000)]
Autoconf.

22 years agoWell the absolute correct solution would involve all of:
Bruce Momjian [Thu, 15 Nov 2001 16:35:19 +0000 (16:35 +0000)]
Well the absolute correct solution would involve all of:
int8, int16, int32, int64 and separately uint8, uint16, uint32, uint64

The previous patch grouped:
int8, int16 and int32
uint8, uint16 and uint32
int64 and uint64  <-- this grouping is wrong on AIX 4.3.3 and below

If you prefer to make 4 groups out of this you could apply this patch.

Andreas

22 years agoUpdate md5.h because it can't get the value from configure.
Bruce Momjian [Thu, 15 Nov 2001 16:16:08 +0000 (16:16 +0000)]
Update md5.h because it can't get the value from configure.

22 years agoFix for AIX compile and unsigned/signed typedefs.
Bruce Momjian [Thu, 15 Nov 2001 16:09:34 +0000 (16:09 +0000)]
Fix for AIX compile and unsigned/signed typedefs.

Peter E, Tatsuo, Andreas

22 years agoOnly use RTLD_GLOBAL when available, which it isn't in older releases of the OS.
Peter Eisentraut [Thu, 15 Nov 2001 16:08:15 +0000 (16:08 +0000)]
Only use RTLD_GLOBAL when available, which it isn't in older releases of the OS.

22 years agoSignificant editorial overhaul of plpgsql documentation.
Tom Lane [Thu, 15 Nov 2001 06:25:22 +0000 (06:25 +0000)]
Significant editorial overhaul of plpgsql documentation.

22 years agoAdd changes for multibyte support in 7.2.
Tatsuo Ishii [Thu, 15 Nov 2001 06:15:34 +0000 (06:15 +0000)]
Add changes for multibyte support in 7.2.

22 years agoFix comment at top of file to match file name.
Bruce Momjian [Thu, 15 Nov 2001 03:12:53 +0000 (03:12 +0000)]
Fix comment at top of file to match file name.

22 years agoUpdate TODO list.
Bruce Momjian [Thu, 15 Nov 2001 03:11:32 +0000 (03:11 +0000)]
Update TODO list.

22 years agoOverhaul SPI documentation: bring it into some semblance of agreement
Tom Lane [Wed, 14 Nov 2001 22:26:02 +0000 (22:26 +0000)]
Overhaul SPI documentation: bring it into some semblance of agreement
with reality, and add doco for Jan's recent round of enhancements.

22 years agoTry to be a little less terse about dealing with variable-length structs
Tom Lane [Wed, 14 Nov 2001 22:14:22 +0000 (22:14 +0000)]
Try to be a little less terse about dealing with variable-length structs
in C, but recommend that newbies who don't recognize this trick should do
some studying ...

22 years agoGnu -> GNU in docs.
Bruce Momjian [Wed, 14 Nov 2001 20:40:33 +0000 (20:40 +0000)]
Gnu -> GNU in docs.

22 years agofixes getIndex to work with forte's transparent persistence
Dave Cramer [Wed, 14 Nov 2001 20:04:00 +0000 (20:04 +0000)]
fixes getIndex to work with forte's transparent persistence

22 years agoUpdate TODO list.
Bruce Momjian [Wed, 14 Nov 2001 16:31:38 +0000 (16:31 +0000)]
Update TODO list.

22 years agoAdded Christof's patches.
Michael Meskes [Wed, 14 Nov 2001 11:11:49 +0000 (11:11 +0000)]
Added Christof's patches.

22 years agoAttached is a patch against the CVS repository that fixes the ResultSet absolute...
Barry Lind [Wed, 14 Nov 2001 04:11:37 +0000 (04:11 +0000)]
Attached is a patch against the CVS repository that fixes the ResultSet absolute() problem.
There's also a little fix for the getRow() method. While fixing
absolute(), I noticed that getRow() wasn't quite following the spec: it
wasn't returning 0 when the ResultSet wasn't positioned on a row.  I've
started a ResultSet test case and included it as well.

Liam Stewart

22 years agoUpdate CVS tags.
Bruce Momjian [Tue, 13 Nov 2001 22:08:04 +0000 (22:08 +0000)]
Update CVS tags.

22 years agoUse better CVS tag.
Bruce Momjian [Tue, 13 Nov 2001 22:07:42 +0000 (22:07 +0000)]
Use better CVS tag.

22 years agoRemove md5.c check, add CVS log stamp. Update comments.
Bruce Momjian [Tue, 13 Nov 2001 22:06:58 +0000 (22:06 +0000)]
Remove md5.c check, add CVS log stamp.  Update comments.

22 years agoGive a more intelligible and useful error message for SELECT with no
Tom Lane [Tue, 13 Nov 2001 02:05:27 +0000 (02:05 +0000)]
Give a more intelligible and useful error message for SELECT with no
destination in plpgsql.

22 years agoUpdate TODO list.
Bruce Momjian [Tue, 13 Nov 2001 01:14:57 +0000 (01:14 +0000)]
Update TODO list.

22 years agoTweak parser so that there is a defined representation for datatypes
Tom Lane [Mon, 12 Nov 2001 21:04:46 +0000 (21:04 +0000)]
Tweak parser so that there is a defined representation for datatypes
bpchar, bit, numeric with typmod -1.  Alter format_type so that this
representation is printed when the typmod is -1.  This ensures that
tables having such columns can be pg_dump'd and reloaded correctly.
Also, remove the rather useless and non-SQL-compliant default
precision and scale for type NUMERIC.  A numeric column declared as
such (with no precision/scale) will now have typmod -1 which means
that numeric values of any precision/scale can be stored in it,
without conversion to a uniform scale.  This seems significantly
more useful than the former behavior.  Part of response to bug #513.

22 years agoUpdate TODO list.
Bruce Momjian [Mon, 12 Nov 2001 20:26:39 +0000 (20:26 +0000)]
Update TODO list.

22 years agoIf the alternatives for a CASE construct all have the same typmod,
Tom Lane [Mon, 12 Nov 2001 20:05:24 +0000 (20:05 +0000)]
If the alternatives for a CASE construct all have the same typmod,
use that typmod not -1 as the typmod of the CASE result.
Part of response to bug#513.

22 years agoIf the inputs of a UNION/INTERSECT/EXCEPT construct all agree on the
Tom Lane [Mon, 12 Nov 2001 20:04:20 +0000 (20:04 +0000)]
If the inputs of a UNION/INTERSECT/EXCEPT construct all agree on the
typmod of a particular column, mark the output with that same typmod,
not -1 as formerly.  -1 is still used if there is any disagreement.
Part of response to bug#513.

22 years agofixed bug in ResultSet. Version 1.29 backed out two previous fixes (1.26 and 1.25...
Barry Lind [Mon, 12 Nov 2001 19:59:46 +0000 (19:59 +0000)]
fixed bug in ResultSet.  Version 1.29 backed out two previous fixes (1.26 and 1.25).  This checkin add back those two previous fixes.  Problem reported by Daniel Germain

22 years agoAdd some more index entries.
Peter Eisentraut [Mon, 12 Nov 2001 19:19:39 +0000 (19:19 +0000)]
Add some more index entries.

22 years agoCommit to support MD5 passwords as per the backend for 7.2. This patch was submitted...
Barry Lind [Mon, 12 Nov 2001 19:11:56 +0000 (19:11 +0000)]
Commit to support MD5 passwords as per the backend for 7.2.  This patch was submitted by Jeremy Wohl jeremyw-pgjdbc@igmus.org

22 years agoAdd port number to pg_dumplo.
Bruce Momjian [Mon, 12 Nov 2001 17:44:14 +0000 (17:44 +0000)]
Add port number to pg_dumplo.

andrea gelmini

22 years agoRepair crash in EvalPlanQual of query involving nestloop with inner
Tom Lane [Mon, 12 Nov 2001 17:18:06 +0000 (17:18 +0000)]
Repair crash in EvalPlanQual of query involving nestloop with inner
index scan.  Problem was that link to outer tuple wasn't being stored
everyplace it needed to be.

22 years agoRemove duplicate extern declaration.
Tom Lane [Mon, 12 Nov 2001 16:34:58 +0000 (16:34 +0000)]
Remove duplicate extern declaration.

22 years agopsql's \do was going out of its way to lie about the result type of
Tom Lane [Mon, 12 Nov 2001 15:57:08 +0000 (15:57 +0000)]
psql's \do was going out of its way to lie about the result type of
operators.  Should report the declared oprresult type, not the return type
of the underlying proc, which might be only binary-compatible (cf.
textcat entries).

22 years agoUpdate FAQ.
Bruce Momjian [Mon, 12 Nov 2001 07:38:57 +0000 (07:38 +0000)]
Update FAQ.

22 years agoUpdate TODO list.
Bruce Momjian [Mon, 12 Nov 2001 07:10:58 +0000 (07:10 +0000)]
Update TODO list.

22 years ago Tables without oids wouldn't be able to be
Bruce Momjian [Mon, 12 Nov 2001 06:09:09 +0000 (06:09 +0000)]
    Tables without oids wouldn't be able to be
used inside fk constraints, since some of the checks
in the trigger did a SELECT oid.  Since the oid wasn't
actually used, I changed this to SELECT 1.  My test
case with non-oid tables now works and fk regression
appears to run fine on my machine.

Stephan Szabo

22 years agoRemove a bunch more no-longer-used stuff in libpq-be.h.
Tom Lane [Mon, 12 Nov 2001 05:43:25 +0000 (05:43 +0000)]
Remove a bunch more no-longer-used stuff in libpq-be.h.

22 years agoUpdate TODO list.
Bruce Momjian [Mon, 12 Nov 2001 05:35:48 +0000 (05:35 +0000)]
Update TODO list.

22 years agoSuppress duplicate error messages in pq_flush. Write error messages to
Tom Lane [Mon, 12 Nov 2001 04:54:08 +0000 (04:54 +0000)]
Suppress duplicate error messages in pq_flush.  Write error messages to
postmaster log with elog(DEBUG) so that they will be timestamped etc.
Once upon a time I think elog() was unsafe here, but it shouldn't be anymore.

22 years agosend() attempt for IDENT communication should retry on EINTR.
Tom Lane [Mon, 12 Nov 2001 04:29:23 +0000 (04:29 +0000)]
send() attempt for IDENT communication should retry on EINTR.

22 years agoThe PacketReceive/PacketSend routines aren't used anymore.
Tom Lane [Mon, 12 Nov 2001 04:19:15 +0000 (04:19 +0000)]
The PacketReceive/PacketSend routines aren't used anymore.

22 years agoUpdate MD5 documentation.
Bruce Momjian [Mon, 12 Nov 2001 03:57:16 +0000 (03:57 +0000)]
Update MD5 documentation.

22 years agoAdd more MD5 documentation now that odbc/jdbc support it.
Bruce Momjian [Mon, 12 Nov 2001 02:35:16 +0000 (02:35 +0000)]
Add more MD5 documentation now that odbc/jdbc support it.

22 years agoSync up both files.
Bruce Momjian [Mon, 12 Nov 2001 02:05:17 +0000 (02:05 +0000)]
Sync up both files.

22 years ago Add comments and remove CVS tag from md5.c so they remain identical.
Bruce Momjian [Mon, 12 Nov 2001 02:00:18 +0000 (02:00 +0000)]
 Add comments and remove CVS tag from md5.c so they remain identical.

22 years agoAdd comments and remove CVS tag from md5.c so they remain identical.
Bruce Momjian [Mon, 12 Nov 2001 01:59:43 +0000 (01:59 +0000)]
Add comments and remove CVS tag from md5.c so they remain identical.

22 years agoUpdate md5 to match.
Bruce Momjian [Mon, 12 Nov 2001 01:56:12 +0000 (01:56 +0000)]
Update md5 to match.

22 years agoAdd comments of duplicate definitions in interfaces/odbc/md5.h.
Bruce Momjian [Mon, 12 Nov 2001 01:52:46 +0000 (01:52 +0000)]
Add comments of duplicate definitions in interfaces/odbc/md5.h.

22 years agoAdd code to check that md5.c files are in sync.
Bruce Momjian [Mon, 12 Nov 2001 01:42:03 +0000 (01:42 +0000)]
Add code to check that md5.c files are in sync.

22 years agoIndent new rename.c for Tom Lane.
Bruce Momjian [Mon, 12 Nov 2001 01:34:50 +0000 (01:34 +0000)]
Indent new rename.c for Tom Lane.

22 years agoAdd md5 authentication support thanks to Bruce Momjian.
Hiroshi Inoue [Mon, 12 Nov 2001 00:54:28 +0000 (00:54 +0000)]
Add md5 authentication support thanks to Bruce Momjian.

22 years agoMake ALTER TABLE RENAME update foreign-key trigger arguments correctly.
Tom Lane [Mon, 12 Nov 2001 00:46:36 +0000 (00:46 +0000)]
Make ALTER TABLE RENAME update foreign-key trigger arguments correctly.
Brent Verner, with review and kibitzing from Tom Lane.

22 years agoClean up a bunch of ScanKeyEntryInitialize calls that weren't bothering
Tom Lane [Mon, 12 Nov 2001 00:00:55 +0000 (00:00 +0000)]
Clean up a bunch of ScanKeyEntryInitialize calls that weren't bothering
to apply the proper Datum conversion macros to search key values.

22 years agoTest program needs to declare MaxBackends, per Bernd Tegge.
Tom Lane [Sun, 11 Nov 2001 22:12:00 +0000 (22:12 +0000)]
Test program needs to declare MaxBackends, per Bernd Tegge.

22 years agoDefend against brain-dead QNX implementation of qsort().
Tom Lane [Sun, 11 Nov 2001 22:00:25 +0000 (22:00 +0000)]
Defend against brain-dead QNX implementation of qsort().
Per report from Bernd Tegge, 10-Nov-01.

22 years agoIn find_mergeclauses_for_pathkeys, it's okay to return multiple merge
Tom Lane [Sun, 11 Nov 2001 20:33:53 +0000 (20:33 +0000)]
In find_mergeclauses_for_pathkeys, it's okay to return multiple merge
clauses per path key.  Indeed, we *must* do so or we will be unable to
form a valid plan for FULL JOIN with overlapping join conditions, eg
select * from a full join b on
a.v1 = b.v1 and a.v2 = b.v2 and a.v1 = b.v2.

22 years agoFix typo pointed out by bruno@wolff.to
Bruce Momjian [Sun, 11 Nov 2001 19:24:28 +0000 (19:24 +0000)]
Fix typo pointed out by bruno@wolff.to

22 years agoFix for compiling libpq++ on Solaris with Sun SPRO6U2.
Bruce Momjian [Sun, 11 Nov 2001 19:20:53 +0000 (19:20 +0000)]
Fix for compiling libpq++ on Solaris with Sun SPRO6U2.

Denis A Ustimenko

22 years agosort_inner_and_outer needs a check to ensure that it's consumed all the
Tom Lane [Sun, 11 Nov 2001 19:18:54 +0000 (19:18 +0000)]
sort_inner_and_outer needs a check to ensure that it's consumed all the
mergeclauses in RIGHT/FULL join cases, just like the other routines have.
I'm not quite sure why I thought it didn't need one --- but Nick
Fankhauser's recent bug report proves that it does.

22 years agoUse abbreviated connection string more widely.
Hiroshi Inoue [Sun, 11 Nov 2001 07:24:36 +0000 (07:24 +0000)]
Use abbreviated connection string more widely.
This seems to fix the trouble with PowerBuilder
reported by Magbus Weber.

22 years agoDefend against possibility that SSL error reporting mechanism returns
Tom Lane [Sun, 11 Nov 2001 02:09:05 +0000 (02:09 +0000)]
Defend against possibility that SSL error reporting mechanism returns
a NULL pointer.  Per report from Stephen Pillinger 8-Nov-01.

22 years agoClean up usage-statistics display code (ShowUsage and friends). StatFp
Tom Lane [Sat, 10 Nov 2001 23:51:14 +0000 (23:51 +0000)]
Clean up usage-statistics display code (ShowUsage and friends).  StatFp
is gone, usage messages now go through elog(DEBUG).

22 years agoRestructure child-exit logging messages for easier translation,
Tom Lane [Sat, 10 Nov 2001 23:06:12 +0000 (23:06 +0000)]
Restructure child-exit logging messages for easier translation,
per suggestion from Peter.

22 years agoAllow TIMESTAMP, VARCHAR, et al to be used as unquoted column names,
Tom Lane [Sat, 10 Nov 2001 22:31:49 +0000 (22:31 +0000)]
Allow TIMESTAMP, VARCHAR, et al to be used as unquoted column names,
though alas not as unquoted function names.  De-reserve a bunch of
keywords that could have been in ColId rather than ColLabel all along.
Per recent proposal in pgsql-patches.

22 years agoRepair erroneous ALTER DROP CONSTRAINT example.
Tom Lane [Sat, 10 Nov 2001 20:13:37 +0000 (20:13 +0000)]
Repair erroneous ALTER DROP CONSTRAINT example.

22 years agoJason Davies patch to getImported/getExported keys
Dave Cramer [Fri, 9 Nov 2001 02:57:50 +0000 (02:57 +0000)]
Jason Davies patch to getImported/getExported keys

22 years agoSupport for images in jadetex and pdfjadetex. Formatting improvements for
Peter Eisentraut [Thu, 8 Nov 2001 23:46:29 +0000 (23:46 +0000)]
Support for images in jadetex and pdfjadetex.  Formatting improvements for
lists, bibliography, index, page numbering.  Add comments.

22 years agoUse <sect1> rather than <section> to simplify formatting.
Peter Eisentraut [Thu, 8 Nov 2001 23:44:01 +0000 (23:44 +0000)]
Use <sect1> rather than <section> to simplify formatting.

22 years agoAdd missing spaces
Peter Eisentraut [Thu, 8 Nov 2001 23:42:23 +0000 (23:42 +0000)]
Add missing spaces

22 years agoFix indexterms
Peter Eisentraut [Thu, 8 Nov 2001 23:41:12 +0000 (23:41 +0000)]
Fix indexterms

22 years agoMove the indexterms around so they don't affect formatting
Peter Eisentraut [Thu, 8 Nov 2001 23:40:40 +0000 (23:40 +0000)]
Move the indexterms around so they don't affect formatting

22 years agoUse <important> rather than <caution> when the condition isn't hazardous,
Peter Eisentraut [Thu, 8 Nov 2001 23:39:22 +0000 (23:39 +0000)]
Use <important> rather than <caution> when the condition isn't hazardous,
because the result looks to "scary" otherwise.

22 years agoSmall tuning
Peter Eisentraut [Thu, 8 Nov 2001 23:37:50 +0000 (23:37 +0000)]
Small tuning

22 years agoSpacing improvements
Peter Eisentraut [Thu, 8 Nov 2001 23:36:55 +0000 (23:36 +0000)]
Spacing improvements

22 years agoDon't use dot in id attribute, which confuses the index generation code in
Peter Eisentraut [Thu, 8 Nov 2001 23:36:18 +0000 (23:36 +0000)]
Don't use dot in id attribute, which confuses the index generation code in
this particular instance.

22 years agoCleanup of bibliography
Peter Eisentraut [Thu, 8 Nov 2001 23:34:33 +0000 (23:34 +0000)]
Cleanup of bibliography

22 years agoFix indenting for 'extern "C"' cases.
Bruce Momjian [Thu, 8 Nov 2001 20:37:52 +0000 (20:37 +0000)]
Fix indenting for 'extern "C"' cases.

22 years agoUpdate TODO list.
Bruce Momjian [Thu, 8 Nov 2001 18:24:55 +0000 (18:24 +0000)]
Update TODO list.

22 years agoMake extern C handling more flexible.
Bruce Momjian [Thu, 8 Nov 2001 17:03:23 +0000 (17:03 +0000)]
Make extern C handling more flexible.

22 years agoWhen given oversized key, encrypt/decrypt corrupted
Bruce Momjian [Thu, 8 Nov 2001 15:56:58 +0000 (15:56 +0000)]
When given oversized key, encrypt/decrypt corrupted
memory.  This fixes it.  Also a free() was missing.

marko

22 years agoPostgreSQL works again on Mac OS X 10.1. Hold your nose before
Tom Lane [Thu, 8 Nov 2001 04:24:03 +0000 (04:24 +0000)]
PostgreSQL works again on Mac OS X 10.1.  Hold your nose before
investigating the kluge that makes it so...

22 years agoAdd casts to suppress compiler warnings observed on Darwin platform
Tom Lane [Thu, 8 Nov 2001 04:05:13 +0000 (04:05 +0000)]
Add casts to suppress compiler warnings observed on Darwin platform
(surprised no one has reported these yet...)

22 years agoFix replacement of extern C string.
Bruce Momjian [Wed, 7 Nov 2001 22:10:02 +0000 (22:10 +0000)]
Fix replacement of extern C string.

22 years agoFix typo.
Bruce Momjian [Wed, 7 Nov 2001 21:29:04 +0000 (21:29 +0000)]
Fix typo.

22 years agoPrevent indenting of 'extern "C"' blocks.
Bruce Momjian [Wed, 7 Nov 2001 21:24:28 +0000 (21:24 +0000)]
Prevent indenting of 'extern "C"' blocks.

22 years agoMention new =NULL change in Migration section.
Bruce Momjian [Wed, 7 Nov 2001 17:27:36 +0000 (17:27 +0000)]
Mention new =NULL change in Migration section.

22 years agoUpdate TODO list.
Bruce Momjian [Wed, 7 Nov 2001 05:27:46 +0000 (05:27 +0000)]
Update TODO list.

22 years agoFix wrapping.
Bruce Momjian [Wed, 7 Nov 2001 03:12:20 +0000 (03:12 +0000)]
Fix wrapping.

22 years agoCorrect, not too ambitious, not too
Bruce Momjian [Wed, 7 Nov 2001 03:10:59 +0000 (03:10 +0000)]
Correct, not too ambitious, not too
long for an enhancement history item? :)

--
Serguei A. Mokhov
~