Today, 11th of January. It’s my birthday.

My family congrats me in the morning and followed by my friends. It seems just like ordinary ritual, but actually that they show their emphatic to me. Hmm.. I remind one sentence: “the happiness is not determined by one factor only, but there are so many factors. However none of them become the most. They must balance each other.”

I’m happy because I have a great family. It’s the real great I mean. I’m thankful for God because He is still take care of me. My birthday wish?? hmm.. I think it cannot be forced. hope comes every time it wants. t doesn’t limited by New Year, Birthday, etc. I just wanna one thing: I want to learn to be better every time.

Popularity: 5% [?]

Dulu Yahoo!Mail sempat memberikan layanan POP3 untuk free emailnya. Tapi itu dulu. Kalau kita sekarang ingin menikmati fasilitas POP3 tersebut gimana caranya? Selain meng-upgrade account (tidak free lagi tentunya ), YPOPs! dapat mengimplementasikannya.

Aq udah coba pake di Linux yang versi 0.8.6.2, dan berjalan baik (untuk versi Windows udah lebih terbaru).

Klo di account mail kita ada lebih dari satu folder, kita juga bisa me-retrieve semua folder tersebut dengan cara di file ypops.ini, pada bagian “Folders=” masukkan nama folder-folder yang ada di account Yahoo dengan separator “|”.

Misalkan pada account Yahoo kita punya folder friendster, training, dan project, maka dibuat seperti ini:
“Folders=friendster|training|project“ tanpa spasi dan tanpa tanda petik (”).

Pada file ypops.ini tersebut yang penting juga untuk diketahui ada nilai variable SmtpPort dan Pop3Port, karena ini sangat diperlukan untuk men-setting mail client nantinya.

Untuk setting email client-nya, petunjuknya ada di sini.

Selamat mencoba dan ber POP3 ria

Popularity: 6% [?]

pre { padding: 1em; border: 1px dashed #2f6fab; color: black; background-color: #f9f9e9; line-height: 1.5em; font-size:9pt}
Whatever the reason is, but sometimes we decided to change column type of table. It’s quite easy to implement the patch it MySQL, but not in PostgreSQL (I’m currently using pgsql 8.14).

There are two ways (I just know those two) to solve that problem:

1st solution:BEGIN;

ALTER TABLE table_name ADD COLUMN new_col new_data_type;

UPDATE table_name SET new_col = CAST(old_col AS new_data_type);

ALTER TABLE table_name DROP COLUMN old_col;

COMMIT;

However, It is used when we want to change type of the latest column (its position in the table), except we can determine to add column in the certain position.

Since it cannot be used in all situations, I have found another way to solve that problem:

2nd solution:1) Copy old table to temporary table

CREATE TABLE temp AS SELECT * FROM old_table;2) Drop old table

DROP TABLE old_table;

3) Create new table (as required structure)

CREATE TABLE new_table ( col1 type(xx), col2 type(xx) );

4) insert data dari table temporary ke table baru

INSERT INTO new_table SELECT * FROM temp ;

Yeah.. that’s it! I think it will be useful.

Popularity: 5% [?]