Re: [GENERAL] Alternative for vacuuming queue-like tables

2006-04-28 Thread kmh496
2006-04-28 (금), 14:40 +0200, Csaba Nagy 쓰시길: > I placed a cron job to > cluster the queue table on it's PK index. what does that mean? -- my site http://www.myowndictionary.com";>myowndictionary was made to help students of many languages learn them faster. ---(end of

[GENERAL] i need perl help for gborg project about mysql conversion

2006-05-06 Thread kmh496
hello, i couldn't find a more appropriate list, and it is *generally* about pgsql http://gborg.postgresql.org/project/mysql2psql/projdisplay.php i tweaked it to convert [ from mysql to pgsql ] SET datatypes as well as ENUMS, and changed it to create an index when it sees a UNIQUE KEY or KEY.

Re: [GENERAL] simple md5 authentication problems

2006-05-08 Thread kmh496
> > > > > > # "local" is for Unix domain socket connections only > > > local all all ident sameuser > > > # IPv4 local connections: > > > hostall all 127.0.0.1/32 md5 > > > # IPv6 local connections: > > > hostall all

Re: [GENERAL] another seemingly simple encoding question

2006-05-20 Thread kmh496
this is a forward of my problem from April. I have this time gone all the way and re-inited a DB from scratch, created a new database, documented the import procedure, set the locale to match but I am still having problems. For example, look at this match count~ mod=# select count(*) from korean_