OSDN Git Service
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.
Bruce Momjian [Mon, 12 Feb 2001 14:21:27 +0000 (14:21 +0000)]
User Manual
Chapter 4
String Operators
Table 4.7: Other String Functions
strpos is missing the result in the result column, it should be 2
Also to_ascii might need a result but maybe not.
Appendix A
In the Time Zone Table
Greenwich is spelled Greenwish
David Aldrich
Bruce Momjian [Mon, 12 Feb 2001 14:17:06 +0000 (14:17 +0000)]
Change more // comments.
Bruce Momjian [Mon, 12 Feb 2001 13:56:37 +0000 (13:56 +0000)]
Remove // and make /* */
Bruce Momjian [Mon, 12 Feb 2001 13:55:36 +0000 (13:55 +0000)]
Add #include <unistd.h>
Bruce Momjian [Mon, 12 Feb 2001 13:09:33 +0000 (13:09 +0000)]
New release format, Peter E style.
Bruce Momjian [Mon, 12 Feb 2001 12:59:22 +0000 (12:59 +0000)]
Replace // comments from file for MS products.
Bruce Momjian [Mon, 12 Feb 2001 12:52:02 +0000 (12:52 +0000)]
poit -> point.
Tom Lane [Sun, 11 Feb 2001 23:46:40 +0000 (23:46 +0000)]
SOCK_get_next_byte should not return garbage after error/EOF. Return
zero bytes instead.
Bruce Momjian [Sun, 11 Feb 2001 23:34:08 +0000 (23:34 +0000)]
Remove unneeded shutdown() call, per Tom Lane.
Tom Lane [Sun, 11 Feb 2001 23:12:28 +0000 (23:12 +0000)]
Improve error message when startup or shutdown proc fails.
Bruce Momjian [Sun, 11 Feb 2001 14:20:30 +0000 (14:20 +0000)]
Move release date into release heading.
Bruce Momjian [Sun, 11 Feb 2001 13:58:12 +0000 (13:58 +0000)]
More cleanups.
Bruce Momjian [Sun, 11 Feb 2001 13:53:42 +0000 (13:53 +0000)]
Include file alignment fixes.
Bruce Momjian [Sun, 11 Feb 2001 13:15:28 +0000 (13:15 +0000)]
Move X packet before shutdown().
Bruce Momjian [Sun, 11 Feb 2001 05:58:41 +0000 (05:58 +0000)]
Source alignment cleanups.
Bruce Momjian [Sun, 11 Feb 2001 05:15:25 +0000 (05:15 +0000)]
More updates.
Bruce Momjian [Sun, 11 Feb 2001 05:13:52 +0000 (05:13 +0000)]
More cleanup.
Bruce Momjian [Sun, 11 Feb 2001 05:04:47 +0000 (05:04 +0000)]
More cleanup.
Bruce Momjian [Sun, 11 Feb 2001 04:56:58 +0000 (04:56 +0000)]
Cleanup of source.
Bruce Momjian [Sun, 11 Feb 2001 02:18:48 +0000 (02:18 +0000)]
Add to Makefile.
Bruce Momjian [Sun, 11 Feb 2001 02:18:27 +0000 (02:18 +0000)]
Add pg_logger to /contrib.
Bruce Momjian [Sun, 11 Feb 2001 02:01:22 +0000 (02:01 +0000)]
The attached patch does the following:
1) Tidies up the Datasource Dialogue now the version options are gone.
2) Tidies a comment in info.c.
3) Increments all version numbers to 07.01.0003 to take account of recent
revisions.
Regards, Dave Page
Tatsuo Ishii [Sun, 11 Feb 2001 01:59:22 +0000 (01:59 +0000)]
Move pg_encoding_mblen() from common.c to wchar.c.
Tatsuo Ishii [Sun, 11 Feb 2001 01:56:58 +0000 (01:56 +0000)]
conv.c did not compile anymore. Fix wrong header file inclusion.
Tatsuo Ishii [Sun, 11 Feb 2001 01:52:11 +0000 (01:52 +0000)]
Clean up mutibyte supoorting source files.
Now only wchar.c is shared by fronetnd/backend.
Bruce Momjian [Sun, 11 Feb 2001 01:48:51 +0000 (01:48 +0000)]
Clean up HISTORY file, add dates to releases.
Peter Eisentraut [Sun, 11 Feb 2001 01:41:00 +0000 (01:41 +0000)]
Repair markup.
Bruce Momjian [Sat, 10 Feb 2001 23:35:04 +0000 (23:35 +0000)]
Disable X connection close in ODBC until solution is found.
Bruce Momjian [Sat, 10 Feb 2001 22:53:40 +0000 (22:53 +0000)]
Format to match standard conventions
Bruce Momjian [Sat, 10 Feb 2001 22:42:01 +0000 (22:42 +0000)]
Convert to standard 4-space tabs.
Peter Eisentraut [Sat, 10 Feb 2001 22:31:42 +0000 (22:31 +0000)]
Only look for bison as YACC; other yaccs need to be selected explicitly.
When no suitable YACC is configured, supply useful informational messages
to users. (Same way flex has been handled for a while.)
Bruce Momjian [Sat, 10 Feb 2001 18:46:34 +0000 (18:46 +0000)]
move comment
Peter Eisentraut [Sat, 10 Feb 2001 18:24:14 +0000 (18:24 +0000)]
Document that NetBSD's libedit can be used instead of readline.
Peter Eisentraut [Sat, 10 Feb 2001 18:02:35 +0000 (18:02 +0000)]
Add note about the availability of contrib/mac for the macaddr data type.
Bruce Momjian [Sat, 10 Feb 2001 17:36:57 +0000 (17:36 +0000)]
Add comment about linker/compiler on bsd.
Bruce Momjian [Sat, 10 Feb 2001 17:17:39 +0000 (17:17 +0000)]
Fix -Bsymbolic for FreeBSD and OpenBSD. NetBSD already had all these fixes.
Peter Eisentraut [Sat, 10 Feb 2001 16:51:40 +0000 (16:51 +0000)]
Repair BSD/OS shared library fixes.
Bruce Momjian [Sat, 10 Feb 2001 16:41:30 +0000 (16:41 +0000)]
Back out addition. Seems grammar doesn't handle CONSTRAINT as optional.
Bruce Momjian [Sat, 10 Feb 2001 16:39:07 +0000 (16:39 +0000)]
Add mention of CONSTRAINT in ADD CONSTRAINT section.
Bruce Momjian [Sat, 10 Feb 2001 16:26:38 +0000 (16:26 +0000)]
Revert shlib changes.
Bruce Momjian [Sat, 10 Feb 2001 16:25:10 +0000 (16:25 +0000)]
Remove protcol option buttons.
Bruce Momjian [Sat, 10 Feb 2001 15:59:16 +0000 (15:59 +0000)]
ODBC BSD/OS fix.
Bruce Momjian [Sat, 10 Feb 2001 12:07:12 +0000 (12:07 +0000)]
cleanup
Bruce Momjian [Sat, 10 Feb 2001 11:59:36 +0000 (11:59 +0000)]
Add URL for my2pg.pl.
Bruce Momjian [Sat, 10 Feb 2001 11:53:14 +0000 (11:53 +0000)]
Add description.
Bruce Momjian [Sat, 10 Feb 2001 11:46:00 +0000 (11:46 +0000)]
Add both conversion utilities.
Bruce Momjian [Sat, 10 Feb 2001 11:43:33 +0000 (11:43 +0000)]
cleanup
Bruce Momjian [Sat, 10 Feb 2001 11:43:12 +0000 (11:43 +0000)]
Add other mysql conversion utility for comparisons.
Bruce Momjian [Sat, 10 Feb 2001 11:31:35 +0000 (11:31 +0000)]
Allow -Bsymbolic on BSDI for ODBC.
Peter Eisentraut [Sat, 10 Feb 2001 10:27:28 +0000 (10:27 +0000)]
Fix on Linux
Tom Lane [Sat, 10 Feb 2001 08:30:13 +0000 (08:30 +0000)]
Minor improvements and copy-editing.
Bruce Momjian [Sat, 10 Feb 2001 07:11:28 +0000 (07:11 +0000)]
More ODBC formatting cleanup.
Tom Lane [Sat, 10 Feb 2001 07:08:44 +0000 (07:08 +0000)]
Fix example of syntactic ambiguity between prefix/infix/postfix operators
--- Postgres now accepts the example we claimed it wouldn't. Miscellaneous
copy-editing as well.
Bruce Momjian [Sat, 10 Feb 2001 07:01:19 +0000 (07:01 +0000)]
Run pgindent over ODBC source. We couldn't do this years ago because we
weren't the master source. We are now, and it really needs it.
Bruce Momjian [Sat, 10 Feb 2001 06:58:40 +0000 (06:58 +0000)]
Remove protocol-dependent code. This should have been on previous commit.
Bruce Momjian [Sat, 10 Feb 2001 06:57:53 +0000 (06:57 +0000)]
Cleanup
Bruce Momjian [Sat, 10 Feb 2001 06:12:15 +0000 (06:12 +0000)]
More cleanup, again not sure it works.
Bruce Momjian [Sat, 10 Feb 2001 05:55:17 +0000 (05:55 +0000)]
Clean up bad variable used in script. Still not sure it works under Linux.
Bruce Momjian [Sat, 10 Feb 2001 05:50:29 +0000 (05:50 +0000)]
Properly exit ODBC with 'X', allow linking on BSD/OS.
Tom Lane [Sat, 10 Feb 2001 05:32:33 +0000 (05:32 +0000)]
Fix documentation of EXECUTE, add documentation of FOR ... EXECUTE.
Tom Lane [Sat, 10 Feb 2001 04:07:25 +0000 (04:07 +0000)]
Fix byte-vs-word-width oversight in m68k TAS() code.
Man, this brings back some old memories ...
Tom Lane [Sat, 10 Feb 2001 03:57:42 +0000 (03:57 +0000)]
Update findoidjoins notes for 7.1.