[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 que

[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 h

[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 postgre

[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 d