> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of Tom Lane
> Sent: Monday, December 24, 2012 9:34 PM
> To: David Johnston
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] "?" hstore operator broken in 9.2?
On 12/24/2012 6:33 PM, Tom Lane wrote:
"David Johnston" writes:
>When I execute the following query:
>SELECT 'a=>1'::hstore ? 'a'::text
FWIW, works fine for me.
>I get an "Input parameter count is less then expected" error message.
I can't find such a message (or indeed anything mentioning
"David Johnston" writes:
> When I execute the following query:
> SELECT 'a=>1'::hstore ? 'a'::text
FWIW, works fine for me.
> I get an "Input parameter count is less then expected" error message.
I can't find such a message (or indeed anything mentioning "parameter
count") anywhere in the Postg
On 12/24/2012 4:45 PM, David Johnston wrote:
SELECT 'a=>1'::hstore ? 'a'::text
fwiw, this works for me...
select hstore 'a=>1' ? 'a';
'something'::SOMETYPE is a type cast operation, while SOMETYPE
'something' is a constant of SOMETYPE. I didn't bother to cast 'a' to
text as 'a' *is* t
Hi,
When I execute the following query:
SELECT 'a=>1'::hstore ? 'a'::text
I get an "Input parameter count is less then expected" error message.
SELECT defined('a=>1'::hstore, 'a'::text) -- works
I have tried on Linux Ubuntu (9.2.1) and Windows 7 (9.2.2) machines.
My knowle
Tom,
Thanks a lot! For some reason, I was under the impression that contrib
would include python. the --with-python switch did the trick.
Best regards
Seref
On Mon, Dec 24, 2012 at 9:35 PM, Tom Lane wrote:
> Seref Arikan writes:
> > After building postgresql from the git repository, I've tried
On 12/24/2012 01:24 PM, Seref Arikan wrote:
Greetings,
After building postgresql from the git repository, I've tried to create
a db that I have, and I've faced the exact same problem described here:
http://archives.postgresql.org/pgsql-general/2012-02/msg00753.php
Basically, the extension directo
Seref Arikan writes:
> After building postgresql from the git repository, I've tried to create a
> db that I have, and I've faced the exact same problem described here:
> http://archives.postgresql.org/pgsql-general/2012-02/msg00753.php
> Basically, the extension directory does not contain plpytho
Greetings,
After building postgresql from the git repository, I've tried to create a
db that I have, and I've faced the exact same problem described here:
http://archives.postgresql.org/pgsql-general/2012-02/msg00753.php
Basically, the extension directory does not contain plpythonu.control. I've
bu
Michael Arnold writes:
> Thanks Tom, but no luck this time: both boxes now on Ubuntu 12.10, but
> same error.
Hm. Are they using identical locale settings? Can you extract a
self-contained test case?
It's still a glibc bug AFAICS, but without a test case you'll not likely
get any traction repo
Sent from my iPad
On 24-Dec-2012, at 17:15, Georges Racinet wrote:
> On 12/24/2012 12:32 PM, John R Pierce wrote:
>> On 12/24/2012 2:43 AM, Georges Racinet wrote:
>>> Make sure both servers aren't running at the same time
>>
>> why? its perfectly OK to ahve severla postgres servers running at
Dear all,
I am having issues with defining a service to start pg_ctl on a Windows
server 2003 machine and accessing a data directory stored on a network
drive.
I have well noted the suggestion of creating an unprivileged user to start
the service
(http://archives.postgresql.org/pgsql-general/2
Thanks Tom, but no luck this time: both boxes now on Ubuntu 12.10, but
same error.
Also removed -march gcc switch, likewise with no impact on error.
Kind regards,
Michael From: Tom Lane
Sent: 24/12/2012 1:16 AM
To: Michael Arnold
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Insert Asse
On 12/24/2012 12:32 PM, John R Pierce wrote:
> On 12/24/2012 2:43 AM, Georges Racinet wrote:
>> Make sure both servers aren't running at the same time
>
> why? its perfectly OK to ahve severla postgres servers running at
> once, as long as they are on different port numbers. I generally use
> 543
On 12/24/2012 2:43 AM, Georges Racinet wrote:
Make sure both servers aren't running at the same time
why? its perfectly OK to ahve severla postgres servers running at once,
as long as they are on different port numbers. I generally use 5432,
5433, 5434, etc for this. mostly for developmen
On Mon, Dec 24, 2012 at 4:13 PM, Georges Racinet wrote:
> On 12/24/2012 08:50 AM, Atri Sharma wrote:
>> I have two 9.2 servers running in different data directories and
>> installation directories. One of them(the main one) has its bin in the
>> path of my system.The other one does not, hence, I n
On 12/24/2012 08:50 AM, Atri Sharma wrote:
> I have two 9.2 servers running in different data directories and
> installation directories. One of them(the main one) has its bin in the
> path of my system.The other one does not, hence, I need to use the
> complete path(/usr/local/pgsql/...).
>
> I wa
I'm sorry my first example was incomplete
I need to migrate data from postgresql to oracle
thus I have to use
dump --column-inserts instead of copy
to have an output like this but order by pk:
INSERT INTO test (id, note, id_father) VALUES (6, 'Homer Simpson ', 5);
INSERT INTO test (id, note, id_f
18 matches
Mail list logo
