X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id E31E4D8733
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu,  8 Sep 2005 19:33:51 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 48452-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu,  8 Sep 2005 22:33:45 +0000 (GMT)
Received: from web50614.mail.yahoo.com (web50614.mail.yahoo.com
	[206.190.39.114])
	by svr1.postgresql.org (Postfix) with SMTP id ACC5CD8305
	for <pgsql-sql@postgresql.org>; Thu,  8 Sep 2005 19:33:45 -0300 (ADT)
Received: (qmail 21919 invoked by uid 60001); 8 Sep 2005 22:33:48 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.br;
	h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=GkG7Q/p0D76Bx3XY6IdZV0vZWUz1urf6pmSQAF030WxoeockXvZMoaTarie/WoARtTq/HFkNURaH6f++PNXbvY+LpeqQZUTTvQj9H41M5nXZEn7Lyg94WZ6kPiGHpGAwV0Oo2WLpcXV/JItjBVfCOGM2YRk9yYBmMwrzstA9LQg=
	;
Message-ID: <20050908223348.21917.qmail@web50614.mail.yahoo.com>
Received: from [62.48.215.253] by web50614.mail.yahoo.com via HTTP;
	Thu, 08 Sep 2005 22:33:48 GMT
Date: Thu, 8 Sep 2005 22:33:48 +0000 (GMT)
From: =?iso-8859-1?q?Jo=FFffffffffffe3o=20Carvalho?=
	<joaocarvalho127@yahoo.com.br>
Subject: Re: queries problems
To: pgsql-sql@postgresql.org
In-Reply-To: <20050902020346.GA58397@winnie.fuhr.org>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-900291876-1126218828=:20668"
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=1.249 required=5 tests=[AWL=-0.146,
	DNS_FROM_RFC_ABUSE=0.374, FROM_ENDS_IN_NUMS=0.516, HTML_20_30=0.504,
	HTML_MESSAGE=0.001]
X-Spam-Level: *
X-Archive-Number: 200509/95
X-Sequence-Number: 22642

--0-900291876-1126218828=:20668
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

The problem here is to compare int2vector with int2.
 
Regards
João Carvalho


Michael Fuhr <mike@fuhr.org> escreveu:
[Please copy the mailing list on replies so others can contribute
to and learn from the discussion.]

On Thu, Sep 01, 2005 at 10:33:44PM -0300, João Carvalho wrote:
> Michael Fuhr escreveu:
> > http://www.postgresql.org/docs/8.0/static/monitoring.html
> > http://www.postgresql.org/docs/8.0/static/catalogs.html
> 
> Tanks a lot, it is part of that information in there. I resolved 
> the schema problem and probably the toast table problem. but I still
> can´t get any information in there about the users of the locks and
> wich atributes are part of each index.

For locks, you can join pg_locks.pid with pg_stat_activity.procpid
and get user names from pg_stat_activity.usename.

http://www.postgresql.org/docs/8.0/static/view-pg-locks.html
http://www.postgresql.org/docs/8.0/static/monitoring-stats.html#MONITORING-STATS-VIEWS-TABLE

For index attributes, see pg_index.indkey and pg_attribute.attnum,
or the pg_get_indexdef() function.

http://www.postgresql.org/docs/8.0/static/catalog-pg-index.html
http://www.postgresql.org/docs/8.0/static/catalog-pg-attribute.html
http://www.postgresql.org/docs/8.0/static/functions-info.html#FUNCTIONS-INFO-CATALOG-TABLE

-- 
Michael Fuhr

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

		
---------------------------------
 Yahoo! Messenger com voz: PROMOÇÃO VOCÊ PODE LEVAR UMA VIAGEM NA CONVERSA. Participe!
--0-900291876-1126218828=:20668
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

<DIV>The problem here is to compare int2vector with int2.</DIV>
<DIV>&nbsp;</DIV>
<DIV>Regards</DIV>
<DIV>João Carvalho</DIV>
<DIV><BR><BR><B><I>Michael Fuhr &lt;mike@fuhr.org&gt;</I></B> escreveu:</DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">[Please copy the mailing list on replies so others can contribute<BR>to and learn from the discussion.]<BR><BR>On Thu, Sep 01, 2005 at 10:33:44PM -0300, João Carvalho wrote:<BR>&gt; Michael Fuhr <MIKE@FUHR.ORG>escreveu:<BR>&gt; &gt; http://www.postgresql.org/docs/8.0/static/monitoring.html<BR>&gt; &gt; http://www.postgresql.org/docs/8.0/static/catalogs.html<BR>&gt; <BR>&gt; Tanks a lot, it is part of that information in there. I resolved <BR>&gt; the schema problem and probably the toast table problem. but I still<BR>&gt; can´t get any information in there about the users of the locks and<BR>&gt; wich atributes are part of each index.<BR><BR>For locks, you can join pg_locks.pid with pg_stat_activity.procpid<BR>and get user names from
 pg_stat_activity.usename.<BR><BR>http://www.postgresql.org/docs/8.0/static/view-pg-locks.html<BR>http://www.postgresql.org/docs/8.0/static/monitoring-stats.html#MONITORING-STATS-VIEWS-TABLE<BR><BR>For index attributes, see pg_index.indkey and pg_attribute.attnum,<BR>or the pg_get_indexdef() function.<BR><BR>http://www.postgresql.org/docs/8.0/static/catalog-pg-index.html<BR>http://www.postgresql.org/docs/8.0/static/catalog-pg-attribute.html<BR>http://www.postgresql.org/docs/8.0/static/functions-info.html#FUNCTIONS-INFO-CATALOG-TABLE<BR><BR>-- <BR>Michael Fuhr<BR><BR>---------------------------(end of broadcast)---------------------------<BR>TIP 2: Don't 'kill -9' the postmaster<BR></BLOCKQUOTE><p>
		<hr size=1> 
Yahoo! Messenger com voz: PROMOÇÃO VOCÊ PODE LEVAR UMA VIAGEM NA CONVERSA. <a href="http://us.rd.yahoo.com/mail/br/taglines/*http://br.yahoo.com/messenger/promocao/">Participe!</a>
--0-900291876-1126218828=:20668--