From: | Grant <emailgrant123b(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | CREATE SEQUENCE |
Date: | 2004-08-03 04:30:52 |
Message-ID: | 20040803043052.44846.qmail@web53201.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm trying to set up the Interchange 5.2 shopping cart
(icdevgroup.org) to use the CREATE SEQUENCE
functionality of pgsql properly and I'm having some
trouble. The table is called order_items and the
field that should sequence is called autonumber. The
Interchange DB config file looks like this for my
order_items table:
Database order_items DEFAULT_TYPE varchar(128)
Database order_items COLUMN_DEF "autonumber=int
char(12) NOT NULL PRIMARY KEY"
I've tried adding the following:
Database order_items CREATE_SEQUENCE
order_items_sequence START 2000
Database order_items COLUMN_DEF "id=int default
nextval('order_items_sequence')"
after reading these docs:
http://developer.postgresql.org/docs/postgres/sql-createsequence.html
but that doesn't seem to do it. This is the
Interchange error I get when trying to get the table
to sequence which may not be relevant here:
//admin/flex_editor DBD::Pg::st execute failed: ERROR:
Relation "1" does not exist at
/usr/local/interchange/lib/Vend/Table/DBI.pm line 942.
Does anyone have any tips for me?
- Grant
__________________________________
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2004-08-03 04:38:32 | Re: CREATE SEQUENCE |
Previous Message | Matthew T. O'Connor | 2004-08-03 04:22:08 | Re: autovacuum problems |