Skip site navigation (1) Skip section navigation (2)

Re: Triggers in Postgres

From: "Jasbinder Bali" <jsbali(at)gmail(dot)com>
To: "Tino Wildenhain" <tino(at)wildenhain(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Triggers in Postgres
Date: 2006-07-31 15:58:49
Message-ID: a47902760607310858j7e968f84ua9e0c5741b2ad7be@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
Actually Postgres manual of triggers says that in postgres, you can't write
a trigger in conventional sql. You have to write it in a procedural language
like C. So wanted some more insight on it.
~Jas


On 7/31/06, Tino Wildenhain <tino(at)wildenhain(dot)de> wrote:
>
> Jasbinder Bali wrote:
> > Hi,
> > Was wondering if one can write triggers with SQL statements as we have
> > in other RDBMS like SQL Server and oracle.
>
> What would such a trigger "in SQL statements" look like?
> SQL Server has Triggers in Transact-SQL, which is just something
> like a pl/language.
>
> > Can these be written in procedural languages only?
> > Please put some insight on what needs to be known before working with
> > triggers in postgres.
>
> You should probably try it when you read all manuals :-)
> pl/sql is very close to pure SQL, so if you manage to write
> your trigger with it - why not? :-)
>
> What should your trigger do btw?
>
> Regards
> Tino
>

In response to

Responses

pgsql-general by date

Next:From: Richard HuxtonDate: 2006-07-31 16:25:01
Subject: Re: Triggers in Postgres
Previous:From: Michelle KonzackDate: 2006-07-31 15:55:41
Subject: Re: Long term database archival

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group