From: | "Jan Branbergen" <jan(at)entrisphere(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | insert into select from |
Date: | 2001-05-03 23:46:03 |
Message-ID: | 9csqhn$165g$1@news.tht.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Jan Branbergen
Your email address : jan(at)entrisphere(dot)com
System Configuration
---------------------
Architecture (example: Intel Pentium) : Intel PII
Operating System (example: Linux 2.0.26 ELF) : NetBSD
PostgreSQL version (example: PostgreSQL-7.0): PostgreSQL-7.0.3
Compiler used (example: gcc 2.8.0) :
Please enter a FULL description of your problem:
------------------------------------------------
When i do a "NSERT INTO screen_filter_field( screen_filter_id,
screen_field_id, seqno, visible, orderno ) SELECT 182, id, seqno, visible,
orderno FROM screen_field WHERE screen_id = 1" i get a permission denied on
table screen_field; i have select, insert, update & delete access to table
screen_filter_field, and select access to table b. when i add update access
to table b, the statement executes fine.
Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
no idea
From | Date | Subject | |
---|---|---|---|
Next Message | pgsql-bugs | 2001-05-04 03:39:14 | error in make the example |
Previous Message | Tom Lane | 2001-05-03 22:21:50 | Re: Error in Makefile.tcldefs |