Menu

#2 VIEWs don't work with PostgreSQL

v1.1
open
nobody
None
5
2002-05-17
2002-05-17
dhoov
No

Hi,

VIEWs on my linux machine do not work with PostgreSQL
7.2.1, DBI-1.21, and DBD-Pg-1.13. The primary dbengine
problem is that the db_isView subroutine of postgres.pl
tries to determine if a table is really a view by using
dbdconn handle instead of dbconn.

Patch:
[p-hoover@iamac37 util]$ diff postgres.pl.orig
postgres.pl.fix
52c52
< my $result = $dbdconn->prepare($cmd);
---
> my $result = $dbconn->prepare($cmd);

Discussion


Log in to post a comment.