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
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
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 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 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
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
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
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
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
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
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
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
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
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
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
"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 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
> -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?
18 matches
Mail list logo
