Bug found: was Re: [ic] DBI error - syntax error in CREATE INDEX?
Mike Heins
mikeh@minivend.com
Thu, 22 Mar 2001 17:59:09 -0500
Quoting LM (lmorley@flexihost.com):
> I think I've found & fixed the problem I reported in my original post -
> it stems from a bug / error in the SQL code that Interchange puts in
> order_returns.pgsql :
>
> CREATE INDEX order_returns_order_number ON
> order_number (order_number)
>
> The problem is after the ON - there's no table etc. named
> "order_number". After looking at the code in order_returns.ora,
> and seeing how the index is creted there, the above statement
> should read (I think):
>
> CREATE INDEX order_returns_order_number ON
> order_returns (order_number)
>
> I issued that command from the postgres command line utility (psql);
> it worked... Had to make the same change to the template
> dbconf/pgsql/order_returns.pgsql too, so the error won't carry over
> into any catalogs I create in the future.
>
> Has anyone else had and fixed the same problem? And, is there
> anyone who's set up Interchange with Postgres who's willing to pass
> along their experiences (off-list would be fine)?
>
That is the problem -- it is benign, though, and shouldn't have caused
anything but a speed decrease.
Thanks for the find and fix. Fixed in CVS.
--
Red Hat, Inc., 131 Willow Lane, Floor 2, Oxford, OH 45056
phone +1.513.523.7621 fax 7501 <mheins@redhat.com>
Few blame themselves until they have exhausted all other possibilities.
-- anonymous