aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
* 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.
* 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.
* 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.
* 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.
* 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
* New WAL version - CRC and data blocks backup.Vadim B. Mikheev2000-12-28
|
* Let's try this again on accepting the correct range of Oid input valuesTom Lane2000-12-28
| | | | for 64-bit platforms ...
* Fix portability problems recently exposed by regression tests on Alphas.Tom Lane2000-12-27
| | | | | | | | | | 1. Distinguish cases where a Datum representing a tuple datatype is an OID from cases where it is a pointer to TupleTableSlot, and make sure we use the right typlen in each case. 2. Make fetchatt() and related code support 8-byte by-value datatypes on machines where Datum is 8 bytes. Centralize knowledge of the available by-value datatype sizes in two macros in tupmacs.h, so that this will be easier if we ever have to do it again.
* Improve comments.Tom Lane2000-12-23
|
* Compute reasonable cost and output-row-count estimates for LIMIT planTom Lane2000-12-23
| | | | nodes.
* Replace overly-cute coding with code that (a) has defined behaviorTom Lane2000-12-23
| | | | | according to the ANSI C spec, (b) gets the boundary conditions right, and (c) is about a third as long and three times more intelligible.
* Small cleanup of temp-table handling. Disallow creation of a non-tempTom Lane2000-12-22
| | | | | | | table that inherits from a temp table. Make sure the right things happen if one creates a temp table, creates another temp that inherits from it, then renames the first one. (Previously, system would end up trying to delete the temp tables in the wrong order.)
* Repair not-too-well-thought-out code to do rangechecking of OIDs onTom Lane2000-12-22
| | | | 64-bit machines. Also, make oidvectorin use the same code as oidin.
* Avoid XLogFlush for clean buffers in BufferSync.Vadim B. Mikheev2000-12-22
|
* Improve error message for case where DROP TABLE is rejected becauseTom Lane2000-12-22
| | | | table has a child table.
* Add 'ONLY' to queries generated by RI triggers, so as to preserve pre-7.1Tom Lane2000-12-22
| | | | | semantics of RI operations. Eventually we ought to look at making RI work properly across inheritance trees, but not for 7.1 ...
* Change default output formatting for CIDR to be unabbreviated, perTom Lane2000-12-22
| | | | | | recommendation from Paul Vixie. Add a new abbrev() function to produce abbreviated format as text. No forced initdb, but new function is not available unless you do an initdb or add the pg_proc row manually.
* - Fixed bug in a connect statement using varchars.Michael Meskes2000-12-22
| | | | - Synced parser.
* Fix PQsetdbLogin() backward compatibility problem.Tatsuo Ishii2000-12-22
| | | | | | | | | | | | If pghost == "" and pgport == "" then PQsetdbLogin() fails with a error message: Is the postmaster running locally and accepting connections on Unix socket '/tmp/.s.PGSQL.0'? I see many applications such as PHP fails due to this behavior. Now if pgport == "", then it is assumed to be a DEF_PGPORT_STR. This is the same behavior as the version prior 7.1.
* Clean up CREATE TYPE/OPERATOR/AGGREGATE productions, so that parserTom Lane2000-12-22
| | | | will not accept types named with operator names or vice versa.
* In looking at the 7.1beta1 code for JDBC, I noticed that support wasBruce Momjian2000-12-22
| | | | | | | | | | | | | | | added to support character set encodings. However I noticed that the encoding that is used isn't obtained from the DB. Since Java uses unicode UCS2 internally the character set encoding is used to translate strings from/to the DB encoding. So it seems logical that the code would get the encoding from the DB instead of the current method of requiring the user pass it as a parameter. Attached is a patch that gets the DB encoding from the DB in the same manner as is done in libpq/fe-connect.c. The patch is created off of the latest CVS sources (Connection.java version 1.10). Barry Lind