Odd random drop sequence failure - Mailing list pgsql-bugs
| From | Casey Allen Shobe |
|---|---|
| Subject | Odd random drop sequence failure |
| Date | |
| Msg-id | 200210212306.22018.cshobe@secureworks.net Whole thread Raw |
| Responses |
Re: Odd random drop sequence failure
(Tom Lane <tgl@sss.pgh.pa.us>)
|
| List | pgsql-bugs |
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.
pgsql-bugs by date: