Re: [GENERAL] strange problem with not existing roles

2014-09-18 Thread Adrian Klaver
On 09/18/2014 09:44 AM, lud...@kni-online.de wrote: Hi Adrian, this database runs as develop-version on my PC and was created by hand, no dumps or pg_upgrade. The same database runs as production-version on another server (PostgreSQL 9.3.1, compiled by Visual C++ build 1600, 32-bit), so far witho

Re: [GENERAL] strange problem with not existing roles

2014-09-18 Thread lud...@kni-online.de
contents. But I'm curious about what has caused the problems and how to avoid them...   Ludwig   Gesendet: Donnerstag, 18. September 2014 um 15:53 Uhr Von: "Adrian Klaver" An: "lud...@kni-online.de" , pgsql-general@postgresql.org Betreff: Re: [GENERAL] strange p

Re: [GENERAL] strange problem with not existing roles

2014-09-18 Thread Adrian Klaver
On 09/18/2014 04:12 AM, lud...@kni-online.de wrote: Hi Adrian, data got into the database with normal update/insert-queries from logged-in database-users using "normal" PG-Users/roles, the "ghost-roles" (with these unusual numerical role-names) were never created by me, I don't know where they co

Re: [GENERAL] strange problem with not existing roles

2014-09-18 Thread lud...@kni-online.de
ems?   Ludwig Gesendet: Mittwoch, 17. September 2014 um 17:33 Uhr Von: "Adrian Klaver" An: "lud...@kni-online.de" , pgsql-general@postgresql.org Betreff: Re: [GENERAL] strange problem with not existing roles On 09/17/2014 08:08 AM, lud...@kni-online.de wrote: > Hi list

Re: [GENERAL] strange problem with not existing roles

2014-09-17 Thread Adrian Klaver
On 09/17/2014 08:08 AM, lud...@kni-online.de wrote: Hi list, I have a strange problem in postgres (PostgreSQL 9.3.1, compiled by Visual C++ build 1600, 64-bit), there are granted privileges on schemas, tables, columns for roles that don't exist. So how did the data get into the database? Exa