diff options
| author | Tom Lane | 2002-03-29 19:06:29 +0000 |
|---|---|---|
| committer | Tom Lane | 2002-03-29 19:06:29 +0000 |
| commit | d5e99ab4d6718e8ef515575e33fb5c6181cdcc96 (patch) | |
| tree | 6c817d6358f50ae920207245c3b862b2cdd74ceb /src/test | |
| parent | 7c1ff354105e2256d7904497d8e282ccec53d2e6 (diff) | |
pg_type has a typnamespace column; system now supports creating types
in different namespaces. Also, cleanup work on relation namespace
support: drop, alter, rename commands work for tables in non-default
namespaces.
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/errors.out | 8 | ||||
| -rw-r--r-- | src/test/regress/output/create_function_2.source | 2 |
2 files changed, 5 insertions, 5 deletions
diff --git a/src/test/regress/expected/errors.out b/src/test/regress/expected/errors.out index bd9707c2bdb..56c8939c6f0 100644 --- a/src/test/regress/expected/errors.out +++ b/src/test/regress/expected/errors.out @@ -137,7 +137,7 @@ drop aggregate 314159 (int); ERROR: parser: parse error at or near "314159" -- bad aggregate type drop aggregate newcnt (nonesuch); -ERROR: RemoveAggregate: type 'nonesuch' does not exist +ERROR: Type "nonesuch" does not exist -- no such aggregate drop aggregate nonesuch (int4); ERROR: RemoveAggregate: aggregate 'nonesuch' for type integer does not exist @@ -167,7 +167,7 @@ drop type 314159; ERROR: parser: parse error at or near "314159" -- no such type drop type nonesuch; -ERROR: RemoveType: type 'nonesuch' does not exist +ERROR: Type "nonesuch" does not exist -- -- DROP OPERATOR @@ -203,10 +203,10 @@ drop operator = ( , int4); ERROR: parser: parse error at or near "," -- no such type1 drop operator = (nonesuch, int4); -ERROR: RemoveOperator: type 'nonesuch' does not exist +ERROR: Type "nonesuch" does not exist -- no such type2 drop operator = (int4, nonesuch); -ERROR: RemoveOperator: type 'nonesuch' does not exist +ERROR: Type "nonesuch" does not exist -- no such type2 drop operator = (int4, ); ERROR: parser: parse error at or near ")" diff --git a/src/test/regress/output/create_function_2.source b/src/test/regress/output/create_function_2.source index 137242da705..4d508497cf6 100644 --- a/src/test/regress/output/create_function_2.source +++ b/src/test/regress/output/create_function_2.source @@ -13,8 +13,8 @@ CREATE FUNCTION hobbies_by_name(hobbies_r.name%TYPE) RETURNS hobbies_r.person%TYPE AS 'select person from hobbies_r where name = $1' LANGUAGE 'sql'; -NOTICE: hobbies_r.name%TYPE converted to text NOTICE: hobbies_r.person%TYPE converted to text +NOTICE: hobbies_r.name%TYPE converted to text CREATE FUNCTION equipment(hobbies_r) RETURNS setof equipment_r AS 'select * from equipment_r where hobby = $1.name' |