Re: DBI -> remote host? - Mailing list pgsql-general

From Steve Wolfe
Subject Re: DBI -> remote host?
Date
Msg-id 001901c0444b$711659a0$50824e40@iboats.com
Whole thread Raw
In response to Is cycle references?  (<limin@www.pumpkinnet.com>)
List pgsql-general
> Be sure to set DBI->trace(2) on.  It helps greatly in tracking errors. I
show it
> below on the database object, but you should be able to set it as a class
> method, I believe. I have done this in the past, but don't see it in any
of my
> code now.

> I realize that this is not exactly what you asked for, but I don't really
> understand what you failure is.  Can you connect via 'psql -h 10.0.1.100
> hyperseek' ?

  Thanks for the letter.  I should have given more detail.

psql -h 10.0.1.100 -d hyperseek -c "\d"

 works just hunky-dorey.  I did a DBI_TRACE, and while I won't pretend to
really understand what's going on, there are no messages indicating errors
or warnings.  (I can provide it if you'd like).  And, there *is* data in the
database.  I checked that very quickly. : )

 the DBI trace shows it connecting as the owner of the table, and shows it
returning the hash when it connects.  When a query is executed, it appears
to function correctly - but no data is returned.  The kicker is that if I
query the tables from PSQL, the data shows up.  Any ideas?  I'm certainly
baffled.

steve



pgsql-general by date:

Previous
From: "Steve Wolfe"
Date:
Subject: DBI -> remote host?
Next
From: Stephan Szabo
Date:
Subject: Re: Is cycle references?