Bug 1470985

Summary:	[RFE] Use JSON instead of TEXT types
Product:	[oVirt] ovirt-engine	Reporter:	Martin Perina <mperina>
Component:	Database.Core	Assignee:	Eli Mesika <emesika>
Status:	CLOSED DEFERRED	QA Contact:	Lucie Leistnerova <lleistne>
Severity:	low	Docs Contact:
Priority:	unspecified
Version:	---	CC:	bugs, lsvaty
Target Milestone:	---	Keywords:	FutureFeature
Target Release:	---	Flags:	mperina: ovirt-4.2? lsvaty: testing_plan_complete- mperina: planning_ack? mperina: devel_ack+ lsvaty: testing_ack+
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Enhancement
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2017-09-05 11:49:14 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	Infra	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:	1459134
Bug Blocks:	1106547

Description Martin Perina 2017-07-14 08:28:21 UTC

Description of problem:

Add support for JSON types [1] instead of the current TEXT type to prevent inserting non JSON values by mistake.

[1] https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.3#JSON:_Additional_functionality

Version-Release number of selected component (if applicable):


How reproducible:


Steps to Reproduce:
1.
2.
3.

Actual results:


Expected results:


Additional info:

Comment 1 Martin Perina 2017-09-05 11:49:14 UTC

It doesn't bring any important benefits at the moment, so closing for now