Does  Zeos support Postgres schemas?
lazarus / 16-Databases

----------------------------------------------------------------------
vfclists · 2024-02-17 03:45

Does  Zeos support Postgres schemas?

It looks like the Catalog property of TZeosConnection is suppposed to
be what the Postgres schema is set to but it doesn't seem to work.

The only other place where the schema can be set seems to be in the
Properties property.

In case it does is there a syntax for this?

----------------------------------------------------------------------
paweld · 2024-02-17 06:41

https://zeoslib.sourceforge.io/viewtopic.php?f=50&t=165327

----------------------------------------------------------------------
vfclists · 2024-02-17 13:09

I have viewed
https://zeoslib.sourceforge.io/viewtopic.php?f=50&t=165327 earlier and
it seems no-one is picking it up.

The PQConnection of the SQLDB components supports it via

options='-c search_path=lazlib_01'

in the Params property, so I suspect the URL generated for the Zeos
connection does not support the options parameter anywhere in its
properties.

Perhaps ZURL needs some updating.

I need to have a talk with the Zeos developers. It doesn't seem to be
too difficult an issue

----------------------------------------------------------------------
Thaddy · 2024-02-17 13:23

I still have no clue why people want to use Zeos? especially with
PostgreSQL. I don't get Zeos. Probably because I don't need it.

----------------------------------------------------------------------
vfclists · 2024-02-17 14:40

Quote from: Thaddy on February 17, 2024, 02:23:53 pmI still have no
clue why people want to use Zeos? especially with PostgreSQL. I don't
get Zeos. Probably because I don't need it.

Because you've got a lot of code and libraries that would take too
long to convert to other libraries?

Also works on Delphi?

----------------------------------------------------------------------
Thaddy · 2024-02-17 14:43

Delphi and Freepascal work perfectly fine without Zeos.
I really do not get Zeos.

----------------------------------------------------------------------
Hansvb · 2024-02-17 17:20

Quote I still have no clue why people want to use Zeos?There is one
thing that zeos can do and standard lazarus components can't. That's a
select* query on an Oracle spatial table and then show the data in a
data grid. With a zeos query component combined with a laz datasource
and datagrid it works, with a lazarus query component, datasource and
datagrid you get an error. (the geometry column is the problem) 
That's for me the only reason to use zeos.

Edit: zeos from trunc. The stable version doesn’t like oracle geometry
either.