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
Bruce Momjian [Thu, 8 Nov 2001 20:37:52 +0000 (20:37 +0000)]
Fix indenting for 'extern "C"' cases.
Bruce Momjian [Thu, 8 Nov 2001 18:24:55 +0000 (18:24 +0000)]
Update TODO list.
Bruce Momjian [Thu, 8 Nov 2001 17:03:23 +0000 (17:03 +0000)]
Make extern C handling more flexible.
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
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...
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...)
Bruce Momjian [Wed, 7 Nov 2001 22:10:02 +0000 (22:10 +0000)]
Fix replacement of extern C string.
Bruce Momjian [Wed, 7 Nov 2001 21:29:04 +0000 (21:29 +0000)]
Fix typo.
Bruce Momjian [Wed, 7 Nov 2001 21:24:28 +0000 (21:24 +0000)]
Prevent indenting of 'extern "C"' blocks.
Bruce Momjian [Wed, 7 Nov 2001 17:27:36 +0000 (17:27 +0000)]
Mention new =NULL change in Migration section.
Bruce Momjian [Wed, 7 Nov 2001 05:27:46 +0000 (05:27 +0000)]
Update TODO list.
Bruce Momjian [Wed, 7 Nov 2001 03:12:20 +0000 (03:12 +0000)]
Fix wrapping.
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
~
Bruce Momjian [Wed, 7 Nov 2001 03:09:15 +0000 (03:09 +0000)]
Some post pgident run updates,
one fuzzy translation fix, some
other messages tweaking. Theoretically,
should be up-to-date by now.
Please apply to /src/interfaces/libpq/ru.po
--
Serguei A. Mokhov
Bruce Momjian [Wed, 7 Nov 2001 01:34:03 +0000 (01:34 +0000)]
Update TODO list.
Tom Lane [Tue, 6 Nov 2001 23:54:32 +0000 (23:54 +0000)]
Add some notes about conditional rules used with views.
Bruce Momjian [Tue, 6 Nov 2001 23:42:44 +0000 (23:42 +0000)]
Update TODO list.
Bruce Momjian [Tue, 6 Nov 2001 22:25:53 +0000 (22:25 +0000)]
Add mention of another MySQL conversion tool.
PostgreSQL Daemon [Tue, 6 Nov 2001 20:12:07 +0000 (20:12 +0000)]
tag'd and branded as b2 ...
Tom Lane [Tue, 6 Nov 2001 18:03:48 +0000 (18:03 +0000)]
Update for latest version of horology test.
Tom Lane [Tue, 6 Nov 2001 18:02:48 +0000 (18:02 +0000)]
Clean up formatting of child process exit-status reports so that they
are correct, consistent, and complete ... motivated by gripe from
Oliver Elphick, but I see someone had already made an incomplete stab
at this.
Thomas G. Lockhart [Tue, 6 Nov 2001 16:31:13 +0000 (16:31 +0000)]
Fix last (?) problem with sensitivity to daylight savings time status
when running the regression test. Reported by Tom Lane.
Thomas G. Lockhart [Tue, 6 Nov 2001 16:29:51 +0000 (16:29 +0000)]
Add British Double Standard Time (BDST) per mailing list report.
Thomas G. Lockhart [Tue, 6 Nov 2001 16:27:31 +0000 (16:27 +0000)]
Use PostgreSQL's standard declaration for a 32-bit integer to define
the cash data type.
Tom Lane [Tue, 6 Nov 2001 01:15:29 +0000 (01:15 +0000)]
Add Darwin to list of known systems for ps_status.
Tom Lane [Tue, 6 Nov 2001 00:38:26 +0000 (00:38 +0000)]
The extra semaphore that proc.c now allocates for checkpoint processes
should be accounted for in the PROC_SEM_MAP_ENTRIES() macro. Otherwise
the ports that rely on this macro to size data structures are broken.
Mea culpa.
Tom Lane [Mon, 5 Nov 2001 19:41:56 +0000 (19:41 +0000)]
Fix coredump in plpgsql when trying to return a rowtype result.
Need to return a TupleTableSlot, not just a bare tuple.
Bruce Momjian [Mon, 5 Nov 2001 17:46:40 +0000 (17:46 +0000)]
New pgindent run with fixes suggested by Tom. Patch manually reviewed,
initdb/regression tests pass.
Hiroshi Inoue [Mon, 5 Nov 2001 10:35:14 +0000 (10:35 +0000)]
Preparation for the parameter array handling.
Hiroshi Inoue [Mon, 5 Nov 2001 09:46:17 +0000 (09:46 +0000)]
1) Fix a few bugs about SQLGetData()
reported by Mika Mantyla.
2) Timestamp precision.
3) Separate ODBC3.0 files.
Bruce Momjian [Mon, 5 Nov 2001 06:37:51 +0000 (06:37 +0000)]
More cleanup for stuff after closing brace in first column.
Bruce Momjian [Mon, 5 Nov 2001 05:47:50 +0000 (05:47 +0000)]
Handle tabs after closing brace in first column with less indenting.
Bruce Momjian [Mon, 5 Nov 2001 05:18:43 +0000 (05:18 +0000)]
Improve readability of script.
Tom Lane [Mon, 5 Nov 2001 05:00:14 +0000 (05:00 +0000)]
CREATE TABLE foo (x,y,z) AS SELECT ... can't apply target column names
to the target list in gram.y; it must wait till after expansion of the
target list in analyze.c. Per bug report 4-Nov:
lx=# CREATE TABLE abc (a char, b char, c char);
CREATE
lx=# CREATE TABLE xyz (x, y, z) AS SELECT * FROM abc;
ERROR: CREATE TABLE/AS SELECT has mismatched column count
Tom Lane [Mon, 5 Nov 2001 01:34:37 +0000 (01:34 +0000)]
Remove ill-considered Assert.
Bruce Momjian [Sun, 4 Nov 2001 21:27:41 +0000 (21:27 +0000)]
Pull in variables defined in structs; had too many tabs.
Tom Lane [Sun, 4 Nov 2001 20:12:57 +0000 (20:12 +0000)]
Fix now-obsolete comment.
D'Arcy J.M. Cain [Sun, 4 Nov 2001 20:11:01 +0000 (20:11 +0000)]
Version was 3.3 but last released version was 3.1. Setting to match rest
of the documentation in preparation for upcoming release.
Tom Lane [Sun, 4 Nov 2001 19:55:31 +0000 (19:55 +0000)]
Merge three existing ways of signaling postmaster from child processes,
so that only one signal number is used not three. Flags in shared
memory tell the reason(s) for the current signal. This method is
extensible to handle more signal reasons without chewing up even more
signal numbers, but the immediate reason is to keep pg_pwd reloads
separate from SIGHUP processing in the postmaster.
Also clean up some problems in the postmaster with delayed response to
checkpoint status changes --- basically, it wouldn't schedule a checkpoint
if it wasn't getting connection requests on a regular basis.
D'Arcy J.M. Cain [Sun, 4 Nov 2001 19:47:16 +0000 (19:47 +0000)]
Note that PyGreSQL has been checked against Python 2.1 now.
D'Arcy J.M. Cain [Sun, 4 Nov 2001 19:42:13 +0000 (19:42 +0000)]
The "%d", while syntactically correct, was confusing. Added a space to
make it clearer that d was the argument to the format operator.
Philip Warner [Sun, 4 Nov 2001 04:05:36 +0000 (04:05 +0000)]
- Fix compiler warning in pg_restore
- Fix handling of {data/schema}-only restores when using a full
backup file; prior version was restoring schema in data-only
restores. Added enum to make code easier to understand.
Bruce Momjian [Sun, 4 Nov 2001 03:08:11 +0000 (03:08 +0000)]
Got "ADD" to appear only in ALTER TABLE and not CREATE TABLE
UNIQUE-PRIMARY KEY notice message. This is what Christopher wanted from
his patch.
Bruce Momjian [Sun, 4 Nov 2001 02:41:09 +0000 (02:41 +0000)]
Remove "ADD" from TABLE / ADD UNIQUE-PRIMARY error message because the
same code is called for both creation and alter. Not worth worrying
about.
Bruce Momjian [Sat, 3 Nov 2001 22:34:13 +0000 (22:34 +0000)]
Require closing paren on line above brace to identify function
difinition, just for formatting workaround, per Tom's discovery.
Tom Lane [Sat, 3 Nov 2001 21:42:47 +0000 (21:42 +0000)]
Clean up wrong, misleading, or obsolete documentation about array types,
particularly in the CREATE TYPE reference page. Fix some other errors
in the CREATE TYPE page, too.
Bruce Momjian [Sat, 3 Nov 2001 12:34:15 +0000 (12:34 +0000)]
More updates for GNU indent.
Hiroshi Inoue [Sat, 3 Nov 2001 06:53:50 +0000 (06:53 +0000)]
1) Improve literal handling in parse_statement().
2) Remove some no longer valid comments.
3) Fix an option dialog setting bug.
4) Fix ODBCVER handling errors.
Bruce Momjian [Sat, 3 Nov 2001 01:49:22 +0000 (01:49 +0000)]
Make pgindent use GNU Indent version 2.X better.
Dave Cramer [Fri, 2 Nov 2001 23:51:18 +0000 (23:51 +0000)]
proper select for Jason Davies patch to getImportedKeys
Dave Cramer [Fri, 2 Nov 2001 23:50:08 +0000 (23:50 +0000)]
proper select for Jason Davies patch to getImportedKeys
fixes for compiling Jason's getImportedKeys, getExportedKeys
Bruce Momjian [Fri, 2 Nov 2001 23:43:24 +0000 (23:43 +0000)]
Add check for 'extern "C"' for pgindent.
Tom Lane [Fri, 2 Nov 2001 20:51:27 +0000 (20:51 +0000)]
Windows portability macros SOCK_ERRNO and SOCK_STRERROR should be in
libpq-int.h, not cluttering application namespace in libpq-fe.h.