Re: where's the reference to a view, here? - Mailing list pgsql-general

From will trillich
Subject Re: where's the reference to a view, here?
Date
Msg-id 20010622130245.A10362@serensoft.com
Whole thread Raw
In response to Re: where's the reference to a view, here?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Fri, Jun 22, 2001 at 09:36:19AM -0400, Tom Lane wrote:
> will trillich <will@serensoft.com> writes:
> > there is a view named "inv" -- but how's that related to this
> > straght table update?
>
> You wouldn't have any ON UPDATE rules or triggers attached to this
> table, would you?
>
>             regards, tom lane

did, in fact, even before i'd "alter table inv rename to _inv"...
wherein lies the culprit. (maybe 'alter table...' needs to root
around some more on those renames to make sure all references
are properly updated... as if i have a clue how hard that would
be...)

--
I figure: if a man's gonna gamble, may as well do it
without plowing.   -- Bama Dillert, "Some Came Running"

will@serensoft.com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!

pgsql-general by date:

Previous
From: Matt Beauregard
Date:
Subject: Re: Suggested improvement : Adjust SEQUENCES to accept an INCREMENT of functionname(parameters) instead of an integer
Next
From: Edwin Grubbs
Date:
Subject: Re: Newbie Inheritance Question