Marc Cousin <[EMAIL PROTECTED]> 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 -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
