Serial versus Serial - What they don't tell you about referential integrity

From: "Albin, Lloyd P" <lalbin(at)scharp(dot)org>
To: <seapug(at)postgresql(dot)org>
Subject: Serial versus Serial - What they don't tell you about referential integrity
Date: 2012-11-05 08:24:30
Message-ID: D780EAC3ADA31F488BCA74ECCD5B717E01BF54F1@ISIS.fhcrc.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: seapug

To All:

I ran across another interesting Postgres issue dealing with Serials and found that not all Serials are equal.

To find out if you are affect by this issue and need to attend this talk just run this query on all your databases. If the result is greater than 0, this is a must attend talk is for you.

SELECT count(*) FROM pg_catalog.pg_attrdef
WHERE adnum = 1
AND adsrc LIKE '%::text)::regclass)';

Lloyd

Browse seapug by date

  From Date Subject
Next Message Albin, Lloyd P 2012-11-05 08:32:30 Next Meeting
Previous Message Robert Bernier 2012-10-31 19:23:30 Re: Site down