[Pkg-postgresql-private] Fwd: postgresql - another problem

[Martin Pitt]

--aM3YZ0Iwxop3KEKx
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Hi!

I have got the mail below some days ago, but just noticed that only I
got it.=20

Can anybody say something sensible to this?

Thanks,

Martin

----- Forwarded message from Jan Gregor <gregor_jan@seznam.cz> -----

Date: Wed, 21 Jan 2004 21:49:28 +0100
To: mpitt@debian.org
Subject: postgresql - another problem
=46rom: Jan Gregor <gregor_jan@seznam.cz>
X-Spam-Status: No, hits=3D0.1 required=3D4.0 tests=3DBAYES_44,RCVD_IN_SORBS=
=20
	autolearn=3Dno version=3D2.61

Hello

 I created this rule :

 CREATE RULE studenti_upd AS ON UPDATE TO studenti where
 NEW.pojistovna!=3DOLD.pojistovna do (insert INTO studenti_log VALUES (
 current_user, current_timestamp, NEW.pojistovna); update studenti_data
 SET pojistovna=3DNEW.pojistovna where id=3DOLD.id);

 It works, but postgresql 7.2.1-2woody4 forces me to grant insert on
 view studenti, without it this message is displayed:
              ERROR:  permission denied for relation studenti=20

 On version 7.4.1, postgresql needs select and update privileges to
 view studenti just as it needs to table on both versions of postgresql
 (7.2.1 and 7.4.1).

 Is it a bug or 7.2.1 feature ?

Jan Gregor

----- End forwarded message -----

--=20
Martin Pitt                 Debian GNU/Linux Developer
martin@piware.de                      mpitt@debian.org
http://www.piware.de             http://www.debian.org

--aM3YZ0Iwxop3KEKx
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFAICCiDecnbV4Fd/IRAkhVAJ9v+tX4nWt22Sy1HNqdVuzxU9y7FACgmEC2
a8YW347nq2B6XaXEJkd3+dk=
=2cnI
-----END PGP SIGNATURE-----

--aM3YZ0Iwxop3KEKx--