Backlog #332

PostgreSQL support

Added by Petri Lammi almost 11 years ago. Updated over 6 years ago.

Status:ClosedStart date:08/30/2010
Priority:NoneDue date:
Assignee:-% Done:

0%

Category:Core & System
Target version:-

Description

A sophisticated, truly dependable DBMS. Please support it for crash-free DB operations.

PostgreSQL home

pgsql.patch Magnifier (41.5 KB) Jeroen Nijhof, 10/14/2010 11:50 AM

History

#1 Updated by Tino Vázquez almost 11 years ago

  • Subject changed from Postgesql support to PostgreSQL support

#2 Updated by Jeroen Nijhof over 10 years ago

I finally wrote the PostgreSQL driver for ONE, see the attached patch.
Fixed a number of SQL statements so it will work with every database and not only SQLite and MySQL.

REMARKS:
  • To compile with pgsql support use: scons pgsql=yes
  • "CREATE TABLE IF NOT EXIST" is not SQL compliant and therefor I fixed the code to be more generic.
    It will first check if a table exist by doing a normal query and if it doesn't exist it will create the table...
  • "REPLACE" is not SQL compliant and therefor I changed it to "UPDATE" just to be more generic.

#3 Updated by Javi Fontan over 10 years ago

Thanks! Its an amazing job. We are discussing the best way to incorporate this patch. It cannot go into 2.0 release as we are in feature freeze but we are looking on a way that it can be accessible and that we can work on it in parallel.

#4 Updated by Anonymous almost 10 years ago

Does this patch need to be updated to work with the upcoming OpenNebula 3.0 version, and if so, will this require someone to step in and contribute an updated patch?

#5 Updated by Carlos Martín almost 10 years ago

Hi Hutson,

The path indeed needs to be updated. We should consider its addition after the 3.0 release.

#6 Updated by Anonymous almost 10 years ago

Can we have it targeted for 3.2 (Assuming that will be the next release), and I'll work on it assuming no one wishes to.

#7 Updated by Ruben S. Montero about 8 years ago

  • Priority changed from Normal to Low

#8 Updated by Ruben S. Montero about 8 years ago

  • Tracker changed from Request to Backlog

#9 Updated by Ruben S. Montero about 8 years ago

  • Status changed from New to Pending

#10 Updated by Ruben S. Montero over 7 years ago

  • Priority changed from Low to None

#11 Updated by Ruben S. Montero over 7 years ago

  • Assignee deleted (Ruben S. Montero)

#12 Updated by Ruben S. Montero over 6 years ago

  • Status changed from Pending to Closed

Also available in: Atom PDF