Re: [Q] DNS(bind) ER model - Mailing list pgsql-general

From Roderick A. Anderson
Subject Re: [Q] DNS(bind) ER model
Date
Msg-id 48A59654.5030304@acm.org
Whole thread Raw
In response to Re: [Q] DNS(bind) ER model  (Andrew Sullivan <ajs@commandprompt.com>)
Responses Re: [Q] DNS(bind) ER model  (Andrew Sullivan <ajs@commandprompt.com>)
List pgsql-general
Andrew Sullivan wrote:
> On Thu, Aug 14, 2008 at 04:20:14PM -0700, Roderick A. Anderson wrote:
>> Anyone aware of an ER model for holding name server records?
>
> What about a datatype?  I have reason to believe that a company I used
> to work for implemented such a thing.  There was some talk of
> releasing it, but I think there was some combination of insufficient
> demand, worries about competitive advantage, and concern about long
> term support.

Thanks A.  I did a quick look and a custom TYPE may be useful.
>
> Because of my involvement in that project, I can't make direct
> recommendations about this topic.  But supposing one was to go to
> various DNS-related lists, it seems to me it wouldn't be that hard to
> get information about the wire datatypes such that you'd have enough
> information to implement them in Postgres (assuming you know something
> about Postgres datatypes).

More research is on the schedule this week-end.

> One hint: remember the "unknown" RRTYPE.  If you have questions about
> RRTYPEs, I'm happy to answer.

Thanks again.  This is a pretty specialized application (at this time)
so the RRTYPEs used are limited.  I am trying to make the model and Pg
implementation as generic as possible in case it gets released into the
wild later.

Thanks for the offer on the RRTYPEs.  Zone files /can/ get pretty hairy
plus the company I'm doing this for gets some strange requests from
their customers -- not always correct or logical.  :-(


Rod
--


pgsql-general by date:

Previous
From: Scott Ribe
Date:
Subject: Re: Confronting the maximum column limitation
Next
From: "Roderick A. Anderson"
Date:
Subject: Re: [Q] DNS(bind) ER model