insert into select from - Mailing list pgsql-bugs

From Jan Branbergen
Subject insert into select from
Date
Msg-id 9csqhn$165g$1@news.tht.net
Whole thread Raw
Responses Re: insert into select from  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name               : Jan Branbergen
Your email address      : jan@entrisphere.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

pgsql-bugs by date:

Previous
From: Vivek Khera
Date:
Subject: Re: freebsd sample startup script doesn't work
Next
From: Marcin Zukowski
Date:
Subject: RE: Found an example prooving bug