I'd love to use ConTemplate, but I'm fully committed to Postgres. I've made a series of modifications (see attached patch file) to (I believe) let contemplate work with postgres. Most of these are format changes (double quotes around variables in sql statement to single). I have also made set up the tables to use the Drupal 5 unsigned integer construct (int_unsigned) which is not standard in Postgres.

I've got this up and running on a test site in preparation for transition to operation as soon as Drupal 5 goes final.

carl.

CommentFileSizeAuthor
contemplate-psql-patch4.93 KBcarlmuck
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

artfikan’s picture

artfikan CreditAttribution: artfikan commented

Hi carl,

I'm new here and I'd to use Contemplate with PostgreSQL. Do this patch make it? Can you explain how to apply the patch?

Thanks.

jrglasgow’s picture

jrglasgow CreditAttribution: jrglasgow commented

This looks to be a Duplicate of #172775: Problem with table creation in PostgreSQL and #189939: CCK does not work with postgres 8.2, or maybe they are a duplicate of this Issue,... Anyways I applied the patch in #172775: Problem with table creation in PostgreSQL . If that doesn't fix the problem you are having let me know.

jrglasgow’s picture

jrglasgow CreditAttribution: jrglasgow commented
Status: Active » Postponed (maintainer needs more info)