Hi Thom - The proper place for this is not in either mailing list - it's in the issue queue <http://drupal.org/project/issues/drupal>. You'll find a number of "installation fails" issues, and you should find the one that matches, or create a new one. And you should read the ones that are there to get clues about what the problem might be Many people are very anxious to make installs as good as they can be, so please work with them in the queue. You can become one of them, helping to resolve this problem. If you create a new issue <http://drupal.org/node/add/project-issue/drupal>, (or if you just chime in on an existing one) please make sure to give complete information, as it suggests there, so somebody can understand and repeat exactly what you've done. You should mention, for example, whether this is a new install or an upgrade, whether you dropped the database and recreated it before installing, and whether you have any non-core modules installed (I hope not). -Randy On Sun, Feb 13, 2011 at 4:37 AM, Thom Brown <thom@linux.com> wrote:

On 11 February 2011 14:15, Thom Brown <thom@linux.com> wrote:

...

Hi,

I've tried to install Drupal 7 on 2 separate systems using a PostgreSQL 9.0 database backend, and both times it has failed at the same point. The error message in the PostgreSQL logs both times is:

ERROR: null value in column "rid" violates not-null constraint STATEMENT: INSERT INTO role_permission (rid, permission, module) VALUES (NULL, 'administer blocks', 'block')

I followed the instructions in INSTALL.pgsql.txt, and everything else installs up to this point.

The actual error message returned on the installation page is:

An AJAX HTTP error occurred. HTTP Result Code: 200 Debugging information follows. Path: http://bison:8089/install.php?profile=standard&locale=en&id=1&op=do StatusText: OK ResponseText: Home | Drupal @import url("http://bison:8089/modules/system/system.theme.css?0"); @import url("http://bison:8089/modules/system/system.messages.css?0"); @import url("http://bison:8089/modules/system/system.menus.css?0"); @import url("http://bison:8089/modules/system/system.base.css?0"); @import url("http://bison:8089/modules/comment/comment.css?0"); @import url("http://bison:8089/modules/field/theme/field.css?0"); @import url("http://bison:8089/modules/node/node.css?0"); @import url("http://bison:8089/modules/search/search.css?0"); @import url("http://bison:8089/modules/user/user.css?0"); @import url("http://bison:8089/modules/system/system.admin.css?0"); @import url("http://bison:8089/modules/system/system.maintenance.css?0 "); @import url("http://bison:8089/themes/seven/reset.css?0"); @import url("http://bison:8089/themes/seven/style.css?0"); Home Installation tasksChoose profile(done)Choose language(done)Verify requirements(done)Set up database(done)Install profile(active)Configure siteFinished SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block

Is this a bug?

Forwarding to development list as no response on support list.

-- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux user: #516935

-- Randy Fay Drupal Module and Site Development randy@randyfay.com +1 970.462.7450