aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
...
* Add casting for numeric/float4/float8 type valueHiroshi Inoue2001-02-16
| | | | | | | | | | | 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.
* Update bsdi faq.Bruce Momjian2001-02-16
|
* Update bsdi faq.Bruce Momjian2001-02-16
|
* Take OUTER JOIN semantics into account when estimating the size of joinTom Lane2001-02-16
| | | | | 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 ...
* Update FAQ.Bruce Momjian2001-02-15
|
* Update FAQ.Bruce Momjian2001-02-15
|
* Add some notes about memory management of RI plans.Tom Lane2001-02-15
|
* Update comments about memory management.Tom Lane2001-02-15
|
* Update notes about memory context scheme.Tom Lane2001-02-15
|
* Update obsolete wording of error message.Tom Lane2001-02-15
|
* Although we can't support out-of-line TOAST storage in indexes (yet),Tom Lane2001-02-15
| | | | | | | | 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.
* Further polishing of documentation about new fmgr call convention.Tom Lane2001-02-15
|
* Reduce default selectivity estimates for geometric operators; it seemsTom Lane2001-02-15
| | | | | | | 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 ...
* Update a couple of obsolete comments.Tom Lane2001-02-15
|
* Update TODO list.Bruce Momjian2001-02-15
|
* Update TODO list.Bruce Momjian2001-02-15
|
* Update for Tatsuo.Bruce Momjian2001-02-15
|
* 1) Change transaction boundary in autocommit off modeHiroshi Inoue2001-02-15
| | | | | | | | | | 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).
* Clarify meaning of GEQO_THRESHOLD parameter.Tom Lane2001-02-15
|
* Improve documentation of JOIN syntax. Explain NATURAL as an alternativeTom Lane2001-02-15
| | | | | to ON and USING for specifying the join condition, not as an independent kind of join semantics.
* Unicode <-> SJIS new mapping tables (based on CP932.TXT) contributed byTatsuo Ishii2001-02-15
| | | | Eiji Tokuya" <e-tokuya@Mail.Sankyo-Unyu.co.jp>
* Arrange for ORDER BY an expression on a UNION/INTERSECT/EXCEPT result,Tom Lane2001-02-15
| | | | | | | | | | 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...
* Repair problems with duplicate index names generated when CREATE TABLETom Lane2001-02-14
| | | | specifies redundant UNIQUE conditions.
* Change scoping of table and join refnames to conform to SQL92: a JOINTom Lane2001-02-14
| | | | | | | | | 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.
* Alter documentation of boolean type, add example. Someone figured that itPeter Eisentraut2001-02-14
| | | | | | | wasn't clear that the "boolean type" was actually called "boolean". Add tip about "casting" booleans using CASE. Spell check whole file.
* Format <structname>, <structfield>, and <type> mono-spaced.Peter Eisentraut2001-02-14
|
* Web Feb 14 17:29:00 GMT 2001 peter@retep.org.ukPeter Mount2001-02-14
| | | | | | - 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
* Update TODO list.Bruce Momjian2001-02-14
|
* Add 7.X to dialog box.Bruce Momjian2001-02-14
|
* Back out all ODBC formatting changes, and back out removal of <6.4Bruce Momjian2001-02-14
| | | | | | 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.
* Update TODO list.Bruce Momjian2001-02-14
|
* Hmm, so referencing a CSS stylesheet when there isn't one doesn't workPeter Eisentraut2001-02-13
| | | | everywhere.
* Fix markup.Peter Eisentraut2001-02-13
|
* Didn't work when Makefile.custom is missing.Peter Eisentraut2001-02-13
|
* Custom DSSSL stylesheet. Style changes included here:Peter Eisentraut2001-02-13
| | | | | | | | | | | | 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
* Fix tag.Peter Eisentraut2001-02-13
|
* Update TODO list.Bruce Momjian2001-02-13
|
* Update TODO list.Bruce Momjian2001-02-13
|
* Comments about GetFreeXLBuffer().Vadim B. Mikheev2001-02-13
| | | | | GetFreeXLBuffer(): use Insert->LgwrResult instead of private LgwrResult copy if it's more fresh (attempt to avoid acquiring info_lck/lgwr_lck).
* Some more including the patch to DatabaseMetaData backed out by Bruce.Peter Mount2001-02-13
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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.
* Remove postgresql jdbc files, per Peter.Bruce Momjian2001-02-13
|
* Remove postgresql jdbc files, per Peter Mount.Bruce Momjian2001-02-13
|
* Update TODO list.Bruce Momjian2001-02-13
|
* Back out *inv* changes for this file. Peter want to handle it.Bruce Momjian2001-02-13
|
* Remove unused files, per AndreasBruce Momjian2001-02-13
|
* Please apply the following patch to fix AIX and IRIX timestamp behaviorBruce Momjian2001-02-13
| | | | | | | | | | | | | | | 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
* Removed abort() in XLogFileOpen.Vadim B. Mikheev2001-02-13
|
* Added some comments to setval, setval_is_called and do_setvalPhilip Warner2001-02-13
|
* - Fix help output: replace 'f' with 't' and change descPhilip Warner2001-02-13
| | | | | | - 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
* Clean up portability problems in regexp package: change all routineTom Lane2001-02-13
| | | | | | 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.