D0 <[EMAIL PROTECTED]> writes:
> 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
What PG version are you running? This looks like the classic catch-22
f
> Also how do I get a listing of the sequences already created?
>
> TIA
\ds
You can always get a list of commands with \?, and help with \h.
Serge
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/se
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 TABL
