| From: | Casey Allen Shobe <cshobe(at)secureworks(dot)net> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Odd random drop sequence failure |
| Date: | 2002-10-22 03:06:22 |
| Message-ID: | 200210212306.22018.cshobe@secureworks.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
template1=# drop sequence scheduled_queries_id_seq,
scheduled_query_group_types_id_, scheduled_query_groups_id_seq,
scheme_info_id_seq, scheme_info_types_id_seq, schemes_id_seq,
user_info_id_seq, user_info_types_id_seq, schemes_id_seq, user_info_id_seq,
user_info_types_id_seq, user_setting_types_id_seq, user_settings_id_seq;
ERROR: sequence "schemes_id_seq" does not exist
template1=# \ds
List of relations
Name | Type | Owner
---------------------------------+----------+-------
scheduled_queries_id_seq | sequence | admin
scheduled_query_group_types_id_ | sequence | admin
scheduled_query_groups_id_seq | sequence | admin
scheme_info_id_seq | sequence | admin
scheme_info_types_id_seq | sequence | admin
schemes_id_seq | sequence | admin
user_info_id_seq | sequence | admin
user_info_types_id_seq | sequence | admin
user_setting_types_id_seq | sequence | admin
user_settings_id_seq | sequence | admin
(10 rows)
template1=# drop sequence scheduled_queries_id_seq,
scheduled_query_group_types_id_, scheduled_query_groups_id_seq,
scheme_info_id_seq, scheme_info_types_id_seq, schemes_id_seq,
user_info_id_seq, user_info_types_id_seq, schemes_id_seq, user_info_id_seq,
user_info_types_id_seq, user_setting_types_id_seq, user_settings_id_seq;
ERROR: sequence "schemes_id_seq" does not exist
template1=# drop sequence scheduled_queries_id_seq,
scheduled_query_group_types_id_, scheduled_query_groups_id_seq,
scheme_info_id_seq, scheme_info_types_id_seq, user_info_id_seq,
user_info_types_id_seq, schemes_id_seq, user_info_id_seq,
user_info_types_id_seq, user_setting_types_id_seq, user_settings_id_seq;
ERROR: sequence "user_info_id_seq" does not exist
template1=# drop sequence scheduled_queries_id_seq,
scheduled_query_group_types_id_, scheduled_query_groups_id_seq,
scheme_info_id_seq, scheme_info_types_id_seq;
DROP
template1=# \ds
List of relations
Name | Type | Owner
---------------------------+----------+-------
schemes_id_seq | sequence | admin
user_info_id_seq | sequence | admin
user_info_types_id_seq | sequence | admin
user_setting_types_id_seq | sequence | admin
user_settings_id_seq | sequence | admin
(5 rows)
template1=# drop sequence schemes_id_seq, user_info_id_seq,
user_info_types_id_seq, user_setting_types_id_seq, user_settings_id_seq;
DROP
--
Casey Allen Shobe / Network Security Analyst & PHP Developer
SecureWorks, Inc. / 404.327.6339 x169 / Fax: 404.728.0144
cshobe(at)secureworks(dot)net / http://www.secureworks.net
Content is my own and does not necessarily represent my company.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-10-22 04:31:15 | Re: Odd random drop sequence failure |
| Previous Message | geva | 2002-10-20 11:32:16 | vacuum bug |