Re: [Engine-devel] short research on postgresql enums
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(a)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.