PostgreSQL 7.4.2 on i386-redhat-linux-gnu, compiled by GCC 2.96
I have a simple VIEW such as the
following:
CREATE OR REPLACE VIEW vu_tbl_useracc AS
SELECT ua.id_user, ua.id_cmpy, ua.id_contrib, ua.dt_edited,
ua.id_editedby FROM tbl_useracc ua;
GRANT SELECT, INSERT ON TABLE vu_tbl_usera
"Donald Fraser" <[EMAIL PROTECTED]> writes:
> Now whenever I attempt to INSERT into the view I get the following error.
> ERROR: permission denied for relation vu_tbl_useracc
I tried to reproduce this and couldn't.
> I didn't have this problem on version 7.3.4 which is what I have upgraded f=
> r
This is a correction to the previously posted bug - please ignor the
previous posted bug as this is the corrected version:
PostgreSQL 7.4.2 on i386-redhat-linux-gnu, compiled by GCC 2.96
I have a simple VIEW such as the
following:
CREATE OR REPLACE VIEW vu_tbl_useracc AS
SELECT ua.id
This is a correction to the previously posted bug - please ignore the
previous posted bug as this is the corrected version:
PostgreSQL 7.4.2 on i386-redhat-linux-gnu, compiled by GCC 2.96
I have a simple VIEW such as the
following:
CREATE OR REPLACE VIEW vu_tbl_useracc AS
SELECT ua.
"Donald Fraser" <[EMAIL PROTECTED]> writes:
> CREATE OR REPLACE RULE rul_i01 AS
> ON INSERT TO vu_tbl_useracc
>WHERE new.id_contrib = 1 DO SELECT raise_exception('Cannot insert Companies to
> access for CISX Users'::text) AS error;
> ERROR: permission denied for relation vu_tbl_useracc
A
Back in January, I posted a note (subject of "7.3.5 initdb failure on Irix
6.5.18") stating that I'd found a bug in the Irix MIPSpro 7.4.1 C
compiler that caused postgresql to fail reading in transaction logs,
which showed up while trying to run the regression tests.
I can now report that postgres
