[SQL] Cannot build PL/Perl ...

Cannot build PL/Perl because libperl is not a shared library. I'v got this error when I tried to compile PL/Perl. I have SuSE Linux 7.0 , have I get a libperl.so library , and put it in /usr /lib ... Thanks for any help Adam -- ---(end of broadcast)---

[SQL] PL/Perl documentation ...

Is there available some more examples of writing functions in PL/Perl ? In standard documentation there is only just 2 examples. Thanks in advance for any help. Adam -- ---(end of broadcast)--- TIP 2: you can get off all lists at once with

[SQL] SQL-92 SQLSTATE in PostgreSQL ?!

Hi, Is there SQL-92 SQLSTATE or SQL-96 SQLCODE implemented in PostgreSQL (I use version 7.0 on SuSe Linux 6.4) ? If so, how to take the value of it in stored procedures (written in PL/pgSQL or C) In  documentation I found only a short describtion of sqlca In ecpg.   Thanks in advance  Adam

[SQL] SPI documantation

Where can I get more information about programming  in SPI. (more than in PostgreSQL documentation). Thanks for any help Adam

[SQL] pg_recvbuf : unexpected EOF on client

I have an application in Java I use to insert records into postgreSQL base. Java shows no errors, butrecords can't write into base.In pgsqrever.log I found entry :pg_recvbuf : unexpected EOF on client connection.   Thanks for any help. Adam

[SQL] textpos() in postgreSQL 7.0

Hi I notice that string function textpos() doesn't exist in postgreSQL 7.0. I have some plpgsql functions written for 6.5.2 that use textpos() and when I tried to use them in postgreSQL 7.0 I'v got error. Should I compile postgreSQL 7.0 with more options than -enable locale ?!!? Thanks for