Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id D90542E015D
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 12 Mar 2008 01:07:56 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 92597-04 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 12 Mar 2008 01:07:52 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from an-out-0708.google.com (an-out-0708.google.com
 [209.85.132.246])
	by postgresql.org (Postfix) with ESMTP id 036DB2E015B
	for <pgsql-performance@postgresql.org>;
	Wed, 12 Mar 2008 01:07:52 -0300 (ADT)
Received: by an-out-0708.google.com with SMTP id c36so654355ana.33
	for <pgsql-performance@postgresql.org>;
	Tue, 11 Mar 2008 21:07:52 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	bh=brwkrfs4zLo51hZFB17G7262F7vhgo+n+GqO8w987UI=;
	b=FFsJ0vri/7nHXIxz+b6931RKXZLo7rrKZpJnVvLysCTJSfeBSuvJR1HetWT3+VijyKPT6QRuf16Eobqc9oxe555MrF96RoQumdWbj+r9bvKhqUaOHDhI5uqZ5lzi+kcyx6bdu3EhKs/Seq6w5FNJYkJ7BMm7PRyYN6x9qnEkh9k=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=Jf+Br2GvIzp9+jNuFgzaK/jAaVSG2pTCOC3pidF/SUaHOomh5sWp7/xI3hNP4zgrkJpyc48TtFmHUNp+ezOQm97qOz4zE7pOcOg3deTdoalSd5O+LOxMFiVxNspXtuzdWU+VZnkChyockTrzhomyIdCq5fKoH+NYytPiP6Kcgc4=
Received: by 10.100.255.10 with SMTP id c10mr15081163ani.3.1205294872155;
	Tue, 11 Mar 2008 21:07:52 -0700 (PDT)
Received: by 10.100.105.20 with HTTP; Tue, 11 Mar 2008 21:07:52 -0700 (PDT)
Message-ID: <f966c2ee0803112107i30a3249ah1e10b89cb678a32b@mail.gmail.com>
Date: Wed, 12 Mar 2008 09:37:52 +0530
From: "sathiya psql" <sathiya.psql@gmail.com>
To: "Sergey Benner" <sergey.benner@gmail.com>
Subject: Re: list user created triggers
Cc: pgsql-performance@postgresql.org
In-Reply-To: <281d31b40803110733o496e4c51ic8f2c36d0eded2af@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_5371_12799015.1205294872139"
References: <281d31b40803110715u567ce1f6t91d12a3546dce980@mail.gmail.com>
	<281d31b40803110733o496e4c51ic8f2c36d0eded2af@mail.gmail.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200803/237
X-Sequence-Number: 29191

------=_Part_5371_12799015.1205294872139
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

thanks...
after this query also it is showing default triggers ( am very much worried
that how the system triggers are created using my username ....

ok i posted this in the group you specified..

On Tue, Mar 11, 2008 at 8:03 PM, Sergey Benner <sergey.benner@gmail.com>
wrote:

> Again :) Try this query.
>
>
>
> select usename,relname, tgname, tgtype, proname, prosrc, tgisconstraint,
> tgconstrname, tgconstrrelid, tgdeferrable, tginitdeferred, tgnargs,
> tgattr, tgargs from (pg_trigger join pg_class c on tgrelid=c.oid )
> join pg_proc on (tgfoid=pg_proc.oid) join pg_user pu on
> c.relowner=pu.usesysid where pu.usename='YOURUSERNAME';
>
>
>
> Please post such questions to the pgsql-sql@postgresql.org list.
>
> Cheers,
> Sergey
>
>

------=_Part_5371_12799015.1205294872139
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

thanks...<br>after this query also it is showing default triggers ( am very much worried that how the system triggers are created using my username ....<br><br>ok i posted this in the group you specified..<br><br><div class="gmail_quote">
On Tue, Mar 11, 2008 at 8:03 PM, Sergey Benner &lt;<a href="mailto:sergey.benner@gmail.com">sergey.benner@gmail.com</a>&gt; wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Again :) Try this query.<div><div></div><div class="Wj3C7c"><br><br><div class="gmail_quote"><br>select usename,relname, tgname, tgtype, proname, prosrc, tgisconstraint,<br>tgconstrname, tgconstrrelid, tgdeferrable, tginitdeferred, tgnargs,<br>
tgattr, tgargs from (pg_trigger join pg_class c on tgrelid=c.oid )<br>

join pg_proc on (tgfoid=pg_proc.oid) join pg_user pu on c.relowner=pu.usesysid where pu.usename=&#39;YOURUSERNAME&#39;;<br><br><br><br> Please post such questions to the <a href="mailto:pgsql-sql@postgresql.org" target="_blank">pgsql-sql@postgresql.org</a> list.<br>


<br>Cheers, <br><font color="#888888">Sergey<br>
</font></div><br>
</div></div></blockquote></div><br>

------=_Part_5371_12799015.1205294872139--