Re: Foreign key wierdness

From: Didier Moens <moensd(at)xs4all(dot)be>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: Didier Moens <Didier(dot)Moens(at)dmb001(dot)rug(dot)ac(dot)be>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Foreign key wierdness
Date: 2003-01-22 22:31:45
Message-ID: 3E2F1BD1.5080501@xs4all.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Dave Page wrote:

>>From what Tom has said in his reponse, I think the answer for you Didier
>is to remap your integer columns to int8 instead of int4 and see what
>happens. When I get a couple of minutes I will look at putting a Serials
>as... Option in the type map.
>

Thanks Dave, for all of your invested time.

I think the value of tools such as pgAdmin, which provide an almost
bumpless cross-platform migration path, cannot be underestimated.

Regards,
Didier

--

Didier Moens
-----
RUG/VIB - Dept. Molecular Biomedical Research - Core IT
http://www.dmb.rug.ac.be

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-01-22 23:01:53 Proposal: relaxing link between explicit JOINs and execution order
Previous Message Didier Moens 2003-01-22 22:27:35 Re: Foreign key wierdness