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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
