Skip site navigation (1) Skip section navigation (2)

Change view with dependencies function: PG 8.3

From: Thangalin <thangalin(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Cc: sim(at)compulab(dot)co(dot)il
Subject: Change view with dependencies function: PG 8.3
Date: 2010-09-10 15:14:20
Message-ID: AANLkTinKZNv3S3nwVb+p7zdPaAeyC9L4FwhGzG8NARkr@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi,

Found Sim's functions:

http://www.mail-archive.com/pgsql-general(at)postgresql(dot)org/msg57733.html

How do you run the viewchanger function? I have tried:

SELECT 1 FROM viewchanger( 'beplanallcover',
"CREATE OR REPLACE VIEW beplanallcover AS
 SELECT DISTINCT p.personid, ... WHERE p.personid='1234'" )

The error message is:

ERROR:  function CREATE OR REPLACE VIEW beplanallcover AS
 SELECT DISTINCT p.pe() does not exist
HINT:  No function matches the given name and argument types. You may need
to add explicit type casts.

I do not know why *p.personid* is being changed to *p.pe()*.

I could not find much information on whether 8.4 provides a native facility
to change a VIEW's underlying query statement without having to drop all
dependencies. (I noticed there is an ALTER VIEW and mechanism to add
columns.) Any information on other solutions would be greatly appreciated.

Thank you!
Dave

Responses

pgsql-novice by date

Next:From: Thom BrownDate: 2010-09-10 15:33:28
Subject: Re: Getting The Last Entry
Previous:From: Thomas KellererDate: 2010-09-10 14:55:35
Subject: Re: PostgreSQL article online - PDF

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group