Sunday, October 31, 2004
tsearch and parking
My big accomplishment for the week was an install of PostgreSQL on windows 2000. The postgres team just released version 8.0 beta4. It used to be that you could run postgres on windows through the cygwin environment. As of version 8.0 they have released a native win32 port. So I downloaded the installer available from the FTP mirrors and I went to work.
The installation itself is slick as a greased slip n' slide. I don't like windows at all, but I wanted to try this out. It will bennefit me a great deal to be able offer this as a solution to potential clients if they have windows requirements.
So ... the installation is a typical windows installation. It creates a user for the PG superuser, and sets everything up. Part of the installation process is a selection of all available contrib pacakes (including tsearch2). Just a simple click of a checkbox and you are on you way. :-) So the installation is _very_ easy.
It still comes with all of the regular PG command line utilities (createdb, pg_dump, psql etc). It will also install pgAdminnIII for you. I have started using that a little bit on windows, but I found myslef still going back to the command line. This posed some difficulties on my part. I'm too used to a good operating system like any *nix based OS. I ended up writing batch files for ls.bat, cp.bat and will most likely continue to do so to avaoid smacking my computer screen every time I forget to type dir in a DOS command prompt.
I installed vim, of course, and I am currently looking for some other kind of console programs for windows. I seem to be out of luck. cmd.exe it is ... and man does that thing suck. I took me _forever_ to figure out how to do simple things like add a directory to the $PATH variable, or turn on tab completion. BTW ... there is character completion in the DOS window, it's default key just happens to not be tab. I don't understand that ... and It really bothers me that simple things like that have to be configured in the regitry. @#!@#! windows.
I got an email about my tsearch2 intro documentation. Someone had a problem installing tsearch2 following the steps because the user they were installing as did not have superuser privileges and therefore could not install functions with language 'C" (it's not a trusted language).
I started walking through my documentation. I've had some additions on the back burner for the last few months. I asked Oleg what he would like to see added to the docs. I'm also going to run through everything on my new PG windows installation. I figure there will be some new additions based on my playing around. I'll let everyone know when a new edition is out.
I went to Safeway earlier today. I ran in to get a couple of things to make an awesome chicken taco salad. When I came out I put the bag in the passenger seat. Then when I went around to the driver to to get in I couldn't. The owner of a new acura SUV had parked not only crooked in their spot, but angled accross the lines into my spot. I'm a big guy to begin with, but I could only manage to open the car door enough to have about 4 inches of space between the door and the seat. Paris Hilton couldn't even squeeze into my car ... that's how bad this was.
So I leaned up against the trunk of my car. I decided this was the most opportune time to have a cigarette. So I smoked, and watched the passers by in a busy parking lot. All giving me strange looks as this wierd guy just "hanging out" in the Safeway parking lot. After about 10 minutes of sitting there I heard a click click of the SUV automatic doors unlocking. An rather cute girl was walking toward me. She too looked at me kind of wierd, and got into her truck, started it up and backed out ... slowly ... really slowly as to not hit my car. So I then proceeded to get into my car.
Around this point in time I think she must have realized what had happened. This girls was an idiot, and parked so close to me that I couldn't even open my door to get into my car. My door was was still open, and she rolled down the window and was apologizing profusley. I just turned my head and waved. I really didn't care about standing outside for a few minutes. If people flipped out over losing 15 minutes of a saturday afternoon ... you've got some issuses. Now if I had been mising the Roughriders game because of this I probably would have keyed her shiny new van, and smashed her window. But the game wasn't on for like 3 hours ... so who cares?
I drove out the back end of the parking lot. The girl had driven out the front end, and so she passed me on the street as I was waiting to leave. She saw me again ... and she looked pretty fearful. I think she felt really really bad for being stupid. She had her hand covering her mouth, and although I couldn't see clearly into her vehicle ... I think she might even have been crying about it. Now I felt bad. How does that work? Girl is an idiot, can't park, blocks me from getting into my car, I don't even care about it ... really I don't, she feels bad about being and idiot and starts crying, and I feel bad about her feelings? I guess I'm just too nice ;-)
I can't believe the Riders lost against B.C tonight!
ΒΆ 2:24:00 AM
The installation itself is slick as a greased slip n' slide. I don't like windows at all, but I wanted to try this out. It will bennefit me a great deal to be able offer this as a solution to potential clients if they have windows requirements.
So ... the installation is a typical windows installation. It creates a user for the PG superuser, and sets everything up. Part of the installation process is a selection of all available contrib pacakes (including tsearch2). Just a simple click of a checkbox and you are on you way. :-) So the installation is _very_ easy.
It still comes with all of the regular PG command line utilities (createdb, pg_dump, psql etc). It will also install pgAdminnIII for you. I have started using that a little bit on windows, but I found myslef still going back to the command line. This posed some difficulties on my part. I'm too used to a good operating system like any *nix based OS. I ended up writing batch files for ls.bat, cp.bat and will most likely continue to do so to avaoid smacking my computer screen every time I forget to type dir in a DOS command prompt.
I installed vim, of course, and I am currently looking for some other kind of console programs for windows. I seem to be out of luck. cmd.exe it is ... and man does that thing suck. I took me _forever_ to figure out how to do simple things like add a directory to the $PATH variable, or turn on tab completion. BTW ... there is character completion in the DOS window, it's default key just happens to not be tab. I don't understand that ... and It really bothers me that simple things like that have to be configured in the regitry. @#!@#! windows.
I got an email about my tsearch2 intro documentation. Someone had a problem installing tsearch2 following the steps because the user they were installing as did not have superuser privileges and therefore could not install functions with language 'C" (it's not a trusted language).
I started walking through my documentation. I've had some additions on the back burner for the last few months. I asked Oleg what he would like to see added to the docs. I'm also going to run through everything on my new PG windows installation. I figure there will be some new additions based on my playing around. I'll let everyone know when a new edition is out.
I went to Safeway earlier today. I ran in to get a couple of things to make an awesome chicken taco salad. When I came out I put the bag in the passenger seat. Then when I went around to the driver to to get in I couldn't. The owner of a new acura SUV had parked not only crooked in their spot, but angled accross the lines into my spot. I'm a big guy to begin with, but I could only manage to open the car door enough to have about 4 inches of space between the door and the seat. Paris Hilton couldn't even squeeze into my car ... that's how bad this was.
So I leaned up against the trunk of my car. I decided this was the most opportune time to have a cigarette. So I smoked, and watched the passers by in a busy parking lot. All giving me strange looks as this wierd guy just "hanging out" in the Safeway parking lot. After about 10 minutes of sitting there I heard a click click of the SUV automatic doors unlocking. An rather cute girl was walking toward me. She too looked at me kind of wierd, and got into her truck, started it up and backed out ... slowly ... really slowly as to not hit my car. So I then proceeded to get into my car.
Around this point in time I think she must have realized what had happened. This girls was an idiot, and parked so close to me that I couldn't even open my door to get into my car. My door was was still open, and she rolled down the window and was apologizing profusley. I just turned my head and waved. I really didn't care about standing outside for a few minutes. If people flipped out over losing 15 minutes of a saturday afternoon ... you've got some issuses. Now if I had been mising the Roughriders game because of this I probably would have keyed her shiny new van, and smashed her window. But the game wasn't on for like 3 hours ... so who cares?
I drove out the back end of the parking lot. The girl had driven out the front end, and so she passed me on the street as I was waiting to leave. She saw me again ... and she looked pretty fearful. I think she felt really really bad for being stupid. She had her hand covering her mouth, and although I couldn't see clearly into her vehicle ... I think she might even have been crying about it. Now I felt bad. How does that work? Girl is an idiot, can't park, blocks me from getting into my car, I don't even care about it ... really I don't, she feels bad about being and idiot and starts crying, and I feel bad about her feelings? I guess I'm just too nice ;-)
I can't believe the Riders lost against B.C tonight!
ΒΆ 2:24:00 AM
