- 20 2月, 2002 8 次提交
-
-
由 Bruce Momjian 提交于
> * Make single-user local access permissions the default by limiting > permissions on the socket file (Peter E)
-
由 Bruce Momjian 提交于
--- > * Improve caching of attribute offsets when NULLs exist in the row
-
由 Tom Lane 提交于
is different from int).
-
由 Bruce Momjian 提交于
> * -Cache system catalog information in per-database files (Tom)
-
由 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).
-
由 Tom Lane 提交于
backend startup.
-
由 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.
-
由 Tom Lane 提交于
send() and probable process context swap during backend startup.
-
- 19 2月, 2002 5 次提交
-
-
由 Peter Eisentraut 提交于
-
由 Peter Eisentraut 提交于
-
由 Bruce Momjian 提交于
> o Generate failure on short COPY lines rather than pad NULLs
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
pghackers discussion.
-
- 18 2月, 2002 19 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
to use separate LIMIT/OFFSET clauses.
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
'ifdef' in Makefile.
-
由 Bruce Momjian 提交于
-
由 Hiroshi Inoue 提交于
-
由 Bruce Momjian 提交于
Properly handles default values.
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
elog(LOG, "XLogWrite: new log file created - " "consider increasing 'wal_files' in postgresql.conf.");
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Tatsuo Ishii 提交于
Per Yoshinori Ariie's report.
-
由 Bruce Momjian 提交于
> * Have pg_dump use ADD PRIMARY KEY after COPY, for performance (Neil Conway)
-
由 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.
-
由 Hiroshi Inoue 提交于
-
由 Bruce Momjian 提交于
> * Have pg_dump use ADD PRIMARY KEY after COPY, for performance
-
由 Hiroshi Inoue 提交于
-
由 Bruce Momjian 提交于
> * ODBC > o ODBC 3.0 support > o Unicode(UCS-2) support > o Updatable cursors support
-
由 Bruce Momjian 提交于
-
- 17 2月, 2002 3 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
primary keys after the fact! Also, we need to add regression tests for alter table / add primary key and alter table / drop constraint. These shouldn't be added until 7.3 tho methinks... Chris
-
由 Bruce Momjian 提交于
e.g. table contraint definition -> table_constraint_definition.
-
- 16 2月, 2002 1 次提交
-
-
由 Peter Eisentraut 提交于
-
- 15 2月, 2002 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 14 2月, 2002 2 次提交
-
-
由 Tom 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.
-
由 Tom Lane 提交于
was mentioned on the man page for the underlying CREATE USER command, but it should be explained here too.
-
- 13 2月, 2002 1 次提交
-
-
由 Bruce Momjian 提交于
-