Skip site navigation (1) Skip section navigation (2)

Re: Odd random drop sequence failure

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Casey Allen Shobe <cshobe(at)secureworks(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Odd random drop sequence failure
Date: 2002-10-22 04:31:15
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
Casey Allen Shobe <cshobe(at)secureworks(dot)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

In response to

pgsql-bugs by date

Next:From: Sedlak AntonDate: 2002-10-22 11:00:00
Subject: Error in chkpass.c (contrib area) with suggestion
Previous:From: Casey Allen ShobeDate: 2002-10-22 03:06:22
Subject: Odd random drop sequence failure

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group