life.i.think: I <3 postgresql

I <3 postgresql
Scribbled on May 17th. 0 comments.

I sat down on ‘fred,’ the server this is now running on, today to set typo up w/ pg and ran into a small hitch. Make sure you run initdb on your /data directory (pg_dump if you already have stuff in there!). Specifically, rails complaines about the lack of information_schema, and a ’\du’ in psql returns an error.

I think I’ve mentioned that I’m forced to use sqlserver at work for some rails projects I’m doing. I guess it’s good that at least one more person is hammering down on the db adapter (making a total of about 4!).

Fixed nil datetimes in the adapter today, which coincidentally fixed problems with using updated_at.

If you use sqlserver you can test with this patch. (ticket)

UPDATE: I’ve changed the link to the new patch here. I’ve now taken out all typecasting being overriden in the sqlserver adapter, so it should be inhereting the method from abstract_adapter.rb. This seems to work fine … kinda scary though because I can’t see any reason why it was originally done. Mabye problems in old abstract_adapter code?

Comments

Leave a response

Comment