pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Marc Cousin <mcousin@sigma.fr>
Cc: pgsql-admin@postgresql.org
Subject: Re: cannot restore a view after a dump
Date: Tue, 08 Apr 2008 10:03:58 -0400
Message-ID: <448.1207663438@sss.pgh.pa.us> (raw)
In-Reply-To: <200804080911.56042.mcousin@sigma.fr>
References: <200804041022.31746.mcousin@sigma.fr>
	<200804041521.52137.mcousin@sigma.fr>
	<200804080911.56042.mcousin@sigma.fr>

Marc Cousin <mcousin@sigma.fr> writes:
> Sorry to post again, but I feel this issue is a bit strange and I'd like to 
> understand it. The problem is that I've got the same query that runs 
> sometimes, and fails with a syntax error at other times... It's the first 
> time I've seen it, and I've been using PostgreSQL for a while now ...

Oh, sorry for not replying directly to you.  This was analyzed over in
-hackers and we now understand the cause, but haven't a fix quite yet:
http://archives.postgresql.org/pgsql-hackers/2008-04/msg00278.php

It's been broken since approximately forever, so if you'd been using
that view definition for awhile I'm surprised you didn't run into the
problem before.

The reason for the erratic behavior is that it depends on what happened
to already be in the chunks of memory used to form the array constants.
In a freshly-started backend the view creation would probably always
succeed, but as soon as memory has gotten dirtied a bit, maybe not.

			regards, tom lane



view thread (7+ messages)  latest in thread

Message-ID: <448.1207663438@sss.pgh.pa.us>
Permalink:  ../448.1207663438@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/448.1207663438@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, mcousin@sigma.fr
  Subject: Re: cannot restore a view after a dump
  In-Reply-To: <448.1207663438@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox