| From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: How to define automatic filter condition? |
| Date: | 2008-11-12 10:47:53 |
| Message-ID: | 20081112104753.GD13765@a-kretschmer.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
am Wed, dem 12.11.2008, um 11:10:41 +0100 mailte Csaba Együd folgendes:
> Andreas,
> thank you for your reply. Yes, I know that there is such a mathod but I
> read somewhere that it is just a limited way. BTW, I am going to dig into
> this more deeper.
>
> A possible solution has come into my minde: does it have any risk to use a
> read only view for selects but inserts and updates are performed on the
> base table? I mean that I would select data from the view and show that
> automatically filtered row set to the user but when she/he inserts or
> updates a row the generated query would operate on the real (base) table.
Sure, no problem.
Please avoid top-posting.
Regards, Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Csaba Együd | 2008-11-12 10:52:36 | Re: How to define automatic filter condition? |
| Previous Message | Csaba Együd | 2008-11-12 10:10:41 | Re: How to define automatic filter condition? |