PostgreSQL 8.3.0 'unrecognized node type: 1718580065'
Hi all,
I am using version 8.3.0 of the source and compiled it with next options:
PostgreSQL config.status 8.3.0
configured by ./configure, generated by GNU Autoconf 2.59,
with options \"'--enable-cassert' '--enable-debug' '--enable-nls' '--enable-integer-datetimes' '--with-perl' '--with-python' '--with-tcl' '--with-krb5' '--with-openssl' '--enable-thread-safety' '--with-ldap' '--prefix=/media/hda5/postgresql-8.3.0'\"
I am on Kubuntu 7.10:
Linux vladakk-kuci 2.6.22-14-generic #1 SMP Fri Feb 1 04:59:50 UTC 2008 i686 GNU/Linux
Something is wrong on server side !
I don't know if this is known bug, but look in my PostgreSQL log file:
2008-02-07 17:05:18 CET asoft vlada LOG: 00000: execute <unnamed>: CREATE SCHEMA asoft
2008-02-07 17:05:18 CET asoft vlada LOCATION: exec_execute_message, postgres.c:1820
2008-02-07 17:05:18 CET asoft vlada LOG: 00000: duration: 0.806 ms
2008-02-07 17:05:18 CET asoft vlada LOCATION: exec_execute_message, postgres.c:1890
2008-02-07 17:05:18 CET asoft vlada ERROR: XX000: unrecognized node type: 1718580065
2008-02-07 17:05:18 CET asoft vlada LOCATION: copyObject, copyfuncs.c:3573
2008-02-07 17:05:18 CET asoft vlada STATEMENT: ALTER SCHEMA asoft OWNER TO postgres
2008-02-07 17:05:18 CET asoft vlada LOG: 08P01: unexpected EOF on client connection
2008-02-07 17:05:18 CET asoft vlada LOCATION: SocketBackend, postgres.c:323
2008-02-07 17:05:18 CET asoft vlada LOG: 00000: disconnection: session time: 0:00:05.515 user=vlada database=asoft host=localhost port=55602
2008-02-07 17:05:18 CET asoft vlada LOCATION: log_disconnections, postgres.c:3940
Best regards,
Vladimir Kokovic, DP senior, Belgrade, Serbia
Please, can you provide a test case? Which command does fail?
Thanks Zdenek
Vladimir Kokovic wrote:
Show quoted text
Hi all,
I am using version 8.3.0 of the source and compiled it with next options:
PostgreSQL config.status 8.3.0
configured by ./configure, generated by GNU Autoconf 2.59,
with options \"'--enable-cassert' '--enable-debug' '--enable-nls' '--enable-integer-datetimes' '--with-perl' '--with-python' '--with-tcl' '--with-krb5' '--with-openssl' '--enable-thread-safety' '--with-ldap' '--prefix=/media/hda5/postgresql-8.3.0'\"I am on Kubuntu 7.10:
Linux vladakk-kuci 2.6.22-14-generic #1 SMP Fri Feb 1 04:59:50 UTC 2008 i686 GNU/LinuxSomething is wrong on server side !
I don't know if this is known bug, but look in my PostgreSQL log file:
2008-02-07 17:05:18 CET asoft vlada LOG: 00000: execute <unnamed>: CREATE SCHEMA asoft
2008-02-07 17:05:18 CET asoft vlada LOCATION: exec_execute_message, postgres.c:1820
2008-02-07 17:05:18 CET asoft vlada LOG: 00000: duration: 0.806 ms
2008-02-07 17:05:18 CET asoft vlada LOCATION: exec_execute_message, postgres.c:1890
2008-02-07 17:05:18 CET asoft vlada ERROR: XX000: unrecognized node type: 1718580065
2008-02-07 17:05:18 CET asoft vlada LOCATION: copyObject, copyfuncs.c:3573
2008-02-07 17:05:18 CET asoft vlada STATEMENT: ALTER SCHEMA asoft OWNER TO postgres
2008-02-07 17:05:18 CET asoft vlada LOG: 08P01: unexpected EOF on client connection
2008-02-07 17:05:18 CET asoft vlada LOCATION: SocketBackend, postgres.c:323
2008-02-07 17:05:18 CET asoft vlada LOG: 00000: disconnection: session time: 0:00:05.515 user=vlada database=asoft host=localhost port=55602
2008-02-07 17:05:18 CET asoft vlada LOCATION: log_disconnections, postgres.c:3940Best regards,
Vladimir Kokovic, DP senior, Belgrade, Serbia---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match