pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Dropping users with no name
2+ messages / 2 participants
[nested] [flat]

* Dropping users with no name
@ 2001-04-11 16:29 Hans-Jürgen Schönig <hs@cybertec.at>
  2001-04-14 09:09 ` Re: Dropping users with no name Oliver Elphick <olly@lfix.co.uk>
  0 siblings, 1 reply; 2+ messages in thread

From: Hans-Jürgen Schönig @ 2001-04-11 16:29 UTC (permalink / raw)
  To: pgsql-sql

I have accidentally created a user with no name. How can I delete this
user?
I have compiled my attempts below:

    Hans


persons=# SELECT * FROM pg_user;
 usename  | usesysid | usecreatedb | usetrace | usesuper | usecatupd |
passwd  |
valuntil
----------+----------+-------------+----------+----------+-----------+----------+----------

 postgres |       26 | t           | t        | t        | t         |
******** |
          |       27 | f           | f        | f        | f         |
******** |
(2 rows)

persons=# DELETE FROM pg_user where usesysid>26;
DELETE 0

persons=# SELECT '$'|| usename||'$' FROM pg_user;
  ?column?
------------
 $postgres$
 $$
(2 rows)

persons=# DROP USER '';
ERROR:  parser: parse error at or near "'"




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Dropping users with no name
  2001-04-11 16:29 Dropping users with no name Hans-Jürgen Schönig <hs@cybertec.at>
@ 2001-04-14 09:09 ` Oliver Elphick <olly@lfix.co.uk>
  0 siblings, 0 replies; 2+ messages in thread

From: Oliver Elphick @ 2001-04-14 09:09 UTC (permalink / raw)
  To: Hans-Jürgen Schönig <hs@cybertec.at>; +Cc: pgsql-sql

=?iso-8859-1?Q?Hans=2DJ=FCrgen=20Sch=F6nig?= wrote:
  >I have accidentally created a user with no name. How can I delete this
  >user?
  >I have compiled my attempts below:
  >
  >    Hans
  >
  >
  >persons=# SELECT * FROM pg_user;
  > usename  | usesysid | usecreatedb | usetrace | usesuper | usecatupd |
  >passwd  |
  >valuntil
  >----------+----------+-------------+----------+----------+-----------+------
      >----+----------
  >
  > postgres |       26 | t           | t        | t        | t         |
  >******** |
  >          |       27 | f           | f        | f        | f         |
  >******** |
  >(2 rows)
  >
  >persons=# DELETE FROM pg_user where usesysid>26;
  >DELETE 0
 
pg_user is a view.  Try

  DELETE FROM pg_shadow where usename = '';


-- 
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47  6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "Be strong, and let your heart take courage, all you 
      who hope in the Lord."   Psalm 31:24 





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2001-04-14 09:09 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-04-11 16:29 Dropping users with no name Hans-Jürgen Schönig <hs@cybertec.at>
2001-04-14 09:09 ` Oliver Elphick <olly@lfix.co.uk>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox