4 -- bad in postquel, but ok in postsql
18 -- missing relation name
21 select * from nonesuch;
22 ERROR: parser: parse error at or near "select"
23 -- bad name in target list
24 select nonesuch from pg_database;
25 ERROR: Attribute 'nonesuch' not found
26 -- bad attribute name on lhs of operator
27 select * from pg_database where nonesuch = pg_database.datname;
28 ERROR: Attribute 'nonesuch' not found
29 -- bad attribute name on rhs of operator
30 select * from pg_database where pg_database.datname = nonesuch;
31 ERROR: Attribute 'nonesuch' not found
32 -- bad select distinct on syntax, distinct attribute missing
33 select distinct on (foobar) from pg_database;
34 ERROR: parser: parse error at or near "from"
35 -- bad select distinct on syntax, distinct attribute not in target list
36 select distinct on (foobar) * from pg_database;
37 ERROR: Attribute 'foobar' not found
41 -- missing relation name (this had better not wildcard!)
43 ERROR: parser: parse error at or near ";"
46 ERROR: Relation "nonesuch" does not exist
50 -- missing relation name (this had better not wildcard!)
52 ERROR: parser: parse error at or near ";"
55 ERROR: table "nonesuch" does not exist
60 -- missing relation name
62 ERROR: parser: parse error at or near ";"
64 alter table nonesuch rename to newnonesuch;
65 ERROR: Relation "nonesuch" does not exist
67 alter table nonesuch rename to stud_emp;
68 ERROR: Relation "nonesuch" does not exist
70 alter table stud_emp rename to pg_stud_emp;
71 ERROR: renamerel: Illegal class name: "pg_stud_emp" -- pg_ is reserved for system catalogs
73 alter table stud_emp rename to aggtest;
74 ERROR: renamerel: relation "aggtest" exists
76 alter table stud_emp rename to stud_emp;
77 ERROR: renamerel: relation "stud_emp" exists
80 alter table nonesuchrel rename column nonesuchatt to newnonesuchatt;
81 ERROR: Relation "nonesuchrel" does not exist
83 alter table emp rename column nonesuchatt to newnonesuchatt;
84 ERROR: renameatt: attribute "nonesuchatt" does not exist
86 alter table emp rename column salary to manager;
87 ERROR: renameatt: attribute "manager" exists
89 alter table emp rename column salary to oid;
90 ERROR: renameatt: attribute "oid" exists
96 WARNING: ROLLBACK: no transaction in progress
99 WARNING: COMMIT: no transaction in progress
102 -- sfunc/finalfunc type disagreement
103 create aggregate newavg2 (sfunc = int4pl,
108 ERROR: AggregateCreate: function 'int2um(int4)' does not exist
110 create aggregate newcnt1 (sfunc = int4inc,
113 ERROR: Define: "basetype" unspecified
117 -- missing index name
119 ERROR: parser: parse error at or near ";"
122 ERROR: parser: parse error at or near "314159"
125 ERROR: index "nonesuch" does not exist
129 -- missing aggregate name
131 ERROR: parser: parse error at or near ";"
132 -- missing aggregate type
133 drop aggregate newcnt1;
134 ERROR: parser: parse error at or near ";"
135 -- bad aggregate name
136 drop aggregate 314159 (int);
137 ERROR: parser: parse error at or near "314159"
138 -- bad aggregate type
139 drop aggregate newcnt (nonesuch);
140 ERROR: RemoveAggregate: type 'nonesuch' does not exist
142 drop aggregate nonesuch (int4);
143 ERROR: RemoveAggregate: aggregate 'nonesuch' for type integer does not exist
144 -- no such aggregate for type
145 drop aggregate newcnt (float4);
146 ERROR: RemoveAggregate: aggregate 'newcnt' for type real does not exist
150 -- missing function name
152 ERROR: parser: parse error at or near "("
154 drop function 314159();
155 ERROR: parser: parse error at or near "314159"
157 drop function nonesuch();
158 ERROR: RemoveFunction: function 'nonesuch()' does not exist
164 ERROR: parser: parse error at or near ";"
167 ERROR: parser: parse error at or near "314159"
170 ERROR: RemoveType: type 'nonesuch' does not exist
174 -- missing everything
176 ERROR: parser: parse error at or near ";"
178 drop operator equals;
179 ERROR: parser: parse error at or near "equals"
182 ERROR: parser: parse error at or near ";"
183 -- missing parentheses
184 drop operator int4, int4;
185 ERROR: parser: parse error at or near "int4"
186 -- missing operator name
187 drop operator (int4, int4);
188 ERROR: parser: parse error at or near "("
189 -- missing type list contents
190 drop operator === ();
191 ERROR: parser: parse error at or near ")"
193 drop operator === (int4);
194 ERROR: parser: argument type missing (use NONE for unary operators)
195 -- no such operator by that name
196 drop operator === (int4, int4);
197 ERROR: RemoveOperator: binary operator '===' taking 'int4' and 'int4' does not exist
199 drop operator = (nonesuch);
200 ERROR: parser: argument type missing (use NONE for unary operators)
202 drop operator = ( , int4);
203 ERROR: parser: parse error at or near ","
205 drop operator = (nonesuch, int4);
206 ERROR: RemoveOperator: type 'nonesuch' does not exist
208 drop operator = (int4, nonesuch);
209 ERROR: RemoveOperator: type 'nonesuch' does not exist
211 drop operator = (int4, );
212 ERROR: parser: parse error at or near ")"
218 ERROR: parser: parse error at or near ";"
221 ERROR: parser: parse error at or near "314159"
224 ERROR: Rule or view "nonesuch" not found
226 drop tuple rule nonesuch;
227 ERROR: parser: parse error at or near "tuple"
229 drop instance rule nonesuch;
230 ERROR: parser: parse error at or near "instance"
232 drop rewrite rule nonesuch;
233 ERROR: parser: parse error at or near "rewrite"