[GENERAL] cached row type not invalidated after DDL change

for the open session after the first insert. Database sessions that didn’t issue an insert on the old structure don’t have that problem. I could reproduce this behavior in postgres 9.4.3, 9.4.1 and 9.4.0  regards Manuel Kniep

Re: [GENERAL] Partitioning and ORM tools

DELETE FROM ONLY master WHERE id = NEW.id returning * into r; RETURN r; END; $$ LANGUAGE plpgsql; Returning the inserted row here also solves the problem that ORM often need auto increment values back. regards Manuel Kniep

Re: [GENERAL] Partitioning and ORM tools

DELETE FROM ONLY master WHERE id = NEW.id returning * into r; RETURN r; END; $$ LANGUAGE plpgsql; Returning the inserted row here also solves the problem that ORM often need auto increment values back. regards Manuel Kniep

[GENERAL] PG_RETURN_UINT16

Hi, I’m missing a PG_RETURN_UINT16 macro. As we have PG_RETURN_UINT32 and also PG_GETARG_UINT16 is there any reason why there is no PG_RETURN_UINT16 ? cheers Manuel -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postg

[GENERAL] ALTER TYPE ADD SEND AND RECEIVE

I have a custom type and want to add the yet missing  SEND and RECEIVE functions is there anyway to alter the type definition without dropping and recreating it? Manuel

Re: [GENERAL] ALTER TYPE ADD SEND AND RECEIVE

On 11. Dezember 2014 at 00:08:52, Tom Lane (t...@sss.pgh.pa.us) wrote: > Manuel Kniep writes: > > I have a custom type and want to add the yet missing SEND and RECEIVE > > functions > > is there anyway to alter the type definition without dropping and > > recr

[GENERAL] unexpected external sort Disk

Hello, I have table with 37 million entries the whole table has a size of 2.3 GB Although I have set the work_mem to 10 GB I see the an unexpected external sort Disk in Explain Analyze for around 650MB of data EXPLAIN ANALYZE SELECT application_id, price_tier FROM application_prices orde

[GENERAL] table inheritance and locks

Hi, If I aquire a lock on table B which is inherited from table A, Table A seems to be also locked (postgres 9.2). Is there a way to get around it ? I couldn't find any information about this behavior in the documentation. Thanks Manuel Kniep -- Sent via pgsql-general mailing list (

[GENERAL] is there a way to dump the version of extensions

Hi, when doing a pg_dump on postgres 9.2 the resulting sql file only has CREATE EXTENSION extension_name; I would like to include the specific version of the extension to make sure that the correct version is installed when loading the dump like CREATE EXTENSION extension_name VERSION vesion;