pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedCREATE OR REPLACE VIEW
2+ messages / 2 participants
[nested] [flat]
* CREATE OR REPLACE VIEW
@ 2000-11-21 18:56 Ricardo Dias Marques <ricmarques@spamcop.net>
0 siblings, 1 reply; 2+ messages in thread
From: Ricardo Dias Marques @ 2000-11-21 18:56 UTC (permalink / raw)
To: pgsql-sql
Hi all,
Is CREATE OR REPLACE VIEW available in any way, in PostgreSQL 7.0.2?
I am building a PHP/PostgreSQL application, and want to CREATE a VIEW if
it doesn't existe or REPLACE it with a new one, if it already exists. I
was hoping that I didn't have to DROP the VIEW so I don't get error
messages, and also, in my case, DROPping a view, when it doesn't already
exist is causing the PHP script to halt.
Any help is appreciated.
Ricardo Dias Marques
ricmarques@spamcop.net
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: CREATE OR REPLACE VIEW
@ 2000-11-27 15:02 Palle Girgensohn <girgen@partitur.se>
parent: Ricardo Dias Marques <ricmarques@spamcop.net>
0 siblings, 0 replies; 2+ messages in thread
From: Palle Girgensohn @ 2000-11-27 15:02 UTC (permalink / raw)
To: Ricardo Dias Marques <ricmarques@spamcop.net>; +Cc: pgsql-sql
As a work around, you might get off telling php to ignore the
errors, using error_reporting();
CREATE OR REPLACE cannot be found in the postgres docs, so I
guess it is not there?
/Palle
Ricardo Dias Marques wrote:
>
> Hi all,
>
> Is CREATE OR REPLACE VIEW available in any way, in PostgreSQL 7.0.2?
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-11-27 15:02 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-11-21 18:56 CREATE OR REPLACE VIEW Ricardo Dias Marques <ricmarques@spamcop.net>
2000-11-27 15:02 ` Palle Girgensohn <girgen@partitur.se>
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