Am dat asta din php :
$res=pg_exec($pg,"VACUUM") or die (pg_errormessage());
Si a mers.
Am dat asta:
pg_exec($pg, "BEGIN");
$res=pg_exec($pg,"VACUUM") or die (pg_errormessage());
pg_exec($pg, "COMMIT");
Si ghici ce mi-a zis ?
"ERROR: VACUUM cannot run inside a BEGIN/END block "
Deci, merge daca nu il dai intre "BEGIN" si "COMMIT".
Stefanita Vilcu wrote:
> Daca tu ai incercat si merge atunci e ok, la mine nu merge si da
> eroarea:
>
> DBD::Pg::st execute failed: ERROR: VACUUM cannot run inside a
> BEGIN/END block at /home/vsv/radius/radius.pl line 47, <IN> line 22.
>
> folosesc postgres 7.1.2 si DBD::Pg 1.01
>
> codul este:
>
> $sth=$dbh->prepare('VACUUM CURENT');
> $sth->execute;
>
> Vampi
>
> On Mon, 9 Jul 2001, George Mihalcea wrote:
>
> >
> > Pai daca dai din perl un query "vacuum" nu asta face?
> > Vacuum poti da fie cu comanda vacuum, fie din promptul sql ('the PostgreSQL
> > interactive terminal').
> >
> > Stefanita Vilcu wrote:
> >
> > > Salve,
> > >
> > > Stie cineva cum pot sa fac vacuum din perl? Ca eu nu am gasit.
> > > Solutia e sa apelez un script extern, dar nu vreau.
> > >
> > > Multumesc,
> > >
> > > Vampi
> > >
> > > --
> > > Stefanita Valeriu Vilcu, [EMAIL PROTECTED]
> > > Chief Technology Officer
> > > Dynamic Network Technologies, Romania
> > > Tel: +40-1-2106863 Fax: +40-1-3122745
> >
> > ---
> > Send e-mail to '[EMAIL PROTECTED]' with 'unsubscribe rlug' to
> > unsubscribe from this list.
> >
> >
>
> --
> Stefanita Valeriu Vilcu, [EMAIL PROTECTED]
> Chief Technology Officer
> Dynamic Network Technologies, Romania
> Tel: +40-1-2106863 Fax: +40-1-3122745
>
> ---
> Send e-mail to '[EMAIL PROTECTED]' with 'unsubscribe rlug' to
> unsubscribe from this list.
---
Send e-mail to '[EMAIL PROTECTED]' with 'unsubscribe rlug' to
unsubscribe from this list.
