[GENERAL] View Triggers

2007-06-26 Thread Richard Broersma Jr
It seems that insertion triggers on views will/may be added in version 8.3. http://archives.postgresql.org/pgsql-general/2007-02/msg01466.php However, Tom mentioned that adding update and deletion triggers may be a bad idea: http://archives.postgresql.org/pgsql-general/2007-02/msg01466.php ... Ho

Re: [GENERAL] view triggers/procedures

2004-08-23 Thread Csaba Nagy
a, > Thank you for your reply. How do I check the sources. Can you please tell me > in detail. > regds > -raju > > > -Original Message- > From: Csaba Nagy [mailto:[EMAIL PROTECTED] > Sent: Monday, August 23, 2004 4:11 PM > To: SVGK, Raju (Raju) > Cc: '[E

Re: [GENERAL] view triggers/procedures

2004-08-23 Thread SVGK, Raju (Raju)
Csaba, Thank you for your reply. How do I check the sources. Can you please tell me in detail. regds -raju -Original Message- From: Csaba Nagy [mailto:[EMAIL PROTECTED] Sent: Monday, August 23, 2004 4:11 PM To: SVGK, Raju (Raju) Cc: '[EMAIL PROTECTED]' Subject: Re: [GEN

Re: [GENERAL] view triggers/procedures

2004-08-23 Thread Csaba Nagy
Raju, these triggers are the PG implementation of foreign key constraints checking. They are written in C, so if you're curios how they work you will have to check the postgres sources ;-) HTH, Csaba. On Mon, 2004-08-23 at 12:06, SVGK, Raju (Raju) wrote: > Hi, > > I have a table where in lot

[GENERAL] view triggers/procedures

2004-08-23 Thread SVGK, Raju (Raju)
Hi, I have a table where in lot of triggers were included in that as shown below. How to view/access triggers and procedures from postgresql. I am using postgresql 7.4.1 on solaris. regds -raju Process=# \d reviews Table "public.reviews" Column