Re: [HACKERS] Re: [PATCHES] pg_dump primary keys - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] Re: [PATCHES] pg_dump primary keys
Date
Msg-id 23913.944935124@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] Re: [PATCHES] pg_dump primary keys  (wieck@debis.com (Jan Wieck))
Responses Re: [HACKERS] Re: [PATCHES] pg_dump primary keys
Re: Re: [PATCHES] pg_dump primary keys
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Gunther Schadow
Date:
Subject: UNICODE characters vs. BINARY
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] LONG