[ic] Modifying pgsql table

Jeff Fearn interchange-users@interchange.redhat.com
Wed Nov 21 00:58:00 2001


Hi, I am running IC 4.8 on RedHat Linux 7.2, and pgsql. I am trying to add 
some extra price fields to the products database, for locale baseds pricing, 
and am having dificulty deciphering exatly what is required to do this. I am 
just starting to enter products so there is no data to worry about. I was 
wondering if someone could give a point list of the steps required to do 
this? Names for extra price fields will just be <country code_price> i.e. 
NZ_price, US_price etc.

I think the doco needs some point based lists on how to do things, i.e. 
(this is very made up ;)

1. Modify product.pgsql, add new fields.
2. run something to update db
3. import ascii file with records

I'm sure such a structure would help lots of new people, at least they would 
know what they need to lookup to get a step done ... finding it in the doco 
is a different thing though ;) Has there been any though given to using a 
searchable format for the doco, like pdf etc? I think that would also be 
useful, as HTML is nasty to search through, and a pain to d/l if you don't 
have the doco locally.

Thanks, Jeff.



_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp