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