PostgreSQL

Hi.

I have found this specific issue with postgresql: https://drupal.org/node/2142107 .
Do you know a solution for this?

Regards,
Gilsberty

Hi guys,

I'm new to postgreSQL in Drupal and can't figure out how to do a DISTINCT ON select within drupal's query classes with declared fields like this:

SELECT DISTINCT ON (field1, field2) field1, field2, field3 FROM table1

I see you can set a query as $query->distinct(TRUE) but that just seems to add the word DISTINCT, which if I understand it, just makes sure that all columns combined are unique.

Is this possible to pass those DISTINCT ONs to a funciton or should I rewrite my query to do it some other way?

Hi there!

In our recent project we had implemented 'personalized' database querying, so all queries from particular user executed (and appears in SQL log) as dedicated Postgres user.

Maybe someone find it useful for same purpose or for future evolution - like setting some users with more priority, limiting users activity, etc.

The project was initially published with sandbox status, then promoted to regular
http://drupal.org/project/pgsign

Thank you,
Dennis

After several hours of uncertainty it seems that I have managed to migrate a MySQL Drupal to a PostgreSQL. So I want to share my experience with this group where I think could be useful.

There are several problemas to solve: table structure translation, autoincrement values / sequences, serialized data, etc.

I've tried several ways, but always I came up against some problem.

Database schema

MySQL and PostgreSQL use different data types for its columns, they define its tables in its own way, you can't use MySQl definitions.

Buenas me permito hacer un anuncio desde el grupo de Geoinquietos de Valencia ya que alguna vez me habéis preguntado (u os he dado la brasa) sobre las posibilidades de OpenStreetMap como fuente de datos para aplicaciones web y similares. Supongo que con los recientes casos de cambio de Google Maps a esta plataforma de cartografía en web (especialmente Foursquare) a más de uno le interesará...

Hi,

I recently installed Drupal 7 on Windows with Apache Web server (2.2) and PostGres DB. When I try to access the drupal site, I'm always seeing the directory listing and if I click on a specific php page, I'm able to see the HTML contents; but none of the dynamic features (search, filter, etc.) are working. I thought PHP wasn't installed fine; but if I throw in a simple PHP page with PHP functions, I'm able to get dynamic contents on the page. Is there any other configuration I need to do before I get started with my first site?

Thanks in advance for your help!

Regards,
Yogaesh

Is anyone working on Postgres support for Aegir?

hi,

i've created this module:

http://drupal.org/project/settings_audit_log

which uses a trigger to watch the variable table, and i need help porting it to postgresql.

please drop by the issue queue if you can help.

Hello,

The security team occasionally gets security issues which affect Drupal's interaction with PostgreSQL and sometimes the team has patches that will work on MySQL and break PostgreSQL, but do not receive enough reviews from PostgreSQL users prior to being released.

If you are
1. A PostgreSQL expert
2. Interested in joining the security team

Please send an email to security [at] drupal.org listing your interest and qualificiations.

日本PostgreSQLユーザ会（JPUG)が、11月20,21日に設立10周年記念のPostgreSQLカンファレンス2009Japanを開催します。

http://www.postgresql.jp/events/pgcon09j/j/

そこで、次のようなご協力を関連のある各コミュニティにお願いしてほしいとのことでした。

稲葉さん（実行委員長）より：

昨日の理事会でお願いいたしましたが、PostgreSQLに関係のありそうな各種OSS
コミュニティに、協力団体になっていただきたいと思います。

こちらからのお願い