PostgreSQL 8.3.0 'unrecognized node type: 1718580065'

Started by Vladimir Kokovicalmost 18 years ago3 messages
#1Vladimir Kokovic
vladimir.kokovic@a-asoft.com

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

#2Zdenek Kotala
Zdenek.Kotala@Sun.COM
In reply to: Vladimir Kokovic (#1)
Re: PostgreSQL 8.3.0 'unrecognized node type: 1718580065'

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

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

#3Vladimir Kokovic
vladimir.kokovic@a-asoft.com
In reply to: Zdenek Kotala (#2)
Re: PostgreSQL 8.3.0 'unrecognized node type: 1718580065'

Hi

After Tom Lane did patch for copyfuncs.c my problem is gone !

Thanks Tom

Best regards,
Vladimir Kokovic, DP senior, Belgrade, Serbia