[GENERAL] Function not inserting rows

2017-08-23 Thread Frank Foerster
Hi, i have the following question: Given an empty database with only schema api_dev in it, a table and a function is created as follows: CREATE TABLE api_dev.item_texts ( item_id integer, item_text text ) WITH ( OIDS=FALSE ); CREATE OR REPLACE FUNCTION api_dev.add_texts_to_item( p_it

[GENERAL] Is it possible to "pip" pg_dump output into new db ?

2014-03-25 Thread Frank Foerster
Hi, we are currently in the process of upgrading a production/live 1 TB database from 9.2 to 9.3 via pg_dump, which is quite a lengthy process. Fortunately we have a capable spare-server so we can restore into a clean, freshly setup machine. I just wondered wether the intermediate step of writin