SET DEFAULT problem in staticpage plugin (PG problem)

[ads]

Hello all,

i just tried to install the 'serendipity_plugin_staticpage' and got an error:

ERROR: adding columns with defaults is not implemented HINT: Add the column, then use ALTER TABLE SET DEFAULT

in: include/db/postgres.inc.php

It seems the error occur, if plugins/serendipity_event_staticpage/serendipity_event_staticpage.php tries to modify tables from line 716. The code is completely mysqlish ...

Would'nt it be a good idea to create a interface for manipulating the database? Something like serendipity_alter_table(...)?

I really like Serendipity, but all the Mysql stuff is really a mess, i don't want to switch databases just for a blog.

[garvinhicking]

Hi!

Sadly it seems that little web-developers use pgsql. All of our developers mainly use mysql, and thus such problems may arise.

Maybe you can contribute a patch to the plugin that will work onall mysql and pgsql and sqlite? The main developer of that plugin uses MySQL only.

A "alter table" default API function would be nice, maybe you'd like to contribute this function and we will commit it to the repository? Of course having an API function would mean that plugin devs would need to start using it in the future, which might be hard because they are often used to issuing SQL calls directly.

Best regards,
Garvin