[ic] Help needed with table getting wiped!

Peter peter at pajamian.dhs.org
Mon Apr 12 23:18:21 EDT 2004


k wrote:
> Have you added a prodimage.pgsql file to your
> path_to_your_catalog/dbconf/pgsql directory?

Yep, contents of it are as follows:
bash-2.05a$ cat prodimage.pgsql
Database  prodimage  prodimage.txt __SQLDSN__
ifdef SQLUSER
Database  prodimage  USER         __SQLUSER__
endif
ifdef SQLPASS
Database  prodimage  PASS         __SQLPASS__
endif
Database  prodimage  KEY          code
Database  prodimage  COLUMN_DEF   "code=VARCHAR(12) NOT NULL PRIMARY KEY"
Database  prodimage  COLUMN_DEF   "sku=VARCHAR(64) NOT NULL"
Database  prodimage  COLUMN_DEF   "sort=integer"
Database  prodimage  COLUMN_DEF   "image=varchar(128)"
Database  prodimage  COLUMN_DEF   "width=integer"
Database  prodimage  COLUMN_DEF   "height=integer"


Peter


More information about the interchange-users mailing list