#771 postgresql 8.3 doesn't like single quoted role names in the OWNER clause - Ruby on Rails

Type	To find
responsible:me	tickets assigned to you
tagged:"@high"	tickets tagged @high
milestone:next	tickets in the upcoming milestone
state:invalid	tickets with the state invalid
created:"last week"	tickets created last week
sort:number, importance, updated	tickets sorted by #, importance or updated
Combine keywords for powerful searching.
Use advanced searching »

This project is archived and is in readonly mode.

#771 ✓resolved

postgresql 8.3 doesn't like single quoted role names in the OWNER clause

Reported by azimux | August 7th, 2008 @ 12:18 PM | in 2.1.1

postgresql does not like single quoted role names for the OWNER clause

This bug prevents me from being able to create the test database successfully when doing rake test. To reproduce this simply try running rake test on any rails app while using postgresql. It might require a recent version to expose the bug. I am running 8.3.3

The fix is trivial, unquoting the ownername, but I've attatched a patch anyways

Comments and changes to this ticket

You flagged this item as spam.
isak August 8th, 2008 @ 10:07 AM
- Tag changed from “activerecord, bug, edge, patch, postgresql” to “2.1, activerecord, bug, edge, patch, postgresql, tiny”
The bug applies to 8.2 as well, probably earlier versions too.

Adding "tiny" and "2.1" tags.
Pratik August 22nd, 2008 @ 04:25 AM
- Assigned user set to “Tarmo Tänav”
Jeremy Kemper August 22nd, 2008 @ 05:33 AM
- State changed from “new” to “open”
- Milestone changed from “2.x” to “2.1.1”
Tarmo Tänav August 22nd, 2008 @ 07:59 AM
- no changes were found...
- 0001-Properly-quote-CREATE-DATABASE-parameters-in-postgre.patch 1.3 KB
Tarmo Tänav August 22nd, 2008 @ 07:59 AM
Actually the values should be quoted, but with double-quotes because they are database name references and not values.
You flagged this item as spam.
azimux August 22nd, 2008 @ 08:14 AM
I tried it with double quotes and it worked fine
Repository August 22nd, 2008 @ 08:58 AM
- State changed from “open” to “resolved”
(from [d3b894563a114912113b816f07ed16511363fb65]) Properly quote CREATE DATABASE parameters in postgresql [#771 state:resolved] http://github.com/rails/rails/co...
Repository August 25th, 2008 @ 09:31 AM
(from [a6619865d0191c1001d1f25e8f4d111a0e9f78d2]) Properly quote CREATE DATABASE parameters in postgresql [#771 state:resolved] http://github.com/rails/rails/co...