It all started with a help request from a someone on IRC: he has about 2500 roles, and all of them have been granted USAGE privileges on a schema. He went on to create a bunch more and grant the same privilege, but it failed:

CREATE ROLE some_user_2501;
GRANT USAGE on schema genetics to some_user_2501;

ERROR:  row is too big: size 8168, maximum size 8164

Oops.

Now, let this be …

It is 21 days to PostgreSQL Conference East (#PgEast), which is set once again to break attendance records of all the western world conferences. Hosted in NYC, we have large number of sessions, over 60 speakers, a full day of trainings, an excellent NYCPug meeting at the event, and an excessive number of sponsors (nahh... we need 3x more, sponsors ROCK!). I am truly humbled at the amazing level of …

I have been disappointed for a long time with the way PL/Perl handles array arguments. For example, let's consider a simple Perl function that takes a value and a list and checks whether the value is present in the list.

CREATE FUNCTION check_values
{
    my $val = shift;
    my $aref = shift;
	
    foreach (@$aref) {
        return true if $val eq $_ 
    }
    return false;
}

A practical use for this …

That's right folks, the PostgreSQL Conference East has listed 98% of its talks. We have a lot of great talks, mini-tutorials and trainings.

A simple agenda follows:

• March 22nd is training day.
  Trainings range from 199.00 to 349.00 depending on half or full day.
• March 23rd - 25th is the conference.
  The registration is 249.00

  In particular I am interested to see how Four Square is using MongoDB and …

Alright folks, last call. It is beer thirty. CFP closes today. Let's get those talks in:

Submit Talk to PgEast

Alright slackers, you know who you are. The constant presence at every conference. The speaker, that submits their talk at 11:59PM before the CFP closes, I am talking to YOU! In three days, the CFP for what is going to be the largest PostgreSQL Conference in the Western World to date (I say Western because JPUG kicks U.S. butt in attendance just at their user meetings alone), is going to …

I was surprised at first too but I have been talking to quite a few community members for MongoDB and due to the positive responses, PostgreSQL Conference East is going to be host to the excellent MongoDB community.

JD, Why would you do this? Why do we care? We are relational, they -- well I don't know what they are.

One of the goals of The PostgreSQL Conference Series is …

In my quest to insure an incredible turnout for PostgreSQL Conference, I contacted the MySQL meetup group in NYC. Of course my reasons were simple, I want MySQL people to show up and see the value of PostgreSQL. However, I learned a couple of new things.

• There is a PHP framework called Vork that supports PostgreSQL.
• Ed Boyajian of EnterpriseDB (the new Drupal Enterprise PostgreSQL Company) gave a …

A week ago, I submitted my patch to fix the foreign key lock problem. What I propose is almost exactly what was described in my previous blog posts, with a couple of differences.

The first is that I decided to only check unique indexes, not all indexes. This is good because you can have other indexes for performance and they will not affect locking for foreign keys. I noticed that …

January 18th, 2011: Celebrating 15 years of PostgreSQL, early.

That's right folks, it is time for second call. Content is being submitted steadily. At PgWest last year, we received well over our capacity of content and we would like to keep that trend going.

The PostgreSQL Conference for Developers,End Users and Decision Makers, is being held at the Hotel Pennsylvania,in New York City from March 22nd through 25th 2011. Please …