OSDN Git Service
Tom Lane [Mon, 19 Feb 2001 22:25:43 +0000 (22:25 +0000)]
Document --enable-cassert.
Bruce Momjian [Mon, 19 Feb 2001 21:52:57 +0000 (21:52 +0000)]
Update TODO list.
Bruce Momjian [Mon, 19 Feb 2001 20:46:14 +0000 (20:46 +0000)]
Update TODO list.
Tom Lane [Mon, 19 Feb 2001 19:49:53 +0000 (19:49 +0000)]
Change plpgsql's GET DIAGNOSTICS statement to use SQL99-compatible
syntax. Fix the RESULT_OID case, which never worked. Add documentation.
Bruce Momjian [Mon, 19 Feb 2001 19:06:47 +0000 (19:06 +0000)]
Update TODO list.
Bruce Momjian [Mon, 19 Feb 2001 16:55:08 +0000 (16:55 +0000)]
Update TODO list.
Bruce Momjian [Mon, 19 Feb 2001 15:23:08 +0000 (15:23 +0000)]
Update TODO list.
Michael Meskes [Mon, 19 Feb 2001 07:30:20 +0000 (07:30 +0000)]
Synced gram.y and preproc.y.
Tatsuo Ishii [Mon, 19 Feb 2001 05:16:40 +0000 (05:16 +0000)]
Fix nasty bug in configure.
STRTOL='strtoul.o' --> STRTOUL='strtoul.o'
Tom Lane [Mon, 19 Feb 2001 00:24:30 +0000 (00:24 +0000)]
Update example of partially constraining join order to use a subselect
in FROM instead of an auxiliary view. We didn't have subselect-in-FROM
when I wrote this originally...
Tom Lane [Mon, 19 Feb 2001 00:01:18 +0000 (00:01 +0000)]
AND/OR truth table needs another row IMHO.
Bruce Momjian [Sun, 18 Feb 2001 18:34:02 +0000 (18:34 +0000)]
Add copyright mentions, per Tom Lane.
Peter Eisentraut [Sun, 18 Feb 2001 18:06:10 +0000 (18:06 +0000)]
Allow extract() to accept the same field selectors as date_part(), not just
the ones specified by SQL.
Tom Lane [Sun, 18 Feb 2001 17:53:55 +0000 (17:53 +0000)]
Add --template option to createdb script to allow access to WITH TEMPLATE
option of CREATE DATABASE. In pg_regress, create regression database
from template0 to ensure that any installation-local cruft in template1
will not mess up the tests.
Peter Eisentraut [Sun, 18 Feb 2001 17:17:17 +0000 (17:17 +0000)]
Enhance documentation of date/time functions. Add extract, current_date,
current_time, current_timestamp. Add more examples. Remove age(), because
it doesn't work like it is documented, and no one could explain it to me.
Peter Eisentraut [Sun, 18 Feb 2001 17:15:03 +0000 (17:15 +0000)]
Make <lineannotation> italic. Fix syntax error in print style.
Tom Lane [Sun, 18 Feb 2001 06:07:37 +0000 (06:07 +0000)]
Add note that partial indices are not currently supported.
Tom Lane [Sun, 18 Feb 2001 05:30:12 +0000 (05:30 +0000)]
Update description of fsync option for 7.1.
Tom Lane [Sun, 18 Feb 2001 04:50:43 +0000 (04:50 +0000)]
Change default commit_delay to zero, update documentation.
Tom Lane [Sun, 18 Feb 2001 04:39:42 +0000 (04:39 +0000)]
Change s_lock to not use any zero-delay select() calls; these are just a
waste of cycles on single-CPU machines, and of dubious utility on multi-CPU
machines too.
Tweak s_lock_stuck so that caller can specify timeout interval, and
increase interval before declaring stuck spinlock for buffer locks and XLOG
locks.
On systems that have fdatasync(), use that rather than fsync() to sync WAL
log writes. Ensure that WAL file is entirely allocated during XLogFileInit.
Tom Lane [Sun, 18 Feb 2001 04:28:31 +0000 (04:28 +0000)]
Remove bogus set_ps_display call --- changing displayed status here is
either wrong or unnecessary in most cases, and on systems where setting
status takes a kernel call, the overhead of setting status three times
per command rather than two is annoying.
Tom Lane [Sat, 17 Feb 2001 16:52:53 +0000 (16:52 +0000)]
Catch some stray references to .htm files.
Tom Lane [Sat, 17 Feb 2001 16:47:57 +0000 (16:47 +0000)]
No more .htm files, so don't try to add them to the doc tarballs.
Bruce Momjian [Sat, 17 Feb 2001 14:35:48 +0000 (14:35 +0000)]
Update TODO list.
Tatsuo Ishii [Sat, 17 Feb 2001 10:03:33 +0000 (10:03 +0000)]
Fix a bug in psql. unescape() does not work for multi-byte encodings.
Tatsuo Ishii [Sat, 17 Feb 2001 06:50:03 +0000 (06:50 +0000)]
Fix README in Japanese to sync with README.pgbench updated by Tom.
(thanks!)
Tom Lane [Sat, 17 Feb 2001 03:37:22 +0000 (03:37 +0000)]
Seems a bad idea to assume that select(2) doesn't touch the input masks
if it returns EINTR.
Tom Lane [Sat, 17 Feb 2001 01:00:04 +0000 (01:00 +0000)]
Add current seek position to FDDEBUG output for FileRead,
FileWrite, FileSeek.
Tom Lane [Fri, 16 Feb 2001 23:50:40 +0000 (23:50 +0000)]
Just noticed that use of 'volatile' in HPPA S_UNLOCK() was causing gcc
to generate unnecessarily stupid code. Tweak macro to describe a series
of store-constant ops, not store/load/store/load/store/load/store.
Tom Lane [Fri, 16 Feb 2001 21:41:53 +0000 (21:41 +0000)]
Update README's install instructions to agree with current reality.
Bruce Momjian [Fri, 16 Feb 2001 19:43:52 +0000 (19:43 +0000)]
Update bsdi shared memory stuff.
Bruce Momjian [Fri, 16 Feb 2001 19:27:19 +0000 (19:27 +0000)]
Update BSDI FAQ.
Tom Lane [Fri, 16 Feb 2001 18:50:40 +0000 (18:50 +0000)]
Defend against starting a non-MULTIBYTE-enabled backend in a database
with encoding other than SQL_ASCII. Per recent discussion in pghackers.
Peter Mount [Fri, 16 Feb 2001 16:45:01 +0000 (16:45 +0000)]
Some more updates...
Fri Feb 17 15:11:00 GMT 2001 peter@retep.org.uk
- Reduced the object overhead in PreparedStatement by reusing the same
StringBuffer object throughout. Similarly SimpleDateStamp's are alse
reused in a thread save manner.
- Implemented in PreparedStatement: setNull(), setDate/Time/Timestamp
using Calendar, setBlob(), setCharacterStream()
- Clob's are now implemented in ResultSet & PreparedStatement!
- Implemented a lot of DatabaseMetaData & ResultSetMetaData methods.
We have about 18 unimplemented methods left in JDBC2 at the current
time.
Bruce Momjian [Fri, 16 Feb 2001 16:10:06 +0000 (16:10 +0000)]
Update BSDI SGML.
Tom Lane [Fri, 16 Feb 2001 03:49:40 +0000 (03:49 +0000)]
ichar() has been renamed to chr(), so fix translation table.
Tom Lane [Fri, 16 Feb 2001 03:26:40 +0000 (03:26 +0000)]
Fix bugs in pltcl's new return_null command: it was liable to go belly up
if the return datatype's input converter was at all strict, because the
converter would get called on junk data when returning NULL. Also
ensure that it gives an error rather than coredumping if someone tries
to use it in a trigger function.
Tom Lane [Fri, 16 Feb 2001 03:22:41 +0000 (03:22 +0000)]
Fix erroneous sort request in pltcl selftest.
Tom Lane [Fri, 16 Feb 2001 03:16:58 +0000 (03:16 +0000)]
Clean up two rather nasty bugs in operator selection code.
1. If there is exactly one pg_operator entry of the right name and oprkind,
oper() and related routines would return that entry whether its input type
had anything to do with the request or not. This is just premature
optimization: we shouldn't return the single candidate until after we verify
that it really is a valid candidate, ie, is at least coercion-compatible
with the given types.
2. oper() and related routines only promise a coercion-compatible result.
Unfortunately, there were quite a few callers that assumed the returned
operator is binary-compatible with the given datatype; they would proceed
to call it without making any datatype coercions. These callers include
sorting, grouping, aggregation, and VACUUM ANALYZE. In general I think
it is appropriate for these callers to require an exact or binary-compatible
match, so I've added a new routine compatible_oper() that only succeeds if
it can find an operator that doesn't require any run-time conversions.
Callers now call oper() or compatible_oper() depending on whether they are
prepared to deal with type conversion or not.
The upshot of these bugs is revealed by the following silliness in PL/Tcl's
selftest: it creates an operator @< on int4, and then tries to use it to
sort a char(N) column. The system would let it do that :-( (and evidently
has done so since 6.3 :-( :-(). The result in this case was just a silly
sort order, but the reverse combination would've provoked coredump from
trying to dereference integers. With this fix you get more reasonable
behavior:
pltcl_test=# select * from T_pkey1 order by key1, key2 using @<;
ERROR: Unable to identify an operator '@<' for types 'bpchar' and 'bpchar'
You will have to retype this query using an explicit cast
Hiroshi Inoue [Fri, 16 Feb 2001 03:10:09 +0000 (03:10 +0000)]
Add casting for numeric/float4/float8 type value
automatically to compensate the lack of automatic
conversion functionality of PostgreSQL server.
For example if there's a numeric type binding
1.2567 --> 1.2567::numeric.
I hope this change would enable the use of numeric
type in MS-Access etc.
Thanks Hiroki Kataoka for his checking my code.
Bruce Momjian [Fri, 16 Feb 2001 00:46:21 +0000 (00:46 +0000)]
Update bsdi faq.
Bruce Momjian [Fri, 16 Feb 2001 00:17:57 +0000 (00:17 +0000)]
Update bsdi faq.
Tom Lane [Fri, 16 Feb 2001 00:03:08 +0000 (00:03 +0000)]
Take OUTER JOIN semantics into account when estimating the size of join
relations. It's not very bright, but at least it now knows that
A LEFT JOIN B must produce at least as many rows as are in A ...
Bruce Momjian [Thu, 15 Feb 2001 22:21:23 +0000 (22:21 +0000)]
Update FAQ.
Bruce Momjian [Thu, 15 Feb 2001 22:15:10 +0000 (22:15 +0000)]
Update FAQ.
Tom Lane [Thu, 15 Feb 2001 21:57:43 +0000 (21:57 +0000)]
Add some notes about memory management of RI plans.
Tom Lane [Thu, 15 Feb 2001 21:47:08 +0000 (21:47 +0000)]
Update comments about memory management.
Tom Lane [Thu, 15 Feb 2001 21:38:26 +0000 (21:38 +0000)]
Update notes about memory context scheme.
Tom Lane [Thu, 15 Feb 2001 21:11:17 +0000 (21:11 +0000)]
Update obsolete wording of error message.
Tom Lane [Thu, 15 Feb 2001 20:57:01 +0000 (20:57 +0000)]
Although we can't support out-of-line TOAST storage in indexes (yet),
compressed storage works perfectly well. Might as well have a coherent
strategy for applying it, rather than the haphazard store-what-you-get
approach that was in the code before. The strategy I've set up here is
to attempt compression of any compressible index value exceeding
BLCKSZ/16, or about 500 bytes by default.
Tom Lane [Thu, 15 Feb 2001 19:03:35 +0000 (19:03 +0000)]
Further polishing of documentation about new fmgr call convention.
Tom Lane [Thu, 15 Feb 2001 17:55:17 +0000 (17:55 +0000)]
Reduce default selectivity estimates for geometric operators; it seems
the old ones were not small enough to ensure r-tree and gist indexes would
get picked when available. These numbers are totally bogus anyway, but
in the absence of any real estimation technique, we'd like to select
indexes when available ...
Tom Lane [Thu, 15 Feb 2001 17:46:40 +0000 (17:46 +0000)]
Update a couple of obsolete comments.
Bruce Momjian [Thu, 15 Feb 2001 16:21:38 +0000 (16:21 +0000)]
Update TODO list.
Bruce Momjian [Thu, 15 Feb 2001 16:03:46 +0000 (16:03 +0000)]
Update TODO list.
Bruce Momjian [Thu, 15 Feb 2001 13:31:44 +0000 (13:31 +0000)]
Update for Tatsuo.
Hiroshi Inoue [Thu, 15 Feb 2001 05:32:00 +0000 (05:32 +0000)]
1) Change transaction boundary in autocommit off mode
per recent discussion in pgsql-odbc. Now SELECT is
a boundary but VACUUM isn't.
2) Put back the error handling behavior. When elog(ERROR)
was detected the driver automatically issue "ABORT"
if a transaction is in progress.
3) Driver version is 7.01.0003(Dave already set it but
it was put back).
Tom Lane [Thu, 15 Feb 2001 04:28:50 +0000 (04:28 +0000)]
Clarify meaning of GEQO_THRESHOLD parameter.
Tom Lane [Thu, 15 Feb 2001 04:10:54 +0000 (04:10 +0000)]
Improve documentation of JOIN syntax. Explain NATURAL as an alternative
to ON and USING for specifying the join condition, not as an independent
kind of join semantics.
Tatsuo Ishii [Thu, 15 Feb 2001 01:56:29 +0000 (01:56 +0000)]
Unicode <-> SJIS new mapping tables (based on CP932.TXT) contributed by
Eiji Tokuya" <e-tokuya@Mail.Sankyo-Unyu.co.jp>
Tom Lane [Thu, 15 Feb 2001 01:10:28 +0000 (01:10 +0000)]
Arrange for ORDER BY an expression on a UNION/INTERSECT/EXCEPT result,
such as
SELECT f1 FROM foo UNION SELECT ... ORDER BY upper(f1)
to draw
'ORDER BY on a UNION/INTERSECT/EXCEPT result must be on one of the result columns'
rather than the uninformative 'f1 not found' we were producing before.
Eventually this should actually work, but that looks much too hard to try
to implement in late beta...
Tom Lane [Wed, 14 Feb 2001 23:32:38 +0000 (23:32 +0000)]
Repair problems with duplicate index names generated when CREATE TABLE
specifies redundant UNIQUE conditions.
Tom Lane [Wed, 14 Feb 2001 21:35:07 +0000 (21:35 +0000)]
Change scoping of table and join refnames to conform to SQL92: a JOIN
clause with an alias is a <subquery> and therefore hides table references
appearing within it, according to the spec. This is the same as the
preliminary patch I posted to pgsql-patches yesterday, plus some really
grotty code in ruleutils.c to reverse-list a query tree with the correct
alias name depending on context. I'd rather not have done that, but unless
we want to force another initdb for 7.1, there's no other way for now.
Peter Eisentraut [Wed, 14 Feb 2001 19:37:26 +0000 (19:37 +0000)]
Alter documentation of boolean type, add example. Someone figured that it
wasn't clear that the "boolean type" was actually called "boolean". Add
tip about "casting" booleans using CASE.
Spell check whole file.
Peter Eisentraut [Wed, 14 Feb 2001 19:35:14 +0000 (19:35 +0000)]
Format <structname>, <structfield>, and <type> mono-spaced.
Peter Mount [Wed, 14 Feb 2001 17:45:17 +0000 (17:45 +0000)]
Web Feb 14 17:29:00 GMT 2001 peter@retep.org.uk
- Fixed bug in LargeObject & BlobOutputStream where the stream's output
was not flushed when either the stream or the blob were closed.
- Fixed PreparedStatement.setBinaryStream() where it ignored the length
Bruce Momjian [Wed, 14 Feb 2001 15:12:37 +0000 (15:12 +0000)]
Update TODO list.
Bruce Momjian [Wed, 14 Feb 2001 06:10:31 +0000 (06:10 +0000)]
Add 7.X to dialog box.
Bruce Momjian [Wed, 14 Feb 2001 05:45:46 +0000 (05:45 +0000)]
Back out all ODBC formatting changes, and back out removal of <6.4
protocol. I have left in Tom's SOCK_get_next_byte() fix, and the new
win32.mak file addition. I have also left in the 'X' connection close
fix.
Bruce Momjian [Wed, 14 Feb 2001 02:42:32 +0000 (02:42 +0000)]
Update TODO list.
Peter Eisentraut [Tue, 13 Feb 2001 22:35:15 +0000 (22:35 +0000)]
Hmm, so referencing a CSS stylesheet when there isn't one doesn't work
everywhere.
Peter Eisentraut [Tue, 13 Feb 2001 22:05:47 +0000 (22:05 +0000)]
Fix markup.
Peter Eisentraut [Tue, 13 Feb 2001 21:51:17 +0000 (21:51 +0000)]
Didn't work when Makefile.custom is missing.
Peter Eisentraut [Tue, 13 Feb 2001 21:27:05 +0000 (21:27 +0000)]
Custom DSSSL stylesheet. Style changes included here:
HTML:
* make .html the default extension
* allow use of CSS stylesheet ("stylesheet.css", not included)
* make <set> TOC two levels deep
* put time of creation into meta header
Print:
* make print output justified by default
* footnotes at bottom of each page
* allow TeX to hyphenate
Peter Eisentraut [Tue, 13 Feb 2001 21:13:11 +0000 (21:13 +0000)]
Fix tag.
Bruce Momjian [Tue, 13 Feb 2001 20:54:51 +0000 (20:54 +0000)]
Update TODO list.
Bruce Momjian [Tue, 13 Feb 2001 20:54:04 +0000 (20:54 +0000)]
Update TODO list.
Vadim B. Mikheev [Tue, 13 Feb 2001 20:40:25 +0000 (20:40 +0000)]
Comments about GetFreeXLBuffer().
GetFreeXLBuffer(): use Insert->LgwrResult instead of private LgwrResult
copy if it's more fresh (attempt to avoid acquiring info_lck/lgwr_lck).
Peter Mount [Tue, 13 Feb 2001 16:39:06 +0000 (16:39 +0000)]
Some more including the patch to DatabaseMetaData backed out by Bruce.
Tue Feb 13 16:33:00 GMT 2001 peter@retep.org.uk
- More TestCases implemented. Refined the test suite api's.
- Removed need for SimpleDateFormat in ResultSet.getDate() improving
performance.
- Rewrote ResultSet.getTime() so that it uses JDK api's better.
Tue Feb 13 10:25:00 GMT 2001 peter@retep.org.uk
- Added MiscTest to hold reported problems from users.
- Fixed PGMoney.
- JBuilder4/JDBCExplorer now works with Money fields. Patched Field &
ResultSet (lots of methods) for this one. Also changed cash/money to
return type DOUBLE not DECIMAL. This broke JBuilder as zero scale
BigDecimal's can't have decimal places!
- When a Statement is reused, the previous ResultSet is now closed.
- Removed deprecated call in ResultSet.getTime()
Thu Feb 08 18:53:00 GMT 2001 peter@retep.org.uk
- Changed a couple of settings in DatabaseMetaData where 7.1 now
supports those features
- Implemented the DatabaseMetaData TestCase.
Wed Feb 07 18:06:00 GMT 2001 peter@retep.org.uk
- Added comment to Connection.isClosed() explaining why we deviate from
the JDBC2 specification.
- Fixed bug where the Isolation Level is lost while in autocommit mode.
- Fixed bug where several calls to getTransactionIsolationLevel()
returned the first call's result.
Bruce Momjian [Tue, 13 Feb 2001 16:18:15 +0000 (16:18 +0000)]
Remove postgresql jdbc files, per Peter.
Bruce Momjian [Tue, 13 Feb 2001 16:14:40 +0000 (16:14 +0000)]
Remove postgresql jdbc files, per Peter Mount.
Bruce Momjian [Tue, 13 Feb 2001 16:11:46 +0000 (16:11 +0000)]
Update TODO list.
Bruce Momjian [Tue, 13 Feb 2001 15:43:08 +0000 (15:43 +0000)]
Back out *inv* changes for this file. Peter want to handle it.
Bruce Momjian [Tue, 13 Feb 2001 14:33:51 +0000 (14:33 +0000)]
Remove unused files, per Andreas
Bruce Momjian [Tue, 13 Feb 2001 14:32:52 +0000 (14:32 +0000)]
Please apply the following patch to fix AIX and IRIX timestamp behavior
as previously discussed.
It makes AIX and IRIX not use DST for dates before 1970.
The following expected files need to be removed from the regression tests,
they contain wrong results and are not needed any more.
src/test/regress/expected/horology-1947-PDT.out
src/test/regress/expected/tinterval-1947-PDT.out
src/test/regress/expected/abstime-1947-PDT.out
Zeugswetter Andreas
Vadim B. Mikheev [Tue, 13 Feb 2001 08:44:09 +0000 (08:44 +0000)]
Removed abort() in XLogFileOpen.
Philip Warner [Tue, 13 Feb 2001 01:57:12 +0000 (01:57 +0000)]
Added some comments to setval, setval_is_called and do_setval
Philip Warner [Tue, 13 Feb 2001 01:31:54 +0000 (01:31 +0000)]
- Fix help output: replace 'f' with 't' and change desc
- Add extra arg to formatStringLiteral to specify how to handle LF & TAB.
I opted for encoding them except in procedure bodies & comments
- Fixed bug in tar file input when restoring blobs
Tom Lane [Tue, 13 Feb 2001 00:02:36 +0000 (00:02 +0000)]
Clean up portability problems in regexp package: change all routine
definitions from K&R to ANSI C style, and fix broken assumption that
int and long are the same datatype. This repairs problems observed
on Alpha with regexps having between 32 and 63 states.
Bruce Momjian [Mon, 12 Feb 2001 22:50:06 +0000 (22:50 +0000)]
Attached is a makefile for the ODBC driver for use under win32. It has been
tested only with MS VC++ 6.0SP4 using nmake.
Dave Page
Tom Lane [Mon, 12 Feb 2001 22:17:29 +0000 (22:17 +0000)]
Hmm, this isn't used either.
Tom Lane [Mon, 12 Feb 2001 22:13:06 +0000 (22:13 +0000)]
Remove unused and largely-broken-anyway compatibility defs.
Bruce Momjian [Mon, 12 Feb 2001 21:49:24 +0000 (21:49 +0000)]
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> OK, add #include <stdio.h> to the file. That should fix it.
Seems unlikely, since libpq-fe.h already includes <stdio.h>.
The real problem here is that the code is wrong: it's passing NULL
to an int parameter.
regards, tom lane
Bruce Momjian [Mon, 12 Feb 2001 21:45:24 +0000 (21:45 +0000)]
New MS resource file, pgindented.
Tom Lane [Mon, 12 Feb 2001 21:03:03 +0000 (21:03 +0000)]
Suppress compiler warning on Alpha.
Tom Lane [Mon, 12 Feb 2001 20:07:21 +0000 (20:07 +0000)]
Rearrange order of operations in heap_create_with_catalog so that if
two transactions create the same table name concurrently, the one that
fails will complain about unique index pg_class_relname_index, rather than
about pg_type_typname_index which'll confuse most people. Free side
benefit: pg_class.reltype is correctly linked to the pg_type entry now.
It's been zero in all but the preloaded pg_class entries since who knows
when.
Bruce Momjian [Mon, 12 Feb 2001 18:46:40 +0000 (18:46 +0000)]
Cleanup
Bruce Momjian [Mon, 12 Feb 2001 18:37:35 +0000 (18:37 +0000)]
Add stdio to file.
Bruce Momjian [Mon, 12 Feb 2001 18:30:53 +0000 (18:30 +0000)]
Add // -> /* */ mapping to pgindent.
Bruce Momjian [Mon, 12 Feb 2001 17:54:02 +0000 (17:54 +0000)]
Update ODBC resource MS-generated file.