From: | Jun Yang <jyang825(at)gmail(dot)com> |
---|---|
To: | David Fetter <david(at)fetter(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Can I add a super table to existing tables? |
Date: | 2009-08-02 05:09:59 |
Message-ID: | b365d0610908012209l3a2392bcvcb56c341574bc867@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sat, Aug 1, 2009 at 9:42 PM, David Fetter <david(at)fetter(dot)org> wrote:
> On Sat, Aug 01, 2009 at 08:10:02PM -0700, Jun Yang wrote:
> > On Sat, Aug 1, 2009 at 7:53 PM, David Fetter <david(at)fetter(dot)org> wrote:
> > > On Sat, Aug 01, 2009 at 06:28:54PM -0700, Jun Yang wrote:
> > > > Hi all,
> > > >
> > > > I want to add some common columns to all of my tables.
> > >
> > > Your case may be very special, but offhand, this sounds like a
> > > very bad idea. What task is it you're trying to accomplish?
> >
> > Very simple. I have columns update_by and updated_at that I want
> > every table to have but don't want to add them one by one.
>
> This sounds like you're working your way up to some kind of logging
> system :)
>
> Check out the tablelog <http://pgfoundry.org/projects/tablelog/>
>
Very interesting. Thanks a lot for the pointer.
> Cheers,
> David.
Jun
>
> --
> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Alexy Khrabrov | 2009-08-02 05:42:13 | Re: building a binary-portable database |
Previous Message | Tom Lane | 2009-08-02 04:55:08 | Re: questions on (parallel) COPY and when to REINDEX |