The PostgreSQL User Group Germany is giving a talk and a workshop at the Open Source Day 2008 October 11 in Magdeburg/Germany.
The PostgreSQL User Group Germany is giving a talk and a workshop at the Open Source Day 2008 October 11 in Magdeburg/Germany.
I want to drop a ROLE (previously USER/GROUPs) which is still referenced by object(s) in my database. But PostgreSQL has objections:
In a customer project I have to setup a database from a Makefile. Part of my problem: on Windows the installer may or may not install plpgsql into template1, therefore in consequence this language may or may not be activated in every new database. But that’s not predictable. This problem can appear on different Linux/Unix distributions too.
FOSDEM 2008 in Brussels is a smashing success. As you remember we have a shared devroom together with the BSD projects. So far it seems we are one of the few devrooms who have a full schedule for both days - some other projects (who particulary got a bigger devroom) only had talks for one day or worse.
For FOSDEM, I ordered a new set of blue plush elephants. The parcel arrived today and this time I not only got the usual 18cm stuffed toys, I also got 2 which are 60cm height. Anyone interested? ;-)
As announced back in December, the PostgreSQL Group has a developer room at FOSDEM 2008 in Brussels, together with the BSD team.
If you use pure PHP (no database abstraction layer) with PostgreSQL, you may run into the problem that your BOOLEAN columns are not recognized by PHP but the value is instead returned as a string.
I have seen this question more than once in the past: “How much storage space do I need for my table?”
PostgreSQL can give you this information.
Together with BSD we will have a Developer Room at FOSDEM 2008.
Because I always forget how to stop psql on the first error:
| |
You can include this at the top of your script/file, psql will stop right after the first error and will not try to continue any other commands in the chain.