Umarzuki Mochlis escribió:
> when browsing november 2008 mail archive, i found that my problem
> might be related to postgresql like Julian had but the error message
>
> function create_tmp_table(unknown) does not exist at character 8
>
> aside from that it only happens only 5 times around 11 AM
>
> when i try again at 12 PM
>
> REG-UMAR@192.168.56.6 <mailto:REG-UMAR@192.168.56.6>> create_contact
> CID:CA000001 'Umarzuki' umarzuki@gmail 123 Beranang 43700 MY
> Do you really want to send this command to the server? (y/N): y
> Return code: 2400
> Reason: Command failed
>
Seems like you don't have the PostgreSQL Perl language package
installed. In my case (Ubuntu 8.04):
/root@mguerra:~# dpkg -l | grep postgresql-plperl
ii postgresql-plperl-8.3 8.3.7-0ubuntu8.04.1
PL/Perl procedural language for PostgreSQL 8/
if you have it installed, create the language using the PostgreSQL
command line.
Best regards.
Mario