| Commit message (Collapse) | Author | Age |
|
|
|
|
| |
fixes getIndexInfo throwing NullPointerException
fixes getIndexInfo improper results when multiple key indexs are used
|
| |
|
| |
|
|
|
|
| |
Also, 'fourty' -> 'forty'.
|
|
|
|
| |
is different from int).
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
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).
|
|
|
|
| |
backend startup.
|
|
|
|
|
|
| |
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.
|
|
|
|
| |
send() and probable process context swap during backend startup.
|
| |
|
|
|
|
| |
pghackers discussion.
|
| |
|
|
|
|
| |
to use separate LIMIT/OFFSET clauses.
|
| |
|
|
|
|
| |
'ifdef' in Makefile.
|
| |
|
| |
|
|
|
|
| |
Properly handles default values.
|
|
|
|
|
| |
elog(LOG, "XLogWrite: new log file created - "
"consider increasing 'wal_files' in postgresql.conf.");
|
| |
|
|
|
|
| |
Per Yoshinori Ariie's report.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
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.
|
| |
|
| |
|
| |
|
| |
|
|
|
|
|
|
| |
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.
|
|
|
|
|
|
|
| |
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.
|
|
|
|
|
|
|
|
| |
(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.
|
|
|
|
|
|
| |
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.
|
| |
|
|
|
|
|
|
|
| |
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.
|
|
|
|
| |
the CREATE DATABASE command right in pg_dump -C case.
|
|
|
|
|
| |
crash on Solaris when over disk quota. Instead, report such failures
via elog(DEBUG).
|
| |
|
|
|
|
| |
Patch from sugita@sra.co.jp.
|
| |
|
| |
|
| |
|
| |
|
| |
|
|
|
|
| |
inline routines do.
|
| |
|
|
|
|
|
|
| |
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.
|
|
|
|
| |
cturner@redhat.com.
|
|
|
|
|
| |
It would try to call the input conversion routines for them anyway.
So, a valid input string for the datatype had to be supplied.
|
|
|
|
| |
allows plperl routines to return NULL as intended.
|
|
|
|
|
|
|
| |
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.
|
| |
|
|
|
|
|
| |
value of TCL_SHLIB_LD in the shell script that creates Makefile.tcldefs,
rather than trying to persude gmake to do it.
|