Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Will a DELETE violate an FK?



am  Tue, dem 29.05.2007, um 10:48:21 -0400 mailte Robert James folgendes:
> I'd like to be able to detect if a record has associations. I don't want to
> actually delete it, just know if it could be deleted. (This is to build an
> intelligent menu on a GUI)

Set a savepoint, try to delete the record, catch an error if an error
occurs and rolled back.


> 
> On 5/29/07, Albe Laurenz <all(at)adv(dot)magwien(dot)gv(dot)at> wrote:

And please, no top-posting.


Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group