| From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: how to disable autovaccum |
| Date: | 2009-04-14 10:45:54 |
| Message-ID: | 20090414104554.GE11459@a-kretschmer.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
In response to ahmed soua :
> Hi everybody,
>
> When I was working with Postgis , I had the following error:
> failed: ERREUR: VACUUM ne peut pas être exécuté à partir d'une fonction ou
> d'une chaîne
> contenant plusieurs commandes ( VACUUM cannot be executed from a function or
> from a chain containing several commands)
> Error occurred, cleaning up.
> I had disabled the parameter autocavcum in the file postgresql.conf but i still
> have the same error.
> Can you help me please .
You have to change your application, you can't run VACUUM inside a
transaction, a function or a multicommand string. That is not adjustable
in the config.
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | wstrzalka | 2009-04-14 11:42:39 | Is it bad sorting in UTF ?? |
| Previous Message | ahmed soua | 2009-04-14 10:30:39 | how to disable autovaccum |