summaryrefslogtreecommitdiff
path: root/src
AgeCommit message (Collapse)Author
2001-02-17Fix a bug in psql. unescape() does not work for multi-byte encodings.Tatsuo Ishii
2001-02-17Seems a bad idea to assume that select(2) doesn't touch the input masksTom Lane
if it returns EINTR.
2001-02-17Add current seek position to FDDEBUG output for FileRead,Tom Lane
FileWrite, FileSeek.
2001-02-16Just noticed that use of 'volatile' in HPPA S_UNLOCK() was causing gccTom Lane
to generate unnecessarily stupid code. Tweak macro to describe a series of store-constant ops, not store/load/store/load/store/load/store.
2001-02-16Defend against starting a non-MULTIBYTE-enabled backend in a databaseTom Lane
with encoding other than SQL_ASCII. Per recent discussion in pghackers.
2001-02-16Some more updates...Peter Mount
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.
2001-02-16ichar() has been renamed to chr(), so fix translation table.Tom Lane
2001-02-16Fix bugs in pltcl's new return_null command: it was liable to go belly upTom Lane
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.
2001-02-16Fix erroneous sort request in pltcl selftest.Tom Lane
2001-02-16Clean up two rather nasty bugs in operator selection code.Tom Lane
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
2001-02-16Add casting for numeric/float4/float8 type valueHiroshi Inoue
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.
2001-02-16Take OUTER JOIN semantics into account when estimating the size of joinTom Lane
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 ...
2001-02-15Add some notes about memory management of RI plans.Tom Lane
2001-02-15Update comments about memory management.Tom Lane
2001-02-15Update notes about memory context scheme.Tom Lane
2001-02-15Although we can't support out-of-line TOAST storage in indexes (yet),Tom Lane
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.
2001-02-15Reduce default selectivity estimates for geometric operators; it seemsTom Lane
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 ...
2001-02-15Update a couple of obsolete comments.Tom Lane
2001-02-151) Change transaction boundary in autocommit off modeHiroshi Inoue
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).
2001-02-15Unicode <-> SJIS new mapping tables (based on CP932.TXT) contributed byTatsuo Ishii
Eiji Tokuya" <e-tokuya@Mail.Sankyo-Unyu.co.jp>
2001-02-15Arrange for ORDER BY an expression on a UNION/INTERSECT/EXCEPT result,Tom Lane
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...
2001-02-14Repair problems with duplicate index names generated when CREATE TABLETom Lane
specifies redundant UNIQUE conditions.
2001-02-14Change scoping of table and join refnames to conform to SQL92: a JOINTom Lane
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.
2001-02-14Web Feb 14 17:29:00 GMT 2001 peter@retep.org.ukPeter Mount
- 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
2001-02-14Add 7.X to dialog box.Bruce Momjian
2001-02-14Back out all ODBC formatting changes, and back out removal of <6.4Bruce Momjian
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.
2001-02-13Comments about GetFreeXLBuffer().Vadim B. Mikheev
GetFreeXLBuffer(): use Insert->LgwrResult instead of private LgwrResult copy if it's more fresh (attempt to avoid acquiring info_lck/lgwr_lck).
2001-02-13Some more including the patch to DatabaseMetaData backed out by Bruce.Peter Mount
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.
2001-02-13Remove postgresql jdbc files, per Peter.Bruce Momjian
2001-02-13Remove postgresql jdbc files, per Peter Mount.Bruce Momjian
2001-02-13Back out *inv* changes for this file. Peter want to handle it.Bruce Momjian
2001-02-13Remove unused files, per AndreasBruce Momjian
2001-02-13Please apply the following patch to fix AIX and IRIX timestamp behaviorBruce Momjian
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
2001-02-13Removed abort() in XLogFileOpen.Vadim B. Mikheev
2001-02-13Added some comments to setval, setval_is_called and do_setvalPhilip Warner
2001-02-13- Fix help output: replace 'f' with 't' and change descPhilip Warner
- 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
2001-02-13Clean up portability problems in regexp package: change all routineTom Lane
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.
2001-02-12Attached is a makefile for the ODBC driver for use under win32. It has beenBruce Momjian
tested only with MS VC++ 6.0SP4 using nmake. Dave Page
2001-02-12Hmm, this isn't used either.Tom Lane
2001-02-12Remove unused and largely-broken-anyway compatibility defs.Tom Lane
2001-02-12New MS resource file, pgindented.Bruce Momjian
2001-02-12Suppress compiler warning on Alpha.Tom Lane
2001-02-12Rearrange order of operations in heap_create_with_catalog so that ifTom Lane
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.
2001-02-12CleanupBruce Momjian
2001-02-12Add // -> /* */ mapping to pgindent.Bruce Momjian
2001-02-12Update ODBC resource MS-generated file.Bruce Momjian
2001-02-12Change more // comments.Bruce Momjian
2001-02-12Remove // and make /* */Bruce Momjian
2001-02-12Replace // comments from file for MS products.Bruce Momjian
2001-02-12poit -> point.Bruce Momjian