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.

Postgresql issue with use of reserved key words

#258

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)

Regards,

Pascal

Reported by Pascal Peltriaux · April 20th, 2011 @ 04:33 PM

State: duplicate
Milestone: Rundeck 1.4
Assigned to: nobody

Activity

  1. Greg Schueler
    Greg Schueler
    • 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 Import issues when using MySQL back-end

    the table/field renaming should fix postgres as well

    September 12th, 2011 @ 05:12 PM

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.