Thread: error insert
CREATE FUNCTION complex_in(opaque) RETURNS complex AS '/usr/local/pgsql/postgresql-6.4.2/src/tutorial/complex.so' LANGUAGE'c'; NOTICE: ProcedureCreate: type 'complex' is not yet defined NOTICE: ProcedureCreate: type 'complex' is not yet defined CREATE CREATE FUNCTION complex_out(opaque) RETURNS opaque AS '/usr/local/pgsql/postgresql-6.4.2/src/tutorial/complex.so' LANGUAGE'c'; CREATE CREATE TYPE complex ( internallength = 16, input = complex_in, output = complex_out ); CREATE CREATE TABLE test_complex ( a complex, b complex ); CREATE INSERT INTO test_complex VALUES ('(1.0, 2.5)', '(4.2, 3.55 )'); assertion "u.hdr.e_phentsize == sizeof(Elf_Phdr)" failed: file "/usr/src/libexec/rtld-elf/map_object.c", line 118 pqReadData() -- backend closed the channel unexpectedly. This probably means the backend terminated abnormally before orwhile processing the request. We have lost the connection to the backend, so further processing is impossible. Terminating. in the root console: assertion "u.hdr.e_phentsize == sizeof(Elf_Phdr)" failed: file "/usr/src/libexec/rtld-elf/map_object.c", line 118 thank you for your help
Okay, I downloaded 6.5 postgreSQL and installed it. Then I went into the jdbc directory, set my PATH and CLASSPATH to point to jdk 1.1.7 and built the interface. Then I changed my PATH and CLASSPATH to point to JDK 1.2. I typed `make` again. The build went fine. Then I built my test program that uses JDBC and ran it and got this error: Exception caught: The postgresql.jar file does not contain the correct JDBC classes for this JVM. Try rebuilding. Exception thrown was java.lang.ClassNotFoundException: postgresql.jdbc2.Connection What did I do wrong? When I compile and run the program with the JDK 1.1.7 it runs fine. Adam
On Fri, 7 May 1999, Adam H. Pendleton wrote: > Okay, I downloaded 6.5 postgreSQL and installed it. Then I went into the > jdbc directory, set my PATH and CLASSPATH to point to jdk 1.1.7 and built > the interface. Then I changed my PATH and CLASSPATH to point to JDK 1.2. I > typed `make` again. The build went fine. Then I built my test program that > uses JDBC and ran it and got this error: > > Exception caught: The postgresql.jar file does not contain the correct JDBC > classes for this JVM. Try rebuilding. > Exception thrown was java.lang.ClassNotFoundException: > postgresql.jdbc2.Connection > > What did I do wrong? When I compile and run the program with the JDK 1.1.7 > it runs fine. There is an issue with some JVM's where the java.version property doesn't begin with a version number (usually they have a date). When running under JDK1.2, try it with -Djava.version=1.2 ie: java -Djava.version=1.2 my.class Peter -- Peter T Mount peter@retep.org.uk Main Homepage: http://www.retep.org.uk PostgreSQL JDBC Faq: http://www.retep.org.uk/postgresJava PDF Generator: http://www.retep.org.uk/pdf
On 07-May-99 abdelkrim wrote: > CREATE FUNCTION complex_in(opaque) > RETURNS complex > AS '/usr/local/pgsql/postgresql-6.4.2/src/tutorial/complex.so' > LANGUAGE 'c'; > NOTICE: ProcedureCreate: type 'complex' is not yet defined > NOTICE: ProcedureCreate: type 'complex' is not yet defined > CREATE Hmmm. Looks like the 'complex' type needs to be defined first. I used a different example as a basis for adding types and functions, it returned 'opaque' rather than a new type. > CREATE FUNCTION complex_out(opaque) > RETURNS opaque > AS '/usr/local/pgsql/postgresql-6.4.2/src/tutorial/complex.so' > LANGUAGE 'c'; > CREATE > > > CREATE TYPE complex ( > internallength = 16, > input = complex_in, > output = complex_out > ); > CREATE Have you tried putting this CREATE TYPE statement before the first CREATE FUNCTION statement? > CREATE TABLE test_complex ( > a complex, > b complex > ); > CREATE > > > INSERT INTO test_complex VALUES ('(1.0, 2.5)', '(4.2, 3.55 )'); > assertion "u.hdr.e_phentsize == sizeof(Elf_Phdr)" failed: file > "/usr/src/libexec/rtld-elf/map_object.c", line 118 > pqReadData() -- backend closed the channel unexpectedly. > This probably means the backend terminated abnormally before or while > processing the request. > We have lost the connection to the backend, so further processing is > impossible. Terminating. > > > > in the root console: > > assertion "u.hdr.e_phentsize == sizeof(Elf_Phdr)" failed: file > "/usr/src/libexec/rtld-elf/map_object.c", line 118 > ---------------------------------- Date: 10-May-99 Time: 11:01:42 Craig Orsinger (email: <orsingerc@epg.lewis.army.mil>) Logicon RDA Bldg. 8B28 "Just another megalomaniac with ideas above his 6th & F Streets station. The Universe is full of them." Ft. Lewis, WA 98433 - The Doctor ----------------------------------
On 10-May-99 Craig Orsinger wrote: >> CREATE FUNCTION complex_in(opaque) >> RETURNS complex >> AS '/usr/local/pgsql/postgresql-6.4.2/src/tutorial/complex.so' >> LANGUAGE 'c'; >> NOTICE: ProcedureCreate: type 'complex' is not yet defined >> NOTICE: ProcedureCreate: type 'complex' is not yet defined >> CREATE > > Hmmm. Looks like the 'complex' type needs to be defined first. > I used a different example as a basis for adding types and functions, > it returned 'opaque' rather than a new type. I'd suggest replacing "RETURNS complex" with "RETURNS opaque" and see how that goes. >> CREATE FUNCTION complex_out(opaque) >> RETURNS opaque >> AS '/usr/local/pgsql/postgresql-6.4.2/src/tutorial/complex.so' >> LANGUAGE 'c'; >> CREATE >> >> >> CREATE TYPE complex ( >> internallength = 16, >> input = complex_in, >> output = complex_out >> ); >> CREATE > > Have you tried putting this CREATE TYPE statement before the > first CREATE FUNCTION statement? This will not work, for reasons that should have been obvious - the input and output functions would not have been CREATE'd yet. ---------------------------------- Date: 10-May-99 Time: 11:55:53 Craig Orsinger (email: <orsingerc@epg.lewis.army.mil>) Logicon RDA Bldg. 8B28 "Just another megalomaniac with ideas above his 6th & F Streets station. The Universe is full of them." Ft. Lewis, WA 98433 - The Doctor ----------------------------------