Hi,
I have the following setup:
Database Local has a table L1
Database Remote has a table R1 and a table R2.
Table Remote.R1 has a trigger. This trigger updates Remote.R2
I create a foreign table F1 on Database local which points to Remote.R1
When updating F1 the trigger on Remote.R1
On 10/12/2015 03:59 PM, Jim Nasby wrote:
On 10/6/15 12:18 PM, Olivier Dony wrote:
We would happily skip the micro-transactions (as a perf workaround) if
there was a way to detect this situation, but we couldn't find a way to
do that in 9.3. <9.3 we used SELECT FOR UPDATE NOWAIT
On 10/05/2015 11:17 PM, Kevin Grittner wrote:
Jim Nasby wrote:
On 10/2/15 11:44 AM, Olivier Dony wrote:
On 10/02/2015 12:28 AM, Jim Nasby wrote:
On 9/29/15 9:47 AM, Olivier Dony wrote:
-- Setup tables
CREATE TABLE users ( id serial PRIMARY KEY,
name varchar
On 10/02/2015 12:28 AM, Jim Nasby wrote:
On 9/29/15 9:47 AM, Olivier Dony wrote:
My understanding of the KEY SHARE/NO KEY UPDATE locks introduced in 9.3
was that they would avoid side-effects/blocking between transactions
that are only linked via FK constraints, as long as the target PK was
not
ame = 'order of foo (2)',
user_id = 1
WHERE id = 1;
T1 fails with:
ERROR: could not serialize access due to concurrent update
CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."users" x WHERE "id"
OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF
is really difficult to understand what's going
on and, eventualy, modify my program to make my transactions run successfully
more often.
What is the correct way to suggest this improvement for a future version of
PostgreSQL ?
Regards.
Olivier.
De : pgsql-gener
he other connections involved in the failure.
The Postgresql wiki on SSI has no such information.
Thanks is advance.
Olivier.
for notifications on a channel. Have you any idea on such
implementation?
--
Olivier Chaussavoine
openbarter.org
A,A). Do you think this function get_rect_from_cap() could be usefull?
2013/8/11 Bruno Wolff III
> On Sat, Aug 10, 2013 at 12:18:48 +0200,
> Olivier Chaussavoine
> >
> wrote:
>
>> I did not found any geographic indexing with earthdistance, and need it.
>>
>
&
ave members
> from South Africa using a US zipcode - which is what ... 5000 miles off?
>
> Earthdistance is definitely easy to deal with - just give a
> latitude/longitude and off you go..
>
>
>
> Uwe
>
>
>
>
>
>
>
>
>
> On Fri, 08/09/2013
dans le répertoire « /home/olivier/ob/proj-4.8.0/src »
/bin/bash ../libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I.
-DPROJ_LIB=\"/usr/local/share/proj\" -DMUTEX_pthread -g -O2 -MT
jniproj.lo -MD -MP -MF .deps/jniproj.Tpo -c -o jniproj.lo jniproj.c
libtool: compile: gcc -DHAV
to adapt the circle type to a new type
'spherical cap' that would allow simple geographic indexing?
--
Olivier Chaussavoine
Hi John
It doesn't matter where the file is stored. I want to know if I can do some
processing like find similar photos or how many a given word appear in the
multimedia content ( e.g. an audio or video) using a query language such as
SQL.
Regards
Olivier
2013/7/27 John R Pierce
>
Hi,
Can SQL be used to retrieve data from multimedia content such as audio,
video, image, full text?
Regards
Olivier
output type of each column
and i want to avoid this, if possible.)
Thanks in advance,
--
Olivier
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ata of the new cluster is scattered
across two paths which is not what I expected.
> The only way is to change the code. It shouldn't be too hard, but is
> potentially dangerous.
Why dangerous ? It could be an option.
Regards,
--
Olivier LEVESQUE
--
Sent via pgsql-general mailing li
de translate the location to one in
the new cluster data directory (PGDATA), i.e.
/pgqdata/pgserver02/data/tbs_ptest
Does anyone know a possible workaround for this problem ?
Thank you.
--
Olivier LEVESQUE
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to y
e per
user" and "one schema per user in the same database".
What is the best practice here ? Which solution will be the easiest to
manage ?
Cheers,
Olivier
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
our help !
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: mardi 13 mars 2007 16:57
To: Olivier Ceulemans
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] More information on how to understand table
pg_locks.
"Olivier Ceulemans" <[EMAIL PROTECTED]> wri
Hi All,
I wrote an application making 'advanced' use of transactions. The
application is not tied to a specific kind of database. It runs fine on
oracle, db2, sql server but I run into a deadlock on postgresql.
I have two transactions (let's say A & B). These two transactions are
initiated by t
why? How can I do to make postgresql to work only with the tuples
resulting from the join conditions? Is it a configuration problem ?
Thanks in advance for any help.
--
Olivier Sirven
Elma Ingénierie Informatique
3, rue d'Uzès
F-75002 - Paris - France
http://www.elma.fr
Tel: +33
Hi,
I'm trying to list views, eliminating internal ones from the output.
Using 7.2, I found this simple statement :
SELECT viewname FROM pg_views WHERE viewname !~ '^pg_';
It works fine, ignoring 23 pg_* tables. And I get my actual views returned.
But, with 7.4, I get many (about 30) more system
escaping function?
What about writing nessus plugin(s) or a specific scanner for these
escaping issues ? I don't know if a such thing already exists...
--
Olivier
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
How to drop a table and it's sequence(s) automaticaly ?
Is there any way to find all sequence of a table with a query (without \d) ?
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail comma
o obtain a 1 in this case)
Is it possible to disting the two types of error ?
thanks,
Olivier chapiteau
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
:
_ a server Postgresql
_ my workstation
I want to install the minimum configuration under the Postgresql server.
On my workstation, I installed pgaccess and would like to connect to
server and design databases.
The server and the workstation are under the OpenBSD OS.
Do I need X-client on my server ?
Thanks.
Olivier
y simple applications done.
Could anyone give me help on the requirements for pgaccess use or where
I can read documentation on it ?
Thanks in advance.
Olivier.
27 matches
Mail list logo
