Menu

#7 1st column of VIEWs are chopped off

open
nobody
5
2002-05-18
2002-05-18
Anonymous
No

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";

Discussion


Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.