Re: Followup to my bug report

Hmmm, I thought I had tested for that. It seemed to me that functions were evaluated
at run-time, so any reference in a function to a table would not be noticed until
that function was actually called (this is for PL/pgsql where I know that even stupid
syntax errors are not caught until run-time). The SQL parser, however, does check
that the function exists before one can create the table...

Thank you for following up on this.
Mark

Bruce Momjian wrote:

> We did discuss this. It seems there is circular dependency about
> dumping functions and tables, where some rely on the other. We
> discussed this, and the only fix we can think of is to dump the entries
> in creation order, using the oid as a guide.
>
> Not sure when we can implement this.
>
> > Hi Bruce,
> >
> > Sorry to bother you personally, but as you are keeper of the "To Do" list, I
> > thought I would check with you directly rather than clutter up the Postgresql
> > mail lists.
> >
> > Some time ago I submitted a bug report about PostgreSQL pg_dump. I would forward
> > you a copy of my e-mail if I could find one.
> >
> > The essence of the report was that the order of the dumped items from pg_dump
> > made a direct reload (without hand editing the dump) impossible.
> >
> > The case I stumbled on was something like:
> >
> >
> > > CREATE Function MyTimeStamp (what ever);
> > >
> > > CREATE TABLE MyTable (
> > > key int PRIMARY KEY,
> > > add_date timestamp DEFAULT MyTimeStamp()
> > > );
> > >
> > The problem is that pg_dump dumps the Functions after the Tables, so when
> > re-loading, the above table definition fails (it doesn't know about the function
> > MyTimeStamp() at the time of creation).
> >
> > There were no comments about my report at the time I made it, so I was concerned
> > that the HACKERs may have missed it. With a major release "just now coming", I
> > thought I should re-port the report.
> >
> > Hope this helps,
> > Mark
> >
> > --
> > Mark Dalphin email: mdalphin(at)amgen(dot)com
> > Mail Stop: 29-2-A phone: +1-805-447-4951 (work)
> > One Amgen Center Drive +1-805-375-0680 (home)
> > Thousand Oaks, CA 91320 fax: +1-805-499-9955 (work)
> >
> >
> >
> >
>
> --
> Bruce Momjian | http://www.op.net/~candle
> maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania 19026

--
Mark Dalphin email: mdalphin(at)amgen(dot)com
Mail Stop: 29-2-A phone: +1-805-447-4951 (work)
One Amgen Center Drive +1-805-375-0680 (home)
Thousand Oaks, CA 91320 fax: +1-805-499-9955 (work)