aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
...
* Update:Bruce Momjian2003-10-21
| | | | | < * Allow INET subnet tests to use indexes > * Allow INET subnet tests using non-constants to be indexed
* Cope with platforms that offer LONGLONG_MIN in place of the C99-specTom Lane2003-10-21
| | | | LLONG_MIN. One example is AIX, per report from Andreas.
* Revert to 7.3-and-before practice of only including <fcntl.h> in c.hTom Lane2003-10-21
| | | | on Windows; per complaint from Andreas that it breaks AIX build.
* Fix findLastBuiltinOid_V70() to deliver correct result when runningTom Lane2003-10-21
| | | | | | against a 7.0 server. Christopher Kings-Lynne
* Update per Tom:Bruce Momjian2003-10-21
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | < * Allow INET subnet tests using non-constants > * Allow INET subnet tests to use indexes 101a102 > o Allow MIN()/MAX() on arrays 144c145 < * Allow CREATE INDEX zman_index ON test (date_trunc( 'day', zman ) datetime_ops) > * -Allow CREATE INDEX zman_index ON test (date_trunc( 'day', zman ) datetime_ops) 166c167 < * Improve handling of index scans for NULL > * Allow use of indexes to search for NULLs 203a205 > * Add optional textual message to NOTIFY 252c254 < o Add SET SCHEMA > o Add SET PATH for schemas 297a300 > * Allow fastpast to pass values in portable format 344a348 > * Allow statement-level triggers to access modified rows 526d529 < o Add optional textual message to NOTIFY 530d532 < o Allow fastpast to pass values in portable format 533c535 < o Special passing of binary values in platform-neutral format (bytea?) > o -Special passing of binary values in platform-neutral format (bytea?)
* Add release info about dollar signs to migration section:Bruce Momjian2003-10-21
| | | | | | | <listitem><para> Dollar sign (<literal>$</>) is no longer allowed in operator names</para></listitem> <listitem><para> Dollar sign (<literal>$</>) can be a non-first character in identifiers</para></listitem>
* Update catalog version after information schema changes.Peter Eisentraut2003-10-20
|
* Complain if pg_restore is given both -d and -f options; this suggestsTom Lane2003-10-20
| | | | the user is confused about whether -f is input or output file.
* It is possible for ResolveNew to be used to insert a sublink into aTom Lane2003-10-20
| | | | | | | | | | subquery that didn't previously have one. We have traditionally made the caller of ResolveNew responsible for updating the hasSubLinks flag of the outermost query, but this fails to account for hasSubLinks in subqueries. Fix ResolveNew to handle this. We might later want to change the calling convention of ResolveNew so that it can fix the outer query too, simplifying callers. But I went with the localized fix for now. Per bug report from J Smith, 20-Oct-03.
* Improve error reporting in parseTypeString(), motivated by confusingTom Lane2003-10-20
| | | | behavior reported by Martin Marques.
* Install dummy sqlda.h file since this is needed for compatibility.Michael Meskes2003-10-20
|
* When building shared libraries on HPUX with gcc, forcibly include -lgccTom Lane2003-10-20
| | | | | | | | | to ensure any needed compiler support routines are included. This is arguably appropriate on *every* gcc platform, but for the moment I'll take the conservative approach of only doing it on a platform where it's provably useful. Per complaint from Heiko Lehmann, 13-Feb-03, as well as personal experience --- contrib/pgstattuple has never worked for me, but it does now.
* Save_r, Save_t should be static not global variables.Tom Lane2003-10-19
|
* Update README file to show 7.4 oidjoins relationships. The regressionTom Lane2003-10-19
| | | | test was updated previously, but documentation is lagging.
* Adjust libpq to avoid deadlock when both client and server want to sendTom Lane2003-10-19
| | | | | | data, and both have filled the transmission buffers. One scenario where this can happen was illustrated here: http://archives.postgresql.org/pgsql-hackers/2003-04/msg00979.php
* Check for both Informix modes when parsing include files.Michael Meskes2003-10-19
|
* Cleanup on --help-config: Now called --describe-config, no further options,Peter Eisentraut2003-10-18
| | | | | machine readable, without headers, not sorted. Parameter descriptions adjusted to fit first sentence + rest convention.
* Further work on information_schema. _pg_keyissubset() wasn't quiteTom Lane2003-10-18
| | | | | | | | | | fully search-path-proof yet; also, element_types view did not work for parameters and result types of functions, because it didn't generate the object_name for the function the same way the data_type_privileges view does. While at it, centralize dependencies on INDEX_MAX_KEYS/ FUNC_MAX_ARGS into a function returning setof int, so that it will be easier to fix information_schema for nonstandard values of these parameters.
* Repair interaction between IN-join processing and subselect pullup thatTom Lane2003-10-18
| | | | | I inadvertently broke a few days ago (per report from Sean Thomas). Add regression test case to try to catch any similar breakage in future.
* Simplify loop test to avoid bug in AIX compiler, per Andreas.Tom Lane2003-10-18
|
* Information schema fixes:Peter Eisentraut2003-10-18
| | | | | | | | Use pg_get_constraintdef instead of pg_constraint.consrc Use UNION ALL instread of UNION Make use of regclass type for getting OID of system catalogs Add schema qualifications where necessary Fix typos
* Must free the pgParameterStatus chain in freePGconn(). My fault,Tom Lane2003-10-18
| | | | well spotted by Neil Conway.
* Document all the system views created by initdb (several of these wereTom Lane2003-10-17
| | | | | never documented anywhere, sigh). Centralize the detailed documentation of system views into catalogs.sgml, and provide cross-references.
* Add a listing of our SQLSTATE error codes to the documentation.Tom Lane2003-10-17
| | | | Link to it from some appropriate places.
* Fix busted markup.Tom Lane2003-10-17
|
* Fix elog tab-insertion code to insert tabs only where wanted.Tom Lane2003-10-17
|
* Remove automatic '()' in other branch of UNION as well.Peter Eisentraut2003-10-17
|
* Adjust display of actual runtimes in EXPLAIN output to use three fractionalTom Lane2003-10-17
| | | | | digits, and label it 'ms' not 'msec', for consistency with psql's \timing display. Per recent discussions.
* Use pg_get_constraintdef() rather than pg_constraint.consrc; this isTom Lane2003-10-17
| | | | | a portion of a patch recently submitted by Christopher Kings-Lynne. Applied by agreement that this is a bug fix.
* Add note deprecating use of consrc.Tom Lane2003-10-17
|
* Fix bugs in referential_constraints view.Peter Eisentraut2003-10-16
|
* There should not be an automatic '()' after a function name whenPeter Eisentraut2003-10-16
| | | | tab-completing.
* Set attstattarget to -1 for all system catalog columns. All but a fewTom Lane2003-10-16
| | | | | | | | | | | of the entries used to be zero, which I think I had deliberately done in the name of saving cycles during ANALYZE, but it was really a rather foolish decision. Some of the more complex views in information_schema were getting really bad plans for lack of statistics on the columns they were joining over. I'm not forcing an initdb for this, but I think there will be one soon anyway to repair some bugs in the information_schema views.
* Avoid division by zero in estimate_num_groups() when table has no rows.Tom Lane2003-10-16
|
* Ensure that all places that are complaining about exhaustion of sharedTom Lane2003-10-16
| | | | | | | | memory say 'out of shared memory'; some were doing that and some just said 'out of memory'. Also add a HINT about increasing max_locks_per_transaction where relevant, per suggestion from Sean Chittenden. (The former change does not break the strings freeze; the latter does, but I think it's worth doing anyway.)
* Cause tab completion to do something moderately reasonable with mixed-caseTom Lane2003-10-16
| | | | | identifiers --- it will now complete these correctly with double quoting. Fix a few other issues in passing.
* Add mention of SIGHUP on the postmaster manual page.Bruce Momjian2003-10-16
|
* Fix bad interaction between NOTIFY processing and V3 extended queryTom Lane2003-10-16
| | | | | | | | | | protocol, per report from Igor Shevchenko. NOTIFY thought it could do its thing if transaction blockState is TBLOCK_DEFAULT, but in reality it had better check the low-level transaction state is TRANS_DEFAULT as well. Formerly it was not possible to wait for the client in a state where the first is true and the second is not ... but now we can have such a state. Minor cleanup in StartTransaction() as well.
* Minor copy-editing.Tom Lane2003-10-16
|
* Add:Bruce Momjian2003-10-16
| | | | > * Allow pg_dump to dump CREATE CONVERSION (Christopher)
* Fix SGML markup.Bruce Momjian2003-10-16
| | | | Update HISTORY file.
* This patch adds another item to the "migration to 7.4" list in theBruce Momjian2003-10-16
| | | | | | | HISTORY file, and attributes the shared-buffer-alignment change to Manfred Spraul. Neil Conway
* I have run pg_autovacuum on AIX, so that can, at least loosely, beBruce Momjian2003-10-16
| | | | | | | | | considered "tested." And I have turned all of the 7.4 HISTORY material into DocBook for release.sgml Christopher Browne
* Cause the default CFLAGS to be -O2 -fno-strict-aliasing when using gcc,Tom Lane2003-10-15
| | | | | per recent pghackers discussions. Also ensure that explicitly setting CFLAGS in the configure environment will be honored.
* Translation updatesPeter Eisentraut2003-10-15
|
* New translationPeter Eisentraut2003-10-15
|
* Translation updatePeter Eisentraut2003-10-15
|
* New translationPeter Eisentraut2003-10-15
|
* Use PQescapeString to ensure that tab-completion queries are not messedTom Lane2003-10-14
| | | | | | | up by quotes or backslashes in words that are being matched to database names (per gripe from Ian Barwick, though I didn't use his patch). Also fix possible memory leakage if _complete_with_query isn't run to completion (not clear if that can happen or not, but be safe).
* Remove void* in MemSet until we understand the gcc 3.3.1 problem better.Bruce Momjian2003-10-14
|