Re: foreign Key problem

> -----Original Message-----
> From: Stephan Szabo [mailto:sszabo@megazone23.bigpanda.com]
> Sent: 20 June 2002 23:14
> To: Dave Page
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] foreign Key problem
>
>
> On Thu, 20 Jun 2002, Dave Page wrote:
>
> > Any ideas gratefully received!
>
> Wierd. Is there any inheritance or other such in the schema
> (in which case you need to use ONLY on the selects to see if
> the rows exist)?  I'm not sure what else would make it miss
> the data, but if you can send a dump or example that
> illustrates, I can take a look at what it's doing.
>

The only inheritance in the DB is another table that inherits sys_users.
Actually, come to think of it most of the records in sys_users would
have come from there. I can't send a full dump as it's data that comes
under the UK Data Protection Act, but the table that inherits sys_users
looks like:

-- Table: hr_staff
CREATE TABLE hr_staff (
  hr_payroll_no varchar(8),
  hr_title varchar(128),
  hr_department varchar(128),
  hr_office varchar(128),
  hr_telephone varchar(16),
  hr_mobile varchar(16),
  hr_image varchar(128),
  hr_hol_basic int4,
  hr_hol_adjust int4,
  hr_hol_unit varchar(1) DEFAULT 'D'
) INHERITS(sys_users) WITH OIDS;

I'll see if I can get a test example to work (==fail) with non-sensitive
data as soon as England have beaten Brazil... :-)

Regards, Dave.