Re: [Fwd: Re: [gnome-db] mergeant help]

[Jack Coates <jack lyris com>]

On Thu, 2003-10-16 at 13:01, Rodrigo Moya wrote:
> On Thu, 2003-10-16 at 20:45, Jack Coates wrote:
> > On Thu, 2003-10-16 at 01:50, Rodrigo Moya wrote:
> > ...
> > > > > > mergeant runs, connect brings up the right connectoid, but then nothing
> > > > > > happens.
> > > > > > 
> > > > > > Data source properties:
> > > > > > Provider PostgreSQL
> > > > > > Connection string: DSN=DATABASE=lmdatabase;HOST=127.0.0.1;PORT=5432
> > > > > > descrip, username, password all ok.
> > > > > > 
> > > > > can you try using HOSTADDR instead of HOST?
> > > > > 
> > > > > cheers
> > > > 
> > > > no change; I also verified that pg_hba.conf will allow loopback IP
> > > > connections.
> > > > 
> > > hmm, does your connection string contain the 'DSN=' part?
> > > 
> > > cheers
> > 
> > DSN=DATABASE=lmdatabase;HOSTADDR=127.0.0.1;PORT=5432
> 
> remove the DSN= part. That's wrong. Did you create it by hand?
> 
> cheers

no, but it could theoretically have persisted from one of the older
installs (that was the recommended format for ~/.gda/config). I can now
connect, but it's having trouble seeing the table space. Here's stdout:
Position 0: Expected 16, got 17

(mergeant:10699): mergeant-WARNING **: The provider has returned the
wrong 
number and/or types of data
for the TYPES schema description.
Please contact the provider's maintainer and report the problem.
Position 0: Expected 16, got 17

(mergeant:10699): mergeant-WARNING **: The provider has returned the
wrong 
number and/or types of data
for the PROCEDURES schema description.
Please contact the provider's maintainer and report the problem.
Position 0: Expected 16, got 17

(mergeant:10699): mergeant-WARNING **: The provider has returned the
wrong 
number and/or types of data
for the AGGREGATES schema description.
Please contact the provider's maintainer and report the problem.
Position 0: Expected 16, got 17

(mergeant:10699): mergeant-WARNING **: The provider has returned the
wrong 
number and/or types of data
for the TABLES schema description.
Please contact the provider's maintainer and report the problem.
Position 0: Expected 16, got 17

(mergeant:10699): mergeant-WARNING **: The provider has returned the
wrong 
number and/or types of data
for the VIEWS schema description.
Please contact the provider's maintainer and report the problem.
Position 0: Expected 16, got 17

(mergeant:10699): mergeant-WARNING **: The provider has returned the
wrong 
number and/or types of data
for the SEQUENCE schema description.
Please contact the provider's maintainer and report the problem.

cheers,
-- 
Jack Coates, Lyris Technologies Applications Engineer
510-549-4350 x148, jack lyris com