Hi all,

I just updated my svn dabo and daboide and the ide
finally allowed me to select a connection and
subsequently a table & fields!!  Thanks a lot
guys.  Good work

But now for the down side.  There is still some
very  odd behavior.  First of all I am connecting
to a postgresql database with multiple schemas. 
The ide apparently can only see the "public"
schema and not the others.  

And this is what is really strange.  The two
tables in the public schema that dabo can see are
the two tables that PostGIS created by default
(the spatial_ref_sysem table and the geometry
table).  They are simple tables such as:
CREATE TABLE spatial_ref_sys
(
  srid integer NOT NULL,
  auth_name character varying(256),
  auth_srid integer,
  srtext character varying(2048),
  proj4text character varying(2048),
  CONSTRAINT spatial_ref_sys_pkey PRIMARY KEY (srid)
) 
WITHOUT OIDS;
ALTER TABLE spatial_ref_sys OWNER TO postgres;

So I then created my dabo form and all was fine. 
Then I created another table by:
CREATE TABLE hole_test
(
  holeid character varying(30) NOT NULL,
  e_utm double precision,
  n_utm double precision,
  z_utm double precision,
  CONSTRAINT hole_test_holeid_pkey PRIMARY KEY
(holeid)
) 
WITHOUT OIDS;
ALTER TABLE hole_test OWNER TO postgres;

I then entered three records into the table with
no problem then tried to create a dabo form.  Now
the ide will not open the connection and allow me
to select a table then fields.

Very strange indeed!

Phil




_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users

Reply via email to