Commit Graph

  • 248cbb5796 Temporary ifdef out migrating functions to avoid compiler warnings. Tatsuo Ishii 2002-07-19 00:22:24 +00:00
  • 4feeee17ce Done: Bruce Momjian 2002-07-19 00:17:53 +00:00
  • b75fcf9326 Complete TODO item: Bruce Momjian 2002-07-19 00:17:40 +00:00
  • 97377048b4 pg_cast table, and standards-compliant CREATE/DROP CAST commands, plus extension to create binary compatible casts. Includes dependency tracking as well. Peter Eisentraut 2002-07-18 23:11:32 +00:00
  • a345ac8842 Done: Bruce Momjian 2002-07-18 23:07:09 +00:00
  • 981d045e88 Complete TODO item: Bruce Momjian 2002-07-18 23:06:20 +00:00
  • 85d2a629c6 Create directory before installing files. Peter Eisentraut 2002-07-18 22:58:08 +00:00
  • 776fc8cc5c New depend code doesn't need sequence drop. Bruce Momjian 2002-07-18 22:31:44 +00:00
  • 2aa6a5de87 Sic transit src/utils. Tom Lane 2002-07-18 22:15:10 +00:00
  • 7d78bac108 Back out BETWEEN node patch, was causing initdb failure. Bruce Momjian 2002-07-18 17:14:20 +00:00
  • a938f32a5a New depend code auto-drops sequence, fix copy2.out. Bruce Momjian 2002-07-18 17:11:49 +00:00
  • 11333426f1 Implement DROP SCHEMA. It lacks support for dropping conversions and operator classes, both of which are schema-local and so should really be droppable. Tom Lane 2002-07-18 16:47:26 +00:00
  • 8bed350c4a Fix copy-and-pasteo (CASCADE/RESTRICT in wrong place). Tom Lane 2002-07-18 15:49:08 +00:00
  • 55fa0e6d2a Fix typo (PG_UNICODE -> PG_UTF8) Tatsuo Ishii 2002-07-18 05:07:30 +00:00
  • fb94c09ae4 Done: Bruce Momjian 2002-07-18 05:01:51 +00:00
  • a9f6c5b5c7 Unique and primary key constraints are both dumped using ALTER TABLE statements. Unique indexes with CREATE INDEX. Bruce Momjian 2002-07-18 04:50:51 +00:00
  • e6f02c8231 REVOKE ALL ON FUNCTION nonexistant() FROM PUBLIC; Bruce Momjian 2002-07-18 04:50:10 +00:00
  • 8f211f8a84 Fix for PgTransaction class to make these visible to C apps: Bruce Momjian 2002-07-18 04:49:30 +00:00
  • 5a5e46ea7e Here (finally ;-)) is a doc patch covering the Table Function C API. It reflects the changes in the tablefunc-fix patch that I sent in the other day. It also refers to "see contrib/tablefunc for more examples", which is next on my list of things to finish and submit. Bruce Momjian 2002-07-18 04:47:17 +00:00
  • 8c26bc5364 The attached patch fixes a tiny memory leak in psql, when using the 'expanded' output mode (\x). Bruce Momjian 2002-07-18 04:46:24 +00:00
  • 2c48b3db95 here are the copy2.sql and copy2.out files for the new regression tests Bruce Momjian 2002-07-18 04:45:51 +00:00
  • a90db34b54 The attached patch (against HEAD) implements Bruce Momjian 2002-07-18 04:43:51 +00:00
  • fc5372e099 You made a tiny little type in a comment in parsenodes.h (abotu instead of about). Bruce Momjian 2002-07-18 04:42:29 +00:00
  • 3e22406ec6 Finished the Between patch Christopher started. Bruce Momjian 2002-07-18 04:41:46 +00:00
  • 7ea5f1d7f1 Here is a patch for the Table Function API. It fixes a bug found by Neil Bruce Momjian 2002-07-18 04:40:30 +00:00
  • a5a8110a86 Contrib port/ usage is same as others so no need for rules. Bruce Momjian 2002-07-18 04:33:39 +00:00
  • 7c5c1a2adb Add comment to file about port files. Bruce Momjian 2002-07-18 04:30:36 +00:00
  • 3d7a9ac769 Fix breakage for pltcl modules. pg_get_enconv_by_encoding() has been changed since CREATE CONVERSION supported. Tatsuo Ishii 2002-07-18 04:16:07 +00:00
  • 404e9a12a5 Move libc replacement files from src/backend/port to src/port. Bruce Momjian 2002-07-18 04:13:59 +00:00
  • 7f43165dd2 Make src/backend/port/*.c file location dependent only on configure.in. Bruce Momjian 2002-07-18 03:59:49 +00:00
  • eb335a034b I have committed many support files for CREATE CONVERSION. Default conversion procs and conversions are added in initdb. Currently supported conversions are: Tatsuo Ishii 2002-07-18 02:02:30 +00:00
  • df432df9fa Done, not sure when, reported by Neil Conway: Bruce Momjian 2002-07-17 22:15:20 +00:00
  • de1a6978fe Improve getopt_long search, per Peter: Bruce Momjian 2002-07-17 02:54:01 +00:00
  • 5af19e4227 Add more dependency insertions --- this completes the basic pg_depend functionality. Of note: dropping a table that has a SERIAL column defined now drops the associated sequence automatically. Tom Lane 2002-07-16 22:12:20 +00:00
  • cdebcad6af fixed bug in support for timestamp without time zone reported by Yuva Chandolu (ychandolu@ebates.com) Barry Lind 2002-07-16 21:05:17 +00:00
  • 846ea08d34 Oops, sometimes strtol isn't called in pg_atoi, so we do need that badp check. Bruce Momjian 2002-07-16 18:34:16 +00:00
  • 7aee5ed3b7 Fix tid to in/out as unsigned. Bruce Momjian 2002-07-16 17:55:25 +00:00
  • 14f1588356 Add initdb code to set up initial contents of pg_depend, pinning all objects created during initdb (except for the system views, which I think do not need to be pinned). Tom Lane 2002-07-16 17:48:46 +00:00
  • 93d6a8aa7d > pgsql-bugs@postgresql.org wrote: > > David Clark (dclarknospam@opsi.co.za) reports a bug with a severity > > Table 3-7 SQL Literal escaped octets shows the input escape > > representation for a single quote as '\\'' , but the third paragraph > > below table 3-8 SQL Output Escaped Octets says that the single quote > > must be input as '\'' > > Nice catch. '\'' is correct as shown in the example in Table 3-7. > > > > > Also in the same paragraph mentioned above it says input for the > > single quote must be '\'' (or '\\134') shouldn't this be (or '\\047') > > Also a bug. Should be '\\047', as you pointed out. > Bruce Momjian 2002-07-16 17:05:46 +00:00
  • 3c7798f068 Add conversion procs for CREATE CONVERSION Tatsuo Ishii 2002-07-16 09:25:06 +00:00
  • 743b747264 Fix typo Tatsuo Ishii 2002-07-16 06:58:44 +00:00
  • d49108fd73 Add FindDefaultConversionProc Tatsuo Ishii 2002-07-16 06:58:14 +00:00
  • 30ec31604d Add code to extract dependencies from an expression tree, and use it to build dependencies for rules, constraint expressions, and default expressions. Repair some problems in the original design of recursiveDeletion() exposed by more complex dependency sets. Fix regression tests that were deleting things in illegal sequences. Tom Lane 2002-07-16 05:53:34 +00:00
  • 1e07ab78cc Add DLLINIT mention in port/Makefile. Bruce Momjian 2002-07-16 05:49:38 +00:00
  • 3cbb9eb265 Move few remaining src/utils files to backend/port so everything is in one place. Everything may be moved to src/utils eventually. Bruce Momjian 2002-07-16 05:46:36 +00:00
  • d76eef3e7c Add mention of TOAST storage for character columns. Bruce Momjian 2002-07-16 04:45:59 +00:00
  • b3341ddbf2 Mark 'line' as 'not implemented' in SGML and psql \dT, per Thomas Lockhart. initdb not forced. Bruce Momjian 2002-07-16 03:30:27 +00:00
  • 7fb9b5d434 This fixes 2 inaccuracies in the recently added SQL99 feature list docs. UNIQUE and DISTINCT predicates are both listed as implemented -- AFAIK, neither is. Bruce Momjian 2002-07-16 00:51:37 +00:00
  • b52790b069 Add comment for isbn,issn data type, from Pete St. Onge Bruce Momjian 2002-07-16 00:48:30 +00:00
  • 1a6f91c9f3 Item not needed: Bruce Momjian 2002-07-15 23:34:34 +00:00
  • b00e50fbb8 Remove indenting of Makefile comments, per Peter.\ Bruce Momjian 2002-07-15 23:32:28 +00:00
  • 4ea0275f18 Remove utils/getopt.c file, not needed, it only allowed "--flag" warnings, and we now look for getopt_long in libgetopt.a. Bruce Momjian 2002-07-15 22:48:54 +00:00
  • cc618f2653 Add search for libgetopt.a in hopes of finding getopt_long(). Bruce Momjian 2002-07-15 22:41:45 +00:00
  • b9104e3a97 Remove certain Makefile dependencies by using full pathnames in configure.in. Bruce Momjian 2002-07-15 21:34:05 +00:00
  • 7bd631bfa4 Use the dependency mechanism to manage column defaults. We need this so that dependencies in default expressions (on operators, functions, etc) can be expressed properly. Tom Lane 2002-07-15 16:33:32 +00:00
  • 3c580b8d97 Fix make_ctags for exhuberant tags. Bruce Momjian 2002-07-15 14:45:51 +00:00
  • 5fad748eb8 Fix a bug about the handling of '.' in parse.c. Hiroshi Inoue 2002-07-15 02:56:39 +00:00
  • e552e9e512 Improve relcache.c error reporting for the next guy who has to debug this thing. Bruce Momjian 2002-07-15 01:57:51 +00:00
  • 91dfa1af97 Fix \? and \pset pager handling. \? wasn't honoring pager before. Bruce Momjian 2002-07-15 01:56:25 +00:00
  • d5fa19c6ee Add COMMENT ON CONSTRAINT facility (from Rod Taylor's pg_constraint patch). Fix comment.c to not depend on parser token values, per discussion awhile back. Tom Lane 2002-07-14 23:38:13 +00:00
  • c4fb2b4e9e Remove no-longer-appropriate notes about lack of CASCADE/RESTRICT behavior. Tom Lane 2002-07-14 22:47:56 +00:00
  • df3f5dfd19 In DeleteAttributeTuples, use a single indexscan instead of the multiple scans that will most likely be caused by SearchSysCache probes. Also, share some code between index deletion and table deletion. Tom Lane 2002-07-14 21:08:08 +00:00
  • 942a2e94fa Fix testing of partial-index predicates to work correctly in cases where varno of index's relation is not 1. This embarrassing oversight pointed out by Dmitry Tkach 12-Jul-02. Tom Lane 2002-07-13 19:20:34 +00:00
  • 59097af0bb Mark as done, per Rod: Bruce Momjian 2002-07-13 02:42:16 +00:00
  • fa064e9794 Both done: Bruce Momjian 2002-07-13 02:21:15 +00:00
  • 4db8718e84 Add SET statement_timeout capability. Timeout is in ms. A value of zero turns off the timer. Bruce Momjian 2002-07-13 01:02:14 +00:00
  • ccb3f90f06 Re-add -I documentation, per Tom. Bruce Momjian 2002-07-13 00:55:53 +00:00
  • 7c6df91dda Second phase of committing Rod Taylor's pg_depend/pg_constraint patch. pg_relcheck is gone; CHECK, UNIQUE, PRIMARY KEY, and FOREIGN KEY constraints all have real live entries in pg_constraint. pg_depend exists, and RESTRICT/CASCADE options work on most kinds of DROP; however, pg_depend is not yet very well populated with dependencies. (Most of the ones that are present at this point just replace formerly hardwired associations, such as the implicit drop of a relation's pg_type entry when the relation is dropped.) Need to add more logic to create dependency entries, improve pg_dump to dump constraints in place of indexes and triggers, and add some regression tests. Tom Lane 2002-07-12 18:43:19 +00:00
  • 791a40f943 Changed getCrossReference to return information about each composite key seperately It used to return them as a,b in one row, and now returns a in one row, and b in one row Dave Cramer 2002-07-12 13:07:48 +00:00
  • b82b2db7c1 An improvement of User Interface(Setup dialog) by Dave Page. Hiroshi Inoue 2002-07-12 02:02:26 +00:00
  • 59e5d516aa 1) Fix a memory leak in use declare/fetch mode. 2) Change default build mode to multibyte(Windows). Hiroshi Inoue 2002-07-12 01:41:25 +00:00
  • 839a346560 Not a valid item: Bruce Momjian 2002-07-11 21:41:25 +00:00
  • ccdb8a8d3a Remove duplicate: Bruce Momjian 2002-07-11 21:40:20 +00:00
  • 29dfd5fa26 Change error messages ExecAppend->ExecInsert and ExecReplace->ExecUpdate as discussed on hackers. Bruce Momjian 2002-07-11 21:36:20 +00:00
  • c20ae1ce50 Remove references to pre-7.1; too old. Bruce Momjian 2002-07-11 16:38:08 +00:00
  • dddd8608b3 Update FAQ. Bruce Momjian 2002-07-11 16:35:56 +00:00
  • fcc962566a Add new CREATE CONVERSION/DROP CONVERSION command. This is the first cut toward CREATE CONVERSION/DROP CONVERSION implementaion. The commands can now add/remove tuples to the new pg_conversion system catalog, but that's all. Still need work to make them actually working. Documentations, regression tests also need work. Tatsuo Ishii 2002-07-11 07:39:28 +00:00
  • f2bb1cfa85 Done, according to Rod Taylor: Bruce Momjian 2002-07-11 02:56:49 +00:00
  • 3a0136c7d2 Fix getopt flags. Man thing thing was messed up. Bruce Momjian 2002-07-11 02:00:14 +00:00
  • 9c6c0ceb97 Fix another --help typo in pg_restore. Bruce Momjian 2002-07-11 01:57:12 +00:00
  • 263db2e586 Make NAMEDATALEN changeable at compile time. Hiroshi Inoue 2002-07-11 01:52:46 +00:00
  • 87c963658c Fix pg_restore flags in documentation. Bruce Momjian 2002-07-10 02:57:31 +00:00
  • d676e29d41 fix bug in getTime() with fractional seconds reported by Laurette Cisneros (laurette@nextbus.com) Barry Lind 2002-07-10 00:51:36 +00:00
  • 92a77cb870 Oops, proper initialization for domainTypMod was none at all, not 0. Bruce Momjian 2002-07-09 13:52:14 +00:00
  • 81e7e71941 Fix compiler warning: Bruce Momjian 2002-07-09 05:21:35 +00:00
  • 6797ddcc32 Fix typo mentioned by Rich Morin. Bruce Momjian 2002-07-09 04:47:07 +00:00
  • 9af7179a10 Done: Bruce Momjian 2002-07-08 02:01:02 +00:00
  • 2dc53d863c Fix case syntax for freebsd template. Bruce Momjian 2002-07-08 01:54:30 +00:00
  • 20e83274bb Fix typo in xl_heaptid comment Bruce Momjian 2002-07-08 01:52:23 +00:00
  • 4f4753832e Move CXX platform-specific stuff into template files. Bruce Momjian 2002-07-07 20:28:25 +00:00
  • 712f69ece8 Convert expr to case, for Peter E. Bruce Momjian 2002-07-07 14:24:13 +00:00
  • 1666970275 I've fixed up the way domain constraints (not null and type length) are managed as per request. Bruce Momjian 2002-07-06 20:16:36 +00:00
  • 5af6e0a4ac Add comments about sharing. Bruce Momjian 2002-07-06 20:14:58 +00:00
  • 7015111a19 Move simple_prompt() into its own file to be shared with psql and pg_dump. Bruce Momjian 2002-07-06 20:12:30 +00:00
  • d66f172f4b Don't document that UNDO is certain to be added in the future. Bruce Momjian 2002-07-05 19:06:11 +00:00
  • f170e61d9b fixed bug reported by Michael, Dietrich (mdt@emdete.de) where a large object handle was being used after the end of the transaction and thus resulting in an error. Barry Lind 2002-07-05 18:50:27 +00:00
  • fe92e018d7 Add a few new lines to display recently added fields in the ControlFile structure. Now includes the following new fields: integer/float date/time storage maximum length of names (+1; they must also include a null termination) maximum number of function arguments maximum length of locale name Thomas G. Lockhart 2002-07-05 15:31:16 +00:00
  • b2f2415c92 Mark person: Bruce Momjian 2002-07-05 02:10:17 +00:00
  • 5ebbf01838 Done Bruce Momjian 2002-07-05 02:09:52 +00:00
  • 8831c35a19 Fix a bug reported by Zhou Han. Hiroshi Inoue 2002-07-05 01:31:41 +00:00