Re: Problem with insert - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Problem with insert
Date
Msg-id 28482.967046872@sss.pgh.pa.us
Whole thread Raw
In response to Re: Problem with insert  (Jerome Raupach <jraupach@intelcom.fr>)
List pgsql-hackers
Jerome Raupach <jraupach@intelcom.fr> writes:
>> So I think there must be some special feature of your tables that you
>> haven't shown us.  Could we see a schema dump (pg_dump -s) for these
>> tables?

> the error is produced if temp2 is a view.

I had suspected there might be a view involved.  But if you want this
fixed, you're going to need to be more forthcoming about providing a
complete, reproducible example.  I have other things to do than guess
what your view and table definitions are...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: New MAC OUI capabilities
Next
From: Tiago Antão
Date:
Subject: Re: Optimisation deficiency: currval('seq')-->seq scan, constant-->index scan