Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 136472E005A for ; Tue, 22 Apr 2008 19:40:52 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 57019-07 for ; Tue, 22 Apr 2008 19:40:39 -0300 (ADT) X-Greylist: delayed 00:15:53.996802 by SQLgrey-1.7.5 Received: from hq.1pr.ru (hq.1pr.ru [195.42.82.210]) by developer.postgresql.org (Postfix) with ESMTP id 0C63E2E0059 for ; Tue, 22 Apr 2008 19:40:45 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by hq.1pr.ru (Postfix) with ESMTP id 80174FC198 for ; Wed, 23 Apr 2008 02:24:49 +0400 (MSD) Received: from hq.1pr.ru ([127.0.0.1]) by localhost (hq.1pr.ru [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id qKJP1Hn-JKKh for ; Wed, 23 Apr 2008 02:24:48 +0400 (MSD) Received: from enforcer (enforcer.local.1pr.ru [10.0.1.99]) by hq.1pr.ru (Postfix) with ESMTP id 796DCFC197 for ; Wed, 23 Apr 2008 02:24:48 +0400 (MSD) X-AntiVirus: Checked by Dr.Web [version: 4.44, engine: 4.44.0.09170, virus records: 365083, updated: 22.04.2008] Message-ID: <480E646A.4070508@1pr.ru> Date: Wed, 23 Apr 2008 02:19:22 +0400 From: Khobotko Oleg User-Agent: Thunderbird 2.0.0.12 (Windows/20080213) MIME-Version: 1.0 To: pgsql-bugs@postgresql.org Subject: problem Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200804/192 X-Sequence-Number: 20404 Hello, help me please, I don't know how, but i got 2 postgres users. How can I delete the first one ???? thx alot for your answers. /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// select passwd,ctid,xmin,xmax,cmin,cmax from pg_shadow where usesysid =1; passwd | ctid | xmin | xmax | cmin | cmax -------------------------------------+-------+------+----------+----------+----- - | (0,1) | 1 | 16754522 | 16754522 | 0 md510db8c04d26d32185270721fcf32155 | (0,2) | 2 | 0 | 0 | 0 (2 rows) ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// select * from pg_shadow where usesysid=1; usename | usesysid | usecreatedb | usesuper | usecatupd | passwd | valuntil | useconfig ----------+----------+-------------+----------+-----------+--------------------- ----------------+----------+----------- postgres | 1 | t | t | t | | | postgres | 1 | t | t | t | md510db8c04d231142d5 270721fcf740ed5 | infinity | (2 rows) //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// Tom Lane пишет: "spol@mail.ru" writes: > I have two "postgres" user. How to delete the first one ??? > Let's see the system columns (ctid,xmin,xmax,cmin,cmax) for those two rows? regards, tom lane