First install everything we’ll need.
yum install postgresql postgresql-server
initdb -D /var/lib/pgsql/data/
pg_ctl -D /var/lib/pgsql/data -l logfile start
And that should do it. It’s really that easy. You can also run this
ps -eZ | grep postgres
and that will show all the running postgres processes. After that you can do awesome things like create databases
Happy new year! Enjoy the penguins!
It took me a little bit to figure this out and I couldn’t seem to find it anywhere else on the net, but if you want to check your Apple mail using a Linux mail client here are the settings I used.
Server Type: IMAP
Secure Connection: SSL encryption
Server Type: SMTP
The sending mail section is partially blank because I haven’t figured it out yet. If anyone has the missing fields let me know.
See here: http://support.apple.com/kb/HT4864
WordPress appears to have given a gold star because my previous post was my 475th? Why does WordPress care? Do this really mean anything? Is there a page somewhere where I get to see my stars?
I’m considering taking up the Vala language for pet projects. I just finished taking a course in Java and I’m ready to move on to something else.
Anyone have any thoughts or comments on Vala? Good, bad?
It occurred to me today that what if I wanted to track my changes in Excel? I realize that probably sounds stupid, right? More so to me than anyone since 90% of my day job is Oracle programming. But a challenge is a challenge so the first thing I did was hit the nets (naturally). The only real thing of interest I found was this:
Which was pretty good but it wasn’t good enough. I didn’t see any licenses or anything on the page but I thought I’d give them credit anyway.
Moving on though I decided I could make it a lot better. Thus you have the code I’ve linked to below. Instead of just recording just one change on one cell at a time, or just the four or five fields they list, I threw in some extra fields to make it a more legitimate a change log and I also expanded it out so it will now track changes for multiple cells being changed at a time. For example if you highlighted six cells, it will now write six records to the long, one for each of the six cells you just emptied.
I haven’t tried it in LibreOffice so I have no idea if it works there. I wrote it in Excel.
Lets pretend for a moment the following code compiles:
FOR seq IN (SELECT sequence FROM steven.test_table WHERE uid = seq.uid) LOOP
SELECT DISTINCT b.desc, b.code
INTO reason, cd
FROM steven.test_table a, steven.test_map b
WHERE a.uid = seq.uid;
SET reason = reason, cd = cd
WHERE uid = seq.uid;
WHEN NO_DATA_FOUND THEN
-- We ignore this error.
WHEN OTHERS THEN
err_num := SQLCODE;
err_msg := SQLERRM;
catch_error (procedure_name , err_num , err_msg , dos.do_uid , NULL , 'Too many rows found');
The problem is when I actually use this code, if I encounter a NO_DATA_FOUND error the program still drops into the OTHERS exception block and catches the error. Why??
Having the same block of code with two different sets of EXCEPTION statements more or less solves this one.