Odd random drop sequence failure

Started by Casey Allen Shobeover 23 years ago2 messagesbugs
Jump to latest
#1Casey Allen Shobe
cshobe@secureworks.net

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@secureworks.net / http://www.secureworks.net
Content is my own and does not necessarily represent my company.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Casey Allen Shobe (#1)
Re: Odd random drop sequence failure

Casey Allen Shobe <cshobe@secureworks.net> writes:

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

You tried to drop it twice...

regards, tom lane