Received: from flex.flex.ro (IDENT:root@[193.230.255.4])
	by hub.org (8.9.2/8.9.1) with ESMTP id EAA40533
	for <pgsql-interfaces@postgreSQL.org>;
	Thu, 15 Apr 1999 04:25:15 -0400 (EDT) (envelope-from teo@flex.ro)
Received: from flex.ro (IDENT:teo@teo.flex.ro [193.230.255.3]) by flex.flex.ro
	(8.9.1/8.9.1) with ESMTP id KAA32668; Thu, 15 Apr 1999 10:22:25 +0300
Sender: teo@flex.flex.ro
Message-ID: <3715A2C4.865E3A4A@flex.ro>
Date: Thu, 15 Apr 1999 08:26:44 +0000
From: Constantin Teodorescu <teo@flex.ro>
Organization: FLEX Consulting
X-Mailer: Mozilla 4.51 [en] (X11; I; Linux 2.2.5 i586)
X-Accept-Language: en
MIME-Version: 1.0
To: manu manu <bonnard_manu@yahoo.fr>
CC: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] pg_get_view unknow ...
References: <19990415075614.11515.rocketmail@web604.mail.yahoo.com>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

manu manu wrote:
> 
> I install pgaccess0.96 with Postgres 6.3.2 under Redat 5.1
> Every thing go rigth, but when I want to create a view, I have this
> message error:"Error: ERROR: functionpg_get_viewdef(unknowną) does not
> exist"
> Why ?
> How to make it well please ???

In 0.96 I used a function get_viewdef that exists only in 6.4.2 !
Everything else is working but that code that checks a previously
defined view still exists!

So you have 2 choices :

a. upgrade to 6.4.2 (the best)
b. change the PgAccess program and comments thos parts where viewdef is
needed (when creating a view, there is a check if there is already a
view defined. Comment that part. You will get a PostgreSQl error message
when trying to define a view with a name that already exists)

Constantin Teodorescu
FLEX Consulting Braila