| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Gonzalo Aguilar Delgado <gaguilar(at)aguilardelgado(dot)com> |
| Cc: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Problem with insert related to different schemas |
| Date: | 2010-04-20 17:01:25 |
| Message-ID: | 15360.1271782885@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Gonzalo Aguilar Delgado <gaguilar(at)aguilardelgado(dot)com> writes:
>> This is a select query. I don't think that's the right error message.
> Yes, but IS the correct error message.
The query being complained of appears to be a generated foreign key
checking query. It's not surprising it would appear in the context
of an insert.
> It appeared just after upgrading
> to 8.4 as 8.3 had no problem processing this query.
You've either changed the permissions on schema public from what they
were in the old installation, or linked an FK constraint to the wrong
table. I see no reason to think there is either a bug or a version
difference here.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gonzalo Aguilar Delgado | 2010-04-20 17:01:54 | Re: Problem with insert related to different schemas |
| Previous Message | Tim Landscheidt | 2010-04-20 16:47:06 | Re: How to max() make null as biggest value? |