Tom Lane [Sun, 18 Nov 2001 00:59:00 +0000 (00:59 +0000)]
Fix obsolete claim that only btree indexes support multiple columns;
GiST does now, too. (Someone needs to write a description of GiST
to add to this chapter. I don't know enough about it ...)
Tom Lane [Sun, 18 Nov 2001 00:38:00 +0000 (00:38 +0000)]
Clean up treatment of creating/dropping databases in User's Guide and
Admin Guide. Move discussion of template databases out of footnotes
in CREATE DATABASE ref page and into a section of the Admin Guide.
Clean up various obsolete claims, do some copy-editing.
Tom Lane [Sat, 17 Nov 2001 22:23:55 +0000 (22:23 +0000)]
Copy-editing.
Tom Lane [Sat, 17 Nov 2001 22:20:34 +0000 (22:20 +0000)]
Expand documentation for sequence functions (nextval and friends).
Place it in the expected place in the User's Guide, rather than
hiding it in the command reference page for CREATE SEQUENCE.
Bruce Momjian [Sat, 17 Nov 2001 19:53:07 +0000 (19:53 +0000)]
Update TODO list.
Bruce Momjian [Sat, 17 Nov 2001 19:29:19 +0000 (19:29 +0000)]
Update TODO list.
Peter Eisentraut [Sat, 17 Nov 2001 13:27:16 +0000 (13:27 +0000)]
Update key words for recent grammar changes
Tom Lane [Sat, 17 Nov 2001 06:09:30 +0000 (06:09 +0000)]
Fix performance problems in TOAST compressor. The management of
search lists was broken in such a way that only the most recent
instance of a given hash code would ever be searched, thus possibly
missing longer matches further back. Fixing this gave 5 to 10%
compression improvement on some text test cases. Additional small
tweaks to improve speed of inner loops a little bit. There is no
compatibility issue created by this change, since the compressed data
format and decompression algorithm don't change.
Bruce Momjian [Sat, 17 Nov 2001 05:11:43 +0000 (05:11 +0000)]
Update Japanese FAQ's.
Tom Lane [Fri, 16 Nov 2001 23:30:35 +0000 (23:30 +0000)]
IsSystemRelationName() treats TOAST relations as system relations.
This seems the right thing for most usages, but I notice two places
where it is the wrong thing. One is that the default permissions on
TOAST rels should be no-access, not world-readable; the other is that
PrepareForTupleInvalidation doesn't really need to spend time looking
at tuples of TOAST relations.
Bruce Momjian [Fri, 16 Nov 2001 18:28:16 +0000 (18:28 +0000)]
Add missing prototype.
Bruce Momjian [Fri, 16 Nov 2001 18:10:04 +0000 (18:10 +0000)]
Add configure result checks on odbc, per Peter E.
Tom Lane [Fri, 16 Nov 2001 18:04:31 +0000 (18:04 +0000)]
plpython security and error handling fixes, from
Kevin Jacobs and Brad McLean.
Bruce Momjian [Fri, 16 Nov 2001 17:43:25 +0000 (17:43 +0000)]
Update TODO list.
Tom Lane [Fri, 16 Nov 2001 17:01:48 +0000 (17:01 +0000)]
Once again, Michael has overwritten someone else's patch ...
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.
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.
Peter Eisentraut [Fri, 16 Nov 2001 16:29:56 +0000 (16:29 +0000)]
Use -f for rm.
Michael Meskes [Fri, 16 Nov 2001 08:36:37 +0000 (08:36 +0000)]
Committed again to add the missing files/patches.
Hiroshi Inoue [Fri, 16 Nov 2001 05:55:10 +0000 (05:55 +0000)]
Change SQLDescribeCol so that it returns alias name properly.
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.
Tom Lane [Fri, 16 Nov 2001 00:40:11 +0000 (00:40 +0000)]
Fix silly error in plpgsql example.
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.
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.
Bruce Momjian [Thu, 15 Nov 2001 18:40:52 +0000 (18:40 +0000)]
Read getopt() into an int, not char.
Tom Lane [Thu, 15 Nov 2001 17:31:44 +0000 (17:31 +0000)]
Autoconf.
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
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.
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
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.
Tom Lane [Thu, 15 Nov 2001 06:25:22 +0000 (06:25 +0000)]
Significant editorial overhaul of plpgsql documentation.
Tatsuo Ishii [Thu, 15 Nov 2001 06:15:34 +0000 (06:15 +0000)]
Add changes for multibyte support in 7.2.
Bruce Momjian [Thu, 15 Nov 2001 03:12:53 +0000 (03:12 +0000)]
Fix comment at top of file to match file name.
Bruce Momjian [Thu, 15 Nov 2001 03:11:32 +0000 (03:11 +0000)]
Update TODO list.
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.
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 ...
Bruce Momjian [Wed, 14 Nov 2001 20:40:33 +0000 (20:40 +0000)]
Gnu -> GNU in docs.
Dave Cramer [Wed, 14 Nov 2001 20:04:00 +0000 (20:04 +0000)]
fixes getIndex to work with forte's transparent persistence
Bruce Momjian [Wed, 14 Nov 2001 16:31:38 +0000 (16:31 +0000)]
Update TODO list.
Michael Meskes [Wed, 14 Nov 2001 11:11:49 +0000 (11:11 +0000)]
Added Christof's patches.
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
Bruce Momjian [Tue, 13 Nov 2001 22:08:04 +0000 (22:08 +0000)]
Update CVS tags.
Bruce Momjian [Tue, 13 Nov 2001 22:07:42 +0000 (22:07 +0000)]
Use better CVS tag.
Bruce Momjian [Tue, 13 Nov 2001 22:06:58 +0000 (22:06 +0000)]
Remove md5.c check, add CVS log stamp. Update comments.
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.
Bruce Momjian [Tue, 13 Nov 2001 01:14:57 +0000 (01:14 +0000)]
Update TODO list.
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.
Bruce Momjian [Mon, 12 Nov 2001 20:26:39 +0000 (20:26 +0000)]
Update TODO list.
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.
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.
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
Peter Eisentraut [Mon, 12 Nov 2001 19:19:39 +0000 (19:19 +0000)]
Add some more index entries.
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
Bruce Momjian [Mon, 12 Nov 2001 17:44:14 +0000 (17:44 +0000)]
Add port number to pg_dumplo.
andrea gelmini
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.
Tom Lane [Mon, 12 Nov 2001 16:34:58 +0000 (16:34 +0000)]
Remove duplicate extern declaration.
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).
Bruce Momjian [Mon, 12 Nov 2001 07:38:57 +0000 (07:38 +0000)]
Update FAQ.
Bruce Momjian [Mon, 12 Nov 2001 07:10:58 +0000 (07:10 +0000)]
Update TODO list.
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
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.
Bruce Momjian [Mon, 12 Nov 2001 05:35:48 +0000 (05:35 +0000)]
Update TODO list.
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.
Tom Lane [Mon, 12 Nov 2001 04:29:23 +0000 (04:29 +0000)]
send() attempt for IDENT communication should retry on EINTR.
Tom Lane [Mon, 12 Nov 2001 04:19:15 +0000 (04:19 +0000)]
The PacketReceive/PacketSend routines aren't used anymore.
Bruce Momjian [Mon, 12 Nov 2001 03:57:16 +0000 (03:57 +0000)]
Update MD5 documentation.
Bruce Momjian [Mon, 12 Nov 2001 02:35:16 +0000 (02:35 +0000)]
Add more MD5 documentation now that odbc/jdbc support it.
Bruce Momjian [Mon, 12 Nov 2001 02:05:17 +0000 (02:05 +0000)]
Sync up both files.
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.
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.
Bruce Momjian [Mon, 12 Nov 2001 01:56:12 +0000 (01:56 +0000)]
Update md5 to match.
Bruce Momjian [Mon, 12 Nov 2001 01:52:46 +0000 (01:52 +0000)]
Add comments of duplicate definitions in interfaces/odbc/md5.h.
Bruce Momjian [Mon, 12 Nov 2001 01:42:03 +0000 (01:42 +0000)]
Add code to check that md5.c files are in sync.
Bruce Momjian [Mon, 12 Nov 2001 01:34:50 +0000 (01:34 +0000)]
Indent new rename.c for Tom Lane.
Hiroshi Inoue [Mon, 12 Nov 2001 00:54:28 +0000 (00:54 +0000)]
Add md5 authentication support thanks to Bruce Momjian.
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.
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.
Tom Lane [Sun, 11 Nov 2001 22:12:00 +0000 (22:12 +0000)]
Test program needs to declare MaxBackends, per Bernd Tegge.
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.
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.
Bruce Momjian [Sun, 11 Nov 2001 19:24:28 +0000 (19:24 +0000)]
Fix typo pointed out by bruno@wolff.to
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
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.
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.
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.
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).
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.
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.
Tom Lane [Sat, 10 Nov 2001 20:13:37 +0000 (20:13 +0000)]
Repair erroneous ALTER DROP CONSTRAINT example.
Dave Cramer [Fri, 9 Nov 2001 02:57:50 +0000 (02:57 +0000)]
Jason Davies patch to getImported/getExported keys
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.
Peter Eisentraut [Thu, 8 Nov 2001 23:44:01 +0000 (23:44 +0000)]
Use <sect1> rather than <section> to simplify formatting.
Peter Eisentraut [Thu, 8 Nov 2001 23:42:23 +0000 (23:42 +0000)]
Add missing spaces
Peter Eisentraut [Thu, 8 Nov 2001 23:41:12 +0000 (23:41 +0000)]
Fix indexterms
Peter Eisentraut [Thu, 8 Nov 2001 23:40:40 +0000 (23:40 +0000)]
Move the indexterms around so they don't affect formatting
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.
Peter Eisentraut [Thu, 8 Nov 2001 23:37:50 +0000 (23:37 +0000)]
Small tuning
Peter Eisentraut [Thu, 8 Nov 2001 23:36:55 +0000 (23:36 +0000)]
Spacing improvements
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.
Peter Eisentraut [Thu, 8 Nov 2001 23:34:33 +0000 (23:34 +0000)]
Cleanup of bibliography