Friday, November 03, 2006

While Creating database

Please remeber that while designing your database in postgresql using pgAdmin give UTF8 encoding,, it is easy to test your queries in pgAdmin client. Otherwise you have to give always table name in double quotes

for eg. select * from "table"

Error in Database query

There was a problem while using postgresql as backend, I can not execute the queries.
Later I understood the problem that I gave my table name as user and it is already a built in table in postgresql. So my friends never give table name those already there in database

Blog updating error

Hai friends, few days before we are not able to update our blog, becuase some error occured while updating. We recovered the problem by rollbacking our blog. We already stored a backup of our previous posts..