Contents of /bin/MasterDelTable

#!/usr/bin/perl -w
# MasterAddTable
# Vadim Mikheev, (c) 2000, PostgreSQL Inc.

eval '(exit $?0)' && eval 'exec perl -S $0 ${1+"$@"}'
    & eval 'exec perl -S $0 $argv:q'
    if 0;

use Pg;
use Getopt::Long;
use strict;

$| = 1;

my ($debug,$verbose) = (0,0);
my ($help,$masterhost,$masterport,$masteruser,$masterpassword);

my $result = GetOptions(
        "debug!" => \$debug, "verbose!" => \$verbose, "help" => \$help,
        "masterhost=s" => \$masterhost, "masterport=i" => \$masterport,
        "masteruser=s" => \$masteruser, "masterpassword=s" => \$masterpassword,
        );

if (defined($help) || (scalar(@ARGV) < 2)) {
    print "Usage: $0 [options] masterdb table
Options:
        --masterhost=hostname --masterport=port
        --masteruser=username --masterpassword=string
";
    exit ((scalar(@ARGV) < 2)? 1:0);
}

my $dbname = $ARGV[0];
my $table = $ARGV[1];
#my $keyname = $ARGV[2];

my $minfo = "dbname=$dbname";
$minfo = "$minfo host=$masterhost" if (defined($masterhost));
$minfo = "$minfo port=$masterport" if (defined($masterport));
$minfo = "$minfo user=$masteruser" if (defined($masteruser));
$minfo = "$minfo password=$masterpassword" if (defined($masterpassword));

my $conn = Pg::connectdb($minfo);
if ($conn->status != PGRES_CONNECTION_OK) {
    print STDERR "Failed opening $minfo\n";
    exit 1;
}

$result = $conn->exec("BEGIN");
die $conn->errorMessage if $result->resultStatus ne PGRES_COMMAND_OK;

$result = $conn->exec("DROP TRIGGER _RSERV_TRIGGER_T_ ON \"$table\"");
die $conn->errorMessage if $result->resultStatus ne PGRES_COMMAND_OK;

$result = $conn->exec("DELETE FROM _RSERV_TABLES_ WHERE tname='$table'");
die $conn->errorMessage if $result->resultStatus ne PGRES_COMMAND_OK;

$result = $conn->exec("COMMIT");
die $conn->errorMessage if $result->resultStatus ne PGRES_COMMAND_OK;

exit(0);
1	#!/usr/bin/perl -w
2	# MasterAddTable
3	# Vadim Mikheev, (c) 2000, PostgreSQL Inc.
4
5	eval '(exit $?0)' && eval 'exec perl -S $0 ${1+"$@"}'
6	& eval 'exec perl -S $0 $argv:q'
7	if 0;
8
9	use Pg;
10	use Getopt::Long;
11	use strict;
12
13	$\| = 1;
14
15	my ($debug,$verbose) = (0,0);
16	my ($help,$masterhost,$masterport,$masteruser,$masterpassword);
17
18	my $result = GetOptions(
19	"debug!" => \$debug, "verbose!" => \$verbose, "help" => \$help,
20	"masterhost=s" => \$masterhost, "masterport=i" => \$masterport,
21	"masteruser=s" => \$masteruser, "masterpassword=s" => \$masterpassword,
22	);
23
24	if (defined($help) \|\| (scalar(@ARGV) < 2)) {
25	print "Usage: $0 [options] masterdb table
26	Options:
27	--masterhost=hostname --masterport=port
28	--masteruser=username --masterpassword=string
29	";
30	exit ((scalar(@ARGV) < 2)? 1:0);
31	}
32
33	my $dbname = $ARGV[0];
34	my $table = $ARGV[1];
35	#my $keyname = $ARGV[2];
36
37	my $minfo = "dbname=$dbname";
38	$minfo = "$minfo host=$masterhost" if (defined($masterhost));
39	$minfo = "$minfo port=$masterport" if (defined($masterport));
40	$minfo = "$minfo user=$masteruser" if (defined($masteruser));
41	$minfo = "$minfo password=$masterpassword" if (defined($masterpassword));
42
43	my $conn = Pg::connectdb($minfo);
44	if ($conn->status != PGRES_CONNECTION_OK) {
45	print STDERR "Failed opening $minfo\n";
46	exit 1;
47	}
48
49	$result = $conn->exec("BEGIN");
50	die $conn->errorMessage if $result->resultStatus ne PGRES_COMMAND_OK;
51
52	$result = $conn->exec("DROP TRIGGER _RSERV_TRIGGER_T_ ON \"$table\"");
53	die $conn->errorMessage if $result->resultStatus ne PGRES_COMMAND_OK;
54
55	$result = $conn->exec("DELETE FROM _RSERV_TABLES_ WHERE tname='$table'");
56	die $conn->errorMessage if $result->resultStatus ne PGRES_COMMAND_OK;
57
58	$result = $conn->exec("COMMIT");
59	die $conn->errorMessage if $result->resultStatus ne PGRES_COMMAND_OK;
60
61	exit(0);