Sorry my English.
Anyone know a trubl PGACCESS (with PostgreSQL 7.1.1) in View Functions show
_all_ system functions.
For resolve it you must replase in ..../pgaccess/lib/mainlib.tcl function
to my function:
--- cut ---
proc {cmd_Functions} {} {
global CurrentDB PgAcVar
set maxim 16384
setCursor CLOCK
catch {
wpg_select $CurrentDB "select oid from pg_database where
datname='template1'" rec {
set maxim $rec(oid)
}
}
.pgaw:Main.lb delete 0 end
catch {
set alex_owner_id $PgAcVar(opendb,username)
if {! $PgAcVar(pref,systemtables)} {
set alex_owner " and proowner = (SELECT usesysid FROM pg_user WHERE usename
= '$alex_owner_id') "
} else {
set alex_owner ""
}
wpg_select $CurrentDB "select proname from pg_proc where oid>$maxim
$alex_owner order by proname" rec {
pgaw:Main.lb insert end $rec(proname)
}
}
setCursor DEFAULT
}
--- cut ---
In attach. full mainlib.tcl for PGACCESS v.0.98.7
