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
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