Обсуждение: Odd random drop sequence failure

Поиск
Список
Период
Сортировка

Odd random drop sequence failure

От
Casey Allen Shobe
Дата:
template1=3D# drop sequence scheduled_queries_id_seq,=20
scheduled_query_group_types_id_, scheduled_query_groups_id_seq,=20
scheme_info_id_seq, scheme_info_types_id_seq, schemes_id_seq,=20
user_info_id_seq, user_info_types_id_seq, schemes_id_seq, user_info_id_seq,=
=20
user_info_types_id_seq, user_setting_types_id_seq, user_settings_id_seq;
ERROR:  sequence "schemes_id_seq" does not exist
template1=3D# \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=3D# drop sequence scheduled_queries_id_seq,=20
scheduled_query_group_types_id_, scheduled_query_groups_id_seq,=20
scheme_info_id_seq, scheme_info_types_id_seq, schemes_id_seq,=20
user_info_id_seq, user_info_types_id_seq, schemes_id_seq, user_info_id_seq,=
=20
user_info_types_id_seq, user_setting_types_id_seq, user_settings_id_seq;
ERROR:  sequence "schemes_id_seq" does not exist
template1=3D# drop sequence scheduled_queries_id_seq,=20
scheduled_query_group_types_id_, scheduled_query_groups_id_seq,=20
scheme_info_id_seq, scheme_info_types_id_seq, user_info_id_seq,=20
user_info_types_id_seq, schemes_id_seq, user_info_id_seq,=20
user_info_types_id_seq, user_setting_types_id_seq, user_settings_id_seq;
ERROR:  sequence "user_info_id_seq" does not exist
template1=3D# drop sequence scheduled_queries_id_seq,=20
scheduled_query_group_types_id_, scheduled_query_groups_id_seq,=20
scheme_info_id_seq, scheme_info_types_id_seq;
DROP
template1=3D# \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=3D# drop sequence schemes_id_seq, user_info_id_seq,=20
user_info_types_id_seq, user_setting_types_id_seq, user_settings_id_seq;
DROP

--=20
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.

Re: Odd random drop sequence failure

От
Tom Lane
Дата:
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