- 23 4月, 2006 5 次提交
-
-
由 Tatsuo Ishii 提交于
-
由 Tatsuo Ishii 提交于
-
由 Bruce Momjian 提交于
< o Fix psql's backslash commands more consistent > o Fix psql's \d commands more consistent
-
由 Bruce Momjian 提交于
< o Fix psql's \dn for various schema combinations (Neil) > o Fix psql's backslash commands more consistent 625a626 > http://archives.postgresql.org/pgsql-hackers/2004-11/msg00014.php
-
由 Bruce Momjian 提交于
o Fix psql's \dn for various schema combinations (Neil) http://archives.postgresql.org/pgsql-hackers/2004-11/msg00014.php
-
- 22 4月, 2006 7 次提交
-
-
由 Bruce Momjian 提交于
patch separators in COPY. Backpatch doubleing backslashes suggestion to 8.1.
-
由 Tom Lane 提交于
not named ones, and replace linear searches of the list with array indexing. The named-parameter support has been dead code for many years anyway, and recent profiling suggests that the searching was costing a noticeable amount of performance for complex queries.
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
Intel compiler has a bug in checking for division by NAN # (NaN == 0), -mp1 fixes it, so someday we might way to add it.
-
由 Bruce Momjian 提交于
the Intel compiler. Jeremy Drake
-
由 Bruce Momjian 提交于
permission item: < o %Allow pg_hba.conf settings to be controlled via SQL > o %Allow per-database permissions to be set via GRANT < This would add a function to load the SQL table from < pg_hba.conf, and one to writes its contents to the flat file. < The table should have a line number that is a float so rows < can be inserted between existing rows, e.g. row 2.5 goes < between row 2 and row 3. > Allow database connection checks based on GRANT rules in > addition to the existing access checks in pg_hba.conf.
-
由 Tom Lane 提交于
to track the number of LWLock acquisitions and the number of times we block waiting for an LWLock, on a per-process basis. After having needed this twice in the past few months, seems like it should go into CVS.
-
- 21 4月, 2006 1 次提交
-
-
由 Tom Lane 提交于
of rejecting palloc(0). Also, tweak like_selectivity() to avoid assuming the presented pattern is nonempty; although that assumption is valid, it doesn't really help much, and the new coding is more correct anyway since it properly handles redundant wildcards. In combination these changes should eliminate a Coverity warning noted by Martijn.
-
- 20 4月, 2006 9 次提交
-
-
由 Bruce Momjian 提交于
failure, to reduce confusion in the log file.
-
由 Tom Lane 提交于
whenever we start to read within that file. The first page carries extra identification information that really ought to be checked, but as the code stood, this was only checked when we switched sequentially into a new WAL file, or if by chance the starting checkpoint record was within the first page. This patch ensures that we will detect bogus 'long header' information before we start replaying the WAL sequence.
-
由 Tom Lane 提交于
symbol for PPC64 hardware. I hadn't known that Apple supported PPC64 at all, but darn if there aren't 64-bit variant libraries in OS X as well as support in their gcc.
-
由 Bruce Momjian 提交于
< encoding. > encoding. This requires using mblen() to determine if the > backslash is inside or outside a multi-byte sequence.
-
由 Bruce Momjian 提交于
> > o Add new version of PQescapeString() that doesn't double backslashes > that are part of a client-only multibyte sequence > > Single-quote is not a valid byte in any supported client-only > encoding. > > o Add new version of PQescapeString() that doesn't double > backslashes when standard_conforming_strings is true and > non-E strings are used
-
由 Bruce Momjian 提交于
our to_* functions were not handling that.
-
由 Tom Lane 提交于
no evidence that any currently-supported platform needs this, and good reason to think that any platform that did need it couldn't use the static libraries anyway --- libpq, at least, has circular references. Removing the code shuts up tsort warnings about the circular references on some platforms.
-
由 Tom Lane 提交于
routine, but perhaps some applications do. Found by Martijn van Oosterhout using Coverity.
-
由 Tom Lane 提交于
Per Martijn van Oosterhout.
-
- 19 4月, 2006 3 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
> o Add reporting of the current WAL file, perhaps as part of > partial log file archiving
-
由 Bruce Momjian 提交于
-
- 18 4月, 2006 3 次提交
-
-
由 Bruce Momjian 提交于
Backpatch.
-
由 Bruce Momjian 提交于
8.0), and add as suggestion to use log_min_error_statement for this purpose. I also fixed the code so the first EXECUTE has it's prepare, rather than the last which is what was in the current code. Also remove "protocol" prefix for SQL EXECUTE output because it is not accurate. Backpatch to 8.1.X.
-
由 Tom Lane 提交于
to occur between pg_start_backup() and pg_stop_backup(), even if the GUC setting full_page_writes is OFF. Per discussion, doing this in combination with the already-existing checkpoint during pg_start_backup() should ensure safety against partial page updates being included in the backup. We do not have to force full page writes to occur during normal PITR operation, as I had first feared.
-
- 17 4月, 2006 1 次提交
-
-
由 Bruce Momjian 提交于
< o Update pg_dump and psql to use the new COPY libpq API (Christopher) > o -Update pg_dump and psql to use the new COPY libpq API (Christopher)
-
- 16 4月, 2006 3 次提交
-
-
由 Bruce Momjian 提交于
< o %Have pg_dump use multi-statement transactions for INSERT dumps
-
由 Bruce Momjian 提交于
entire table load.
-
由 Tom Lane 提交于
CREATE AGGREGATE aggname (input_type) (parameter_list) along with the old syntax where the input type was named in the parameter list. This fits more naturally with the way that the aggregate is identified in DROP AGGREGATE and other utility commands; furthermore it has a natural extension to handle multiple-input aggregates, where the basetype-parameter method would get ugly. In fact, this commit fixes the grammar and all the utility commands to support multiple-input aggregates; but DefineAggregate rejects it because the executor isn't fixed yet. I didn't do anything about treating agg(*) as a zero-input aggregate instead of artificially making it a one-input aggregate, but that should be considered in combination with supporting multi-input aggregates.
-
- 15 4月, 2006 2 次提交
-
-
由 Bruce Momjian 提交于
> * -Re-enable the GUC full_page_writes in 8.2 when reliability issues have
-
由 Tom Lane 提交于
update no-longer-existing pages to fall through as no-ops, but make a note of each page number referenced by such records. If we don't see a later XLOG entry dropping the table or truncating away the page, complain at the end of XLOG replay. Since this fixes the known failure mode for full_page_writes = off, revert my previous band-aid patch that disabled that GUC variable.
-
- 14 4月, 2006 2 次提交
-
-
由 Tom Lane 提交于
If a process abandons a wait in LockBufferForCleanup (in practice, only happens if someone cancels a VACUUM) just before someone else sends it a signal indicating the buffer is available, it was possible for the wakeup to remain in the process' semaphore, causing misbehavior next time the process waited for an lmgr lock. Rather than try to prevent the race condition directly, it seems best to make the lock manager robust against leftover wakeups, by having it repeat waiting on the semaphore if the lock has not actually been granted or denied yet.
-
由 Tom Lane 提交于
alternatives ("|" symbol). The original coding allowed the added ^ and $ constraints to be absorbed into the first and last alternatives, producing a pattern that would match more than it should. Per report from Eric Noriega. I also changed the pattern to add an ARE director ("***:"), ensuring that SIMILAR TO patterns do not change behavior if regex_flavor is changed. This is necessary to make the non-capturing parentheses work, and seems like a good idea on general principles. Back-patched as far as 7.4. 7.3 also has the bug, but a fix seems impractical because that version's regex engine doesn't have non-capturing parens.
-
- 13 4月, 2006 4 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
At any rate, here's a revision to CVS HEAD to reflect some changes by myself and by Seneca Cunningham for the AIX FAQ. It touches on the following issues: 1. memcpy pointer patch for dynahash.c 2. AIX memory management, which can, for 32 bit cases, bite people quite unexpectedly... Chris Browne
-