#258 ✓duplicate
Pascal Peltriaux

Postgresql issue with use of reserved key words

Reported by Pascal Peltriaux | April 20th, 2011 @ 04:33 PM | in Rundeck 1.4 (closed)

Hi guys,

I did try to setup Rundeck using a Postgresql DB.
I'm running rundeck 1.2, postgresql 8.3 on a RedHat (5.6) server

I encounter the following issue, when trying to initialize the DB (or even trying to using it), rundeck report error accessing or creating tables that have the tablename user OR the column name user.
"user" is a Postgresql reserved keyword and always refer to the Postgres user table. In order to bypass this, you can quote the user ( "user" ) and Postgres will understand you dont refer to "his" user table but to yours.

I have attached two files, the Rundeck.log error when running Rundeck with Postgresql (when it tries creating DB tables)
And also the same request in Postgresql with and without quote (work when quoted and doesn't when not)



Comments and changes to this ticket

  • alcinoos

    alcinoos August 6th, 2011 @ 11:39 AM


    I have the same issue with rundeck 1.3. I have created a git patch to change database mapping for User entity to table "login" instead of "user" which is, as Pascal said, a Postgresql reserved keyword.



  • Greg Schueler

    Greg Schueler September 12th, 2011 @ 05:12 PM

    • State changed from “new” to “duplicate”
    • Tag set to bug, database, postgresql
    • Milestone set to Rundeck 1.4
    • Milestone order changed from “25” to “0”

    marking as duplicate of #383

    the table/field renaming should fix postgres as well

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.

New-ticket Create new ticket

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile ยป

(DEPRECATED) Please use github issues for issue tracking at http://github.com/dtolabs/rundeck/issues

Shared Ticket Bins

People watching this ticket