[Engine-devel] short research on postgresql enums

[Itamar Heim]

On 12/11/2011 05:54 PM, Maor wrote:
> On 12/09/2011 10:43 PM, Laszlo Hornyak wrote:
>> Hi,
>>
>> I looked into Mike's database patch ( http://gerrit.ovirt.org/#change,500 ) today and read Yaniv's comment on it. I have seen another patches related to enums and how they are stored in the database. I made a quick test to compare between varchar and enum and the results are here: http://dummywarhead.blogspot.com/2011/12/postgresql-enums-vs-varchar.html
>>
>> IMO enums could be a good solution, but changing enums could be a pain under postgres 9.1. So what if we could use varchar now and migrate to enum once postgres 9.1 replaces the older installations :)
>>
>> Laszlo
>> _______________________________________________
>> Engine-devel mailing list
>> Engine-devel at ovirt.org
>> http://lists.ovirt.org/mailman/listinfo/engine-devel
> +1 liked the article.
> I wonder, how common are database enums among different DB providers,
> for supporting DB migration in the future if needed.

that's a very good point, considering we are still on the path of moving 
to hibernate.

>
> I also searched a little bit on the subject and found the following
> article:
>    http://www.designmagick.com/article/29/PostgreSQL-Enum-Types
> Postgres 8.4.7 supports the CHECK function, which validate specific
> values. (not sure how is the performance).
> but maybe we can use it, if we choose to adapt the enum idea later.
>
>
> _______________________________________________
> Engine-devel mailing list
> Engine-devel at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/engine-devel