summaryrefslogtreecommitdiff
path: root/src
AgeCommit message (Collapse)Author
2002-02-22Patch from Cormac TwomeyDave Cramer
fixes getIndexInfo throwing NullPointerException fixes getIndexInfo improper results when multiple key indexs are used
2002-02-22now compiles clean with jdk 1.4Dave Cramer
2002-02-20Fix comment.Tom Lane
2002-02-19Avoid failures in cash_out and cash_words for INT_MIN.Tom Lane
Also, 'fourty' -> 'forty'.
2002-02-19Add casts to suppress gcc warnings on Solaris (where apparently pid_tTom Lane
is different from int).
2002-02-19A bunch of changes aimed at reducing backend startup time...Tom Lane
Improve 'pg_internal.init' relcache entry preload mechanism so that it is safe to use for all system catalogs, and arrange to preload a realistic set of system-catalog entries instead of only the three nailed-in-cache indexes that were formerly loaded this way. Fix mechanism for deleting out-of-date pg_internal.init files: this must be synchronized with transaction commit, not just done at random times within transactions. Drive it off relcache invalidation mechanism so that no special-case tests are needed. Cache additional information in relcache entries for indexes (their pg_index tuples and index-operator OIDs) to eliminate repeated lookups. Also cache index opclass info at the per-opclass level to avoid repeated lookups during relcache load. Generalize 'systable scan' utilities originally developed by Hiroshi, move them into genam.c, use in a number of places where there was formerly ugly code for choosing either heap or index scan. In particular this allows simplification of the logic that prevents infinite recursion between syscache and relcache during startup: we can easily switch to heapscans in relcache.c when and where needed to avoid recursion, so IndexScanOK becomes simpler and does not need any expensive initialization. Eliminate useless opening of a heapscan data structure while doing an indexscan (this saves an mdnblocks call and thus at least one kernel call).
2002-02-19Remove some unnecessary pqsignal() calls to shave a few cycles offTom Lane
backend startup.
2002-02-19Arrange to call localtime() during postmaster startup. On most Unixen,Tom Lane
the first call of localtime() in a process will read /usr/lib/tztab or local equivalent. Better to do this once in the postmaster and inherit the data by fork() than to have to do it during every backend start.
2002-02-19Avoid calling pq_flush just after sending AUTH_REQ_OK; this saves oneTom Lane
send() and probable process context swap during backend startup.
2002-02-18Privileges on functions and procedural languagesPeter Eisentraut
2002-02-18Replace number-of-distinct-values estimator equation, per recentTom Lane
pghackers discussion.
2002-02-18Remove MAX/MIN() macros, use c.h Max/Min() instead.Bruce Momjian
2002-02-18Disable LIMIT #,# syntax, as agreed to months ago. Print message sayingBruce Momjian
to use separate LIMIT/OFFSET clauses.
2002-02-18Reorder postgresql.conf WAL section to be clearer.Bruce Momjian
2002-02-18Don't mention TIOGA in Makefile and move strdup.c rule into properBruce Momjian
'ifdef' in Makefile.
2002-02-18Add code to preserve paren level display after \g, as submitted months ago.Bruce Momjian
2002-02-18Remove compile warnings in multibute mode.Hiroshi Inoue
2002-02-18Fix param handling of create* admin scripts as described months ago.Bruce Momjian
Properly handles default values.
2002-02-18Add better error text:Bruce Momjian
elog(LOG, "XLogWrite: new log file created - " "consider increasing 'wal_files' in postgresql.conf.");
2002-02-18Add HTML output option to pgcvslog.Bruce Momjian
2002-02-18Fix kanji-coversion key binding. This has been broken since 7.1Tatsuo Ishii
Per Yoshinori Ariie's report.
2002-02-18The version is now 7.01.0010.Hiroshi Inoue
1) Handle parameter array. 2) Allow re-use of the connection handle after SQLDisconnect. 3) Reject NULL if no indicator specified. 4) Improve the handling of '_' in table name. 5) Unify internal begin/commit/abort operations. 6) Change SQLTables() to return null not "" for the table_owner. 7) Fix a bug about parameter handling reported by Benoit Menendez. 8) Add cast in handling ODBC date/time escape sequences. 9) Fix a bug about cache_size handing in declare/fetch mode. [ODBC3.0 related] 10) Improve the handling of descriptor handles(ODBC3.0). 11) Improve the type handling of some types for ODBC3.0. [Thanks to Marcelo Aceto for his useful patches] 12) Allow nested ODBC escape. 13) Allow changing autocommit on/off inside the transaction block. 14) Improve the handling of ODBC scalar functions.
2002-02-18Separate info30.c from info.c.Hiroshi Inoue
2002-02-18Add files for ODBC3.0 support.Hiroshi Inoue
2002-02-18Remove ODBC todo, add to main TODO.Bruce Momjian
2002-02-15Remove warning about automatic inclusion of sqlca.Peter Eisentraut
2002-02-14Ensure that a cursor is scanned under the same scanCommandId it wasTom Lane
originally created with, so that the set of visible tuples does not change as a result of other activity. This essentially makes PG cursors INSENSITIVE per the SQL92 definition. See bug report of 13-Feb-02.
2002-02-12Use RTLD_NOW, not RTLD_LAZY, as binding mode for dlopen() on all platforms.Tom Lane
This restores the Linux behavior to what it was in PG 7.0 and 7.1, and causes other platforms to agree. (Other well-tested platforms like HPUX were doing it this way already.) Per pghackers discussion over the past month or so.
2002-02-12Modify COPY TO to emit carriage returns and newlines as backslash escapesTom Lane
(backslash-r, backslash-n) for protection against newline-conversion munging. In future we will also tweak COPY FROM, but this part of the change should be backwards-compatible. Per pghackers discussion. Also, update COPY reference page to describe the backslash conversions more completely and accurately.
2002-02-11Tweak GiST code to work correctly on machines where 8-byte alignmentTom Lane
of pointers is required. Patch from Teodor Sigaev per pghackers discussion. It's an ugly kluge but avoids forcing initdb; we'll put a better fix into 7.3 or later.
2002-02-11Fix for old FreeBSD versions that don't have RTLD_GLOBALPeter Eisentraut
2002-02-11Repair problems with EvalPlanQual where target table is scanned asTom Lane
inner indexscan (ie, one with runtime keys). ExecIndexReScan must compute or recompute runtime keys even if we are rescanning in the EPQ case. TidScan seems to have comparable problems. Per bug noted by Barry Lind 11-Feb-02.
2002-02-11Be more wary about mixed-case database names and user names. GetTom Lane
the CREATE DATABASE command right in pg_dump -C case.
2002-02-10Don't Assert() that fsync() and close() never fail; I have seen thisTom Lane
crash on Solaris when over disk quota. Instead, report such failures via elog(DEBUG).
2002-02-08Move sys/types.h to top, for hiroyuki hanai/ FreeBSD.Bruce Momjian
2002-02-07pgstat's truncation of query string needs to be multibyte-aware.Tom Lane
Patch from sugita@sra.co.jp.
2002-02-07Removed a check for REINDEX TABLE.Hiroshi Inoue
2002-02-06Fix failure to reconnect as sequence's owner before issuing setval().Tom Lane
2002-01-30Update Win32-world version number of libpq++.Peter Eisentraut
2002-01-30Add cast to suppress gcc warning on Darwin platform.Tom Lane
2002-01-29updatePeter Eisentraut
2002-01-29Make S/390 TAS spell __inline__ the same way as the other eight GCCTom Lane
inline routines do.
2002-01-26Updates from Serguei MokhovPeter Eisentraut
2002-01-25Tweak pg_dump to say GRANT ALL when appropriate, rather than enumeratingTom Lane
the individual privilege bits. I regard this as an important change for cross-version compatibility: without this, a 7.1 dump loaded into 7.2 is likely to be short a few privileges.
2002-01-24Tweak plperl.c to compile against threaded Perls, per report fromTom Lane
cturner@redhat.com.
2002-01-24pltcl's spi_execp didn't handle NULL arguments quite correctly.Tom Lane
It would try to call the input conversion routines for them anyway. So, a valid input string for the datatype had to be supplied.
2002-01-24Fix incorrect test for whether Perl code is returning undef. ThisTom Lane
allows plperl routines to return NULL as intended.
2002-01-24Fix logic error in insert_fsm_page_entry: because compact_fsm_page_listTom Lane
removes any empty chunks, the chunk previously added won't be there anymore, so it's possible there is zero free space in the rel's page list afterwards. Must loop back and rerun the part that adds a chunk to the list.
2002-01-23Remove long-obsolete version of pltcl documentation.Tom Lane
2002-01-23Clean up Red Hat Tcl RPM brain-damage in a more reliable way: fix theTom Lane
value of TCL_SHLIB_LD in the shell script that creates Makefile.tcldefs, rather than trying to persude gmake to do it.