[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: [ic] Problems updating products with POSTGRES
John Nealy wrote:
> I did a perl -i -pe 's/NOT NULL//g' * on the files in
> /var/lib/interchange/my_catlog_name/pgsql and
> /var/lib/pgsql/basw/my_catalog_name and restarted the interchange
> server. I was still unable to create new items in admin. Should I
> create one from scratch, then apply the NOT NULL fix?
>
> John.
>
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@www.minivend.com
> http://www.minivend.com/mailman/listinfo/interchange-users
O.K. I got the brain working with full oxygen this time. I did a
pg_dump of my database, removed the NOT
NULL with the commands I found on the list, and created a new database
from the altered database
definition and viola'! I am working perfectly with PostgreSQL. Thanks
to all who pointed me in the right directions, directly and indirectly.
John Nealy.
_______________________________________________
Interchange-users mailing list
Interchange-users@www.minivend.com
http://www.minivend.com/mailman/listinfo/interchange-users
