perl-embperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gavin Carr <ga...@openfusion.com.au>
Subject Re: DBIx::Recordset and postgresql schemas?
Date Wed, 25 Aug 2004 10:04:05 GMT
On Wed, Aug 25, 2004 at 08:06:10AM +0200, Robert Germi? wrote:
> Gavin Carr wrote:
> 
> >It looks like DBIx::Database->new is stripping the schema information 
> >from table names before calling QueryMetadata, which seems to be
> >required now? Anyone else seen this, or are successfully using
> >DBIx::Recordset with PostgreSQL 7.3+ (when schemas came in)? Or am
> >I missing something obvious?
> 
> i got 7.3.6 and it works ok (don't use schemas)

I'm not using schemas either, but postgresql is (at least as of 7.4,
I don't have a 7.3 here to check). As postgres:

$ psql template1
template1=# \dn
        List of schemas
        Name        |  Owner   
--------------------+----------
 information_schema | postgres
 pg_catalog         | postgres
 pg_temp_1          | postgres
 pg_toast           | postgres
 public             | postgres
(5 rows)

and if I do the following (again as the postgres user):

  perl -MDBIx::Database -le 'DBIx::Database->new("dbi:Pg:dbname=template1","postgres",undef,undef,"foo",1)'

I get a long list of errors about non-existent relations. Does the above 
work okay for you on 7.3?

Cheers,
Gavin


---------------------------------------------------------------------
To unsubscribe, e-mail: embperl-unsubscribe@perl.apache.org
For additional commands, e-mail: embperl-help@perl.apache.org


Mime
View raw message