Can not drop sequence...
От | D0 |
---|---|
Тема | Can not drop sequence... |
Дата | |
Msg-id | 3B03D58D.ECA89D66@aero-graphics.com обсуждение исходный текст |
Ответы |
Re: Can not drop sequence...
|
Список | 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
В списке pgsql-general по дате отправления: