PostgreSQL Support

This module works great with postgres when you add the smiley examples to the database directly as recently posted in http://drupal.org/node/view/7300">node 7300

However adding smileys via the filter admin interface will only work when adding your first item. I believe it might have something to do with a behavior I found.

The included smileys.pgsql includes the following postgres SQL command:

CREATE SEQUENCE smileys_id_seq INCREMENT 1 START 1;

Even though this states to start the first id at 1 and increment thereafter, I noticed after adding my first smiley with the smiley administrator that it was created with id 0. When adding a second smiley, the admin tool reports back that it added correctly, but nothing more shows up in the table.

I really don't know anything about SQL, but this seems to have something to do with the problem. Anyway we seem to be very close to closing this feature request.