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: [EMAIL PROTECTED]> To:
pgsql-general@postgresql.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@postgresql.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
