Hi.
i use postgresql 9.6.3.
I have made a small graph with nodes and edges. Each edge has a distance
numeric (7,3) attribute.
when i create a recursive query and try to add the distances i get a message:
ERROR: recursive query "edges" column 3 has type numeric(7,3) in non-recursive
term but
Den tors 2017-08-03 skrev k b <k_b0...@yahoo.se>:
Ämne: cast issue in WITH RECURION
Till: pgsql-general@postgresql.org
Datum: torsdag 3 augusti 2017 20:22
Hi.
i use postgresql 9.6.3.
I have made a small graph with nodes
and edges. Eac
> when i
create a recursive query and try to add the distances i get
a message:
> ERROR: recursive query
"edges" column 3 has type numeric(7,3) in
non-recursive term but type numeric overall.
> My exercise is almost
identical to the example in the docs:
>
WITH RECURSIVE
> when i
create a recursive query and try to
add the distances i get
a message:
> ERROR: recursive query
"edges" column 3 has type numeric(7,3)
in
non-recursive term but type numeric
overall.
> My exercise is almost
identical to the example in the docs:
>
WITH RECURSIVE
Hi,
We are planning to use Postgres 9.1 in our commercial product having a coldfire
m68k architecture based controller on Linux platform.
Since ready installer was not present for this architecture, we cross compiled
the source code and it is working fine now, though we are yet to do
licensing of Postgresql
On 12/05/11 12:23 AM, Jayashankar K B wrote:
Now we have a doubt about licensing.
What is the licensing process if we want to use postgresql with our
proprietary software?
Could anyone please throw some light on this ?
very simple.
PostgreSQL Database Management
Hi,
Is there a ready postgres 9.1 Package for the i.MX51X processor (ARM Cortex
architecture) available or do I need to compile the Postgres source myself ?
I need it for a board having the i.MX51 processor and Linux (one of the latest
versions of kernel - yet to decide the exact version).
If I
Hi,
Anybody with any ideas on using Postgres on ARM CORTEX A8 based processors.. ?
Thanks!
Jay
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Jayashankar K B
Sent: 16 February 2012 PM 04:00
To: pgsql-general@postgresql.org
Subject: [GENERAL
Hi,
Is there a ready postgres 9.1 Package for the i.MX51X processor (ARM Cortex
architecture) available or do I need to compile the Postgres source myself ?
I need it for a board having the i.MX51 processor and Linux (a variant of
Debian distribution based on Linux kernel 2.6.35).
If I need to
Hi All,
I am trying to compile Postgres Source code for ARM cortex A8 architecture.
While compiling, I got an error message which read selected processor does not
support `swpb r4,r4,[r3]'
One of the Postgres forums at the location
and Regards
Jayashankar
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: 24 February 2012 AM 09:20
To: Jayashankar K B
Cc: pgsql-general@postgresql.org; pgsql-performa...@postgresql.org
Subject: Re: [PERFORM] Disable-spinlocks while compiling postgres 9.1 for ARM
Cortex A8
know what I am doing wrong and what I should be doing.
Thanks and Regards
Jayashankar
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: 24 February 2012 AM 09:20
To: Jayashankar K B
Cc: pgsql-general@postgresql.org; pgsql-performa...@postgresql.org
Subject: Re: [PERFORM
Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: 25 February 2012 PM 12:54
To: Jayashankar K B
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Re: [PERFORM] Disable-spinlocks while compiling postgres
9.1 for ARM Cortex A8
Jayashankar K B jayashankar...@lnties.com writes:
I tried
Hi All,
Could anyone explain me the significance of the following compile time
parameters ?
1. --disable-integer-datetimes
2. --disable-float4-byval
3. --disable-float8-byval
Do they have any effect on performance of postgres w.r.t speed of database
insert/select, amount of CPU
Hi,
We are using Postgres 9.1.1 on a board with Coldfire controller.
The postgres processes are crashing and restarting upon executing a particular
instruction and it keeps repeating. Even when we tried with Postgres 9.1.3,
same problem happens.
It works fine until the FINANCIALTRANSACTIONID
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Jayashankar K B
Sent: Tuesday, May 22, 2012 11:27 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Postgres process is crashing continously in 9.1.1
Hi,
We are using Postgres 9.1.1 on a board with Coldfire controller.
The postgres
: Re: [GENERAL] Postgres process is crashing continously in 9.1.1
On 05/21/12 11:05 PM, Jayashankar K B wrote:
board with Coldfire controller.
what is this board? Coldfire is the embedded 68k-like Freescale processor?
what operating system is this under? what sort of storage does
...@postgresql.org] On Behalf Of Chris Angelico
Sent: Tuesday, May 22, 2012 3:10 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Postgres process is crashing continously in 9.1.1
On Tue, May 22, 2012 at 4:51 PM, Jayashankar K B jayashankar...@lnties.com
wrote:
On writing into this table
Hi,
We are facing one database crash issue because of stored procedures.
When the stored procedure with a set of values is executed the first time, it
works fine.
If the same stored procedure is executed with same set of values once more, the
database crashes with the error
WARNING:
19 matches
Mail list logo