Role export fails when sql is more strict than mysql [#330350]

"WHERE 1" is misinterpreted by postgresql. To perform role export must be "WHERE true"

I generated a patch for this issue.

Comment	File	Size	Author
#2	330350_install_profile_wizard_pgsql.2.patch	1016 bytes	dww
	roles_patch_pgsql.patch	669 bytes	dalad

Comments

dww

we/he/they

commented 12 December 2008 at 22:13

Status:

Needs review

» Needs work

Why use a WHERE clause at all? Why not just:

$result = db_query("SELECT rid, perm FROM {permission}");

dww

we/he/they

commented 13 December 2008 at 02:36

Assigned:	dalad	» dww
Status:	Needs work	» Needs review

Status	File	Size
new	330350_install_profile_wizard_pgsql.2.patch	1016 bytes

Untested, but I can't see how this would hurt...

dww

we/he/they

commented 14 December 2008 at 04:36

Version:	5.x-1.1	» 5.x-2.x-dev
Status:	Needs review	» Fixed

dmitrig01 said this was RTBC, so I committed to DRUPAL-5--2.

28 December 2008 at 05:03

Status:

Fixed

» Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.