1. 31 Oct, 2001 2 commits
  2. 12 Oct, 2001 1 commit
    • Tom Lane's avatar
      Break transformCreateStmt() into multiple routines and make · f9e6e27c
      Tom Lane authored
      transformAlterStmt() use these routines, instead of having lots of
      duplicate (not to mention should-have-been-duplicate) code.
      Adding a column with a CHECK constraint actually works now,
      and the tests to reject unsupported DEFAULT and NOT NULL clauses
      actually fire now.  ALTER TABLE ADD PRIMARY KEY works, modulo
      having to have created the column(s) NOT NULL already.
      f9e6e27c
  3. 09 Aug, 2001 1 commit
  4. 30 May, 2001 1 commit
  5. 11 May, 2001 1 commit
  6. 09 May, 2001 1 commit
  7. 05 Dec, 2000 1 commit
    • Tom Lane's avatar
      From Stephan Szabo: · 981a7d32
      Tom Lane authored
      I believe this should fix the issue that Philip Warner
      noticed about the check for unique constraints meeting the
      referenced keys of a foreign key constraint allowing the
      specification of a subset of a foreign key instead of
      rejecting it.  I also added tests for a base case of
      this to the foreign key and alter table tests and patches
      for expected output.
      981a7d32
  8. 29 Aug, 2000 1 commit
    • Bruce Momjian's avatar
      This is mostly the same as an earlier patch I · d4f62650
      Bruce Momjian authored
      didn't hear anything about, but which would
      have broken with the function manager changes
      anyway.
      
      Well, this patch checks that a unique constraint
      of some form (unique or pk) is on the referenced
      columns of an FK constraint and that the columns
      in the referencing table exist at creation time.
      The former is to move closer to SQL compatibility
      and the latter is in answer to a bug report.
      I also added a basic check of this functionality
      to the alter table and foreign key regression
      tests.
      
      Stephan Szabo
      sszabo@bigpanda.com
      d4f62650
  9. 16 Jul, 2000 1 commit
  10. 14 Mar, 2000 1 commit
    • Thomas G. Lockhart's avatar
      Implement column aliases on views "CREATE VIEW name (collist)". · 64568100
      Thomas G. Lockhart authored
      Implement TIME WITH TIME ZONE type (timetz internal type).
      Remap length() for character strings to CHAR_LENGTH() for SQL92
       and to remove the ambiguity with geometric length() functions.
      Keep length() for character strings for backward compatibility.
      Shrink stored views by removing internal column name list from visible rte.
      Implement min(), max() for time and timetz data types.
      Implement conversion of TIME to INTERVAL.
      Implement abs(), mod(), fac() for the int8 data type.
      Rename some math functions to generic names:
       round(), sqrt(), cbrt(), pow(), etc.
      Rename NUMERIC power() function to pow().
      Fix int2 factorial to calculate result in int4.
      Enhance the Oracle compatibility function translate() to work with string
       arguments (from Edwin Ramirez).
      Modify pg_proc system table to remove OID holes.
      64568100
  11. 22 Feb, 2000 1 commit
    • Bruce Momjian's avatar
      Well, here's the first pass on regression · 020be62d
      Bruce Momjian authored
      tests for the Foreign Key support in 7.0 which
      was made against a CVS copy from this
      afternoon.
      
      This modifies
       src/test/regress/sql/run_check.tests
       src/test/regress/sql/alter_table.sql
       src/test/regress/expected/alter_table.out
       src/test/regress/sql/foreign_key.sql
       src/test/regress/expected/foreign_key.out
      
      sszabo@bigpanda.co
      020be62d
  12. 15 Feb, 2000 1 commit
    • Tom Lane's avatar
      New cost model for planning, incorporating a penalty for random page · b1577a7c
      Tom Lane authored
      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.
      
      Planner now estimates both startup cost (cost before retrieving
      first tuple) and total cost of each path, so it can optimize queries
      with LIMIT on a reasonable basis by interpolating between these costs.
      Same facility is a win for EXISTS(...) subqueries and some other cases.
      
      Redesign pathkey representation to achieve a major speedup in planning
      (I saw as much as 5X on a 10-way join); also minor changes in planner
      to reduce memory consumption by recycling discarded Path nodes and
      not constructing unnecessary lists.
      
      Minor cleanups to display more-plausible costs in some cases in
      EXPLAIN output.
      
      Initdb forced by change in interface to index cost estimation
      functions.
      b1577a7c
  13. 11 Jan, 2000 1 commit
  14. 09 Jan, 2000 1 commit
  15. 23 Feb, 1999 1 commit
  16. 02 Feb, 1999 1 commit
  17. 30 Aug, 1998 1 commit
  18. 26 Apr, 1998 1 commit
  19. 07 Apr, 1998 1 commit
  20. 30 Mar, 1998 1 commit
    • Bruce Momjian's avatar
      The following uuencoded, gzip'd file will ... · 57b59664
      Bruce Momjian authored
      1. Remove the char2, char4, char8 and char16 types from postgresql
      2. Change references of char16 to name in the regression tests.
      3. Rename the char16.sql regression test to name.sql.  4. Modify
      the regression test scripts and outputs to match up.
      
      Might require new regression.{SYSTEM} files...
      
      Darren King
      57b59664
  21. 05 Jan, 1998 1 commit
  22. 01 Dec, 1997 1 commit
  23. 16 Sep, 1997 1 commit
  24. 05 May, 1997 1 commit
  25. 29 Apr, 1997 1 commit