Re: [HACKERS] CREATE OR REPLACE VIEW/TRIGGER

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Bill Studenmund <wrstuden(at)netbsd(dot)org>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr>, <pgsql-hackers(at)postgresql(dot)org>, <pgadmin-hackers(at)postgresql(dot)org>, <dpage(at)vale-housing(dot)co(dot)uk>, <lockhart(at)fourpalms(dot)org>, <Inoue(at)tpf(dot)co(dot)jp>, <oleg(at)sai(dot)msu(dot)su>, <scrappy(at)hub(dot)org>
Subject: Re: [HACKERS] CREATE OR REPLACE VIEW/TRIGGER
Date: 2001-10-24 21:56:01
Message-ID: Pine.LNX.4.30.0110242143580.647-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers pgsql-hackers

Bill Studenmund writes:

> > Our current CREATE OR REPLACE FUNCTION perserves the OID of the
> > function. Is there similar functionality you need where a simple
> > DROP (ignore the error), CREATE will not work?
>
> If possible, it's nice to not have commands whose error codes you ignore.
> That way if you see an error, you know you need to do something about it.

Technically, it's not an error, it's an "exception condition". This might
make you feel better when consciously ignoring it. ;-)

--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter

In response to

Browse pgadmin-hackers by date

  From Date Subject
Next Message Steve Boyle (Roselink) 2001-10-25 02:32:17
Previous Message Mike Mascari 2001-10-24 05:13:43 Re: CREATE OR REPLACE VIEW/TRIGGER

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-10-24 22:13:02 "Triggered data change violation", once again
Previous Message Peter Eisentraut 2001-10-24 21:55:42 Re: Index of a table is not used (in any case)