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
--+--+--
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
> |
"[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)---
"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
