[Users] postgres

19 Dec 2006

Hi,

What is the best way to use postgres with openser?

Is postgres a viable option?

I ask, because the install script appears to be broken.
If I am able to fix it well enough create the necessary tables,
will it be fit for use?

As an example, there are several errors in the openser_postgres.sh that
comes with openser 1.1

In particular, there are instances where the following is done:

create table a (
   field type,
   index a_idx(field)
);

However, postgres requires syntax like this:

create table a (
    field type
);
create index a_idx on a (field);

Thanks.