postgres

code related to postgreSQL.

server side C

• mule -> utf8
• human(int8) display a human-readable string representing a number like: 8.1GB http://www.ruska.it/comp/activity/c/pg/human/

bookmarks:

NEsted, transitive closure

http://threebit.net/tutorials/nestedset/tutorial1.html http://www.dbazine.com/oracle/or-articles/tropashko4 http://www.sai.msu.su/~megera/postgres/gist/ltree/ http://www.mrnaz.com/static/articles/trees_in_sql_tutorial/

EXPLAIN VERBOSE

http://pgsqld.active-venture.com/planner-optimizer.html

http://www.varlena.com/varlena/GeneralBits/116.php

http://www.postgresql.org/docs/7.4/static/protocol-message-formats.html RowDescription (B)

see postgres-fsource

Creating a new DB

why does it work w/ strace, but not w/o it? ; strace -f -e open * unset LANG; LC_ALL="C" LC_COLLATE="C" LC_MESSAGES='C' initdb

[14 lug 06] LC_MESSAGE="it" initdb works!

Create the DB:

users.sql

??? psql:/linux/10/postgres/structure.dec2:9834: ERROR: permission denied for language c UPDATE pg_shadow set usesuper = 't' where usename 'mmc' or usename'beta';

-- select * from pg_authid;

functions:

ret.so ?? char_in_set.so int_counter.so

human ??

Fight agains pl/TCL!

could not find function "char_in_text" in file "/usr/lib/postgresql/char_in_set.so"

Emacs & psql

To write utf8, I had to disable readline!