"John Hansen" <john(at)geeknet(dot)com(dot)au> writes:
> create table foo ( id serial primary key, path text);
> alter table foo add ref foo;
> Is this a bug or a random feature?
I'd say it's a random misfeature ;-). I certainly don't care to promise
that it's supported ... but on the other hand, preventing you from doing
it seems nontrivial (consider indirect recursions). I'd put this in the
category of "doctor, it hurts when I do that".
regards, tom lane