Re: REVOKE command not working as expected

Hi,

Thanks for your answer, I know, that's why we have this statement:
https://github.com/guillermo-carrasco/scilifelab/blob/master/scripts/dbsync.sh#L20

On Tue, Nov 12, 2013 at 4:01 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>wrote:

> On Tue, Nov 12, 2013 at 7:58 AM, Guillermo Carrasco
> <guillermo(dot)carrasco(at)scilifelab(dot)se> wrote:
> > Hi everyone,
> >
> > The problem is that sometimes (apparently random), even after having
> invoked
> > EVOKE CONNECT ON DATABASE \"$DB\" FROM PUBLIC;, when the scripts starts
> > dumping, it fails because it says that there are some active connections.
>
> Revoking connection does not disconnect currently connected clients.
>

--
------------------------------------------------------------------------
Guillermo Carrasco Hernández, Computer Scientist

GitHub: https://github.com/guillermo-carrasco
LinkedIn: http://linkd.in/XeFUSB<http://www.linkedin.com/pub/guillermo-carrasco-hern%C3%A1ndez/43/760/220>
Personal blog: http://mussolblog.wordpress.com/
------------------------------------------------------------------------