On Mon, 02 Jan 2006 14:26:14 +0100
Mario Splivalo <[EMAIL PROTECTED]> threw this fish to the penguins:
> While browsing the web I've seen that many people 'need' the ability to
> create uuid/guid values from within the PostgreSQL. Most of them are
> switching from MSSQL, and they're missing the ne
Thanks to everyone for the responses ... ended up doing a trigger on the
comments table that updates another table to maintain a "pointer" to the
active record ... sped up the query that was hampering us from ~26 000ms
to 47ms ... the killer part of the query was that each time it was havin
g
On Thursday 05 January 2006 04:58, [EMAIL PROTECTED] wrote:
>That's not what foreign keys do. The only thing a foreign key
> provides is a guarantee that if any records in B (the referencing
> table) still reference a record in table A (the referenced table)
> then you cannot delete that reference
Scott, Casey wrote:
I have 2 tables. One containing information about servers, and the other
containing information about IP addresses.
E.G.
Server table:
namemac
mac2
-
SERVER1 00:0d:56:ba:ad:92
SE
