Re: Re: [PATCHES] pg_dump primary keys

Started by Bruce Momjianalmost 26 years ago1 messageshackers
Jump to latest
#1Bruce Momjian
bruce@momjian.us

Added to TODO list.

Peter Eisentraut wrote:

What though if a function accesses a table? Which one goes first? Do we
have to maintain a network of dependencies in pg_dump? Eventually we'll
probably have to, with all the foreign key stuff coming up. Gloomy
prospects.

Couldn't we solve this by the simple expedient of dumping all the
objects in the database in OID order?

Expecting pg_dump to parse function bodies to discover what
relations/types are mentioned doesn't look appetizing at all...

regards, tom lane

************

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026