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
[EMAIL PROTECTED] / http://www.secureworks.net
Content is my own and does not necessarily represent my company.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
