- 25 4月, 2006 6 次提交
-
-
由 Bruce Momjian 提交于
< * Add RESET CONNECTION command to reset all session state > * Add RESET SESSION command to reset all session state 447c447 < notify the protocol when a RESET CONNECTION command is used. > notify the protocol when a RESET SESSION command is used.
-
由 Bruce Momjian 提交于
< o %Prevent child tables from altering or dropping constraints < like CHECK that were inherited from the parent table < like CHECK that are inherited by child tables < < Dropping constraints should only be possible with CASCADE. < > like CHECK that are inherited by child tables unless CASCADE > is used > o %Prevent child tables from altering or dropping constraints > like CHECK that were inherited from the parent table
-
由 Bruce Momjian 提交于
> * -Add transaction_timestamp(), statement_timestamp(), clock_timestamp()
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
o Support ISO INTERVAL syntax if units cannot be determined from the string, and are supplied after the string The SQL standard states that the units after the string specify the units of the string, e.g. INTERVAL '2' MINUTE should return '00:02:00'. The current behavior has the units restrict the interval value to the specified unit or unit range, INTERVAL '70' SECOND returns '00:00:10'. For syntax that isn't uniquely ISO or PG syntax, like '1' or '1:30', treat as ISO if there is a range specification clause, and as PG if there no clause is present, e.g. interpret '1:30' MINUTE TO SECOND as '1 minute 30 seconds', and interpret '1:30' as '1 hour, 30 minutes'. This makes common cases like SELECT INTERVAL '1' MONTH SQL-standard results. The SQL standard supports a limited number of unit combinations and doesn't support unit names in the string. The PostgreSQL syntax is more flexible in the range of units supported, e.g. PostgreSQL supports '1 year 1 hour', while the SQL standard does not.
-
由 Bruce Momjian 提交于
o -Add support for day-time syntax, INTERVAL '1 2:03:04'DAY TO SECOND
-
- 23 4月, 2006 4 次提交
-
-
由 Bruce Momjian 提交于
< * -Eventually enable escape_string_warning and standard_conforming_strings > * -Enable escape_string_warning and standard_conforming_strings > * Make standard_conforming_strings the default in 8.3? > > When this is done, backslash-quote should be prohibited in non-E'' > strings because of possible confusion over how such strings treat > backslashes. Basically, '' is always safe for a literal single > quote, while \' might or might not be based on the backslash > handling rules. >
-
由 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 1 次提交
-
-
由 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.
-
- 20 4月, 2006 2 次提交
-
-
由 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
-
- 19 4月, 2006 1 次提交
-
-
由 Bruce Momjian 提交于
> o Add reporting of the current WAL file, perhaps as part of > partial log file archiving
-
- 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 1 次提交
-
-
由 Bruce Momjian 提交于
< o %Have pg_dump use multi-statement transactions for INSERT dumps
-
- 15 4月, 2006 1 次提交
-
-
由 Bruce Momjian 提交于
> * -Re-enable the GUC full_page_writes in 8.2 when reliability issues have
-
- 13 4月, 2006 1 次提交
-
-
由 Bruce Momjian 提交于
< multiple I/O channels simultaneously. > multiple I/O channels simultaneously. One idea is to create a > background reader that can pre-fetch sequential and index scan > pages needed by other backends. This could be expanded to allow > concurrent reads from multiple devices in a partitioned table.
-
- 11 4月, 2006 3 次提交
-
-
由 Bruce Momjian 提交于
< * Allow user-defined functions retuning a domain value to enforce domain > * -Allow user-defined functions retuning a domain value to enforce domain
-
由 Bruce Momjian 提交于
* Re-enable the GUC full_page_writes in 8.2 when reliability issues have been addressed
-
由 Bruce Momjian 提交于
> * Allow log_min_messages to be specified on a per-module basis > > This would allow administrators to see more detailed information from > specific sections of the backend, e.g. checkpoints, autovacuum, etc.
-
- 10 4月, 2006 1 次提交
-
-
由 Bruce Momjian 提交于
< * Experiment with multi-threaded backend [thread] > * Experiment with multi-threaded backend for backend creation [thread] 1003a1004,1008 > > * Experiment with multi-threaded backend better resource utilization > > This would allow a single query to make use of multiple CPU's or > multiple I/O channels simultaneously.
-
- 09 4月, 2006 1 次提交
-
-
由 Bruce Momjian 提交于
> * Allow the creation of indexes with mixed ascending/descending > specifiers > > This is possible now by creating an operator class with reversed sort > operators. One complexity is that NULLs would then appear at the start > of the result set, and this might affect certain sort types, like > merge join. >
-
- 07 3月, 2006 2 次提交
-
-
由 Bruce Momjian 提交于
> * -Eventually enable escape_string_warning and standard_conforming_strings
-
由 Bruce Momjian 提交于
> 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. >
-
- 06 3月, 2006 5 次提交
-
-
由 Bruce Momjian 提交于
> o Check WSACancelBlockingCall() for interrupts (win32intr) >
-
由 Bruce Momjian 提交于
> o Add COPY TO STDIN / STDOUT handling
-
由 Bruce Momjian 提交于
< * %Disallow changing sequence characteristics like INCREMENT for SERIAL columns > * %Disallow ALTER SEQUENCE changes for SERIAL sequences because pg_dump > does not dump the changes
-
由 Bruce Momjian 提交于
> * %Disallow changing sequence characteristics like INCREMENT for SERIAL columns
-
由 Bruce Momjian 提交于
> o Port contrib/xml2
-
- 05 3月, 2006 1 次提交
-
-
由 Bruce Momjian 提交于
> o -Add "include file" functionality in postgresql.conf
-
- 04 3月, 2006 3 次提交
-
-
由 Bruce Momjian 提交于
> * Allow FSM page return free space based on table clustering, to assist > in maintaining clustering?
-
由 Bruce Momjian 提交于
> * -Allow TRUNCATE ... CASCADE/RESTRICT
-
由 Bruce Momjian 提交于
< o %Have COPY return the number of rows loaded/unloaded? > o -Have COPY return the number of rows loaded/unloaded?
-
- 03 3月, 2006 4 次提交
-
-
由 Bruce Momjian 提交于
> * 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
-
由 Bruce Momjian 提交于
> * Add missing parameter handling in to_char() > > http://archives.postgresql.org/pgsql-hackers/2005-12/msg00948.php >
-
由 Bruce Momjian 提交于
> * Allow to_date() and to_timestamp() accept localized month names
-
由 Bruce Momjian 提交于
> * Improve port/qsort() to handle sorts with 50% unique and 50% duplicate > value [qsort] > > This involves choosing better pivot points for the quicksort.
-
- 01 3月, 2006 1 次提交
-
-
由 Bruce Momjian 提交于
* Split out libpq pgpass and environment documentation sections to make it easier for non-developers to find
-
- 27 2月, 2006 1 次提交
-
-
由 Bruce Momjian 提交于
> * -Add 'tid != tid ' operator for use in corruption recovery
-