I am new to QxOrm and the entityEditor
The first thing i wanted to do, was to import some entities from an existing db.
Environment
Postgres 9.3
EntityEditor 1.1.3
DB structure with public and isoxml2 schema and the tables:
- isoxml2.wkr_worker
- public.wkr_worker (other columns than isoxml2.wkr_worker to be able to see differences)
- public.lsg
- all tables have a primary key which sequence is defined in isoxml2 schema.
The first try was without any searchpath on postgres session and user (default on postgres)
- Code: Select all
ALTER USER postgres SET search_path = '';
- all columns are recoginized (OK)
- public.wkr_worker was not shown in dialog (Not OK)
- primary key was not recognized on any table (public, isoxml2) (Not OK)
Error
Entity 'variodoc::wkr_worker' is not valid :
- Primary key property is empty
Due to the sequence is defined in isoxml2 schema I changed the searchpath to
- Code: Select all
ALTER USER postgres SET search_path = 'isoxml2', 'public'
- all columns are recognized for isoxml2 (OK)
- the columns for public.lsg are not recognized (not OK)
- public.wkr_worker was not shown in dialog (Not OK)
- primary keys are recognized on any table in isoxml2 (OK)
The third try was to change the searchpath order to
- Code: Select all
ALTER USER postgres SET search_path = 'public', 'isoxml2'
- all columns are recognized for public (OK)
- the columns for isoxml2 are not recognized (not OK)
- isoxml2.wkr_worker was not shown in dialog (Not OK)
I think the schema have to be concerned by building the dialog to avoid throwing away tables with duplicate names.
Further the pk search when the pk is defined in a schema is not working.
Exists there any solution to be able to import the entities correctly with many schemas and without setting any searchpath?
Regards
jackson