Taking a hint from alt_login, a dba.install file can create the required view.
Tested with a recent pgsql.
If pgsql 7.3 support is required, someone would need to cook a query that will only work with pgsql >=7.4, and run the test to create the right view in the installer...

Right now, both view creation commands `work', but only one creates a usable view.

CommentFileSizeAuthor
install.patch842 bytesespie

Comments

dww’s picture

dww
we/he/they
commented
Status: Needs review » Needs work

I have no way to test this right now. If someone else does, I'd commit it.

However, there are some code style problems in this patch, in particular, the use of tabs not spaces. Also, we don't normally split such SQL statements into so many lines. So, please fix those and then see if you can find someone else to test this. Thanks.

jeremy’s picture

jeremy commented

Ooh, I've been wanting to play with my local PostgreSQL installation. I'll try and test this soon.

I don't see any need to support PostgreSQL 7.3 personally, but what does Drupal core support?

espie’s picture

espie commented

Well, it definitely works with recent postgresql (tested with 8.2.6) here, so if pgsql <=7.3 is not an issue, I'll clean up the style issues with my patch tomorrow...

next step will be to have a look at phppgadmin to see how to grab the missing table structure from php, and see if I can improve on the view...

jeremy’s picture

jeremy commented
Status: Needs work » Closed (won't fix)

The 5.x branch is no longer supported.