[Dovecot] PostgreSQL user database

[Marco Herrn]

On Fri, Dec 10, 2004 at 01:13:44AM +0200, Timo Sirainen wrote:
> Well, view isn't exactly required as you can just write the same SQL 
> command into pass_query directly.

I have to admit that this didn't came to my mind. Of course this way I
achieve the same without views...

> But why would you want to avoid views? They seem perfectly good 
> solution to me. And if views aren't enough, you could write PostgreSQL 
> function to return the wanted fields. 

The database is used for several other tools and purposes and I don't
want to 'pollute' it with views or function that are only used by one
tool. It wouldn't be a big deal, but it seems to me a less optimal
solution. Of course, by specifying to full query I would use as the
view, I don't have to touch the database and everything is fine. :-)

But I came to another problem when doing this. Is it the case that
dovecot expects uids and gids always as numbers? I only store the
human readable names of them, but dovecot complains with:

  Error: Logins with UID 0 not permitted

Or is this a different error, maybe on my configuration side?

Regards
Marco

-- 
Exercise your freedom of religion.
Set fire to a church of your choice.
--
Marco Herrn              _  ___      o             '       (_)<   _ _
                         _>(__'>            o          0         (_X %
                                   >(_`>  O         o  _; _;'7^'_ \;\ %
(GnuPG/PGP-encrypted mail preferred)       _;\ _.\ _.';;) ;,;_/;
Key ID: 0x94620736                  _  _'./_\('))_; );/\)}/`fsc