Re: Feature or Bug Questions

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Feature or Bug Questions
Date: 2002-09-26 16:13:10
Message-ID: 20020926121310.B1869@mail.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, Sep 26, 2002 at 08:54:12AM -0700, Derek Neighbors wrote:
>
> If you drop a table and then recreate it. Trying to access a view on
> that table returns error about OID not being found. If you drop and
> recreate the view the problem goes away.

Yes. This is a known problem. I _think_ 7.3 (currently in beta) is
going to do something about it, but don't hold me to that.

>
> Issue #2
>
> This one is a bit more indepth but on updates it appears that implicit
> numeric conversion is not happening. Here is a link to some of our
> lengthy discussions on it...

There has been a great whack of discussion in -hackers recently about
the implicit rules. The short answer is Here There Be Dragons. But
you can probably try quoting everything; you may find it works fine
for you.

A

----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Adam Erickson 2002-09-26 17:25:51 Re: hardware question
Previous Message Derek Neighbors 2002-09-26 15:54:12 Feature or Bug Questions