Forum OpenACS Q&A: load-geo-tables error

Collapse
1: load-geo-tables error
Posted by Harshal Maheshri on 11/09/00 10:07 AM
Hi all, I've installed Postgres 7.0.2, OpenACS 3.2.2 , Aolserver 3.0 undex redhat 6.2.
Everything works fine, but when i execute load-geo- tables of openacs, i get an error indicating that query buffer length of 20000 exceeded.

What's the reason for this error?
Also how can i increase the query buffer size.

Any answers to this will be highly appreciated.

Thanks in advance

Harshal

Collapse
2: Response to load-geo-tables error (response to 1)
Posted by Don Baccus on 11/09/00 03:59 PM
Are you sure you're actually running with PG 7.0.2 and not the PG 6.5
that came with RH 6.2?  The RPMs install in different directories than
a built-by-hand PG's default directories, so it is possible to
build/install PG yourself but end up running the PG that came with the
distro if you're not aware of this.

I'm asking because query buffer length limits went away in PG 7...

If you are indeed actually running PG 7.0, then I'm stymied for the
moment.

Collapse
3: Response to load-geo-tables error (response to 1)
Posted by Harshal Maheshri on 11/10/00 01:57 AM
Thanks,

the version of PG is 7.0.2 only and is not bundled with RH 6.2 i have downloaded the PG from site itself.
Any help would be highly appreciated.

Harshal