14 Feb 2001 donky   » (Apprentice)

Have written down a basic set of SQL table creation commands and they are waiting for PostgresQL to become functional. The first step for that to happen is to get Python working with it.

  • PyGreSQL
    Looks like a good start. Was a really simple install, just hand compiled the shared object according to the "RedHat" instructions that are in the README.linux file - then copied it into the python1.5/lib-dynload directory.

  • mxDateTime
    Gives database safe dates and times or something. Yet to determine if it is of any use. Installed it anyway.

Well after spending several hours playing around with PostgreSQL, I have finally set up a user who can create tables within the database they "own". Well, upon a check just now, it appears not. Feh. Initially the problem was that I created my new database "whelkboard" while I was the "postgres" user. Then I was trying to access and then assign the database to the "wbuser" user. With no luck, there seemed to either be no way in PostgreSQL how to give "wbuser" the ability to create tables within it. So, I dropped the database and created it as "wbuser". This worked fine, and creating tables also worked fine - in psql that is.

But, that however, is about as much help as tits on a bull. What I really want is for the "pgdb" Python module to create tables as that user. I can get it to connect as that user to that database. I can execute the table creation statements on the database with the same output as seen in psql, but the statements don't seem to actually create the databases. Admittedly, I think "pgdb" is designed for PostgreSQL 6.5, but given that the messages coming back from the version I have are the same ones I see in psql, that seems to indicate that this isn't the problem. God knows what is.

Latest blog entries     Older blog entries

New Advogato Features

New HTML Parser: The long-awaited libxml2 based HTML parser code is live. It needs further work but already handles most markup better than the original parser.

Keep up with the latest Advogato features by reading the Advogato status blog.

If you're a C programmer with some spare time, take a look at the mod_virgule project page and help us with one of the tasks on the ToDo list!