6
# Code still has to be documented
9
#load /usr/local/pgsql/lib/libpgtcl.so
14
# Check for minimum arguments
18
puts stderr "usage: pltcl_delmod dbname \[options\] modulename \[...\]"
20
puts stderr "options:"
21
puts stderr " -host hostname"
22
puts stderr " -port portnumber"
28
# Remember database name and initialize options
30
set dbname [lindex $argv 0]
38
if {[string compare [string index [lindex $argv $i] 0] "-"] != 0} {
42
set opt [lindex $argv $i]
45
puts stderr "no value given for option $opt"
49
set val [lindex $argv $i]
54
append options "-host \"$val\" "
57
append options "-port $val "
60
puts stderr "unknown option '$opt'"
69
if {$i >= $argc || $errors > 0} {
71
puts stderr "usage: pltcl_delmod dbname \[options\] modulename \[...\]"
73
puts stderr "options:"
74
puts stderr " -host hostname"
75
puts stderr " -port portnumber"
80
proc delmodule {conn modname} {
82
regsub -all {\\} $xname {\\} xname
83
regsub -all {'} $xname {''} xname
86
pg_select $conn "select * from pltcl_modules where modname = '$xname'" \
93
puts "Module $modname not found in pltcl_modules"
99
[pg_exec $conn "delete from pltcl_modules where modname = '$xname'"] \
102
[pg_exec $conn "delete from pltcl_modfuncs where modname = '$xname'"] \
105
puts "Module $modname removed"
108
set conn [eval pg_connect $dbname $options]
111
delmodule $conn [lindex $argv $i]