Yukiharu YABUKI の tDiary

_ [Debian] Yeah! uploaded yc-el

やったぜ．

yabuki@Hrestol:~$ apt-cache show yc-el
Package: yc-el
Priority: optional
Section: editors
Installed-Size: 348
Maintainer: Yukiharu YABUKI 
Architecture: i386
Version: 4.0.13-3
Depends: emacs21 | xemacs20-mule | xemacs21-mule | xemacs20-mule-canna-wnn | xemacs21-mule-canna-wnn | xemacs21-gnome-mule-canna-wnn | xemacs21-gnome-mule, libc6 (>= 2.3.5-1)
Suggests: canna
Filename: pool/main/y/yc-el/yc-el_4.0.13-3_i386.deb
Size: 70518
MD5sum: 4134ab56bc4fb3b95039e6f8b9d6eb2f
Description: Yet another Canna client for Emacsen
 Canna client for emacs21 or xemacs with MULE support.
 yc.el is implemented in pure elisp, allowing use of Canna on
 emacsen without direct support for Canna.
 .
 Canna is a Japanese input method.
Tag: accessibility::input, culture::japanese, made-of::lang:lisp, role::sw:client, role::sw:plugin, suite::emacs, use::editing
 
Package: yc-el
Status: install ok installed
Priority: optional
Section: editors
Installed-Size: 324
Maintainer: Junichi Uekawa 
Architecture: i386
Version: 4.0.13-2
Depends: emacs21 | xemacs20-mule | xemacs21-mule | xemacs20-mule-canna-wnn | xemacs21-mule-canna-wnn | xemacs21-gnome-mule-canna-wnn | xemacs21-gnome-mule, libc6 (>= 2.3.2.ds1-4)
Suggests: canna
Description: Yet another Canna client for Emacsen.
 Canna client for emacs21 or xemacs with MULE support.
 yc.el is implemented in pure elisp, allowing use of Canna on
 emacsen without direct support for Canna.
 .
 Canna is a Japanese input method.
 
yabuki@Hrestol:~$ 

_ rdesktop

下田くんが，所用にてrdesktopで作業したい理由ができたので，すこしレクチャー．窓の手というアプリケーションでiconを32bitや24bitにしていると rdesktop -a 16 でつなぐと減色していた．rdesktop の時は，その機能は使わないようにしてもらうことにした．

_ [ORCA] tbl_ptinf, tbl_ptnum

データ移行のサポート．ストアドプロシージャとは †(http://oss.kk-ntc.co.jp/jpug/pukiwiki/pukiwiki.php?%A5%B9%A5%C8%A5%A2%A5%C9%A5%D7%A5%ED%A5%B7%A1%BC%A5%B8%A5%E3%A1%CACREATE%20FUNCTION%A1%CB) Debian Woodyにて

orca@orca-box:~$ dpkg -l *postgre*
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Installed/Config-files/Unpacked/Failed-config/Half-installed
|/ Err?=(none)/Hold/Reinst-required/X=both-problems (Status,Err: uppercase=bad)
||/ Name                     Version                  Description
+++-========================-========================-================================================================
un  aolserver-postgres                          (no description available)
pn  cl-uncommonsql-postgresq                    (no description available)
pn  courier-authpostgresql                      (no description available)
pn  gda-postgres                                (no description available)
pn  libgtrans-postgresql-6-5                    (no description available)
pn  odbc-postgresql                             (no description available)
pn  perdition-postgresql                        (no description available)
un  postgres95                                  (no description available)
un  postgres95-dev                              (no description available)
ii  postgresql               7.2.1-2woody8            Object-relational SQL database, descended from POSTGRES.
ii  postgresql-client        7.2.1-2woody8            Front-end programs for PostgreSQL
ii  postgresql-contrib       7.2.1-2woody8            Additional facilities for PostgreSQL
pn  postgresql-dev                              (no description available)
ii  postgresql-doc           7.2.1-2woody8            Documentation for the PostgreSQL database.
un  postgresql-pl                               (no description available)
un  postgresql-test                             (no description available)
pn  webmin-postgresql                           (no description available)

ってな感じで．

orca@orca-box:~$ /usr/lib/postgresql/bin/createlang --help
createlang installs a procedural language into a PostgreSQL database.
 
Usage:
  createlang [options] langname [dbname]
 
Options:
  -h, --host=HOSTNAME             Database server host
  -p, --port=PORT                 Database server port
  -U, --username=USERNAME         Username to connect as
  -W, --password                  Prompt for password
  -d, --dbname=DBNAME             Database to install language in
  -L, --pglib=DIRECTORY           Find language interpreter file in DIRECTORY
  -l, --list                      Show a list of currently installed languages
 
Report bugs to .
orca@orca-box:~$ 

使えるかの確認．

orca@orca-box:~$ /usr/lib/postgresql/bin/createlang -l -d orca
Procedural languages
  Name   | Trusted? 
---------+----------
 plpgsql | t
(1 row)

で，sql文を作る．ちょっとした例文としては

$cat 20060213mnt.sql
DROP FUNCTION   MNT20060213();
CREATE FUNCTION MNT20060213() RETURNS text AS '
  DECLARE
  -- declaretion
  text_output text := ''\n'';
  BEGIN
    RAISE NOTICE ''START\n'';
    RAISE NOTICE ''END\n'';
    return text_output;
  END;
' LANGUAGE 'plpgsql';
select MNT20060213();

ってな感じ．実行は

orca@orca-box:~$ psql orca < 20060213mnt.sql 
DROP
CREATE
NOTICE:  START
NOTICE:  END