aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Add:Bruce Momjian2002-09-03
| | | | > * Gavin Sherry <swm@linuxworld.com.au>
* EXTRACT(EPOCH FROM timestamp) gave wrong answers in the int64-timestampTom Lane2002-09-03
| | | | | case for timestamptz input, and differently wrong answers in the float- timestamp case for timestamp input.
* Arrange for the default permissions on a database to allow temp tableTom Lane2002-09-03
| | | | | | | creation to world, but disallow temp table creation in template1. Per latest round of pghackers discussion. I did not force initdb, but the permissions lockdown on template1 will not take effect unless you do one (or manually REVOKE TEMP ON DATABASE template1 FROM public).
* conversion test fails if there is an existing user named foo. Choose a nameTom Lane2002-09-03
| | | | somewhat less likely to provoke a conflict.
* Remove all traces of multibyte and locale options. Clean up commentsPeter Eisentraut2002-09-03
| | | | referring to "multibyte" where it really means character encoding.
* Work around mktime() brain damage in recent versions of glibc by usingTom Lane2002-09-03
| | | | | | | a series of localtime() calls to determine the local timezone offset when mktime() fails. This eliminates regression failures on RHL 7.3, and should continue to work until it occurs to the glibc boys to break localtime() as well. By then I hope we'll have our own timezone code...
* Eliminate unnecessary dependency on mktime(), and consequent 'Unable toTom Lane2002-09-03
| | | | convert date to tm' failures, by using DetermineLocalTimeZone() instead.
* Workaround for format strings that are concatenated from macrosPeter Eisentraut2002-09-03
| | | | (INT64_FORMAT), which gettext cannot handle.
* AIX shlib fix for building libpq.so from Tomoyuki NiijimaBruce Momjian2002-09-03
|
* Add:Bruce Momjian2002-09-03
| | | | > * to_char(0,'FM999.99') returns a period, to_char(1,'FM999.99') does not
* Fix SGML build failure.Bruce Momjian2002-09-03
|
* I think reindex_index had better get AccessExclusiveLock on the parentTom Lane2002-09-03
| | | | heap, not just ExclusiveLock.
* Clean out cruft left by nonstandard test procedure.Tom Lane2002-09-03
|
* last-minute CreateTemplateTupleDesc fixes.Tom Lane2002-09-03
|
* Change ownership:Bruce Momjian2002-09-03
| | | | | | | < o -ALTER TABLE ADD PRIMARY KEY (Christopher) < o -ALTER TABLE ADD UNIQUE (Christopher) > o -ALTER TABLE ADD PRIMARY KEY (Tom) > o -ALTER TABLE ADD UNIQUE (Tom)
* Documentation improvements.Tom Lane2002-09-03
|
* Code review and documentation updates for indisclustered patch.Tom Lane2002-09-03
|
* Partial solution for 'unexpected EOF' problem with pg_disconnect: itTom Lane2002-09-02
| | | | | | | seems we have a choice between annoying messages and leaking memory (or dumping core, but that's right out). Patch also fixes several other problems in pg_disconnect, such as being willing to close a channel that isn't a PG channel.
* Translation updatesPeter Eisentraut2002-09-02
|
* Avoid shell syntax error if list of languages is empty.Peter Eisentraut2002-09-02
|
* Fix typos.Peter Eisentraut2002-09-02
|
* Convert control status codes to human-readable strings.Peter Eisentraut2002-09-02
|
* pg_on_connection_loss command for libpgtcl. Patch fromTom Lane2002-09-02
| | | | | | | | Gerhard Hintermayer, revised and documented by Tom Lane. This patch also fixes a 'must fix' bug: libpgtcl's LISTEN/NOTIFY support was broken by the recent changes to the PGnotify structure. Guess that change wasn't quite so safe as we thought.
* Fix obsolete description of PGnotify struct.Tom Lane2002-09-02
|
* Department of second thoughts: make checks for replacing a view slightlyTom Lane2002-09-02
| | | | | more flexible, and improve the error reporting. Also, add documentation for REPLACE RULE/VIEW.
* No more need for 'privileges' file.Bruce Momjian2002-09-02
|
* Improve CVS log grouping.Bruce Momjian2002-09-02
|
* Updated from Tom:Bruce Momjian2002-09-02
| | | | | | | | | | | | | | | < 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
* Add check for Ant version >= 1.5.Bruce Momjian2002-09-02
|
* Updates from Tom:Bruce Momjian2002-09-02
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | < * 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)
* Fix breakage introduced by evidently-completely-untested snprintf patch.Tom Lane2002-09-02
|
* Fix broken markup.Tom Lane2002-09-02
|
* Fix conversion regressin test failure.Tatsuo Ishii2002-09-02
|
* Done:Bruce Momjian2002-09-02
| | | | | | > * -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]
* Add missing dblink files.Bruce Momjian2002-09-02
|
* Fixes for intagg regression tests to match new array internal handling.Bruce Momjian2002-09-02
| | | | mlw
* In case Florian and I don't finish his changes to this contrib beforeBruce Momjian2002-09-02
| | | | | | | | 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
* Update catversion so we are sure everyone gets the bytea LIKE fix.Bruce Momjian2002-09-02
|
* > Okay. When you get back to the original issue, the gold is hidden inBruce Momjian2002-09-02
| | | | | | | | | | | | > 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
* This patch fixes a minor inaccuracy in the documentation: NOT NULL isBruce Momjian2002-09-02
| | | | | | | | 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
* Tab completion in psql is missing the REINDEX command.Bruce Momjian2002-09-02
| | | | Alvaro Herrera
* Attached is a fairly sizeable update to contrib/dblink. I'd love to getBruce Momjian2002-09-02
| | | | | | | | | | | | | | 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
* I checked all the previous string handling errors and most of them wereBruce Momjian2002-09-02
| | | | | | | | | | | | | | | 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
* I guess the intention was to test incomplete SELECT statements, notBruce Momjian2002-09-02
| | | | | | | | missing semicolons. I also added a SELECT statement without a target list. Manfred Koizar
* Okay, attached is a patch that moves the alter table regression testBruce Momjian2002-09-02
| | | | | | | | 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
* Here's a doc patch for the new string functions recently committed --Bruce Momjian2002-09-02
| | | | | | | replace, split, and to_hex. The patch also moves encode and decode into alphabetical order (since everything else in the table was). Joe Conway
* Move pg_settings doc into the right section.Bruce Momjian2002-09-02
|
* Here is a documentation patch for the pg_settings virtual table. IfBruce Momjian2002-09-02
| | | | | | there are no objections, please apply. Joe Conway
* Attached is an update to contrib/tablefunc. It introduces a newBruce Momjian2002-09-02
| | | | | | | | | | | | | | | | | | 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
* Add GUC variable to print original query to the server logs when thereBruce Momjian2002-09-02
| | | | | | is an error, warning, etc. Gavin Sherry
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-06 15:57:59 +0000