summaryrefslogtreecommitdiff
AgeCommit message (Collapse)Author
2002-04-29Implement checking of USAGE rights on namespaces.Tom Lane
2002-04-29Add cache invalidation callback hooks.Tom Lane
2002-04-29Add missing 'static' keyword to suppress compiler complaints.Tom Lane
gcc does not complain about this mistake, but other compilers do.
2002-04-29Remove unnecessary/obsolete regproctooid() references.Tom Lane
2002-04-29Add Polish FAQ from Marcin Mazurek.Bruce Momjian
2002-04-28Fix problem with new pg_hba.conf code where the same comparison functionBruce Momjian
was incorrectly used for both qsort and bsearch.
2002-04-28Second try at fixing join alias variables. Instead of attaching miscellaneousTom Lane
lists to join RTEs, attach a list of Vars and COALESCE expressions that will replace the join's alias variables during planning. This simplifies flatten_join_alias_vars while still making it easy to fix up varno references when transforming the query tree. Add regression test cases for interactions of subqueries with outer joins.
2002-04-28 - Synced yet again.Michael Meskes
- Fixed a typo in a comment printed by ecpg.
2002-04-28Make ruleutils.c use format_type for printing typenames. Minor tweaksTom Lane
in quoting rules and recognition of implicit type coercions.
2002-04-28Minor code cleanup.Tom Lane
2002-04-27Support toasting of shared system relations, and provide toast tables forTom Lane
pg_database, pg_shadow, pg_group, all of which now have potentially-long fields. Along the way, get rid of SharedSystemRelationNames list: shared rels are now identified in their include/pg_catalog/*.h files by a BKI_SHARED_RELATION macro, while indexes and toast rels inherit sharedness automatically from their parent table. Fix some bugs with failure to detoast pg_group.grolist during ALTER GROUP.
2002-04-27Fix write of pg_pwd file for multiple users. Broken recently by myBruce Momjian
pg_hba.conf changes.
2002-04-27Restructure aclcheck error reporting to make permission-failureTom Lane
messages more uniform and internationalizable: the global array aclcheck_error_strings[] is gone in favor of a subroutine aclcheck_error(). Partial implementation of namespace-related permission checks --- not all done yet.
2002-04-27Update DROP COLUMN example to use transactions and rollback-able DROP TABLE>Bruce Momjian
2002-04-26Fix typo.Tom Lane
2002-04-26Move renametrig() from tablecmds.c to trigger.c --- if we're going toTom Lane
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.
2002-04-26Updated:Bruce Momjian
> o Abort all SET changes made in an aborted transaction
2002-04-26Add checking for syslog.hTatsuo Ishii
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...
2002-04-26Add current_schema() and current_schemas() inquiry functions.Tom Lane
Update has_table_privilege functions to cope with schema-qualified names in the same way as nextval() and others.
2002-04-25Add a reference page for CREATE SCHEMA.Tom Lane
2002-04-25Added:Bruce Momjian
> * Allow backslash handling in quoted strings to be disabled for portability
2002-04-25Improve display of headings in HTML.Bruce Momjian
2002-04-25Updates for schema features.Tom Lane
2002-04-25Implement types regprocedure, regoper, regoperator, regclass, regtypeTom Lane
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.
2002-04-25Fix for the following items about escape sequenceHiroshi Inoue
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:
2002-04-25Fix password code to deal with new quoting code.Bruce Momjian
2002-04-24Remove reference to NAMEDATALEN, which wasn't necessary anyway.Peter Eisentraut
2002-04-24Remove references to NAMEDATALEN and INDEX_MAX_KEYS from pg_dump. HandlesPeter Eisentraut
any size now.
2002-04-24Remove reference to BLCKSZ.Peter Eisentraut
2002-04-24Don't dump core on empty table.Tom Lane
2002-04-24Remove compile warnings for lo dump by casting to char *.Bruce Momjian
2002-04-24Missed one NAMEDATALEN.Peter Eisentraut
2002-04-24Remove traces of NAMEDATALEN and INDEX_MAX_KEYS from psql. Build buffersPeter Eisentraut
dynamically with PQExpBuffer.
2002-04-24Update version for UNKNOWN regression fix.Bruce Momjian
2002-04-24Fix UNKNOWN regression test failure.Bruce Momjian
2002-04-24Fix regression for new DROP RULE syntax.Bruce Momjian
2002-04-24Add missing columns for UNKNOWN patch. Increment catalog version.Bruce Momjian
2002-04-24Add missing SGML file.Bruce Momjian
2002-04-24Restrict comment to the current database in order to prevent them fromBruce Momjian
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
2002-04-24Here's a doc patch for ALTER TRIGGER RENAME. Please apply if there areBruce Momjian
no objections. Joe Conway
2002-04-24Attached is a patch for ALTER TRIGGER RENAME per the above thread. IBruce Momjian
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
2002-04-24The attached patch adds regression tests for setting and removingBruce Momjian
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>
2002-04-24I've improved the contributed vacuumlo command, now it behaves like all otherBruce Momjian
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
2002-04-24The attached patch cleans up some code in pg_dump. It cuts someBruce Momjian
unused function arguments, and makes the TableInfo struct slightly smaller by removing an unnecessary member. Neil Conway <neilconway@rogers.com>
2002-04-24Update patch for DEFAULT on Views.Bruce Momjian
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>
2002-04-24Oops, wrong commit on previous. It was:Bruce Momjian
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>
2002-04-24Doc fix for INSERT ... (DEFAULT, ...)Bruce Momjian
Appears I forgot to update the docs earlier. Rod Taylor
2002-04-24Appears I forgot to update the docs earlier.Bruce Momjian
Please note I have no way to test this. Docbook doesn't like my cygwin setup. -- Rod Taylor
2002-04-24Update jdbc errors_zh_TW.properties.Bruce Momjian
Zhenbang Wei
2002-04-24Attached is an update to contrib/dblink. Please apply if there are noBruce Momjian
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