Re: sqlbox and PostgreSQL

Stipe,

I tried to report the bug to http://bugs.kannel.org/ but the form  
does not allow me to post it because there is no Category selected,  
the thing is that Category does not show options to be selected.

Anyway the problem is:

sql = octstr_format("CREATE TABLE IF NOT EXISTS %S (sql_id bigint(20)  
not null auto_increment primary key, momt enum('MO', 'MT') null,  
sender varchar(20) null, receiver varchar(20) null, udhdata varchar 
(255) null, msgdata varchar(255) null, time bigint(20) null,
....

The statement above is part of sqlbox_configure_pgsql, as you can  
see, it has MySQL specific syntax like auto_increment (which  
equivalent in PostgreSQL is SERIAL), CREATE TABLE IF NOT EXISTS, etc.  
So this statement won't create the table in PostgreSQL if it does not  
exist.

Cesar,

On Nov 22, 2005, at 7:15 AM, Stipe Tolj wrote:

> Cesar Gutierrez Corea wrote:
>
>> Hi,
>> sqlbox_configure_pgsql does not create the tables if they do not   
>> exist, that CREATE statement only works with MySQL.
>
> thanks for reporting. Would you mind to profile a bug report to  
> http://bugs.kannel.org/ in order to help Rene keep track of issues?
>
> Please provide as much logging output as possible to help resolving.
>
> Thanks in advance.
>
> Stipe
>
> mailto:stolj_{at}_wapme-group.de
> -------------------------------------------------------------------
> Wapme Systems AG
>
> Vogelsanger Weg 80
> 40470 Düsseldorf, NRW, Germany
>
> phone: +49.211.74845.0
> fax: +49.211.74845.299
>
> mailto:info_{at}_wapme-systems.de
> http://www.wapme-systems.de/
> -------------------------------------------------------------------

--
Cesar Gutierrez Corea
Software Engineer
[email protected]