Re: where's the reference to a view, here?

From: will trillich <will(at)serensoft(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: where's the reference to a view, here?
Date: 2001-06-22 18:02:45
Message-ID: 20010622130245.A10362@serensoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jun 22, 2001 at 09:36:19AM -0400, Tom Lane wrote:
> will trillich <will(at)serensoft(dot)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(at)serensoft(dot)com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Åkerud 2001-06-22 18:06:03 Multiple Indexing, performance impact
Previous Message Matt Beauregard 2001-06-22 17:45:48 Re: Suggested improvement : Adjust SEQUENCES to accept an INCREMENT of functionname(parameters) instead of an integer