From: Constantin Teodorescu <teo@flex.ro>
To: Laurent TASTET <laurent@internet-montblanc.fr>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] I can't use pgaccess !!
Date: Mon, 08 Mar 1999 19:37:26 +0200
Message-ID: <36E40AD6.517310D3@flex.ro> (raw)
References: <36E404A0.1E7412DC@internet-montblanc.fr>
Laurent TASTET wrote:
>
> Hi,
>
> I've dowloaded pgaccess 0.95, and I'm working with postgresql 6.3.2
> I applied the patch, as described on the web site , but when I launch
> pgaccess (wish -f pgaccess.tcl, I get an error message :
>
> " Error : function Pg_get_viewdef(name) does not exist !" and I can't
> use anything !
0.95 uses a mechanism of detecting tables from views that doesn't work
in 6.3.x
A better sollution is to upgrade your PostgreSQL to 6.4.2
If not , you should make a change in PgAccess in the procedure that
loads tables.
search "proc {cmd_Views}"
and replace code in loop wpg_select with :
wpg_select $dbc "select relname from pg_class where (relname !~ '^pg_')
and (relkind='r') and (rel
hasrules) order by relname" rec {
.dw.lb insert end $rec(relname)
}
Keep in touch,
--
Constantin Teodorescu
FLEX Consulting Braila, ROMANIA
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: teo@flex.ro, laurent@internet-montblanc.fr
Subject: Re: [INTERFACES] I can't use pgaccess !!
In-Reply-To: <36E40AD6.517310D3@flex.ro>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox