Search Postgresql Archives

Re: deleting a foreign key that has no references

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "Glen W. Mabey" <Glen.Mabey@xxxxxxxx>
Subject: Re: deleting a foreign key that has no references
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Mon, 19 Mar 2007 12:53:08 -0400
Cc: hubert depesz lubaczewski <depesz@xxxxxxxxx>, postgresql-general <pgsql-general@xxxxxxxxxxxxxx>
Comments: In-reply-to "Glen W. Mabey" <Glen.Mabey@xxxxxxxx> message dated "Mon, 19 Mar 2007 11:12:35 -0500"
In-reply-to: <20070319161235.GA21566@xxxxxxxxxxxxxxxxx>
References: <20070319141724.GB12597@xxxxxxxxxxxxxxxxx> <9e4684ce0703190851g17438842s31a2a7c154cc27e0@xxxxxxxxxxxxxx> <20070319161235.GA21566@xxxxxxxxxxxxxxxxx>

"Glen W. Mabey" <Glen.Mabey@xxxxxxxx> writes:
> What I'm hoping to find out is whether there is some way to directly
> find out how many (using a SELECT query) references there are to a key.

There's no hidden shortcut for that, no.

			regards, tom lane

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Insert fail: could not open relation with OID 3221204992
  - From: araza

References:
- deleting a foreign key that has no references
  - From: Glen W. Mabey
- Re: deleting a foreign key that has no references
  - From: hubert depesz lubaczewski
- Re: deleting a foreign key that has no references
  - From: Glen W. Mabey

Prev by Date: Re: deleting a foreign key that has no references
Next by Date: DBD:Pg for Windows (PostgreSQL+Perl)
Previous by thread: Re: deleting a foreign key that has no references
Next by thread: Insert fail: could not open relation with OID 3221204992
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux