aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Add:Bruce Momjian2006-03-06
| | | | | | | | > o Prevent parent tables from altering or dropping constraints > like CHECK that are inherited by child tables > > Dropping constraints should only be possible with CASCADE. >
* Update item.Bruce Momjian2006-03-06
|
* Add for Win32:Bruce Momjian2006-03-06
| | | | | > o Check WSACancelBlockingCall() for interrupts (win32intr) >
* Add WSACancelBlockingCall TODO.detail item.Bruce Momjian2006-03-06
|
* Add for ecpg:Bruce Momjian2006-03-06
| | | | > o Add COPY TO STDIN / STDOUT handling
* Fix psql history handling so 'execute' backslash commands (\g)Bruce Momjian2006-03-06
| | | | remain as part of the multi-line query.
* Update:Bruce Momjian2006-03-06
| | | | | | < * %Disallow changing sequence characteristics like INCREMENT for SERIAL columns > * %Disallow ALTER SEQUENCE changes for SERIAL sequences because pg_dump > does not dump the changes
* Add:Bruce Momjian2006-03-06
| | | | > * %Disallow changing sequence characteristics like INCREMENT for SERIAL columns
* Prevent autovacuum from zeroing damaged pages.Bruce Momjian2006-03-06
|
* in the docs, the function "ascii(text)" is described asBruce Momjian2006-03-06
| | | | | | | | | | | | | | | | | returning "ASCII code of the first character of the argument" (see http://www.postgresql.org/docs/8.1/interactive/functions-string.html, Table 9-6. "Other String Functions"). Presumably this should read "ASCII code of the first byte of the argument", which is what is returned when the argument is a multi-byte character (although then with UTF-8 at least that might not necessarily be an ASCII code). Ian Barwick
* In psql, save history of backslash commands used in multi-lineBruce Momjian2006-03-06
| | | | | statements before the multi-line statement, rather than inside the multi-line statement.
* Per recent discussion on -hackers, we should sometimes reorder theNeil Conway2006-03-05
| | | | | | | | | | columns of the grouping clause to avoid redundant sorts. The optimizer is not currently capable of doing this, so this patch implements a simple hack in the analysis phase (transformGroupClause): if any subset of the GROUP BY clause matches a prefix of the ORDER BY list, that prefix is moved to the front of the GROUP BY clause. This shouldn't change the semantics of the query, and allows a redundant sort to be avoided for queries like "GROUP BY a, b ORDER BY b".
* Add:Bruce Momjian2006-03-05
| | | | > o Port contrib/xml2
* Prepared queries for PLPerl, plus fixing a small plperl memory leak. PatchAndrew Dunstan2006-03-05
| | | | and docs from Dmitry Karasik, slightly editorialised.
* Update copyright for 2006. Update scripts.Bruce Momjian2006-03-05
|
* Update to 2006.Bruce Momjian2006-03-05
|
* Done:Bruce Momjian2006-03-05
| | | | > o -Add "include file" functionality in postgresql.conf
* Check for "msys" so it doesn't use 'con' by checking for an evironmentBruce Momjian2006-03-05
| | | | variable.
* Improve STRINGS_H macro test for MSVC extensions.Bruce Momjian2006-03-05
| | | | Add DLLIMPORT for V1 headers, in case Win32 don't export all symbols.
* Improve OS X shared-memory documentation: fix typos and provide a usableTom Lane2006-03-05
| | | | example of /etc/sysctl.conf contents.
* Support include directives in postgresql.conf.Tom Lane2006-03-04
| | | | Patch by Joachim Wieland, somewhat reworked for clarity and portability.
* Declare the arguments of AllocateFile() as const char *, not char *.Tom Lane2006-03-04
| | | | This is consistent with the standard definition of fopen().
* Incorporate a couple of recent tuplesort.c improvements into tuplestore.c.Tom Lane2006-03-04
| | | | | | In particular, ensure that enlargement of the memtuples[] array doesn't fall foul of MaxAllocSize when work_mem is very large, and don't bother enlarging it if that would force an immediate switch into 'tape' mode anyway.
* Prevent lazy_space_alloc from making requests that exceed MaxAllocSize,Tom Lane2006-03-04
| | | | per report from Stefan Kaltenbrunner.
* Prevent sorting from requesting a SortTuple array that exceeds MaxAllocSize;Tom Lane2006-03-04
| | | | | | | we'll go over to disk-based sort if we reach that limit. This fixes Stefan Kaltenbrunner's observation that sorting can suffer an 'invalid memory alloc request size' failure when sort_mem is set large enough. It's unfortunately not so easy to fix in 8.1 ...
* Tighten up SJIS byte sequence check. Now we reject invalid SJIS byteTatsuo Ishii2006-03-04
| | | | | sequence such as "0x95 0x27". Patches from Akio Ishida. Also update copyright notice.
* Add:Bruce Momjian2006-03-04
| | | | | > * Allow FSM page return free space based on table clustering, to assist > in maintaining clustering?
* > gettimeofday.c:35: warning: integer constant is too large for "long"Bruce Momjian2006-03-04
| | | | | | | | | | > type Wouldn't it be better to use the UINT64CONST macro? I realize this file is Windows-only, but we do worry about more than one compiler on that platform. Kris Jurka
* > It doesn't say that only the listed commands acquire ACCESS EXCLUSIVE,Bruce Momjian2006-03-04
| | | | | | | | | > just that certain commands do. TRUNCATE isn't shown. Patch against HEAD to add TRUNCATE to the list of commands that aquire ACCESS EXCLUSIVE. Jim C. Nasby, Sr.
* Use DEVTTY as 'con' on Win32 as a replacement for /dev/tty.Bruce Momjian2006-03-04
|
* That was a typo in my comment before the code (the nutshellBruce Momjian2006-03-04
| | | | | | | | descriptions after the code are correct). Only shmmax needs to be multiples of the page size (at least, that's how I interpret the Darwin code). Chris Campbell
* This patch fixes this warning.Bruce Momjian2006-03-03
| | | | | | | gettimeofday.c:35: warning: integer constant is too large for "long" type Kris Jurka
* Avoid trying to open /dev/tty on Win32. Some Win32 systems haveBruce Momjian2006-03-03
| | | | | | | | | | | /dev/tty, but it isn't a device file and doesn't work as expected. This fixes a known bug where psql does not prompt for a password on some Win32 systems. Backpatch to 8.1.X. Robert Kinberg
* Improve pg_dump and psql to use libpq's newer COPY support routines,Tom Lane2006-03-03
| | | | | instead of the old deprecated ones. Volkan Yazici, with some editorializing by moi.
* Fixes for Win32-client only compiles.Bruce Momjian2006-03-03
| | | | Hiroshi Saito
* Rename Online Backup to Continuous Archiving.Bruce Momjian2006-03-03
|
* Update ipcclean to use try 'id' first for root check.Bruce Momjian2006-03-03
|
* Add workaround so MSVC doesn't try to load strings.h, which it doesn'tBruce Momjian2006-03-03
| | | | | | have. This happens when MSVC uses pg_config.h generated by MinGW. Per report from Charles F. I. Savage
* Teach PQcmdTuples() that a COPY command tag might contain a row count,Tom Lane2006-03-03
| | | | | and tighten up its sanity checking of the tag as a safety measure. Volkan Yazici.
* Clarify macro layout for win32 IMPORT.Bruce Momjian2006-03-03
|
* Done:Bruce Momjian2006-03-03
| | | | > * -Allow TRUNCATE ... CASCADE/RESTRICT
* Done:Bruce Momjian2006-03-03
| | | | | < o %Have COPY return the number of rows loaded/unloaded? > o -Have COPY return the number of rows loaded/unloaded?
* Make the COPY command return a command tag that includes the number ofTom Lane2006-03-03
| | | | | rows copied. Backend side of Volkan Yazici's recent patch, with corrections and documentation.
* Dept. of second thoughts: rejigger the TRUNCATE ... CASCADE patch so thatTom Lane2006-03-03
| | | | | | | relations are still checked for permissions etc as soon as they are opened. The original form of the patch could hold exclusive lock for a long time on relations that the user doesn't even have permissions to access, let alone truncate.
* In ipcclean, check LOGNAME only if USER is not set.Bruce Momjian2006-03-03
| | | | Fixes problem with 'su' on some platforms.
* Fix a typo.Neil Conway2006-03-03
|
* Add CASCADE option to TRUNCATE. Joachim WielandTom Lane2006-03-03
|
* Add:Bruce Momjian2006-03-03
| | | | | > * Allow FSM to return free space toward the beginning of the heap file, > in hopes that empty pages at the end can be truncated by VACUUM
* Appended is a small documentation patch that adds a note to the CREATEBruce Momjian2006-03-03
| | | | | | | | | ROLE page, based on what Tom Lane told me here: http://archives.postgresql.org/pgsql-general/2005-11/msg00998.php Joachim Wieland
* Add:Bruce Momjian2006-03-03
| | | | | | | > * Add missing parameter handling in to_char() > > http://archives.postgresql.org/pgsql-hackers/2005-12/msg00948.php >