This is a general problem that appears to affect all
database clients (I'm using PostgreSQL). The 1st
column of all VIEWs that are displayed as a list is cut
off. I noticed this because I have a VIEW with only
one column. No data appears when I look at this VIEW.
Here is a patch (hack) that corrects this bug:
[p-hoover util]$ cvs diff base.pl
Index: base.pl
===================================================================
RCS file: /cvsroot/dbengine/dbengine/util/base.pl,v
retrieving revision 1.10
diff -r1.10 base.pl
752c752
< $search = "SELECT $fields FROM $table $suche $order";
---
> $search = "SELECT 0 AS oid,$fields FROM $table
$suche $order";