summaryrefslogtreecommitdiff
AgeCommit message (Collapse)Author
2001-02-20Changes:Bruce Momjian
* reverse the change #include <> -> "" in krb.c. It _must not_ include files in "." * Makefile update. Inconsistent var usage and SHLIB was not set. Now it should work with all external libs. arko Kreen
2001-02-20Truncate incoming username and database name to NAMEDATALEN-1 charactersTom Lane
so that we don't reject overlength names unnecessarily.
2001-02-20Update HPUX FAQ.Bruce Momjian
2001-02-20Fix pg_passwd's failure to cope with usernames > 8 chars.Tom Lane
2001-02-20Remove inclusion of <varargs.h> on SunOS; this does not work since weTom Lane
use the ANSI varargs style (<stdarg.h>) not the old style. Tatsuo had reported this change was necessary back in the 7.0 beta cycle (4/13/00) but for some reason, making the edit never got done.
2001-02-19Document --enable-cassert.Tom Lane
2001-02-19Update TODO list.Bruce Momjian
2001-02-19Update TODO list.Bruce Momjian
2001-02-19Change plpgsql's GET DIAGNOSTICS statement to use SQL99-compatibleTom Lane
syntax. Fix the RESULT_OID case, which never worked. Add documentation.
2001-02-19Update TODO list.Bruce Momjian
2001-02-19Update TODO list.Bruce Momjian
2001-02-19Update TODO list.Bruce Momjian
2001-02-19Synced gram.y and preproc.y.Michael Meskes
2001-02-19Fix nasty bug in configure.Tatsuo Ishii
STRTOL='strtoul.o' --> STRTOUL='strtoul.o'
2001-02-19Update example of partially constraining join order to use a subselectTom Lane
in FROM instead of an auxiliary view. We didn't have subselect-in-FROM when I wrote this originally...
2001-02-19AND/OR truth table needs another row IMHO.Tom Lane
2001-02-18Add copyright mentions, per Tom Lane.Bruce Momjian
2001-02-18Allow extract() to accept the same field selectors as date_part(), not justPeter Eisentraut
the ones specified by SQL.
2001-02-18Add --template option to createdb script to allow access to WITH TEMPLATETom Lane
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.
2001-02-18Enhance documentation of date/time functions. Add extract, current_date,Peter Eisentraut
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.
2001-02-18Make <lineannotation> italic. Fix syntax error in print style.Peter Eisentraut
2001-02-18Add note that partial indices are not currently supported.Tom Lane
2001-02-18Update description of fsync option for 7.1.Tom Lane
2001-02-18Change default commit_delay to zero, update documentation.Tom Lane
2001-02-18Change s_lock to not use any zero-delay select() calls; these are just aTom Lane
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.
2001-02-18Remove bogus set_ps_display call --- changing displayed status here isTom Lane
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.
2001-02-17Catch some stray references to .htm files.Tom Lane
2001-02-17No more .htm files, so don't try to add them to the doc tarballs.Tom Lane
2001-02-17Update TODO list.Bruce Momjian
2001-02-17Fix a bug in psql. unescape() does not work for multi-byte encodings.Tatsuo Ishii
2001-02-17Fix README in Japanese to sync with README.pgbench updated by Tom.Tatsuo Ishii
(thanks!)
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-16Update README's install instructions to agree with current reality.Tom Lane
2001-02-16Update bsdi shared memory stuff.Bruce Momjian
2001-02-16Update BSDI FAQ.Bruce Momjian
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-16Update BSDI SGML.Bruce Momjian
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-16Update bsdi faq.Bruce Momjian
2001-02-16Update bsdi faq.Bruce Momjian
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-15Update FAQ.Bruce Momjian
2001-02-15Update FAQ.Bruce Momjian