Patch for PGACCESS

From: Alexander Dederer <dederer(at)spb(dot)cityline(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: Patch for PGACCESS
Date: 2001-05-26 10:27:08
Message-ID: 9eo09n$2ba6$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-patches

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

Attachment Content-Type Size
mainlib.tcl text/plain 33.4 KB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Madness 2001-05-26 11:02:20 altering data type in a column
Previous Message Simon Crute 2001-05-26 09:00:37 Re: Autocommit off in psql??

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2001-05-28 00:36:54 Re: Patch for JDBC fractional hour timezone offset bug
Previous Message Bruce Momjian 2001-05-26 00:44:09 Re: Patch for JDBC fractional hour timezone offset bug