- 11 May, 2001 1 commit
-
-
Tom Lane authored
name in two different tests. This solution does not meet with universal approval, so it may get changed later ...
-
- 09 May, 2001 1 commit
-
-
Bruce Momjian authored
in referencing and referenced columns of an fk constraint aren't comparable using '=' at constraint definition time rather than insert/update time. Stephan Szabo
-
- 05 Dec, 2000 1 commit
-
-
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.
-
- 29 Aug, 2000 1 commit
-
-
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
-
- 14 Mar, 2000 1 commit
-
-
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.
-
- 22 Feb, 2000 1 commit
-
-
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
-
- 15 Feb, 2000 1 commit
-
-
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.
-
- 11 Jan, 2000 1 commit
-
-
Tom Lane authored
-
- 06 Jan, 2000 1 commit
-
-
Thomas G. Lockhart authored
-
- 05 Jan, 2000 1 commit
-
-
Thomas G. Lockhart authored
-
- 02 Feb, 1999 1 commit
-
-
Bruce Momjian authored
-
- 30 Aug, 1998 1 commit
-
-
Thomas G. Lockhart authored
Fix example columns in alter_table.out to use datetime and timespan as a substitute for oidint4 and oidname.
-
- 26 Apr, 1998 1 commit
-
-
Bruce Momjian authored
-
- 07 Apr, 1998 1 commit
-
-
Bruce Momjian authored
-
- 30 Mar, 1998 1 commit
-
-
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
-
- 01 Dec, 1997 1 commit
-
-
Thomas G. Lockhart authored
Add tests for strings and varchar.
-
- 27 Apr, 1997 1 commit
-
-
Marc G. Fournier authored
what's being tested :)
-