Re: [PERFORM] Domain vs table

2009-10-25 Thread decibel
On Oct 20, 2009, at 6:55 AM, Merlin Moncure wrote: On Sun, Oct 11, 2009 at 11:31 AM, Michal Szymanski wrote: I think I've found answer to my question http://www.commandprompt.com/blogs/joshua_drake/2009/01/ fk_check_enum_or_domain_that_is_the_question/ I mostly agree with the comments on

Re: [PERFORM] Domain vs table

2009-10-20 Thread Merlin Moncure
On Sun, Oct 11, 2009 at 11:31 AM, Michal Szymanski wrote: > I think I've found answer to my question > http://www.commandprompt.com/blogs/joshua_drake/2009/01/fk_check_enum_or_domain_that_is_the_question/ > I mostly agree with the comments on the blog but let me throw a couple more points out the

Re: [PERFORM] Domain vs table

2009-10-17 Thread Michal Szymanski
I think I've found answer to my question http://www.commandprompt.com/blogs/joshua_drake/2009/01/fk_check_enum_or_domain_that_is_the_question/ Michal Szymanski -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresq

[PERFORM] Domain vs table

2009-10-17 Thread Michal Szymanski
Hi, We have table 'user' and one column define status of user, currently there are 2 valuse 'A' acitve and 'D' deleted. Currently we define column as domain type ( status_domain with two possible values) but I'm not sure is it good solution, maybe it is better create separate table e.g account_sta