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

From Doug McNaught
Subject Re: Backing up databases with large objects DOESN'T WORK?
Date
Msg-id m3lme44y3r.fsf@varsoon.denali.to
Whole thread Raw
In response to Backing up databases with large objects DOESN'T WORK?  (Doug McNaught <doug@wireboard.com>)
List pgsql-general
Tom Lane <tgl@sss.pgh.pa.us> writes:

> 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...

OK.  I will tangle with the schema definition tomorrow and see if I
can get it to work.

Thanks again...

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863

pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: Backing up databases with large objects DOESN'T WORK?
Next
From: pilsl@goldfisch.at
Date:
Subject: libnss-psql : troubles with groups