| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Harry Hehl" <Harry(dot)Hehl(at)diskstream(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_dump output containing CREATE TYPE does not restore with psql |
| Date: | 2006-09-20 17:52:14 |
| Message-ID: | 11789.1158774734@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I wrote:
> "Harry Hehl" <Harry(dot)Hehl(at)diskstream(dot)com> writes:
>> The restore fails with:
>> psql:x:384: ERROR: foreign key constraint "accepttaskevent" cannot be
>> implemented
>> DETAIL: Key columns "accepttaskevent" and "objectid" are of
>> incompatible types: public.ds_uuid and public.ds_uuid.
> This seems to be a variant of the problem discussed here:
> http://archives.postgresql.org/pgsql-hackers/2006-02/msg00284.php
Actually, it's exactly the problem discussed in this thread:
http://archives.postgresql.org/pgsql-hackers/2006-02/msg00960.php
We had more or less arrived at a consensus about what to do about it,
but nothing ever actually got done, and I fear it's too late now for
8.2 :-(
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Fetter | 2006-09-20 18:00:14 | Re: postgresql rising |
| Previous Message | Tom Lane | 2006-09-20 17:42:59 | Re: 8.2: select from an INSERT returning? |