Re: [BUGS] BUG #5555: ALTER TABLE ONLY ... SET NOT NULL on parent prevent prior inherited tables from being restored

2010-07-15 Thread Bernd Helmle
--On 12. Juli 2010 14:39:19 -0400 Tom Lane wrote: Yeah. Past discussions of this have leaned to the viewpoint that we should disallow the above, ie it should not be possible to have NOT NULL on the parent unless all the children have it too. Nobody's got round to implementing it though. Th

Re: [BUGS] BUG #5559: Full SSL verification fails when hostaddr provided

2010-07-15 Thread Stephen Frost
* Tom Lane (t...@sss.pgh.pa.us) wrote: > Stephen Frost writes: > > Perhaps I was being a bit overzealous in my last response, sorry about > > that. If the point here is that people who are using hostaddr are in an > > environment where DNS is non-functional or actively broken, then yes, > > just

Re: [BUGS] BUG #5559: Full SSL verification fails when hostaddr provided

2010-07-15 Thread Tom Lane
Stephen Frost writes: > Reviewing what's currently on developer.postgresql.org, here's what I > think the docs would read and what the associated code behavior should > be (which I think it's pretty close to already, but perhaps not > entirely..): I think this is overcomplicated and probably wron

Re: [BUGS] BUG #5559: Full SSL verification fails when hostaddr provided

2010-07-15 Thread Stephen Frost
* Tom Lane (t...@sss.pgh.pa.us) wrote: > I suggest that we document hostaddr as being an auxiliary field that is > not intended to be the primary source of the host name, but merely saves > libpq from having to do a forward DNS lookup. In some cases it will > work to supply hostaddr without host,

Re: [BUGS] BUG #5559: Full SSL verification fails when hostaddr provided

2010-07-15 Thread Tom Lane
Stephen Frost writes: > * Tom Lane (t...@sss.pgh.pa.us) wrote: >> I suggest that we document hostaddr as being an auxiliary field that is >> not intended to be the primary source of the host name, but merely saves >> libpq from having to do a forward DNS lookup. In some cases it will >> work to s