| From: | "Stephen Martin" <stephen(at)sealteam(dot)demon(dot)co(dot)uk> |
|---|---|
| To: | <pgsql-interfaces(at)postgreSQL(dot)org> |
| Subject: | |
| Date: | 2000-02-27 01:01:55 |
| Message-ID: | NDBBKKNKKLBACABPPCCNGEHPDOAA.stephen@sealteam.demon.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-interfaces |
Hello,
How can one differential between apparently duplicated usernames?
For example I have a postgres id 'www' present within my pg_shadow/pg_user.
I recently installed a package and inadvertantly created another 'www' user.
I have managed to remove the duplicate user by deleting it from pg_shadow by
identifying it via its usesysid field.
How can I
1) Ensure I canot in future create duplicate names?
2) If duplicate users are possible by what other means can the
various instances of them be referenced?
Stephen
----------------------------------------------
010000C9
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Martin | 2000-02-27 01:15:34 | RE: [INTERFACES] Date: Sat, 26 Feb 2000 17:01:55 -0800 |
| Previous Message | Tom Lane | 2000-02-26 23:46:32 | Re: [HACKERS] Numeric with '-' |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Martin | 2000-02-27 01:15:34 | RE: [INTERFACES] Date: Sat, 26 Feb 2000 17:01:55 -0800 |
| Previous Message | Byron Nikolaidis | 2000-02-26 16:11:33 | Re: [INTERFACES] Access97 -> ODBC -> Postgres Problems |