Re: [GENERAL] Can pg_restore produce create or replace commands

2015-01-17 Thread Adrian Klaver
On 01/17/2015 10:05 AM, Berend Tober wrote: I often work with the output of pg_restore from a custom format dump file. For example a file produced by running pg_restore -s -1 -L listfile dumpfile where listfile has been edited to comment out most of the rows to leave only the data base objects

Re: [GENERAL] Can pg_restore produce create or replace commands

2015-01-17 Thread Thomas Kellerer
Berend Tober wrote on 17.01.2015 19:05: I often work with the output of pg_restore from a custom format dump file. For example a file produced by running pg_restore -s -1 -L listfile dumpfile where listfile has been edited to comment out most of the rows to leave only the data base objects I'm

[GENERAL] Can pg_restore produce create or replace commands

2015-01-17 Thread Berend Tober
I often work with the output of pg_restore from a custom format dump file. For example a file produced by running pg_restore -s -1 -L listfile dumpfile where listfile has been edited to comment out most of the rows to leave only the data base objects I'm currently interested in. Most often,

Re: [GENERAL] Can pg_restore produce create or replace commands

2015-01-17 Thread Berend Tober
Adrian Klaver wrote: On 01/17/2015 10:05 AM, Berend Tober wrote: I often work with the output of pg_restore from a custom format dump file. ... Most often, I'm refactoring functions and so don't really want to drop the function but rather want to do a create or replace function... Not sure

Re: [GENERAL] Can pg_restore produce create or replace commands

2015-01-17 Thread Adrian Klaver
On 01/17/2015 10:05 AM, Berend Tober wrote: I often work with the output of pg_restore from a custom format dump file. For example a file produced by running pg_restore -s -1 -L listfile dumpfile where listfile has been edited to comment out most of the rows to leave only the data base objects

Re: [GENERAL] Can pg_restore produce create or replace commands

2015-01-17 Thread Berend Tober
Adrian Klaver wrote: On 01/17/2015 10:05 AM, Berend Tober wrote: I often work with the output of pg_restore from a custom format dump file... Most often, I'm refactoring functions and so don't really want to drop the function but rather want to do a create or replace function... I am not

Re: [GENERAL] Can pg_restore produce create or replace commands

2015-01-17 Thread Berend Tober
Thomas Kellerer wrote: Berend Tober wrote on 17.01.2015 19:05: I often work with the output of pg_restore from a custom format dump file. ... Most often, I'm refactoring functions and so don't really want to drop the function but rather want to do a create or replace function ... To me this

Re: [GENERAL] WAL supported extension

2015-01-17 Thread Michael Paquier
On Sat, Jan 17, 2015 at 11:18 PM, Kouhei Sutou k...@cozmixng.org wrote: (Is this mailing list right mailing list for asking this question...?) Hackers would have been fine as well. Is there any plan to implement PostgreSQL API to implement WAL supported extension? Not that I know of, the last

[GENERAL] Alternatives to a unique indexes with NULL

2015-01-17 Thread Peter Hicks
All, I have a Rails application on 9.3 in which I want to enforce a unique index on a set of fields, one of which includes a NULL-able column. According to http://www.postgresql.org/docs/9.3/static/indexes-unique.html, btree indexes can't handle uniqueness on NULL columns, so I'm looking

Re: [GENERAL] Alternatives to a unique indexes with NULL

2015-01-17 Thread John McKown
On Sat, Jan 17, 2015 at 6:27 AM, Peter Hicks peter.hi...@poggs.co.uk wrote: All, I have a Rails application on 9.3 in which I want to enforce a unique index on a set of fields, one of which includes a NULL-able column. According to

Re: [GENERAL] Alternatives to a unique indexes with NULL

2015-01-17 Thread Peter Hicks
Hi John On 17/01/15 12:39, John McKown wrote: ​I read the above. As I understand it, you can have a unique index on a column which is NULL-able. That will guarantee that all the non-NULL values are unique. What it will not guarantee is that there will be at most one NULL value in the indexed

Re: [GENERAL] Alternatives to a unique indexes with NULL

2015-01-17 Thread Andreas Kretschmer
Peter Hicks peter.hi...@poggs.co.uk wrote: All, I have a Rails application on 9.3 in which I want to enforce a unique index on a set of fields, one of which includes a NULL-able column. According to http://www.postgresql.org/docs/9.3/static/indexes-unique.html, btree indexes can't

[GENERAL] WAL supported extension

2015-01-17 Thread Kouhei Sutou
Hi, (Is this mailing list right mailing list for asking this question...?) Is there any plan to implement PostgreSQL API to implement WAL supported extension? Background: I'm writing an extension(*) that provides index module for CJK ready fast full-text search feature. (*) PGroonga: