On 9 March 2012 22:12, Vivien Malerba <[email protected]> wrote: > > > On 9 March 2012 12:16, Piotr Pokora <[email protected]> wrote: > >> Hi! >> >> I am quite confused with meta store functionality. >> First, all operations are very slow (if you compare to direct RDBM >> queries) and frnakly speaking I have no idea how to improve them. >> Second, I have problems with GdaConnection options. >> >> All is working fine, when I open connection with >> GDA_CONNECTION_OPTIONS_NONE >> >> and update meta store on demand: >> >> https://github.com/midgardproject/midgard-core/blob/ratatoskr/src/midgard_core_query.c#L58 >> >> I tried to set up the same database as meta store, which seems to >> improve performance a bit, but fails with postgres provider: >> >> syntax error at or near "'Nullable'" >> LINE 1: ...eric_precision, c.numeric_scale, c.is_nullable AS >> 'Nullable'...^, >> No:(-1), src:gda-postgres, SQL: 42601 >> > > This definitely looks like a bug which should be corrected. I'll work on > it ASAP. > > Can you try running the tests/meta-store/check_meta_store_postgresql test program (you may have to explicitely ask make to compile it first)? Note that you need to export the POSTGRESQL_META_CNC environment variable first so that the test program knows where to connect to, for example:
export POSTGRESQL_META_CNC="HOST=gda;PORT=5432;USERNAME=gdauser;PASSWORD=GdaUser;DB_NAME=test" Note that you should create a test DB for this as the test creates a meta store in the identified database, and thus creates many tables in it. You should have a result similar to the one attached. Let me know how it goes. Regards, Vivien
testresult.xz
Description: application/xz
_______________________________________________ gnome-db-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnome-db-list
