On Thu, Feb 26, 2009 at 12:25:08AM +0100, damien clochard wrote:
> Last week, i took some time to check if i was still able to write
> some basic C code. So i looked into the TODO list and picked some
> trivial items.
> This one is very basic, it just shows the child tables of a specific
> table when you type \d <tablename> in psql :
> # create table mother(id SERIAL);
> # create table daughter() inherits(mother);
> # create table daughter2() inherits(mother);
> # create schema plop;
> # create table plop.daughter3() inherits(mother);
> # \d mother
> Table "public.mother"
> Column | Type | Modifiers
> id | integer | not null default nextval('mother_id_seq'::regclass)
> Child tables: daughter,
> I understand that it may not be the best moment to submit such a
> trivial patch, as most of you are working hard on more important
> topics. If you think i should submit it later, just let me know.
> BTW, this is the first patch i submit so any comment is more than
Should the patch (and the feature) use WITH RECURSIVE in order to get
the entire tree?
David (yes, I know it's predictable from me, but WITH RECURSIVE really
is a neat new toy ;)
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2009-02-26 00:30:30|
|Subject: Re: Have \d show child tables that inherit from the specified parent |
|Previous:||From: Joshua D. Drake||Date: 2009-02-25 23:26:03|
|Subject: Re: effective_cache_size less than shared_buffers|