Lighthouse has a new layout. Prefer the old one? Return to the old layout, and switch back any time from the link at the top of each page.

This project is archived and is in readonly mode.

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

#771

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

Reported by azimux · August 7th, 2008 @ 12:18 PM

State: resolved
Milestone: 2.1.1
Assigned to: Tarmo Tänav Tarmo Tänav
Importance: High

Activity

  1. isak
    isak
    • 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.

    August 8th, 2008 @ 10:07 AM

  2. Pratik
    Pratik
    • Assigned user set to Tarmo Tänav

    August 22nd, 2008 @ 04:25 AM

  3. Jeremy Kemper
    Jeremy Kemper
    • State changed from new to open
    • Milestone changed from 2.x to 2.1.1

    August 22nd, 2008 @ 05:33 AM

  4. Tarmo Tänav
    Tarmo Tänav

    August 22nd, 2008 @ 07:59 AM

  5. Tarmo Tänav
    Tarmo Tänav

    Actually the values should be quoted, but with double-quotes because they are database name references and not values.

    August 22nd, 2008 @ 07:59 AM

  6. azimux
    azimux

    I tried it with double quotes and it worked fine

    August 22nd, 2008 @ 08:14 AM

  7. Repository
    Repository
    • State changed from open to resolved

    (from [d3b894563a114912113b816f07ed16511363fb65]) Properly quote CREATE DATABASE parameters in postgresql [#771 state:resolved] http://github.com/rails/rails/co...

    August 22nd, 2008 @ 08:58 AM

  8. Repository
    Repository

    (from [a6619865d0191c1001d1f25e8f4d111a0e9f78d2]) Properly quote CREATE DATABASE parameters in postgresql [#771 state:resolved] http://github.com/rails/rails/co...

    August 25th, 2008 @ 09:31 AM