pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedI can't use pgaccess !!
2+ messages / 2 participants
[nested] [flat]
* I can't use pgaccess !!
@ 1999-03-08 17:10 Laurent TASTET <laurent@internet-montblanc.fr>
1999-03-08 17:37 ` Re: [INTERFACES] I can't use pgaccess !! Constantin Teodorescu <teo@flex.ro>
0 siblings, 1 reply; 2+ messages in thread
From: Laurent TASTET @ 1999-03-08 17:10 UTC (permalink / raw)
To: pgsql-interfaces
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 !
please help !
thanks
--
*****************************************************************
* Laurent TASTET - laurent@internet-montblanc.fr *
* Internet Mont-Blanc - http://www.internet-montblanc.fr *
* Administrateur Systèmes & Réseaux *
* Network & System manager *
* Tél : +33 (0)4 50 97 50 55 - Fax : +33 (0)4 50 97 50 43 *
*****************************************************************
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [INTERFACES] I can't use pgaccess !!
1999-03-08 17:10 I can't use pgaccess !! Laurent TASTET <laurent@internet-montblanc.fr>
@ 1999-03-08 17:37 ` Constantin Teodorescu <teo@flex.ro>
0 siblings, 0 replies; 2+ messages in thread
From: Constantin Teodorescu @ 1999-03-08 17:37 UTC (permalink / raw)
To: Laurent TASTET <laurent@internet-montblanc.fr>; +Cc: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1999-03-08 17:37 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-03-08 17:10 I can't use pgaccess !! Laurent TASTET <laurent@internet-montblanc.fr>
1999-03-08 17:37 ` Constantin Teodorescu <teo@flex.ro>
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