- 03 9月, 2002 2 次提交
-
-
由 Bruce Momjian 提交于
< o -ALTER TABLE ALTER COLUMN SET/DROP NOT NULL (Christopher Kings-Lynne) < o ALTER TABLE ADD COLUMN column SERIAL doesn't create sequence > o -ALTER TABLE ALTER COLUMN SET/DROP NOT NULL (Christopher) 200a200,201 > o ALTER TABLE ADD COLUMN column SERIAL doesn't create sequence because > of the item above 232c233 < o -Disallow missing columns in INSERT ... VALUES, per ANSI > o -Disallow missing columns in INSERT ... (col) VALUES, per ANSI 335,336d335 < * Have SERIAL generate non-colliding sequence names when we have < auto-destruction
-
由 Bruce Momjian 提交于
-
- 02 9月, 2002 38 次提交
-
-
由 Bruce Momjian 提交于
< * Allow logging of query durations > * -Allow logging of query durations 51,52d50 < * Make single-user local access permissions the default by limiting < permissions on the socket file (Peter E) 72,73c70,71 < * Reserve last few process slots for super-user if max_connections reached < * Add GUC parameter to print queries that generate errors > * -Reserve last few process slots for super-user if max_connections reached > * -Add GUC parameter to print queries that generate errors 82,83c80,81 < * Declare typein/out functions in pg_proc with a special "C string" data type < * Functions returning sets do not totally work > * -Declare typein/out functions in pg_proc with a special "C string" data type > * -Functions returning sets do not totally work 90c88 < * Allow bytea to handle LIKE with non-TEXT patterns > * -Allow bytea to handle LIKE with non-TEXT patterns 94c92 < o Store binary-compatible type information in the system > o -Store binary-compatible type information in the system 97d94 < o -SELECT col FROM tab WHERE numeric_col = 10.1 fails, requires quotes 102c99 < o Ensure we have array-eq operators for every built-in array type > o -Ensure we have array-eq operators for every built-in array type 119d115 < * Allow setting database character set without multibyte enabled 152d147 < * Have UPDATE/DELETE clean out indexes 198,199d192 < o ALTER TABLE ADD COLUMN to inherited table put column in wrong place < [inheritance] 201d193 < o Add ALTER FUNCTION 203,204c195,196 < o -ALTER TABLE ADD PRIMARY KEY (Tom) < o -ALTER TABLE ADD UNIQUE (Tom) > o -ALTER TABLE ADD PRIMARY KEY (Christopher) > o -ALTER TABLE ADD UNIQUE (Christopher) 248c240 < o -Remove SET KSQO option now that OR processing is improved (Tom) > o -Remove SET KSQO option now that OR processing is improved (Bruce) 280c272 < * Have pg_dump use LEFT OUTER JOIN in multi-table SELECTs > * -Have pg_dump use LEFT OUTER JOIN in multi-table SELECTs 287d278 < * Add config file check for $ODBCINI, $HOME/.odbc.ini, installpath/etc/odbc.ini 318,322d308 < * ODBC < o ODBC 3.0 support < o Unicode(UCS-2) support < o Updatable cursors support < 337c323 < * Fix foreign key constraints to not error on intermediate db states (Stephan) > * -Fix foreign key constraints to not error on intermediate db states (Stephan) 352c338 < * Propagate column or table renaming to foreign key constraints > * -Propagate column or table renaming to foreign key constraints 447c433 < * Remove wal_files postgresql.conf option because WAL files are now recycled > * -Remove wal_files postgresql.conf option because WAL files are now recycled 460c446 < * Improve dynamic memory allocation by introducing tuple-context memory > * -Improve dynamic memory allocation by introducing tuple-context memory 463c449 < * Nested FULL OUTER JOINs don't work (Tom) > * -Nested FULL OUTER JOINs don't work (Tom)
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
-
由 Tatsuo Ishii 提交于
-
由 Bruce Momjian 提交于
> * -Add OR REPLACE clauses to non-FUNCTION object creation > * -Allow autocommit so always in a transaction block > * -Cache most recent query plan(s) (Neil) [prepare]
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
mlw
-
由 Bruce Momjian 提交于
beta, at least get this stuff in. ftipatch.txt - Updates to docs and scripts. Run in the fulltextindexdir WARNING - Add to fulltextindex dir uninstall.sql - Add to fulltextindex dir
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
> src/backend/optimizer/path/indxpath.c; see the "special indexable > operators" stuff near the bottom of that file. (It's a bit of a crock > that this code is hardwired there, and not somehow accessed through a > system catalog, but it's what we've got at the moment.) The attached patch re-enables a bytea right hand argument (as compared to a text right hand argument), and enables index usage, for bytea LIKE Joe Conway
-
由 Bruce Momjian 提交于
not synonymous with CHECK (xxx IS NOT NULL) -- for example, consider ALTER TABLE ADD PRIMARY KEY, which checks for 'NOT NULL', not a check constraint. Neil Conway
-
由 Bruce Momjian 提交于
Alvaro Herrera
-
由 Bruce Momjian 提交于
review/feedback if anyone is interested and can spend the time. But I'd also love to get this committed and address changes as incremental patches ;-), so if there are no objections, please apply. Below I'll give a synopsis of the changes. More detailed descriptions are now in a new doc directory under contrib/dblink. There is also a new dblink.test.sql file which will give a pretty good overview of the functions and their use. Joe Conway
-
由 Bruce Momjian 提交于
already fixed by You. However there were a few left and attached patch should fix the rest of them. I used StringInfo only in 2 places and both of them are inside debug ifdefs. Only performance penalty will come from using strlen() like all the other code does. I also modified some of the already patched parts by changing snprintf(buf, 2 * BUFSIZE, ... style lines to snprintf(buf, sizeof(buf), ... where buf is an array. Jukka Holappa
-
由 Bruce Momjian 提交于
missing semicolons. I also added a SELECT statement without a target list. Manfred Koizar
-
由 Bruce Momjian 提交于
into a separate parallel group. I can't confirm that this fixes the problem for me (since it only occurs about one in ten or one in twenty runs), but I think it's a good bet that it does... Neil Conway
-
由 Bruce Momjian 提交于
replace, split, and to_hex. The patch also moves encode and decode into alphabetical order (since everything else in the table was). Joe Conway
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
there are no objections, please apply. Joe Conway
-
由 Bruce Momjian 提交于
function, connectby(), which can serve as a reference implementation for the changes made in the last few days -- namely the ability of a function to return an entire tuplestore, and the ability of a function to make use of the query provided "expected" tuple description. Description: connectby(text relname, text keyid_fld, text parent_keyid_fld, text start_with, int max_depth [, text branch_delim]) - returns keyid, parent_keyid, level, and an optional branch string - requires anonymous composite type syntax in the FROM clause. See the instructions in the documentation below. Joe Conway
-
由 Bruce Momjian 提交于
is an error, warning, etc. Gavin Sherry
-
由 Bruce Momjian 提交于
pgmonitor. Now log_min_error_statement uses it.
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
< * Evaluate AIX cs() spinlock macro for performance optimizations (Tatsuo)
-
由 Bruce Momjian 提交于
during the regression test. The problem has been reproduced on two machine but both of these are the same type of hardware and software. I also tried to recreate the problem on other machines, on older version of AIX but I couldn't. After looked through pgsql-hackers mailing list, I focused on spin lock issue to solve the problem. The easiest and may not be the best solution for the problem is to give up HAS_TEST_AND_SET. This actually works. One another and better solution for the problem is to use _check_lock() and _clear_lock() as spin lock. Important thing here is to define S_UNLOCK() with _clear_lock(). This will solve the so called "Compiler bug" issue someone wrote on the mailing list. We have some other API such as cs(), compare_and_swap() and fetch_and_or() to do test and set on AIX, but any of these didn't solve my problem. I wrote tiny testing program to see if we have any bug of these API of AIX, but I couldn't see any problem except for compare_and_swap(). It seems that you can not use compare_and_swap() for the purpose, as it would not work as spin lock on any SMP machines I tested. I don't know the reason why cs() nor fetch_and_or()/fetch_and_and() will not work with PostgreSQL on p690. These worked with my testing program on all machines I tested. Tomoyuki Niijima
-
由 Barry Lind 提交于
Fixed support in the driver for notifications (added PGConnection.getNotifications()) - problem reported by Benjamin.Feinstein@guardent.com Worked around server problems with int8/int2 and constants; quote values when they are intended to bind to an int8/int2 column - reported by many Fixed bug in the Array interface with string parsing not handling escaped characters correctly - reported by devajx@yahoo.com Added workaround to support 'infinity' and '-infinity' for dates - reported bydmitry@openratings.com Fixed some performance issues with setBlob - reported by d.wall@computer.org Added support for using new prepared statements functionality in 7.3 (added PGStatement.setUseServerPrepare() and isUseServerPrepare() methods) Modified Files: jdbc/org/postgresql/PGConnection.java jdbc/org/postgresql/PGStatement.java jdbc/org/postgresql/core/QueryExecutor.java jdbc/org/postgresql/jdbc1/AbstractJdbc1Connection.java jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSet.java jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java jdbc/org/postgresql/jdbc2/AbstractJdbc2Statement.java jdbc/org/postgresql/jdbc2/Array.java Added Files: jdbc/org/postgresql/PGNotification.java jdbc/org/postgresql/core/Notification.java
-
由 Bruce Momjian 提交于
because c.h has sys/types.h.
-
由 Tom Lane 提交于
Gavin Sherry, Neil Conway, and Tom Lane all got their hands dirty on this one ...
-
由 Tom Lane 提交于
(overlaying low byte of page size) and add HEAP_HASOID bit to t_infomask, per earlier discussion. Simplify scheme for overlaying fields in tuple header (no need for cmax to live in more than one place). Don't try to clear infomask status bits in tqual.c --- not safe to do it there. Don't try to force output table of a SELECT INTO to have OIDs, either. Get rid of unnecessarily complex three-state scheme for TupleDesc.tdhasoids, which has already caused one recent failure. Improve documentation.
-
由 Dave Cramer 提交于
-
由 Dave Cramer 提交于
-
由 Bruce Momjian 提交于
platforms.
-
由 Dave Cramer 提交于
-
由 Dave Cramer 提交于
-
由 Bruce Momjian 提交于
Greg Sabino Mullan
-
由 Bruce Momjian 提交于
Rename debug_print_query to log_statement and rename show_query_stats to show_statement_stats.
-
由 Bruce Momjian 提交于
> o Add table function support to pltcl, plperl, plpython
-
由 Tom Lane 提交于
-