| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Vick Khera <vivek(at)khera(dot)org> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org>, Borek Lupomesky <borek(at)lupomesky(dot)cz> |
| Subject: | Re: Permission denied when inserting |
| Date: | 2011-02-28 16:02:53 |
| Message-ID: | 7872.1298908973@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Vick Khera <vivek(at)khera(dot)org> writes:
> On Mon, Feb 28, 2011 at 9:37 AM, Borek Lupomesky <borek(at)lupomesky(dot)cz> wrote:
>> "permout_site_fkey" FOREIGN KEY (site, cp) REFERENCES out2cp(site, cp) ON
>> DELETE CASCADE
> you don't have permissions to verify the FK constraint. the query you
> see in the error is exactly this test.
Right. But actually, that query will be run with the permissions of the
owner of the table, so it's that user (not necessarily the one doing the
INSERT) who lacks permissions.
It sounds like the dump-and-restore process was pretty incomplete.
How was it done exactly? Not with pg_dumpall, I'm guessing.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniele Varrazzo | 2011-02-28 16:03:12 | Re: Binary params in libpq |
| Previous Message | Tom Lane | 2011-02-28 15:58:06 | Re: Issues with imported blobs from Postgres 8 to 9 |