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)
Regards,
Pascal
Comments and changes to this ticket
-
alcinoos August 6th, 2011 @ 11:39 AM
Hello,
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.
Regards,
Rémy
-
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.
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
Greg Schueler
Pascal Peltriaux