Project

General

Profile

Actions
Copy link

Feature #29768

open

Use debversion postgresql-extension

Added by Markus Bucher over 4 years ago. Updated 4 months ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
Repositories
Target version:
-
Difficulty:
Triaged:
Yes
Bugzilla link:
Pull request:
https://github.com/Katello/katello/pull/8708, https://github.com/Katello/katello/pull/8757, https://github.com/Katello/katello/pull/8760
Fixed in Releases:
Katello 4.0.0
Found in Releases:
Red Hat JIRA:

Description

To be able to efficiently compare debian-version strings within the database, we should use the debversion extension for postgresql.

This will probably require a dependency in the katello rpm.

Actions
Copy link
 #1

Updated by The Foreman Bot over 4 years ago

  • Status changed from New to Ready For Testing
  • Pull request https://github.com/Katello/katello/pull/8708 added
Actions
Copy link
 #2

Updated by James Jeffers over 4 years ago

  • Target version set to 1235
  • Triaged changed from No to Yes
Actions
Copy link
 #3

Updated by Jonathon Turel over 4 years ago

  • Target version changed from 1235 to Katello 4.0.0
Actions
Copy link
 #4

Updated by The Foreman Bot over 4 years ago

  • Fixed in Releases Katello 4.0.0 added
Actions
Copy link
 #5

Updated by Markus Bucher over 4 years ago

  • Status changed from Ready For Testing to Closed
Actions
Copy link
 #6

Updated by The Foreman Bot over 4 years ago

  • Assignee set to Evgeni Golov
  • Pull request https://github.com/Katello/katello/pull/8757 added
Actions
Copy link
 #7

Updated by The Foreman Bot over 4 years ago

  • Pull request https://github.com/Katello/katello/pull/8760 added
Actions
Copy link
 #8

Updated by Justin Sherrill over 4 years ago

  • Status changed from Closed to New

The commits were reverted, so i'm reopening this

Actions
Copy link
 #9

Updated by Chris Roberts over 4 years ago

  • Target version changed from Katello 4.0.0 to Katello 3.17.0
Actions
Copy link
 #10

Updated by Chris Roberts about 4 years ago

  • Target version changed from Katello 3.17.0 to Katello 3.18.0
Actions
Copy link
 #11

Updated by Jonathon Turel about 4 years ago

All PRs here are closed. Can I mark this as Closed?

Actions
Copy link
 #12

Updated by Jonathon Turel about 4 years ago

I looked closely and it seems this was actually reverted. Was it added back?

Actions
Copy link
 #13

Updated by Markus Bucher about 4 years ago

No, it has not been readded, yet, because we need a new implementation of the PostgreSQL-Extension first.

The existing one uses compiled C-code to utilize the debian-library for version-comparing.
This however prevents rails from applying the db-migration to activate the extension, because only the (db-)superuser is allowed to enable C-(/native-)extensions.

Therefore, we have to first implement a new version of the PostgreSQL-Extension in PLPGSQL-language as it was done with the evr-extension for RPMs.

Actions
Copy link
 #14

Updated by Jonathon Turel about 4 years ago

  • Category set to Repositories
  • Target version changed from Katello 3.18.0 to Katello 4.0.0

Thanks for the info Markus! I'm going to move this off to Katello 4.0 to maintain visibility on it.

Actions
Copy link
 #15

Updated by Justin Sherrill almost 4 years ago

  • Target version deleted (Katello 4.0.0)

moving this to the backlog

Actions
Copy link
 #16

Updated by Evgeni Golov almost 4 years ago

  • Assignee deleted (Evgeni Golov)

I really should not be assigned

Actions
Copy link

Also available in: Atom PDF