aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Update DROP COLUMN example to use transactions and rollback-able DROP TABLE>Bruce Momjian2002-04-27
|
* Fix typo.Tom Lane2002-04-26
|
* Move renametrig() from tablecmds.c to trigger.c --- if we're going toTom Lane2002-04-26
| | | | | | | divide backend/commands by object type, let's try to pay at least minimal attention to respecting that structure, eh? Also reorder the contents of tablecmds.c; it seems odd to me to put ALTER commands before creation/deletion commands.
* Updated:Bruce Momjian2002-04-26
| | | | > o Abort all SET changes made in an aborted transaction
* Add checking for syslog.hTatsuo Ishii2002-04-26
| | | | | Enable multibyte support by default. Note that this is the first cut, and I'm gloing to remove #ifdef MULTIBYTE and others step by step...
* Add current_schema() and current_schemas() inquiry functions.Tom Lane2002-04-26
| | | | | Update has_table_privilege functions to cope with schema-qualified names in the same way as nextval() and others.
* Add a reference page for CREATE SCHEMA.Tom Lane2002-04-25
|
* Added:Bruce Momjian2002-04-25
| | | | > * Allow backslash handling in quoted strings to be disabled for portability
* Improve display of headings in HTML.Bruce Momjian2002-04-25
|
* Updates for schema features.Tom Lane2002-04-25
|
* Implement types regprocedure, regoper, regoperator, regclass, regtypeTom Lane2002-04-25
| | | | | | | per pghackers discussion. Add some more typsanity tests, and clean up some problems exposed thereby (broken or missing array types for some built-in types). Also, clean up loose ends from unknownin/out patch.
* Fix for the following items about escape sequenceHiroshi Inoue2002-04-25
| | | | | | | | | | | by Marcelo Aceto <aceto@newinf.com.br> . 1) Wrong translations of embedded escape sequences inside outer join escape sequences. 2) Wrong translation of parameter markers inside outer joins and function escape sequences. 3) Bad concatenation of date, time, timestamp constants with next word in statement:
* Fix password code to deal with new quoting code.Bruce Momjian2002-04-25
|
* Remove reference to NAMEDATALEN, which wasn't necessary anyway.Peter Eisentraut2002-04-24
|
* Remove references to NAMEDATALEN and INDEX_MAX_KEYS from pg_dump. HandlesPeter Eisentraut2002-04-24
| | | | any size now.
* Remove reference to BLCKSZ.Peter Eisentraut2002-04-24
|
* Don't dump core on empty table.Tom Lane2002-04-24
|
* Remove compile warnings for lo dump by casting to char *.Bruce Momjian2002-04-24
|
* Missed one NAMEDATALEN.Peter Eisentraut2002-04-24
|
* Remove traces of NAMEDATALEN and INDEX_MAX_KEYS from psql. Build buffersPeter Eisentraut2002-04-24
| | | | dynamically with PQExpBuffer.
* Update version for UNKNOWN regression fix.Bruce Momjian2002-04-24
|
* Fix UNKNOWN regression test failure.Bruce Momjian2002-04-24
|
* Fix regression for new DROP RULE syntax.Bruce Momjian2002-04-24
|
* Add missing columns for UNKNOWN patch. Increment catalog version.Bruce Momjian2002-04-24
|
* Add missing SGML file.Bruce Momjian2002-04-24
|
* Restrict comment to the current database in order to prevent them fromBruce Momjian2002-04-24
| | | | | | | | | | | | | | | mysteriously disappearing. ie. \d+ will only ever show the comment for the current database -- which is appropriate since it can only pull comments from the current database. Won't break pgadmin functionality as it enforces this behaviour already. I didn't find any regression tests for COMMENT. Rod Taylor
* Here's a doc patch for ALTER TRIGGER RENAME. Please apply if there areBruce Momjian2002-04-24
| | | | | | no objections. Joe Conway
* Attached is a patch for ALTER TRIGGER RENAME per the above thread. IBruce Momjian2002-04-24
| | | | | | | | left a stub for a future "ALTER RULE RENAME" but did not write that one yet. Bruce, if you want to add my name for for that I'll take it and do it later. Joe Conway
* The attached patch adds regression tests for setting and removingBruce Momjian2002-04-24
| | | | | | | | | default values using ALTER TABLE, on both views and tables. (You'll need to apply the default-values-for-views patch that I sent to -patches earlier for the regression tests to pass.) Neil Conway <neilconway@rogers.com>
* I've improved the contributed vacuumlo command, now it behaves like all otherBruce Momjian2002-04-24
| | | | | | | | postgres command line utilites e.g. supports -U, -p, -h, -?, -v, password prompt and has a "test mode". In test mode, no large objects are removed, just reported. Mario Weilguni
* The attached patch cleans up some code in pg_dump. It cuts someBruce Momjian2002-04-24
| | | | | | | unused function arguments, and makes the TableInfo struct slightly smaller by removing an unnecessary member. Neil Conway <neilconway@rogers.com>
* Update patch for DEFAULT on Views.Bruce Momjian2002-04-24
| | | | | | | | | | Apparently, you need to make two calls to appendPQExpBuffer() to use fmtId() twice, because it uses a static buffer (thanks for spotting this Tom). Another revision of the patch is attached. Neil Conway <neilconway@rogers.com>
* Oops, wrong commit on previous. It was:Bruce Momjian2002-04-24
| | | | | | | | | | The attached patch allows views to have default values. You can't specify a default value within a CREATE VIEW statement, it must be done using ALTER TABLE ... ALTER COLUMN ... SET DEFAULT after the view has already been created. Most of the hard work was done by Tom Lane, I just patched pg_dump and updated the documentation. Neil Conway <neilconway@rogers.com>
* Doc fix for INSERT ... (DEFAULT, ...)Bruce Momjian2002-04-24
| | | | | | Appears I forgot to update the docs earlier. Rod Taylor
* Appears I forgot to update the docs earlier.Bruce Momjian2002-04-24
| | | | | | | | Please note I have no way to test this. Docbook doesn't like my cygwin setup. -- Rod Taylor
* Update jdbc errors_zh_TW.properties.Bruce Momjian2002-04-24
| | | | Zhenbang Wei
* Attached is an update to contrib/dblink. Please apply if there are noBruce Momjian2002-04-24
| | | | | | | | | | | | | | | | | | | objections. Major changes: - removed cursor wrap around input sql to allow for remote execution of INSERT/UPDATE/DELETE - dblink now returns a resource id instead of a real pointer - added several utility functions I'm still hoping to add explicit cursor open/fetch/close support before 7.3 is released, but I need a bit more time on that. On a somewhat unrelated topic, I never got any feedback on the unknownin/out patch and the mb_substring patch. Is there anything else I need to do to get those applied? Joe Conway
* I'm at the win32 error messages once more. The DLL load thingy doesn'tBruce Momjian2002-04-24
| | | | | | | | | | | | | | | | work on all win9x machines, so i made it go thru a l ookup table instead, using the DLL as last resort. I also moved this out of the fe-misc.c file because of the size of the lookup ta ble. Who knows, we might add more other win32 specific code there in the future. I also fixed a small typo in the pg_config.h.win32 that made the compiler compla in about the gnu snprintf declaration. I tried to make this patch with psql coding style. I've successfully tested this on win2k and win98 and it works fine (i.e. the mes sage shows on win98 too, it didn't with the old implementation). Magnus Naeslund
* Reports missing values as bad.Bruce Momjian2002-04-24
| | | | | | | | | | BAD: INSERT INTO tab (col1, col2) VALUES ('val1'); GOOD: INSERT INTO tab (col1, col2) VALUES ('val1', 'val2'); Regress tests against DEFAULT and normal values as they're managed slightly different. Rod Taylor
* Speed improvement for large object restore.Bruce Momjian2002-04-24
| | | | Mario Weilguni
* Here's a patch to add unknownin/unknownout support. I also poked aroundBruce Momjian2002-04-24
| | | | | | | | | | looking for places that assume UNKNOWN == TEXT. One of those was the "SET" type in pg_type.h, which was using textin/textout. This one I took care of in this patch. The other suspicious place was in string_to_dataum (which is defined in both selfuncs.c and indxpath.c). I wasn't too sure about those, so I left them be. Joe Conway
* pgdb.connect() seems to be broken on Python 2.0.1 (which ships withBruce Momjian2002-04-24
| | | | | | | | | | | Slackware 8), and perhaps on other Pythons, haven't checked. Something in the _pg.connect() call isn't working. I think the problem stems from the fact that 'host' is a named parameter of both _pg.connect and pgdb.connect, and so Python treats it as a variable assignment, not a named parameter. Uses non-named parameters. Andrew Johnson
* Sorry for the package, but the following patch need to be applied to getBruce Momjian2002-04-24
| | | | | | the new verion compiled on SCO Openserver 5.0.5 and Unixware 7.1.1 Nicolas Bazin
* xlog.c: If possible please add the following patch to better support NetWare.Bruce Momjian2002-04-24
| | | | Ulrich Neumann
* [ Patch comments in three pieces.]Bruce Momjian2002-04-24
| | | | | | | | | | | | | | | | | | | | Attached is a pacth against 7.2 which adds locale awareness to the character classes of the regular expression engine. ... > > I still think the xdigit class could be handled the same way the digit > > class is (by enumeration rather than using the isxdigit function). That > > saves you a cicle, and I don't think there's any loss. > > In fact, I will email you when I apply the original patch. I miss that case :-(. Here is the pached patch. ... Here is a patch which addresses Tatsuo's concerns (it does return an static struct instead of constructing it).
* Update to my2pg 1.24.Bruce Momjian2002-04-24
|
* Based on this report, I am adding a FUNC_MAX_ARGS define toBruce Momjian2002-04-23
| | | | | | | src/include/pg_config.h.win32. Certainly if we have INDEX_MAX_KEYS in there, we should have FUNC_MAX_ARGS too. Report from Chris Ryan
* Add item:Bruce Momjian2002-04-23
| | | | > * Improve ability to display optimizer analysis using OPTIMIZER_DEBUG
* Update as done:Bruce Momjian2002-04-23
| | | | > * -Use faster flex flags for performance improvement (Peter E)
* Update for syslog and name Tom in trigger:Bruce Momjian2002-04-23
| | | | | > * -Allow user to control trigger firing order (Tom) > * -Compile in syslog functionaility by default (Tatsuo)