Mr Anderson-
you use an enum to indicate your DNSrecordtype as in this MySQL example
CREATE 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 values
Anyone else?
Martin
> Date: Thu, 14 Aug 2008 16:20:14 -0700
> From: raanders@acm.org
> 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.