Postgres Pro
Downloads
Home   >   mailing lists

Re: Backing up databases with large objects DOESN'T WORK? - Mailing list pgsql-general

From Tom Lane
Subject Re: Backing up databases with large objects DOESN'T WORK?
Date
Msg-id 20469.1013126897@sss.pgh.pa.us
Whole thread Raw
In response to Backing up databases with large objects DOESN'T WORK?  (Doug McNaught <doug@wireboard.com>)
List pgsql-general
Tree view 
Doug McNaught <doug@wireboard.com> writes:
> Do I also need an RI constraint?  That's relatively easy to do,
> especially if I'm doing the horrible sed thing.

I don't think an RI constraint would help a lot, since the LO operations
aren't going to check it (eg, lo_unlink won't fire an error).  In
general we don't support triggers placed on system catalogs...

            regards, tom lane

pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: Backing up databases with large objects DOESN'T WORK?
Next
From: Doug McNaught
Date:
Subject: Re: Backing up databases with large objects DOESN'T WORK?