Commit Graph

  • fac4f9a698 HP's compiler objects (quite rightly too) to 'static void foo();' followed by 'extern void foo() { ... }'. Tom Lane 2000-02-19 18:58:37 +00:00
  • dfdff4e0f1 First workaround solution for Jan's column constraint attributes. Thomas G. Lockhart 2000-02-19 08:25:49 +00:00
  • 58a9ea9d80 Clean up markup so docs will compile. Thomas G. Lockhart 2000-02-19 08:14:54 +00:00
  • ac324075de Update for new Irix info. Thomas G. Lockhart 2000-02-19 08:14:33 +00:00
  • 4fec86f1f6 Fix nasty bug in setting client_encoding Tatsuo Ishii 2000-02-19 05:04:54 +00:00
  • eb089e7f76 Add new backslash command \eset and \eshow. Tatsuo Ishii 2000-02-19 05:01:16 +00:00
  • c239c11a63 Fix compiler warning Tatsuo Ishii 2000-02-19 04:59:30 +00:00
  • 3cfdd8fdf2 Clean up scan.l's handling of \r vs \n --- they are reliably treated as equivalent now, which should make Windows and Mac clients happier. Also fix failure to handle SQL comments between segments of a multiline quoted literal. Tom Lane 2000-02-19 04:17:25 +00:00
  • 905404a246 Remove gcc warnings. The Postgres world isn't really safe for 'const' qualifiers yet ... Tom Lane 2000-02-19 02:29:07 +00:00
  • 3cbcb78a3d Plug some more memory leaks in the planner. It still leaks like a sieve, but this is as good as it'll get for this release... Tom Lane 2000-02-18 23:47:31 +00:00
  • bc8a39beef *** empty log message *** Michael Meskes 2000-02-18 16:02:49 +00:00
  • ab0c8c691e *** empty log message *** Michael Meskes 2000-02-18 14:34:12 +00:00
  • e3a97b370c Implement reindex command Hiroshi Inoue 2000-02-18 09:30:20 +00:00
  • e3befe4a66 *** empty log message *** Michael Meskes 2000-02-18 08:49:07 +00:00
  • 8cb624262a Replace inefficient _bt_invokestrat calls with direct calls to the appropriate btree three-way comparison routine. Not clear why the three-way comparison routines were being used in some paths and not others in btree --- incomplete changes by someone long ago, maybe? Anyway, this makes for a nice speedup in CREATE INDEX. Tom Lane 2000-02-18 06:32:39 +00:00
  • 49353692d1 Fixed handling of old --with-mb option using newly gained wisdom from autoconf mailing list. ;) Peter Eisentraut 2000-02-18 00:21:38 +00:00
  • b3b35e98b6 *** empty log message *** Michael Meskes 2000-02-17 19:48:58 +00:00
  • 3ca3bb7d8b Fix assert bug(was my fault) Hiroshi Inoue 2000-02-17 05:00:38 +00:00
  • 598ea2c359 Finish repairing 6.5's problems with r-tree indexes: create appropriate selectivity functions and make the r-tree operators use them. The estimation functions themselves are just stubs, unfortunately, but perhaps someday someone will make them compute realistic estimates. Change pg_am so that the optimizer can reliably tell the difference between ordered and unordered indexes --- before it would think that an r-tree index can be scanned in '<<' order, which is not right AFAIK. Repair broken negator links for network_sup and related ops. Initdb forced. This might be my last initdb force for 7.0 ... hope so anyway ... Tom Lane 2000-02-17 03:40:02 +00:00
  • cf880a6160 Update expected/horology-no-DST-before-1970.out to match new datetime regress test. Someone needs to deal with fixing expected/horology-solaris-1947.out too, assuming we still need it. Tom Lane 2000-02-17 02:20:59 +00:00
  • 0d9a0ed6d1 Package: postgresql Version: 6.5.3-11 Severity: important Bruce Momjian 2000-02-16 23:07:31 +00:00
  • a52692213c README not needed anymore. Bruce Momjian 2000-02-16 21:26:00 +00:00
  • bf566b202e All regression tests pass except for rules.sql (unrelated). Implement "date/time grand unification". Transform datetime and timespan into timestamp and interval. Deprecate datetime and timespan, though translate to new types in gram.y. Transform all datetime and timespan catalog entries into new types. Make "INTERVAL" reserved word allowed as a column identifier in gram.y. Remove dt.h, dt.c files, and retarget datetime.h, datetime.c as utility routines for all date/time types. date.{h,c} now deals with date, time types. timestamp.{h,c} now deals with timestamp, interval types. nabstime.{h,c} now deals with abstime, reltime, tinterval types. Make NUMERIC a known native type for purposes of type coersion. Not tested. Thomas G. Lockhart 2000-02-16 18:17:02 +00:00
  • 8997675c4b All regression tests pass except for rules.sql (unrelated). Implement "date/time grand unification". Transform datetime and timespan into timestamp and interval. Deprecate datetime and timespan, though translate to new types in gram.y. Transform all datetime and timespan catalog entries into new types. Make "INTERVAL" reserved word allowed as a column identifier in gram.y. Remove dt.h, dt.c files, and retarget datetime.h, datetime.c as utility routines for all date/time types. date.{h,c} now deals with date, time types. timestamp.{h,c} now deals with timestamp, interval types. nabstime.{h,c} now deals with abstime, reltime, tinterval types. Make NUMERIC a known native type for purposes of type coersion. Not tested. Thomas G. Lockhart 2000-02-16 17:27:27 +00:00
  • 41f1f5b76a Implement "date/time grand unification". Transform datetime and timespan into timestamp and interval. Deprecate datetime and timespan, though translate to new types in gram.y. Transform all datetime and timespan catalog entries into new types. Make "INTERVAL" reserved word allowed as a column identifier in gram.y. Remove dt.h, dt.c files, and retarget datetime.h, datetime.c as utility routines for all date/time types. date.{h,c} now deals with date, time types. timestamp.{h,c} now deals with timestamp, interval types. nabstime.{h,c} now deals with abstime, reltime, tinterval types. Make NUMERIC a known native type for purposes of type coersion. Not tested. Thomas G. Lockhart 2000-02-16 17:26:26 +00:00
  • c97672b083 Make ISO date style (e.g. "2000-02-16 09:33") the default. Implement "date/time grand unification". Transform datetime and timespan into timestamp and interval. Deprecate datetime and timespan, though translate to new types in gram.y. Transform all datetime and timespan catalog entries into new types. Make "INTERVAL" reserved word allowed as a column identifier in gram.y. Remove dt.h, dt.c files, and retarget datetime.h, datetime.c as utility routines for all date/time types. date.{h,c} now deals with date, time types. timestamp.{h,c} now deals with timestamp, interval types. nabstime.{h,c} now deals with abstime, reltime, tinterval types. Make NUMERIC a known native type for purposes of type coersion. Not tested. Thomas G. Lockhart 2000-02-16 17:25:49 +00:00
  • 35ba9de276 *** empty log message *** Michael Meskes 2000-02-16 16:18:29 +00:00
  • 988d53e5ea include cleanup Bruce Momjian 2000-02-16 13:22:00 +00:00
  • 78693c89d7 Clean up include files use in psql. Bruce Momjian 2000-02-16 13:15:26 +00:00
  • 5933f1857f *** empty log message *** Michael Meskes 2000-02-16 11:52:25 +00:00
  • 68be513f8b If we don't have any stats for a boolean column, assume the disbursion is 0.5, not something small. Tom Lane 2000-02-16 01:00:23 +00:00
  • deee4e1612 Make eqsel produce better results for boolean columns, and make scalarltsel a little more forgiving at the boundaries of the known range of a column value. Tom Lane 2000-02-16 00:59:27 +00:00
  • 9c80cceb02 Update EXPLAIN documentation to reflect the fact that the planner now produces two cost numbers instead of one. Tom Lane 2000-02-15 23:37:49 +00:00
  • 47dde30222 Remove long-dead code. Tom Lane 2000-02-15 23:12:26 +00:00
  • 90e160beff Fix missing lfirst() in ListTableAsAttrs(). This code doesn't seem to be used at the moment, but as long as I'm looking at it... Tom Lane 2000-02-15 23:09:08 +00:00
  • b1577a7c78 New cost model for planning, incorporating a penalty for random page accesses versus sequential accesses, a (very crude) estimate of the effects of caching on random page accesses, and cost to evaluate WHERE- clause expressions. Export critical parameters for this model as SET variables. Also, create SET variables for the planner's enable flags (enable_seqscan, enable_indexscan, etc) so that these can be controlled more conveniently than via PGOPTIONS. Tom Lane 2000-02-15 20:49:31 +00:00
  • 553b5da6a1 Change to report COPY line number in error messages affects results of constraints regress test. Tom Lane 2000-02-15 19:45:31 +00:00
  • 30f16e72a4 *** empty log message *** Michael Meskes 2000-02-15 19:23:20 +00:00
  • 6124c674ce Silence gcc warning about uninitialized var. Tom Lane 2000-02-15 18:17:33 +00:00
  • 16620abe12 Removed unused var to silence gcc warning. Tom Lane 2000-02-15 18:15:12 +00:00
  • 72786e04fd *** empty log message *** Michael Meskes 2000-02-15 12:15:57 +00:00
  • 4c2071c8bf Repair bogus rule display of attr lists. Tom Lane 2000-02-15 08:24:12 +00:00
  • 1204c3e964 Remove some // comments, which are not ANSI C last I heard. Tom Lane 2000-02-15 07:47:37 +00:00
  • f770a61cfa Rename file to be consistant with other platform-specific FAQs. Thomas G. Lockhart 2000-02-15 05:22:36 +00:00
  • f0c66e539b Fix extraneous ending tag on libpq.sgml. Renormalize query.sgml and fix indenting. Thomas G. Lockhart 2000-02-15 03:57:02 +00:00
  • a344a6e7b5 Carry column aliases from the parser frontend. Enables queries like SELECT a FROM t1 tx (a); Allow join syntax, including queries like SELECT * FROM t1 NATURAL JOIN t2; Update RTE structure to hold column aliases in an Attr structure. Thomas G. Lockhart 2000-02-15 03:38:29 +00:00
  • 92c8437d8d Update "join syntax" test for new capabilities. Thomas G. Lockhart 2000-02-15 03:31:33 +00:00
  • ebd697a388 Add line to mention PST8PDT time zone. Seems useful, but maybe not? Thomas G. Lockhart 2000-02-15 03:30:57 +00:00
  • e0c192e4d7 Fix up error message to start with cap letter. Thomas G. Lockhart 2000-02-15 03:30:06 +00:00
  • a1e6a09a89 Fix up tabbing for _int8 entry. Thomas G. Lockhart 2000-02-15 03:28:31 +00:00
  • 5c4b2b23af Add "DEC" as synonym for "DECIMAL". Add "SESSION_USER" as SQL92 keyword; equivalent to CURRENT_USER for now. Implement column aliases (aka correlation names) and more join syntax. Fix up indenting and tabbing. Thomas G. Lockhart 2000-02-15 03:26:38 +00:00
  • 929e50ece8 Recognize special case of POSIX time zone: "GMT+8" and "GMT-8". Still needs to be done for the general case: "tz+/-#" where tz is a 3 char string. This will probably involve moving code around to other places. Thomas G. Lockhart 2000-02-15 03:17:09 +00:00
  • 7c07006ad4 Fix up error and log messages. Thomas G. Lockhart 2000-02-15 03:00:37 +00:00
  • f4ca323d21 I suspect that you are not the person to send this to, but I wasn't sure where else to mail it. I am the maintainer of unixODBC, and we have a set of code in our project that started life as the Postgres windows ODBC driver, which has been ported back to unix. Anyway I have just fixed a memory leak in the driver, and I cant see any mention of the fix being done in the main Postgres code, so I thougth I would let you know. Bruce Momjian 2000-02-14 12:33:19 +00:00
  • d891ca1853 Update README.NT with new NT ipc location. Bruce Momjian 2000-02-14 12:29:58 +00:00
  • 08b999f1bd *** empty log message *** Michael Meskes 2000-02-14 10:00:06 +00:00
  • 9672d38f91 Adjusted psql echoing options (-a and -e) Peter Eisentraut 2000-02-13 21:45:15 +00:00
  • a2226ad237 contrib-array.patch Bruce Momjian 2000-02-13 18:59:53 +00:00
  • 77d31cf3c1 2. trigger.c fails to compile due to a syntax error. It contains a switch statement that has an empty default label. A label of a switch statement must be followed by a statement (or a label which is followed by a statement (or a label which ...)). Bruce Momjian 2000-02-13 13:21:11 +00:00
  • 2fb0ff0c5b Default argument for createdb Changed EXIT_ON_ERROR to ON_ERROR_STOP in psql Peter Eisentraut 2000-02-10 20:08:58 +00:00
  • 7528fd2d52 Add btree indexing of boolean values Don Baccus Bruce Momjian 2000-02-10 19:51:52 +00:00
  • ede72c2826 Improve default compile ops. Bruce Momjian 2000-02-10 19:11:17 +00:00
  • 25fdc6bac6 Add no CVS to make_mkid. Bruce Momjian 2000-02-10 18:41:35 +00:00
  • ecef31ca61 Prevent tags files in cvs directory. Bruce Momjian 2000-02-10 18:34:26 +00:00
  • 5d93742b8d You will need to copy "config.h.win32" to "config.h" in the include directory. Bruce Momjian 2000-02-10 15:47:58 +00:00
  • b1b8fc813f Update length to 31. Bruce Momjian 2000-02-10 04:08:25 +00:00
  • 566c05c31a Here is the patch to add plperl to droplang. Mark Hollomon Bruce Momjian 2000-02-09 20:23:26 +00:00
  • 1a03ab9c87 Update TODO list. Bruce Momjian 2000-02-09 20:09:29 +00:00
  • ecd8537376 I checked the WinNT port yesterday (a few days old snapshot from CVS) and I am including a patch to get it compile. Bruce Momjian 2000-02-09 16:23:44 +00:00
  • 3dec14197b Enable backward sequential scan even after reaching EOF. Hiroshi Inoue 2000-02-09 03:49:47 +00:00
  • 9e34883565 Fixed broken initdb --show patch Peter Eisentraut 2000-02-09 00:21:49 +00:00
  • 1960f4be14 Ooops ... 'char c' can hold a char, but it can't hold EOF ... Tom Lane 2000-02-09 00:10:11 +00:00
  • 1cc7e40c80 yesterday I had a problem with initdb. I set bad environment values and initdb crashs (I set pglib path to PG 6.5.3 directory instead to 7.0 and initdb take this BKI old templates ... (initdb not check BKI version and BKI files not has any version comments (TODO?)) Bruce Momjian 2000-02-08 15:58:54 +00:00
  • 394af52795 I'm sending patch with new version of to_char numbers formatting. Bruce Momjian 2000-02-08 15:57:01 +00:00
  • 9ceb5d8a7b Fixed psql double quoting of SQL ids Fixed libpq printing functions Peter Eisentraut 2000-02-07 23:10:11 +00:00
  • 4842ef8624 Mask removal of network_ops in 7.0. Bruce Momjian 2000-02-07 21:24:15 +00:00
  • aef647a274 Enabled MATCH <unspecified> Jan Wieck 2000-02-07 18:12:49 +00:00
  • f59daf80f7 Added complete MATCH <unspecified> support contributed by Don Baccus. Jan Wieck 2000-02-07 17:50:38 +00:00
  • f1acd900ad Disable/reenable triggers for data only dump. Jan Wieck 2000-02-07 16:30:58 +00:00
  • d8733ce674 Repair planning bugs caused by my misguided removal of restrictinfo link fields in JoinPaths --- turns out that we do need that after all :-(. Also, rearrange planner so that only one RelOptInfo is created for a particular set of joined base relations, no matter how many different subsets of relations it can be created from. This saves memory and processing time compared to the old method of making a bunch of RelOptInfos and then removing the duplicates. Clean up the jointree iteration logic; not sure if it's better, but I sure find it more readable and plausible now, particularly for the case of 'bushy plans'. Tom Lane 2000-02-07 04:41:04 +00:00
  • 2bda7a4406 change copyright year 1999->2000 Minor fix Tatsuo Ishii 2000-02-07 04:31:10 +00:00
  • 5b58de124e Allow SELECT .. FOR UPDATE in PL/pgSQL. Hiroshi Inoue 2000-02-07 03:39:13 +00:00
  • 7d738f9586 Remove ugly call ImmediateSharedRelationCacheInvalidate() from md.c. Hiroshi Inoue 2000-02-07 02:38:18 +00:00
  • 4acf890948 Removed special hack causing ON UPDATE NO ACTION trigger to be suppressed. Jan Wieck 2000-02-06 10:19:45 +00:00
  • a64d3bc433 Solaris has always had problems with 1947 in the regression tests so I prepared a set of expected files to make things look OK. Bruce Momjian 2000-02-06 05:09:42 +00:00
  • 81fc1d5edb Rename same() to sameseti() to have a slightly less generic name. Move nonoverlap_sets() and is_subset() to list.c, where they should have lived to begin with, and rename to nonoverlap_setsi and is_subseti since they only work on integer lists. Tom Lane 2000-02-06 03:27:35 +00:00
  • 418b270020 Fix a bug when specfying -D option. fix suggested by Keith Parks. Tatsuo Ishii 2000-02-06 00:49:03 +00:00
  • 60be6da731 Replace nth() calls in inner loops with traversal of the list via lnext, to eliminate O(N^2) behavior with lots of indexquals. Tom Lane 2000-02-05 23:19:44 +00:00
  • 78296c2797 Further cleanup for OR-of-AND WHERE-clauses. orindxpath can now handle extracting from an AND subclause just those opclauses that are relevant for a particular index. For example, we can now consider using an index on x to process WHERE (x = 1 AND y = 2) OR (x = 2 AND y = 4) OR ... Tom Lane 2000-02-05 18:26:09 +00:00
  • dd14cd63be Update TODO list. Bruce Momjian 2000-02-05 17:02:43 +00:00
  • d4e62e5ded Change function name PQclientencoding to PQclientEncoding since it seems more suitable for the naming convention in libpq. Tatsuo Ishii 2000-02-05 12:33:22 +00:00
  • b304b4a90e Change function name PQclientencoding to PQclientEncoding since it seems more suitable for the naming convention in libpq. Tatsuo Ishii 2000-02-05 12:27:56 +00:00
  • ad15560573 Enabling automatic primary key detection for self-referencing FOREIGN KEY constraint during CREATE TABLE. Tnx to Stephan. Jan Wieck 2000-02-05 00:20:38 +00:00
  • 582ec175c9 Small bugfix for DROP TABLE if table is self-referenced by a FOREIGN KEY constraint. Jan Wieck 2000-02-04 23:45:04 +00:00
  • 7932f86c53 Update TODO list. Bruce Momjian 2000-02-04 22:41:28 +00:00
  • ddd596d386 Added ALTER TABLE ... ADD CONSTRAINT (provided by Stephan Szabo). Jan Wieck 2000-02-04 18:49:34 +00:00
  • 74d53d7838 Made prototypes for yyerror() consistent with Bruce's last changes Jan Wieck 2000-02-04 18:45:23 +00:00
  • df035f762a Update TODO list. Bruce Momjian 2000-02-04 05:04:55 +00:00
  • b64826a47d Squash longstanding memory leak: when catcache.c copied a tuple into the cache context, it didn't bother to free the tuple that CatalogIndexFetchTuple had allocated in the transaction context. Do enough cache lookups in the same xact, and you start to notice... Tom Lane 2000-02-04 03:16:03 +00:00
  • 16d0adb93f Update TODO list. Bruce Momjian 2000-02-03 12:22:33 +00:00