Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] dump/reload

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: brett(at)work(dot)chicken(dot)org (Brett McCormick)
Cc: pgsql-hackers(at)hub(dot)org
Subject: Re: [HACKERS] dump/reload
Date: 1998-06-03 04:09:07
Message-ID: (view raw or whole thread)
Lists: pgsql-hackers
> On Tue, 2 June 1998, at 22:19:01, Bruce Momjian wrote:
> > > they don't always work, in the case of a table with an attribute that
> > > calls a function for its default value.
> > This is a good point, and something worth thinking about.  Maybe we
> > could scan through the defaults for a table, and call the dumpfunction
> > command for any functions.  Then when they are later attempted to be
> > created, they would fail, or we could somehow mark them as already
> > dumped.
> Would we look at the binary plan (aiee!) or just try and parse the
> string value 'pg_attdef.adsrc` for a function call?

I see pg_attrdef.adsrc now.  Wow, that looks tough.  Could we grab any
identifier before an open paren?

There has to be an easy fix for this.  Can't think of it though.

Bruce Momjian                          |  830 Blythe Avenue
maillist(at)candle(dot)pha(dot)pa(dot)us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 1998-06-03 04:11:01
Subject: Re: [HACKERS] keeping track of connections
Previous:From: Bruce MomjianDate: 1998-06-03 04:05:48
Subject: Re: [HACKERS] dump/reload

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group