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,xmi
"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
"[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)---
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
> |
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
--+--+--
Vinicio Llumiquinga <[EMAIL PROTECTED]> writes:
> fmgr_info: function 18816: cache lookup failed
> This happend when I write any function.
I suspect you dropped the plpgsql call handler function.
If so, the only convenient recovery method AFAIK is to drop the
plpgsql language entry and all your
I have a problem
I have a function in plpgsql:
create function add_one (integer) returns integer as '
begin
return $1+1;
end;
' language 'plpgsql';
When I create in psql monitor this function the message is CREATED
Then I write:
select add_one(1);
and always say:
fmgr_info: function 18816:
