Mr Anderson-you use an enum to indicate your DNSrecordtype as in this MySQL exampleCREATE TABLE dns_updates| Field |Type | Null | Key | Default | Extra || id | int(11) | NO | PRI | NULL | auto_increment || bd_order_id | int(11) | YES | | NULL || domain | varchar(70) | NO | | || dns_entry_type | enum('MX','TXT') | YES | | NULL || dns_entry_value | varchar(255) | YES | | || created_timestamp | datetime | NO | MUL | 0000-00-00 00:00:00 |for Postgres sub in text[] columns dns_entry_type forthe specified enum datatype and insert in '{"MX", "TXT"}' for dns_entry_type valuesAnyone else?Martin > Date: Thu, 14 Aug 2008 16:20:14 -0700> From: raanders(at)acm(dot)org> To: pgsql-general(at)postgresql(dot)org> Subject: [GENERAL] [Q] DNS(bind) ER model> > Anyone aware of an ER model for holding name server records?> > Working on the zone file data and I am getting close but keep running > into the differences between MX records (with a priority) and the others > that can hold either a domain/sub-domain/host name or an IP address > depending on whether is an A, TXT, PTR, etc. or a CNAME.> > Much of the database will be populated and changed automagically so the > controller for the application will do the right thing but humans will > get involved every so often. I hope I can get the database to make the > right thing easy and the wrong thing "impossible" for them.> > Any suggestions?> > > Rod> -- > > -- > Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)> To make changes to your subscription:> http://www.postgresql.org/mailpref/pgsql-general
_________________________________________________________________
Get Windows Live and get whatever you need, wherever you are. Start here.
http://www.windowslive.com/default.html?ocid=TXT_TAGLM_WL_Home_082008