[BUGS] help me please

2007-12-28 Thread [EMAIL PROTECTED] 

hello

Help me please...
I have two "postgres" user. How to delete the first one ???

***
# 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 | 
md53532747417351142d5270721fcf740ed5 | infinity |

(2 rows)
***

***
# select * from pg_user where usesysid=1;
usename  | usesysid | usecreatedb | usesuper | usecatupd |  passwd  | 
valuntil | useconfig

--+--+-+--+---+--+--+---
postgres |1 | t   | t| t |  
|  |
postgres |1 | t   | t| t |  | 
infinity |

(2 rows)
***


I tried  
   delete from pg_shadow where passwd is null;


but it's not working.

Help me please
oleg

---(end of broadcast)---
TIP 4: Have you searched our list archives?

  http://archives.postgresql.org

Re: [BUGS] help me please

2007-12-28 Thread Josh Tolley 
On Dec 28, 2007 7:01 AM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> hello
>
> Help me please...
> I have two "postgres" user. How to delete the first one ???
>
> ***
> # 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 |
> md53532747417351142d5270721fcf740ed5 | infinity |
> (2 rows)
> ***
>
> ***
> # select * from pg_user where usesysid=1;
>  usename  | usesysid | usecreatedb | usesuper | usecatupd |  passwd  |
> valuntil | useconfig
> --+--+-+--+---+--+--+---
>  postgres |1 | t   | t| t | 
> |  |
>  postgres |1 | t   | t| t |  |
> infinity |
> (2 rows)
> ***
>
>
> I tried
> delete from pg_shadow where passwd is null;
>
> but it's not working.
>
> Help me please
> oleg

pg_shadow is a view based on pg_authid. Try deleting it from
pg_authid. Note that pg_authid is defined with OIDs, which might also
be useful for you.

- Josh / eggyknap

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly

Re: [BUGS] help me please

2007-12-28 Thread Tom Lane 
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> 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

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org

Re: [BUGS] help me please

2007-12-28 Thread Tom Lane 
"Josh Tolley" <[EMAIL PROTECTED]> writes:
> pg_shadow is a view based on pg_authid.

Not in 7.4 it wasn't ...

regards, tom lane

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings