userpref - other purposes

[Duane Hill <d....@yournetplus.com>]

I know if there is a misconfiguration in one of the config files SA will
usually skip it and keep running.

Does the same hold true for extraneous data within the userpref SQL
table? I have a custom Postfix policy and would rather use the existing
userpref table than to create an additional table and have to perform
two queries.

------
  _|_
 (_| |

Re: userpref - other purposes

[Duane Hill <d....@yournetplus.com>]

On Thu, 13 Dec 2007 19:04:46 -0500
Matt Kettler <mk...@verizon.net> wrote:

> Duane Hill wrote:
> > I know if there is a misconfiguration in one of the config files SA
> > will usually skip it and keep running.
> >   
>
> Well, it might.. It will essentially start discarding data until it
> can make sense of the configuration stream again. Note this might
> actually cause options in other files to be discarded, it all depends
> on how badly you confuse the parser.
>
> > Does the same hold true for extraneous data within the userpref SQL
> > table? I have a custom Postfix policy and would rather use the
> > existing userpref table than to create an additional table and have
> > to perform two queries.
>
> This would likely have the same effect on the parser.

Ok. So I create another table and link to the userpref using the prefid
column and use a select...join on statement.

------
  _|_
 (_| |