Re: [GENERAL] how to query against nested hstore data type

2014-08-24 Thread Huang, Suya
-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Huang, Suya Sent: Monday, August 25, 2014 12:18 PM To: Peter Geoghegan Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] how to query against nested hstore data type

Re: [GENERAL] how to query against nested hstore data type

2014-08-24 Thread Huang, Suya
-Original Message- From: Peter Geoghegan [mailto:peter.geoghega...@gmail.com] Sent: Monday, August 25, 2014 12:14 PM To: Huang, Suya Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] how to query against nested hstore data type On Sun, Aug 24, 2014 at 7:05 PM, Huang, Suya wrote: >

Re: [GENERAL] how to query against nested hstore data type

2014-08-24 Thread Peter Geoghegan
On Sun, Aug 24, 2014 at 7:05 PM, Huang, Suya wrote: > It’s my test DB, the version is PostgreSQL 9.4beta2. I’m testing with nested > hstore feature. Really? Nested hstore only made it into that version as jsonb, which you're clearly not using here. -- Regards, Peter Geoghegan -- Sent via pg

[GENERAL] how to query against nested hstore data type

2014-08-24 Thread Huang, Suya
Hi, It's my test DB, the version is PostgreSQL 9.4beta2. I'm testing with nested hstore feature. testdb=# \d+ test Table "public.test" Column | Type | Modifiers | Storage | Stats target | Description ++---+--+--+

Re: [GENERAL] How to insert either a value or the column default?

2014-08-24 Thread Adrian Klaver
On 08/24/2014 11:50 AM, Daniele Varrazzo wrote: On Sat, Aug 23, 2014 at 7:10 PM, W. Matthew Wilson wrote: I have a table that looks sort of like this: create table tasks ( task_id serial primary key, title text, status text not null default 'planned' )

Re: [GENERAL] How to insert either a value or the column default?

2014-08-24 Thread Daniele Varrazzo
On Sat, Aug 23, 2014 at 7:10 PM, W. Matthew Wilson wrote: > I have a table that looks sort of like this: > > create table tasks > ( > task_id serial primary key, > title text, > status text not null default 'planned' > ); > > In python, I have a function like th

Re: [GENERAL] Failure to load plpgsql.so

2014-08-24 Thread Tom Lane
Matthew Pounsett writes: > I’m in the process of installing mediawiki, and ran into this error while it > was setting up the database: > • Query: > CREATE FUNCTION page_deleted() RETURNS TRIGGER LANGUAGE plpgsql AS $mw$ BEGIN > DELETE FROM recentchanges WHERE rc_namespace = OLD.page_names

[GENERAL] Failure to load plpgsql.so

2014-08-24 Thread Matthew Pounsett
I’m in the process of installing mediawiki, and ran into this error while it was setting up the database: • Query: CREATE FUNCTION page_deleted() RETURNS TRIGGER LANGUAGE plpgsql AS $mw$ BEGIN DELETE FROM recentchanges WHERE rc_namespace = OLD.page_namespace AND rc_title = OLD.page_tit

Re: [GENERAL] How to insert either a value or the column default?

2014-08-24 Thread Adrian Klaver
On 08/23/2014 11:10 AM, W. Matthew Wilson wrote: I have a table that looks sort of like this: create table tasks ( task_id serial primary key, title text, status text not null default 'planned' ); In python, I have a function like this: def insert

Re: [GENERAL] ERROR: Problem running post install step

2014-08-24 Thread Adrian Klaver
On 08/24/2014 09:18 AM, Brodie S wrote: This issue may have been resolved. I have yet to encounter any of those issues with SMB. For what it's worth, I just tried connecting to the share with AFP and running the installer. Same result For what its worth, the tips say to use CIFS to force the o

Re: [GENERAL] ERROR: Problem running post install step

2014-08-24 Thread Brodie S
This issue may have been resolved. I have yet to encounter any of those issues with SMB. For what it's worth, I just tried connecting to the share with AFP and running the installer. Same result On Sun, Aug 24, 2014 at 10:12 AM, Adrian Klaver wrote: > On 08/23/2014 04:07 PM, Brodie S wrote: >>

Re: [GENERAL] ERROR: Problem running post install step

2014-08-24 Thread Adrian Klaver
On 08/23/2014 04:07 PM, Brodie S wrote: I'm using Unraid and SMB Are you aware of the Mavericks issues with SMB?: http://hints.macworld.com/article.php?story=20131122083837447 http://www.macwindows.com/mavericks-filesharing.html -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsq

Re: [GENERAL] pgbouncer setup in the architecture

2014-08-24 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > I'd like to use pgbouncer as connection pooler in our productive > environment, which consists of six master db server plus 6 slaves and many > webserver and services. For example, I'd like to use it as a central point > from where I can redir