On Aug 19, 2009, at 10:33 PM, Craig Ringer wrote:
On Wed, 2009-08-19 at 08:58 -0400, Arturo Pérez wrote:
19-Aug 02:24 bacula-dir JobId 1951: Fatal error: sql_create.c:789
Fill Path table Query failed: INSERT INTO Path (Path) SELECT a.Path
FROM (SELECT DISTINCT Path FROM batch) AS a WHERE NOT EXISTS (SELECT
Path FROM Path WHERE Path = a.Path) : ERR=ERROR: array size exceeds
the maximum allowed (268435455)
That's odd. Where's the array? Subqueries shouldn't result in
arrays in
any way, no?
Looks like a bad build so far. I was upgrading to 3.0/8.4 and tried
to build
everything universal (on Mac) to future-proof the upgrade. I built
just a native
binary and it seems to work better.
-arturo
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
