2
# src/pl/tcl/modules/pltcl_delmod.in
8
# Code still has to be documented
11
#load /usr/local/pgsql/lib/libpgtcl.so
16
# Check for minimum arguments
20
puts stderr "usage: pltcl_delmod dbname \[options\] modulename \[...\]"
22
puts stderr "options:"
23
puts stderr " -host hostname"
24
puts stderr " -port portnumber"
30
# Remember database name and initialize options
32
set dbname [lindex $argv 0]
40
if {[string compare [string index [lindex $argv $i] 0] "-"] != 0} {
44
set opt [lindex $argv $i]
47
puts stderr "no value given for option $opt"
51
set val [lindex $argv $i]
56
append options "-host \"$val\" "
59
append options "-port $val "
62
puts stderr "unknown option '$opt'"
71
if {$i >= $argc || $errors > 0} {
73
puts stderr "usage: pltcl_delmod dbname \[options\] modulename \[...\]"
75
puts stderr "options:"
76
puts stderr " -host hostname"
77
puts stderr " -port portnumber"
82
proc delmodule {conn modname} {
84
regsub -all {\\} $xname {\\} xname
85
regsub -all {'} $xname {''} xname
88
pg_select $conn "select * from pltcl_modules where modname = '$xname'" \
95
puts "Module $modname not found in pltcl_modules"
101
[pg_exec $conn "delete from pltcl_modules where modname = '$xname'"] \
104
[pg_exec $conn "delete from pltcl_modfuncs where modname = '$xname'"] \
107
puts "Module $modname removed"
110
set conn [eval pg_connect $dbname $options]
113
delmodule $conn [lindex $argv $i]