> I have a very simple query that is giving me some issues due to the size of
> the database and the number of requests I make to it in order to compile the
> report I need:
>
> A dumbed down version of the table and query:
>
> CREATE TABLE a_to_b (
> id_a INT NOT NULL REFER
I have my own Python application using a PostgreSQL database over
SQLAlchemy.
Currently I pack the application in a deb-file.
After installation (on a fresh system! Ubuntu 14.04.2) it doesn't run
because of some PostgreSQL-settings.
Of course I understand why and I know (a little bit) which settin
Hi
I am not really an expert, but from your description I guess that you
assume an existing PostgreSQL installation on your customers' server. If
that is the case you probably won't get around giving instructions to
your customer and let them do the change. I would not like to install
applica
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Filipe Pina said:
> I really can't find any other solution for what I need (in short: make sure
> no transactions are left out due to serialization failures)
I think you may have been too quick to rule out advisory locks as a solution.
Yes, y
I don't understand the inconsistent behavior of the range types' upper
function in regard to inclusive ranges.
For example(s):
1. SELECT upper(int4range(1, 4, '[]')) = 4; -- FALSE
2. SELECT upper(int8range(1, 4, '[]')) = 4; -- FALSE
3. SELECT upper(numrange(1, 4, '[]')) = 4; -- TRUE
4. SELECT uppe
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
On 05/07/2015 19:13, Dane Foster wrote:
> I don't understand the inconsistent behavior of the range types'
> upper function in regard to inclusive ranges.
>
> For example(s): 1. SELECT upper(int4range(1, 4, '[]')) = 4; --
> FALSE 2. SELECT upp
Dane Foster writes:
> I don't understand the inconsistent behavior of the range types' upper
> function in regard to inclusive ranges.
The behavior is different for discrete vs. continuous ranges. For
example,
regression=# select int4range(1, 4, '[]');
int4range
---
[1,5)
(1 row)
re
On 07/05/2015 10:13 AM, Dane Foster wrote:
I don't understand the inconsistent behavior of the range types' upper
function in regard to inclusive ranges.
For example(s):
1. SELECT upper(int4range(1, 4, '[]')) = 4; -- FALSE
2. SELECT upper(int8range(1, 4, '[]')) = 4; -- FALSE
3. SELECT upper(numr
Thanks everyone. I understand now. The funny thing is I read the
documentation many weeks before actually using range types for the first
time but it didn't click that the documentation was describing the behavior
I was observing, until now.
Thanks again,
Dane
On Sun, Jul 5, 2015 at 1:33 PM, Ad
Hi,
I've got a function with 5 dblink select statement all to my local server
with the same connection string.
When one more dblink select statement is added the query fails.
Is there some kind of limit that I can configure? If so, which one an where?
Thanks,
Peter
On 2015-07-05 15:11 Charles Clavadetscher
wrote:
> I am not really an expert, but from your description I guess that you
> assume an existing PostgreSQL installation on your customers' server.
The application is a simple open source using a local PostgreSQL
database. The customer is just any use
On 7/5/2015 3:15 AM, c.bu...@posteo.jp wrote:
These are the modification I have to do to make my application run with
the connetion string "postgres://puser@localhost/FoobarTest".
The settings are about
the /etc/postgresql/9.3/main/pg_hba.conf file.
There I change this line
hostall
On July 5, 2015 08:58:17 PM c.bu...@posteo.jp wrote:
> On 2015-07-05 15:11 Charles Clavadetscher
>
> wrote:
> > I am not really an expert, but from your description I guess that you
> > assume an existing PostgreSQL installation on your customers' server.
>
> The application is a simple open sou
On 2015-07-05 15:13 Jan de Visser wrote:
> You could set up a whole new server with a different $PGDATA on a
> different port.
I (and the user) don't want to setup anything - that is the point.
> What I'm wondering though is what made you decide to use pgsql for
> your project? It seems to me th
Hi,
Below alarm was raised at the system where postgres database was used..
---
BGWPOL22-00:/var/opt/mediation/MMStorage6/Server8/CXC1734739_R8J/storage/logging/ACTIVE#
cat AA::80165730a!
1434
On 7/5/2015 9:43 PM, c.bu...@posteo.jp wrote:
But isn't there a way to use PostgreSQL without that setup and
configuration things?
no, not really, as its a generic database server meant to be used by
multiple applications across a network, with a wide range of
configuration options, plugins a
16 matches
Mail list logo
