> ----- Original Message ----- 
> From: "Roberto Mello" <[EMAIL PROTECTED]>
> To: "Comunidade PostgreSQL Brasileira" 
> <[email protected]>
> Sent: Wednesday, October 29, 2008 6:02 PM
> Subject: Re: [pgbr-geral] Erro na Função
>

> Roberto

> [1] http://www.postgresql.org/docs/8.3/static/pgrowlocks.html
>
>

Prezado Roberto

Problema resolvido! Agora é esperar o próximo... rs rs rs rs
Instalei o módulo e funcionou, obrigado pela ajuda!


/* pgrowlocks.sql em: C:\Arquivos de programas\PostgreSQL\8.3\share\contrib\ 
*/

/* $PostgreSQL: pgsql/contrib/pgrowlocks/pgrowlocks.sql.in,v 1.3 2007/11/13 
04:24:28 momjian Exp $ */

-- Adjust this setting to control where the objects get created.

SET search_path = public;

CREATE OR REPLACE FUNCTION a003.pgrowlocks(IN relname text,
    OUT locked_row TID,  -- row TID
    OUT lock_type TEXT,  -- lock type
    OUT locker XID,  -- locking XID
    OUT multi bool,  -- multi XID?
    OUT xids xid[],  -- multi XIDs
    OUT pids INTEGER[])  -- locker's process id
RETURNS SETOF record
AS '$libdir/pgrowlocks', 'pgrowlocks'
LANGUAGE C STRICT;
 

_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Responder a