From: | D0 <jnielsen(at)aero-graphics(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Can not drop sequence... |
Date: | 2001-05-17 13:43:41 |
Message-ID: | 3B03D58D.ECA89D66@aero-graphics.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
agi_db=# create table analytics_budget
agi_db-# (
agi_db(# analytics_budget_id serial not null primary key,
agi_db(# triangulation int2,
agi_db(# sales_order_id int4 not null references
sales_order(sales_order_id) default
atoi(currval('sales_order_sales_order_id'))
agi_db(# );
NOTICE: CREATE TABLE will create implicit sequence
'analytics_bud_analytics_bud_seq' for SERIAL column
'analytics_budget.analytics_budget_id'
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index
'analytics_budget_pkey' for table 'analytics_budget'
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR: Relation 'analytics_bud_analytics_bud_seq' already exists
agi_db=# drop sequence analytics_bud_analytics_bud_seq;
ERROR: Relation 'analytics_bud_analytics_bud_seq' does not exist
agi_db=# drop sequence analytics_budget_analytics_budget_seq;
NOTICE: identifier "analytics_budget_analytics_budget_seq" will be
truncated to "analytics_budget_analytics_budg"
ERROR: Relation 'analytics_budget_analytics_budg' does not exist
So... How do I get rid of this sequence?
Also how do I get a listing of the sequences already created?
TIA
--
Jason Nielsen Aero-Graphics, Inc.
Computer Grunt (Systems Administrator) www.aero-graphics.com
From | Date | Subject | |
---|---|---|---|
Next Message | John Burski | 2001-05-17 13:55:45 | Re: Restore from a dead machine. |
Previous Message | User JOHN | 2001-05-17 13:19:15 | Re: Restore from a dead machine. |