[GENERAL] provide pg_get_notifications()

Hi, Please provide a pg_get_notifications() function (or similar) as a complement to pg_notify(). Currently, in java jdbc, the clients must poll for notifications using getNotifications() method in org.postgresql.PGConnection. So, clients must obtain a reference to connection object and cast it

[GENERAL] custom system catalog table names

Hi, How can one create a postgres build with custom system table names? For example, instead of pg_class, I'd like to name the table as foobar_class. Or instead of pg_catalog, foobar_catalog. I don't care about compatiblity with pgadmin, jdbc drivers, etc. I'd be happy just as long as I have a

[GENERAL] writing a plpgsql query for the first time

Hi, I am having trouble writing my first plpgsql query. Any idea why the following plpgsql does not work?? test=# drop function if exists testfunc() ; DROP FUNCTION test=# create function testfunc() test-# returns table (id int, code char(1)) as $$ test$# BEGIN test$# return

[GENERAL] heap-only tuples, and constraints

Hi, Question about heap-only tuples, and constraint checking. Does this statement (UPDATE user SET email='newChangedVal', password='existingVal') requires updating an index on user.password? Or more generally, if an UPDATE includes an explicit but unchanged value for an index column, does