hcq/postgresql
1
0
Fork 0
mirror of https://git.postgresql.org/git/postgresql.git synced 2026-02-18 20:36:58 +08:00
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • 15162aef24 Make dumpACL behave more reasonably for case where owner has revoked some of his own privileges. Tom Lane 2002-05-06 18:33:45 +00:00
  • 340b66cc70 Cause fmtId to always use its internal buffer for the returned value, in hopes of making erroneous usage more apparent. Per discussion 15-Apr. Tom Lane 2002-05-06 17:34:45 +00:00
  • 1cf693ab86 Reorder snapshot checks to save a couple comparisons in the common case, where the tuple's xmin or xmax is older than the snapshot xmin. There is no need to check it against snapshot xmax in that case. Tom Lane 2002-05-06 02:39:01 +00:00
  • 205b5c2f4b A little paranoia never hurt anyone. Tom Lane 2002-05-05 17:50:04 +00:00
  • 77c4ba63b8 plpgsql_dstring_append was broken for long strings. Tom Lane 2002-05-05 17:38:28 +00:00
  • c0e9dc1229 plpgsql_dstring_append was broken for long strings. Tom Lane 2002-05-05 17:38:26 +00:00
  • 846429e3d6 Not needed anymore. Tom Lane 2002-05-05 16:47:09 +00:00
  • d15c30d327 Add missing includes. Tom Lane 2002-05-05 16:14:24 +00:00
  • 17ea23dd17 Add a trivial testbed for pg_sema and pg_shmem code. Tom Lane 2002-05-05 16:02:37 +00:00
  • 2010a43fcb Cope with case that SEM_FAILED is not defined (assume failure code is -1) Tom Lane 2002-05-05 16:01:50 +00:00
  • 8df5625966 First test of Darwin port with POSIX semaphore code. Tom Lane 2002-05-05 01:03:26 +00:00
  • 3e48c66136 Fix code to work when isalpha and friends are macros, not functions. Tom Lane 2002-05-05 00:50:31 +00:00
  • 72a3902a66 Create an internal semaphore API that is not tied to SysV semaphores. As proof of concept, provide an alternate implementation based on POSIX semaphores. Also push the SysV shared-memory implementation into a separate file so that it can be replaced conveniently. Tom Lane 2002-05-05 00:03:29 +00:00
  • 91fc10fdac Fix compile errors in CYR_RECODE code, per report from Oliver Elphick. Tom Lane 2002-05-03 20:43:30 +00:00
  • 90739d4621 Make ruleutils.c schema-aware. Displayed names are schema-qualified only if they would not be found without qualification given the current search path, as per idea from Peter Eisentraut. Tom Lane 2002-05-03 20:15:02 +00:00
  • 1a69a37d5b Fix obsolete comments. Tom Lane 2002-05-03 17:42:11 +00:00
  • d662f29302 Use quote_identifier on relation names in EXPLAIN output, per suggestion from Liam Stewart. Minor code cleanups also. Tom Lane 2002-05-03 15:56:45 +00:00
  • 4a2fe8e03d Fix typo in usage instructions. Tom Lane 2002-05-03 14:21:38 +00:00
  • 8338cc03a8 Remove the last traces of datatypes datetime and timespan. Tom Lane 2002-05-03 04:11:08 +00:00
  • 53cedcac22 Retire xlateSqlType/xlateSqlFunc; all type name translations are now handled as special productions. This is needed to keep us honest about user-schema type names that happen to coincide with system type names. Per pghackers discussion 24-Apr. To avoid bloating the keyword list too much, I removed the translations for datetime, timespan, and lztext, all of which were slated for destruction several versions back anyway. Tom Lane 2002-05-03 00:32:19 +00:00
  • c2def1b128 Fix backslash-n typo, per Joe Conway. Tom Lane 2002-05-02 21:44:43 +00:00
  • 3220fd2138 Tweak scanner/grammar interface so that the keyword-as-identifier rules in gram.y can make use of the keywords.c string table, instead of having their own copies of the keyword strings. This saves a few kilobytes and more importantly eliminates an opportunity for cut-and-paste errors. Tom Lane 2002-05-02 18:44:11 +00:00
  • 0041a3d72f Add routines in namespace.c to determine whether objects are visible in the search path. (We might want to make these available as SQL functions too, but I haven't done that yet.) Fix format_type to be schema-aware. Tom Lane 2002-05-01 23:06:41 +00:00
  • a829cbb877 Give left_oper() and right_oper() noError parameters like oper() (the binary case) already has. Needed for upcoming ruleutils change. Tom Lane 2002-05-01 19:26:08 +00:00
  • 61446e0927 Improve lexer's error reporting. You get the whole token mentioned now in parse error messages, not just the part scanned by the last flex rule. For example, select "foo" "bar"; used to draw ERROR: parser: parse error at or near """ which was rather unhelpful. Now it gives ERROR: parser: parse error at or near ""bar"" Also, error messages concerning bitstring literals and suchlike will quote the source text at you, not the processed internal form of the literal. Tom Lane 2002-05-01 17:12:08 +00:00
  • 241978b91b The attached patch fixes 4 instances of missing simi-colons in the PL/PgSQL grammar, which were causing warnings when used with Bison 1.35. Jan Wieck 2002-05-01 12:40:22 +00:00
  • ffd1a5d853 Change heap_get_latest_tid() so that a transaction can see changes made by the transaction itself. Hiroshi Inoue 2002-05-01 01:27:31 +00:00
  • d1406f1b1e Change heap_get_latest_tid() so that a transaction can see changes made by the transaction itself. Hiroshi Inoue 2002-05-01 01:23:37 +00:00
  • 936afc8a4b Fix obj_description() and col_description() functions to work reliably in presence of schemas. Tom Lane 2002-04-30 21:01:52 +00:00
  • 1e4f34f309 Document that NAMEDATALEN must be a multiple of sizeof(int). Tom Lane 2002-04-30 19:53:03 +00:00
  • e4f06dc12e Clean up loose ends remaining from schema privileges discussion. I concluded that RENAME should require CREATE privilege on the namespace as well as ownership of the table. Tom Lane 2002-04-30 01:26:26 +00:00
  • 4c25a0655b Code review for ALTER TRIGGER RENAME patch: make better use of index, don't scribble on tuple returned by table scan. Tom Lane 2002-04-30 01:24:57 +00:00
  • 857661ba2e Enforce EXECUTE privilege for aggregate functions. Tom Lane 2002-04-29 22:28:19 +00:00
  • ccfaf9067d Implement checking of USAGE rights on namespaces. Tom Lane 2002-04-29 22:15:07 +00:00
  • 88ef7067f7 Add cache invalidation callback hooks. Tom Lane 2002-04-29 22:14:34 +00:00
  • 8d615763da Add missing 'static' keyword to suppress compiler complaints. gcc does not complain about this mistake, but other compilers do. Tom Lane 2002-04-29 17:30:18 +00:00
  • e896912ee9 Remove unnecessary/obsolete regproctooid() references. Tom Lane 2002-04-29 04:10:02 +00:00
  • c763cfa9e8 Add Polish FAQ from Marcin Mazurek. Bruce Momjian 2002-04-29 02:57:18 +00:00
  • ea43fec258 Fix problem with new pg_hba.conf code where the same comparison function was incorrectly used for both qsort and bsearch. Bruce Momjian 2002-04-28 22:49:07 +00:00
  • 6c59886942 Second try at fixing join alias variables. Instead of attaching miscellaneous 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. Tom Lane 2002-04-28 19:54:29 +00:00
  • c8996f9c6b - Synced yet again. - Fixed a typo in a comment printed by ecpg. Michael Meskes 2002-04-28 17:20:03 +00:00
  • 25dfba3954 Make ruleutils.c use format_type for printing typenames. Minor tweaks in quoting rules and recognition of implicit type coercions. Tom Lane 2002-04-28 00:49:13 +00:00
  • 7677fe0aa6 Minor code cleanup. Tom Lane 2002-04-28 00:36:38 +00:00
  • c06f6a6bc2 Support toasting of shared system relations, and provide toast tables for 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. Tom Lane 2002-04-27 21:24:34 +00:00
  • 108871f4fc Fix write of pg_pwd file for multiple users. Broken recently by my pg_hba.conf changes. Bruce Momjian 2002-04-27 15:30:07 +00:00
  • 31c775adeb Restructure aclcheck error reporting to make permission-failure 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. Tom Lane 2002-04-27 03:45:03 +00:00
  • aafe72efb2 Update DROP COLUMN example to use transactions and rollback-able DROP TABLE> Bruce Momjian 2002-04-27 03:04:08 +00:00
  • 97b6e3f06f Fix typo. Tom Lane 2002-04-26 19:47:35 +00:00
  • 7de307f96c Move renametrig() from tablecmds.c to trigger.c --- if we're going to 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. Tom Lane 2002-04-26 19:29:47 +00:00
  • e90dbd27b1 Updated: Bruce Momjian 2002-04-26 18:32:44 +00:00
  • 998e1c178c Add checking for syslog.h 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... Tatsuo Ishii 2002-04-26 13:55:38 +00:00
  • a309032d2f Add current_schema() and current_schemas() inquiry functions. Update has_table_privilege functions to cope with schema-qualified names in the same way as nextval() and others. Tom Lane 2002-04-26 01:24:08 +00:00
  • d9375ad564 Add a reference page for CREATE SCHEMA. Tom Lane 2002-04-25 21:47:07 +00:00
  • be004a0c09 Added: Bruce Momjian 2002-04-25 20:39:11 +00:00
  • 8cec968784 Improve display of headings in HTML. Bruce Momjian 2002-04-25 20:20:50 +00:00
  • e358a61d76 Updates for schema features. Tom Lane 2002-04-25 20:14:43 +00:00
  • 52200befd0 Implement types regprocedure, regoper, regoperator, regclass, regtype 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. Tom Lane 2002-04-25 02:56:56 +00:00
  • 4eac3919dd Fix for the following items about escape sequence Hiroshi Inoue 2002-04-25 02:50:08 +00:00
  • 6cdba03d38 Fix password code to deal with new quoting code. Bruce Momjian 2002-04-25 00:56:36 +00:00
  • 39e77dd365 Remove reference to NAMEDATALEN, which wasn't necessary anyway. Peter Eisentraut 2002-04-24 23:00:40 +00:00
  • ed8aa9711e Remove references to NAMEDATALEN and INDEX_MAX_KEYS from pg_dump. Handles any size now. Peter Eisentraut 2002-04-24 22:39:49 +00:00
  • 8889eb098a Remove reference to BLCKSZ. Peter Eisentraut 2002-04-24 21:00:10 +00:00
  • 6260c7c167 Don't dump core on empty table. Tom Lane 2002-04-24 15:56:38 +00:00
  • 8be68479dc Remove compile warnings for lo dump by casting to char *. Bruce Momjian 2002-04-24 14:03:22 +00:00
  • 71aab11327 Missed one NAMEDATALEN. Peter Eisentraut 2002-04-24 06:17:04 +00:00
  • 3d726290c0 Remove traces of NAMEDATALEN and INDEX_MAX_KEYS from psql. Build buffers dynamically with PQExpBuffer. Peter Eisentraut 2002-04-24 05:24:00 +00:00
  • 246f47fdf0 Update version for UNKNOWN regression fix. Bruce Momjian 2002-04-24 05:23:14 +00:00
  • a1fe85d749 Fix UNKNOWN regression test failure. Bruce Momjian 2002-04-24 05:22:20 +00:00
  • eb5df80759 Fix regression for new DROP RULE syntax. Bruce Momjian 2002-04-24 03:52:16 +00:00
  • a4b361b747 Add missing columns for UNKNOWN patch. Increment catalog version. Bruce Momjian 2002-04-24 03:09:09 +00:00
  • f20d467e6b Add missing SGML file. Bruce Momjian 2002-04-24 02:53:13 +00:00
  • ab117a6643 Restrict comment to the current database in order to prevent them from mysteriously disappearing. Bruce Momjian 2002-04-24 02:50:30 +00:00
  • a02f83426b Here's a doc patch for ALTER TRIGGER RENAME. Please apply if there are no objections. Bruce Momjian 2002-04-24 02:49:50 +00:00
  • 3a96b6cdeb Attached is a patch for ALTER TRIGGER RENAME per the above thread. I 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. Bruce Momjian 2002-04-24 02:48:55 +00:00
  • fbc4b7110f The attached patch adds regression tests for setting and removing default values using ALTER TABLE, on both views and tables. Bruce Momjian 2002-04-24 02:47:23 +00:00
  • 7f459808de I've improved the contributed vacuumlo command, now it behaves like all other 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. Bruce Momjian 2002-04-24 02:45:51 +00:00
  • 5b0fb008e7 The attached patch cleans up some code in pg_dump. It cuts some unused function arguments, and makes the TableInfo struct slightly smaller by removing an unnecessary member. Bruce Momjian 2002-04-24 02:44:19 +00:00
  • 244693744f Update patch for DEFAULT on Views. Bruce Momjian 2002-04-24 02:42:27 +00:00
  • 19b31e0713 Oops, wrong commit on previous. It was: Bruce Momjian 2002-04-24 02:40:45 +00:00
  • adf7cc04cb Doc fix for INSERT ... (DEFAULT, ...) Bruce Momjian 2002-04-24 02:38:58 +00:00
  • 9fcc1159be Appears I forgot to update the docs earlier. Bruce Momjian 2002-04-24 02:31:30 +00:00
  • 80e232f2b8 Update jdbc errors_zh_TW.properties. Bruce Momjian 2002-04-24 02:30:53 +00:00
  • 3bf6b8f06a Attached is an update to contrib/dblink. Please apply if there are no objections. Bruce Momjian 2002-04-24 02:28:28 +00:00
  • 30571b5496 I'm at the win32 error messages once more. The DLL load thingy doesn't 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. Bruce Momjian 2002-04-24 02:26:06 +00:00
  • dd4ca824cc Reports missing values as bad. Bruce Momjian 2002-04-24 02:22:54 +00:00
  • e975123454 Speed improvement for large object restore. Bruce Momjian 2002-04-24 02:21:04 +00:00
  • 5d2fdf6e6d Here's a patch to add unknownin/unknownout support. I also poked around 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. Bruce Momjian 2002-04-24 02:12:53 +00:00
  • be9728acf1 pgdb.connect() seems to be broken on Python 2.0.1 (which ships with 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. Bruce Momjian 2002-04-24 01:58:31 +00:00
  • 2d81019493 Sorry for the package, but the following patch need to be applied to get the new verion compiled on SCO Openserver 5.0.5 and Unixware 7.1.1 Bruce Momjian 2002-04-24 01:56:20 +00:00
  • d37134085b xlog.c: If possible please add the following patch to better support NetWare. Bruce Momjian 2002-04-24 01:54:43 +00:00
  • f71c924f10 [ Patch comments in three pieces.] Bruce Momjian 2002-04-24 01:51:11 +00:00
  • 450e728d24 Update to my2pg 1.24. Bruce Momjian 2002-04-24 01:42:29 +00:00
  • 42f2e5bd11 Based on this report, I am adding a FUNC_MAX_ARGS define to src/include/pg_config.h.win32. Certainly if we have INDEX_MAX_KEYS in there, we should have FUNC_MAX_ARGS too. Bruce Momjian 2002-04-23 23:46:37 +00:00
  • 695a042532 Add item: Bruce Momjian 2002-04-23 20:26:29 +00:00
  • c11d9353f1 Update as done: Bruce Momjian 2002-04-23 18:59:30 +00:00
  • 0666ac296b Update for syslog and name Tom in trigger: Bruce Momjian 2002-04-23 16:59:51 +00:00
  • 44cd58e47e Update: Bruce Momjian 2002-04-23 16:56:24 +00:00
  • 28a898ad54 Clean up INT64CONST conflicts. Make the pg_crc code use a macro called UINT64CONST, since unsigned was what it wanted anyway. Centralize macro definitions into c.h. Tom Lane 2002-04-23 15:45:30 +00:00
  • bf1f2e545c 1) Fix SQLProcedures(). 2) Handle timestamp without time zone. 3) Improve SQLForeignKeys() in multibyte mode. Hiroshi Inoue 2002-04-23 04:14:13 +00:00
  • 0c1fe3d2b9 Update SQL-command reference pages for schema features. Tom Lane 2002-04-23 02:07:16 +00:00