aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Clean up some unnecessary fragility in EXECUTE command.Tom Lane2001-01-04
|
* Repair guaranteed core dump in SPI_exec(). Guess this routine wasn'tTom Lane2001-01-04
| | | | used before ...
* I neglected to remove a debug message,sorry.Hiroshi Inoue2001-01-04
|
* pg_dump failed to handle backslashes embedded in function definitionsTom Lane2001-01-04
| | | | | (and most other places where it needed to output a string literal, too, except for data INSERT statements). Per bug report from Easter, 12/1/00.
* Fix breakage of rules using NOTIFY actions, per bug report and patchTom Lane2001-01-03
| | | | from sergiop@sinectis.com.ar.
* New file format for COPY BINARY, in accordance with pghackers discussionsTom Lane2001-01-03
| | | | of early December 2000. COPY BINARY is now TOAST-safe.
* MakeRetrieveViewRuleName was scribbling on memory that didn't belongTom Lane2001-01-03
| | | | to it. Bad dog.
* Repair always-broken date_part('quarter',timestamp).Thomas G. Lockhart2001-01-03
| | | | | | | Previous result did not have correct month boundaries so anything near edge cases was suspect (e.g. April was in Q1 and July, August were lumped into Q2). Thanks to Denis Osadchy <osadchy@turbo.nsk.su> for the report.
* Update TODO list.Bruce Momjian2001-01-03
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Index: TODO =================================================================== RCS file: /home/projects/pgsql/cvsroot/pgsql/doc/TODO,v retrieving revision 1.311 diff -r1.311 TODO 3c3 < Last updated: Tue Jan 2 21:23:11 EST 2001 --- > Last updated: Wed Jan 3 01:56:41 EST 2001 10c10 < A dash(-) marks changes that will appear in the upcoming 7.1 release. --- > A dash (-) marks changes that will appear in the upcoming 7.1 release. 23c23 < * -Creating index of TIMESTAMP & RELTIME fails, or rename to DATETIME(Thomas) --- > * -Creating index of TIMESTAMP & RELTIME fails, or rename to DATETIME (Thomas) 35c35 < * -Views containing aggregates sometimes fail(Jan) --- > * -Views containing aggregates sometimes fail (Jan) 37,38c37,38 < duplicates(inherit) < * -Disallow LOCK on view(Mark Hollomon) --- > duplicates (inherit) > * -Disallow LOCK on view (Mark Hollomon) 58,60c58,60 < * -Add OUTER joins, left and right[outer](Tom, Thomas) < * -Allow long tuples by chaining or auto-storing outside db (TOAST)(Jan) < * Fix memory leak for expressions[memory](Tom?) --- > * -Add OUTER joins, left and right[outer] (Tom, Thomas) > * -Allow long tuples by chaining or auto-storing outside db (TOAST) (Jan) > * Fix memory leak for expressions[memory] (Tom?) 70c70 < * Allow row re-use without vacuum(Vadim) --- > * Allow row re-use without vacuum (Vadim) 74c74 < * More access control over who can create tables and use locks(Karel) --- > * More access control over who can create tables and use locks (Karel) 92c92 < o -Fix large object mapping scheme, own typeid or reltype(Peter) --- > o -Fix large object mapping scheme, own typeid or reltype (Peter) 97c97 < * Fix improper masking of some inet/cidr types [cidr] --- > * -Fix improper masking of some inet/cidr types [cidr] 113c113 < * Get BIT type working --- > * -Get BIT type working 119c119 < * Update macaddr manufacturer numbers, or remove the function macaddr_manuf() --- > * -Update macaddr manufacturer numbers, or remove the function macaddr_manuf() 147c147 < * -Add ALTER TABLE ALTER COLUMN feature(Peter E) --- > * -Add ALTER TABLE ALTER COLUMN feature (Peter E) 157c157 < * Auto-destroy sequence on DROP of table with SERIAL(Ryan) --- > * Auto-destroy sequence on DROP of table with SERIAL (Ryan) 166a167 > * Allow INSERT INTO tab (col1, ..) VALUES (val1, ..), (val2, ..) 172d172 < * Allow INSERT INTO tab (col1, ..) VALUES (val1, ..), (val2, ..) 176c176 < * Make NULL's come out at the beginning or end depending on the --- > * Make NULL's come out at the beginning or end depending on the 220c220 < * Certain indexes will not shrink, i.e. oid indexes with many inserts(Vadim) --- > * Certain indexes will not shrink, i.e. oid indexes with many inserts (Vadim) 226c226 < with after-row images(Vadim) [logging](Vadim) --- > with after-row images (Vadim) [logging] 232c232 < * -Redesign the function call interface to handle NULLs better[function](Tom) --- > * -Redesign the function call interface to handle NULLs better[function] (Tom) 239c239 < * Encrpyt passwords in pg_shadow table using MD5(Vince) --- > * Encrpyt passwords in pg_shadow table using MD5 (Vince) 298a299,300 > * Create a transaction processor to aid in persistent connections and > connection pooling 307c309 < * Remove SET KSQO option now that OR processing is improved(Tom) --- > * Remove SET KSQO option now that OR processing is improved (Tom)
* Update TODO list.Bruce Momjian2001-01-03
| | | | | | | | | | | | | | Index: TODO =================================================================== RCS file: /home/projects/pgsql/cvsroot/pgsql/doc/TODO,v retrieving revision 1.310 diff -r1.310 TODO 3c3 < Last updated: Wed Dec 27 00:44:44 EST 2000 --- > Last updated: Tue Jan 2 21:23:11 EST 2001 310a311 > * Allow libedit to be used in place of libreadline
* Only update stamp-h if config.status actually looks at config.h.Peter Eisentraut2001-01-02
|
* I've found a memory leak in libecpg of PostgreSQL 7.0.3.Bruce Momjian2001-01-02
| | | | | | | | | The leak is caused by the memory allocation in src/interfaces/ecpg/lib/execute.c in line 669 which is never freed. Adding a "free(array_query);" after PQexec in line 671 seems to fix the leak. Thorsten Knabe
* Document tuple ordering differences as a possible cause ofTom Lane2001-01-02
| | | | regression test 'failures'.
* Clean up non-reentrant interface for hash_seq/HashTableWalk, so thatTom Lane2001-01-02
| | | | | | | | starting a new hashtable search no longer clobbers any other search active anywhere in the system. Fix RelationCacheInvalidate() so that it will not crash or go into an infinite loop if invoked recursively, as for example by a second SI Reset message arriving while we are still processing a prior one.
* Tweak temporary-installation setup so that it doesn't break when theTom Lane2001-01-02
| | | | configured install --prefix begins with /data/...
* Update geometry-alpha-precision.out per reports from Brent Verner andTom Lane2001-01-01
| | | | Adriaan Joubert.
* Define HAVE_LIBZ only if we detect <zlib.h> as well as libz.a/.so.Tom Lane2001-01-01
| | | | Otherwise, build falls over on a machine with a non-devel RPM of libz.
* CLUSTER forgot to create a TOAST table for the clustered relation.Tom Lane2001-01-01
|
* Ensure attcacheoff is written out as -1 when writing pg_attributeTom Lane2001-01-01
| | | | tuples for a relation. Needed to prevent Assert failure in CLUSTER.
* Update comment.Tom Lane2001-01-01
|
* Mark geometric 'overlaps' operators (&&) as self-commutative.Tom Lane2000-12-31
|
* Fix typo in error message.Tom Lane2000-12-31
|
* Don't say 'export PGHOST' or 'export PGPORT' unless we actually defineTom Lane2000-12-31
| | | | | those variables. Some shells will invent an empty-string definition in this case, which is not what we want.
* On further thought, we need a defense against empty PGPORT here too.Tom Lane2000-12-31
|
* Ignore PGPORT environment variable if it is an empty string.Tom Lane2000-12-31
|
* Reverse #if test to be defined(__osf__) rather than not-any-of-a-lot-Tom Lane2000-12-31
| | | | of-others.
* Remove incorrect use of rl_special_prefixes until further evaluation.Peter Eisentraut2000-12-31
|
* NetBSD/Alpha porting fixes from tom@minnesota.com.Tom Lane2000-12-31
|
* Be more careful about the difference between signed and unsigned ints.Tom Lane2000-12-30
| | | | Bug is revealed by OID regress test on 64-bit platforms.
* Correct UNDER syntax.Peter Eisentraut2000-12-30
|
* Correct UNDER syntax.Peter Eisentraut2000-12-30
|
* RefinementsPeter Eisentraut2000-12-30
|
* Remove C++ comment.Peter Eisentraut2000-12-30
|
* 1. WAL needs in zero-ed content of newly initialized page.Vadim B. Mikheev2000-12-30
| | | | | 2. Log record for PageRepaireFragmentation now keeps array of !LP_USED offnums to redo cleanup properly.
* Add mention of sysctl(8) for IPC tuning on Linux.Peter Eisentraut2000-12-30
|
* Remove incorrect assert.Peter Eisentraut2000-12-30
|
* Fixed misprint in heap update WALoging.Vadim B. Mikheev2000-12-30
|
* Imporve messages.Tatsuo Ishii2000-12-30
|
* Apparently, special float8 comparison file for Alpha is only neededTom Lane2000-12-30
| | | | when using vendor cc, not gcc.
* Clean up spinlock assembly code slightly (just cosmetic improvements)Tom Lane2000-12-30
| | | | | | | | | for Alpha gcc case. For Alpha non-gcc case, replace use of __INTERLOCKED_TESTBITSS_QUAD builtin with __LOCK_LONG_RETRY and __UNLOCK_LONG. The former does not execute an MB instruction and therefore was guaranteed not to work on multiprocessor machines. The LOCK_LONG builtins produce code that is the same in all essential details as the gcc assembler code.
* Paranoia about possible values of errno after a shmget/semget failure.Tom Lane2000-12-30
| | | | | | In theory we should always get EEXIST if there's a key collision, but if the kernel code tests error conditions in a weird order, perhaps EACCES or EIDRM could occur too.
* Remove obsolete and unportable enable_plpgsql script. createlang hasTom Lane2000-12-30
| | | | been the supported and documented way to do this for a long time...
* Fix unportable use of '!' in shell commands.Peter Eisentraut2000-12-30
|
* column and tuple numbers should be int not size_t.Tom Lane2000-12-29
|
* Fix failure in CreateCheckPoint on some Alpha boxes --- it's not OK toTom Lane2000-12-29
| | | | | | | assume that TAS() will always succeed the first time, even if the lock is known to be free. Also, make sure that code will eventually time out and report a stuck spinlock, rather than looping forever. Small cleanups in s_lock.h, too.
* MUST update (in-memory) data page BEFORE XLogInsert to logVadim B. Mikheev2000-12-29
| | | | NEW page content if WAL will decide to backup page.
* stamp-h needs to be made by config.status, not elsewhere, per recipe inTom Lane2000-12-29
| | | | | Autoconf manual. In particular, touching it before creating config.status is guaranteed to lose.
* nbtree_xlog_newroot: set meta flag in meta page opaque.Vadim B. Mikheev2000-12-29
|
* Attached are patches for two fixes to reduce memory usage by the JDBCBruce Momjian2000-12-28
| | | | | | | | | | | | | | | | | | | | | | | | drivers. The first fix fixes the PreparedStatement object to not allocate unnecessary objects when converting native types to Stings. The old code used the following format: (new Integer(x)).toString() whereas this can more efficiently be occompilshed by: Integer.toString(x); avoiding the unnecessary object creation. The second fix is to release some resources on the close() of a ResultSet. Currently the close() method on ResultSet is a noop. The purpose of the close() method is to release resources when the ResultSet is no longer needed. The fix is to free the tuples cached by the ResultSet when it is closed (by clearing out the Vector object that stores the tuples). This is important for my application, as I have a cache of Statement objects that I reuse. Since the Statement object maintains a reference to the ResultSet and the ResultSet kept references to the old tuples, my cache was holding on to a lot of memory. Barry Lind
* Qualify %.in rule to avoid triggering on configure.in, repair unportablePeter Eisentraut2000-12-28
| | | | | attempt to install more than one file per 'install' invocation, clean up some other oddities.