Re: ERROR: could not open relation - Mailing list pgsql-general

From Thomas F. O'Connell
Subject Re: ERROR: could not open relation
Date
Msg-id D356BC7F-6CBB-439E-BE54-979E96F8D22C@sitening.com
Whole thread Raw
In response to Re: ERROR: could not open relation  ("Thomas F. O'Connell" <tfo@sitening.com>)
List pgsql-general
One final final question: my suspicion is no, but I just want to ask:
this would not affect all inherited tables with bgwriter, would it,
in scenarios where a persistent inherited table gets dropped while a
parent table is being queried? Could this result in a similar
scheduling conflict for bgwriter? I'm under the impression that this
is mostly an issue with the implementation of temp tables and the
planner, but I'd like confirmation from folks who can read the code
more easily...

--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC

Strategic Open Source: Open Your i™

http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005

On Jul 14, 2005, at 4:44 PM, Thomas F. O'Connell wrote:

> From this thread, these two bits about PostgreSQL stand out:
>
> "I have an old note to myself that persistent write errors could
> "clog"
> the bgwriter, because I was worried that after an error it would
> stupidly try to write the same buffer again instead of trying to make
> progress elsewhere.  (CVS tip might be better about this, I'm not
> sure.)
> A dirty buffer for a file that doesn't exist anymore would certainly
> qualify as a persistent failure."
>
> and
>
> "Hmm ... a SELECT from one of the "actual tables" would then scan the
> temp tables too, no?
>
> Thinking about this, I seem to recall that we had agreed to make the
> planner ignore temp tables of other backends when expanding an
> inheritance list --- but I don't see anything in the code implementing
> that, so it evidently didn't get done yet."
>
> I don't immediately see TODO items correpsonding to these. Should
> there be some? Or do these qualify as bugs and should they be
> submitted to that queue?
>
> Thanks again to all developers and community folk who lent insight
> into this error -- diagnosis and recovery (which was, thankfully,
> virtually non-existent).
>
> --
> Thomas F. O'Connell
> Co-Founder, Information Architect
> Sitening, LLC
>
> Strategic Open Source: Open Your i™
>
> http://www.sitening.com/
> 110 30th Avenue North, Suite 6
> Nashville, TN 37203-6320
> 615-260-0005
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that
> your
>       message can get through to the mailing list cleanly
>


pgsql-general by date:

Previous
From: Peter Fein
Date:
Subject: Re: Return SETOF or array from pl/python
Next
From: Peter Fein
Date:
Subject: Re: Return SETOF or array from pl/python