pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_get_view unknow ...
3+ messages / 3 participants
[nested] [flat]
* pg_get_view unknow ...
@ 1999-04-15 07:56 manu manu <bonnard_manu@yahoo.fr>
1999-04-15 08:26 ` Re: [INTERFACES] pg_get_view unknow ... Constantin Teodorescu <teo@flex.ro>
1999-04-15 13:00 ` Re: [INTERFACES] pg_get_view unknow ... José Soares <jose@sferacarta.com>
0 siblings, 2 replies; 3+ messages in thread
From: manu manu @ 1999-04-15 07:56 UTC (permalink / raw)
To: pgsql-interfaces
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 ???
Thanks
Manu.
bonnard_manu@yahoo.fr
_________________________________________________________
ÊTES-VOUS YAHOO!?
Votre e-mail @yahoo.fr gratuit sur http://courrier.yahoo.fr
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] pg_get_view unknow ...
1999-04-15 07:56 pg_get_view unknow ... manu manu <bonnard_manu@yahoo.fr>
@ 1999-04-15 08:26 ` Constantin Teodorescu <teo@flex.ro>
1 sibling, 0 replies; 3+ messages in thread
From: Constantin Teodorescu @ 1999-04-15 08:26 UTC (permalink / raw)
To: manu manu <bonnard_manu@yahoo.fr>; +Cc: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] pg_get_view unknow ...
1999-04-15 07:56 pg_get_view unknow ... manu manu <bonnard_manu@yahoo.fr>
@ 1999-04-15 13:00 ` José Soares <jose@sferacarta.com>
1 sibling, 0 replies; 3+ messages in thread
From: José Soares @ 1999-04-15 13:00 UTC (permalink / raw)
To: manu manu <bonnard_manu@yahoo.fr>; +Cc: pgsql-interfaces
manu manu ha scritto:
> 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 ?
v6.3.2 doesn't have this function, pg_get_viewdef() was introduced with
v6.4.
>
> How to make it well please ???
install v6.4.2 or wait for v6.5.
José
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1999-04-15 13:00 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-04-15 07:56 pg_get_view unknow ... manu manu <bonnard_manu@yahoo.fr>
1999-04-15 08:26 ` Constantin Teodorescu <teo@flex.ro>
1999-04-15 13:00 ` José Soares <jose@sferacarta.com>
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