[development] Drupal 7 fails to install on PostgreSQL

[Thom Brown]

On 11 February 2011 14:15, Thom Brown <thom at 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