[Engine-devel] short research on postgresql enums

[Maor]

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.

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.