By PmGs on

hello everybody,

I discovered drupal recently and my first impression is good, but I had two problem related to postgresql and I wonder is everything is ok with this db.

1) first pb : 'PDOException: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: "types" LINE 5: WHERE (base.product_id IN ('types')) ' , I found the solution in the forum, it works well, but I wonder why this solution is not integrated in the last version of drupal ?

2) second pb : Unknown index product_display. : I found that this bug was post in the forum in June 2014 but as far as I know, is still not solved ! ?

As I said, I am new with drupal, maybe I missed something, ...

For your information I use :
Debian Wheesy 64bit
Postgresql 9.1.15
Php 5.4.39-0
first install : commerce_kickstart-7.x-2.22-core ( drupal-7.35 )
update : drupal-7.36

⋅ Categories: Drupal 7.x

Comments

Jaypan’s picture

Jaypan commented

Drupal core has been tested with PostgreSQL, but most contributed modules probably haven't been tested with PostgreSQL, so there is a good chance you will run into problems.

PmGs’s picture

PmGs commented

Thanks for your answer.

I understand a little bit more how drupal works, for instance I discovered that there is a dedicated forum for drupal commerce ( and probable for other modules ), so I post my question on this forum.

bojanz’s picture

bojanz commented

Kickstart isn't supported on Postgres, you'll need to patch it yourself (and contribute the patches) if you want to use it.

(We simply don't have the resources to test a 100 modules with a database we don't use in production)