[ic] Postgresql error

Mike Heins interchange-users@interchange.redhat.com
Thu Mar 21 12:39:01 2002


Quoting Rick Eicher II (rick@pbol.net):
> I have set up a new catalog with postgresql. The database was made no
> problem there.
> 
> I am unable to go into the admin side and change taxes.
> 
> I get the following error in the logs:
> 
> 216.111.193.94 mAdiXcLE:216.111.193.94 - [20/March/2002:18:00:19 -0600]
> inventory www.e-inventory.biz/cgi-bin/inventory/admin/tax_simple.html
> Attempt to set variable::Variable::TAXAREA in read-only table
> 
> I have search the achieves and have found a few bits and pieces of
> information but not enough to form a solution to try. Something about write
> permissions. But do not know where this is set.
> 
> Familiar with interchange but this is the first time I have done a catalog
> that does not use the default database setup.

Add at the bottom of catalog.cfg:

    Pragma dynamic_variables_file_only

This problem has been answered on the mail list but has not been added
to the FAQ.

-- 
Red Hat, Inc., 3005 Nichols Rd., Hamilton, OH  45013
phone +1.513.523.7621      <mheins@redhat.com>

I am a great believer in luck, and I find that the harder I work
the more luck I have. -- Thomas Jefferson