New bug
I haven't looked into what's causing it yet but...
postgres=# SELECT res, * FROM (
SELECT 'foo'||i AS test, i AS res
FROM (VALUES (1)) AS x(i)
UNION ALL
SELECT 'foo'||i, i
FROM (VALUES (2)) AS x(i)
) AS x;
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
TRAP: FailedAssertion("!(child_attr <= new_max_attr)", File: "prepunion.c", Line: 1726)
Works fine on 8.3 so even though that section of code in prepunion.c hasn't
changed:
postgres=# SELECT res, * FROM (SELECT 'foo'||i AS test, i AS res FROM (VALUES (1)) AS x(i) UNION ALL SELECT 'foo'||i, i FROM (VALUES (2)) AS x(i)) AS x ;
res | test | res
-----+------+-----
1 | foo1 | 1
2 | foo2 | 2
(2 rows)
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's PostGIS support!
Hi,
It works fine on my machine
ibrar@ibrar-laptop:/usr/local/pgsql/bin$ ./psql postgres
psql (8.4devel)
Type "help" for help.
postgres=# SELECT res, * FROM (
SELECT
'foo'||i AS test, i AS res
FROM (VALUES (1)) AS x(i)
UNION ALL
SELECT 'foo'||i, i
FROM (VALUES (2)) AS x(i)
) AS x;
res | test | res
-----+------+-----
1 | foo1 | 1
2 | foo2 | 2
(2 rows)
postgres=#
On Wed, Nov 19, 2008 at 8:38 PM, Gregory Stark <stark@enterprisedb.com> wrote:
I haven't looked into what's causing it yet but...
postgres=# SELECT res, * FROM (
SELECT 'foo'||i AS test, i AS res
FROM (VALUES (1)) AS x(i)
UNION ALL
SELECT 'foo'||i, i
FROM (VALUES (2)) AS x(i)
) AS x;
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.TRAP: FailedAssertion("!(child_attr <= new_max_attr)", File: "prepunion.c", Line: 1726)
Works fine on 8.3 so even though that section of code in prepunion.c hasn't
changed:postgres=# SELECT res, * FROM (SELECT 'foo'||i AS test, i AS res FROM (VALUES (1)) AS x(i) UNION ALL SELECT 'foo'||i, i FROM (VALUES (2)) AS x(i)) AS x ;
res | test | res
-----+------+-----
1 | foo1 | 1
2 | foo2 | 2
(2 rows)--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's PostGIS support!--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
--
Ibrar Ahmed
EnterpriseDB http://www.enterprisedb.com
"Ibrar Ahmed" <ibrar.ahmad@gmail.com> writes:
Hi,
It works fine on my machine
Hm, a fresh checkout doesn't crash for me either any more.
Hopefully it didn't just hide the problem because I stupidly just trashed the
install that was exhibiting the problem.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's 24x7 Postgres support!
