On Wed, 11 Jul 2001, Stefanita Vilcu wrote:
> Ai testat tu si merge? Ca eu urlu de ieri ca un ciine in pustie ca
> miscarea asta nu tine, cel putin la mine.
22:01:32 blackblue (Mituc):/usr/local/sbin>cat muci.pl
#!/usr/bin/perl -w
use strict;
use DBI;
my
$dbh=DBI->connect("dbi:Pg:dbname=testdb;host=localhost","testdb","mucicupisatindouacuckt",
{AutoCommit=>1, RaiseError=>0, PrintError=>0})
|| die "cannot connect: $DBI::errstr";
my $sth=$dbh->prepare("vacuum");
my $rc=$sth->execute;
die "nasol: $DBI::errstr" if (!defined($rc) || $rc eq "");
$sth->finish;
$dbh->disconnect;
22:01:36 blackblue (Mituc):/usr/local/sbin>perl muci.pl
[snip]
NOTICE: Skipping "pg_listener" --- only table owner can VACUUM it
NOTICE: Skipping "pg_description" --- only table owner can VACUUM it
NOTICE: Skipping "pg_shadow" --- only table owner can VACUUM it
NOTICE: Skipping "pg_user" --- only table owner can VACUUM it
NOTICE: Skipping "pg_rules" --- only table owner can VACUUM it
NOTICE: Skipping "pg_views" --- only table owner can VACUUM it
NOTICE: Skipping "pg_tables" --- only table owner can VACUUM it
22:02:24 blackblue (Mituc):/usr/local/sbin>rpm -q postgresql
postgresql-7.0.3-8
~~~Initial am testat pe un postgresql-7.1-1 si a mers ok.
Daca ai vreo tranzactie la mijloc... nu mai stiu ca nu am
incercat. Eu zic ca ar trebui totusi sa-ti mearga... doar ca la un
rollback... n-o sa se mai intimple ce ar trebui. Sau poate ca n-o sa
mearga tocmai in ideea asta, ca dupa vacuum n-o sa poata aduce inapoi cine
stie ce minuni.
--
Tarhon-Onu Victor
Network and System Engineer
RDS Iasi - Network Operations Center
Phone: +40-32-218385, Mobile: +40-093-605070
---
Send e-mail to '[EMAIL PROTECTED]' with 'unsubscribe rlug' to
unsubscribe from this list.
