Moshe Jacobson wrote:
Is there a way to rename an installed extension?
I have written an extension, but I don't like the name I originally chose,
and I would therefore like
to rename it. However, it is installed on a production system, from which it
cannot be uninstalled,
and I would
On Thu, Aug 29, 2013 at 2:44 PM, Tatsuo Ishii is...@postgresql.org wrote:
I have a question about hot_standby_feedback parameter. In my
understanding, if this parameter is on, a long running transaction on
standby will not be canceled even if the transaction conflicts.
As you can see vacuum
Hello all.
I am curious about the following usage of CTEs:
Imagine three tables:
* item (id, item_type1_id, item_type2_id, ...)
* item_type1 (id, ...)
* item_type2 (id, ...)
where
* item_type1_id is FK to item_type1 (id)
* item_type2_id is FK to item_type2 (id)
Items are of two types
On 16 September 2013 11:58, Ladislav Lenart lenart...@volny.cz wrote:
Hello all.
I am curious about the following usage of CTEs:
Imagine three tables:
* item (id, item_type1_id, item_type2_id, ...)
* item_type1 (id, ...)
* item_type2 (id, ...)
where
* item_type1_id is FK to
On 16.9.2013 13:26, Alban Hertroys wrote:
On 16 September 2013 11:58, Ladislav Lenart lenart...@volny.cz wrote:
Hello all.
I am curious about the following usage of CTEs:
Imagine three tables:
* item (id, item_type1_id, item_type2_id, ...)
* item_type1 (id, ...)
* item_type2 (id, ...)
Nevermind, I already found the root cause of my problem: boolean logic of NULL
in conjunction with the NOT IN operator. My real usecase was a bit more
involved:
WITH
items_to_delete AS (
SELECT
item.id AS item_id,
item.item_type1_id AS item_type1_id,
On 09/16/2013 04:57 AM, Ladislav Lenart wrote:
On 16.9.2013 13:26, Alban Hertroys wrote:
Wouldn't it be much easier to define an FK constraint with ON DELETE CASCADE?
With that, you only need to worry about which rows you delete from the
parent table and dependant children will be removed
On 16.9.2013 15:50, Adrian Klaver wrote:
On 09/16/2013 04:57 AM, Ladislav Lenart wrote:
On 16.9.2013 13:26, Alban Hertroys wrote:
Wouldn't it be much easier to define an FK constraint with ON DELETE
CASCADE?
With that, you only need to worry about which rows you delete from the
parent
On 09/16/2013 07:38 AM, Ladislav Lenart wrote:
On 16.9.2013 15:50, Adrian Klaver wrote:
On 09/16/2013 04:57 AM, Ladislav Lenart wrote:
On 16.9.2013 13:26, Alban Hertroys wrote:
..
Hello.
Thank you but I have read this in the official documentation before posting my
(previous) reply.
On 16.9.2013 17:12, Adrian Klaver wrote:
On 09/16/2013 07:38 AM, Ladislav Lenart wrote:
On 16.9.2013 15:50, Adrian Klaver wrote:
On 09/16/2013 04:57 AM, Ladislav Lenart wrote:
On 16.9.2013 13:26, Alban Hertroys wrote:
..
Hello.
Thank you but I have read this in the official
On Fri, Sep 13, 2013 at 7:52 PM, Chris Travers chris.trav...@gmail.com wrote:
On Fri, Sep 13, 2013 at 8:51 AM, Merlin Moncure mmonc...@gmail.com wrote:
What's your client side stack?
merlin
Right now we are using something a little lighter weight in terms db
discovery but it doesn't handle
On 16.9.2013 17:30, David Johnston wrote:
Ladislav Lenart wrote
Hello all.
I am curious about the following usage of CTEs:
Imagine three tables:
* item (id, item_type1_id, item_type2_id, ...)
* item_type1 (id, ...)
* item_type2 (id, ...)
where
* item_type1_id is FK to item_type1
Le lundi 16 septembre 2013 à 08:30 -0700, David Johnston a écrit :
Ladislav Lenart wrote
Hello all.
I am curious about the following usage of CTEs:
Imagine three tables:
* item (id, item_type1_id, item_type2_id, ...)
* item_type1 (id, ...)
* item_type2 (id, ...)
where
*
Ladislav Lenart wrote
Hello all.
I am curious about the following usage of CTEs:
Imagine three tables:
* item (id, item_type1_id, item_type2_id, ...)
* item_type1 (id, ...)
* item_type2 (id, ...)
where
* item_type1_id is FK to item_type1 (id)
* item_type2_id is FK to item_type2
On Sun, Sep 15, 2013 at 8:02 PM, Robert Nix rob...@urban4m.com wrote:
If you do the dump using 9.1's pg_dump without --binary-upgrade, and then
load that dump file into a new empty 9.1 server, then does it crash if you
take a dump against *that* server?
I'll give it a try.
If so, would
Adrian, Kevin,
Thank you for the clues. It turns out a java process was added (between
the data source and database) at same time of postgres upgrade. It was the
java process that incorrectly handled the double precision data.
Joanne
On Sat, Sep 14, 2013 at 9:57 AM, Adrian Klaver
Hi. Can someone explain to me why the last query below is failing, or what
exactly the error message means? I'm sure there's a simple reason, but I'm
totally not seeing it. I boiled this down from a more complicated example,
but I think the problem is the same. Thanks in advance.
Ken
SELECT
Volume, REPLACE(Volume,'.','')
FROM MyTable
The data in my table looks like this:
88.97
448.58 and etc
i want to show like this with out the period:
8897
44858
I have tried to use different ways but still getting the error i hope
someone out there can help me. How can i
On Mon, Sep 16, 2013 at 5:32 PM, Ken Tanzer ken.tan...@gmail.com wrote:
SELECT 'found' WHERE 'test' = ANY( (SELECT ARRAY['test','pass','fail']) );
It works if you drop the inner SELECT.
SELECT 'found' WHERE 'test' = ANY( ARRAY['test','pass','fail'] );
On 9/16/2013 4:55 PM, karinos57 wrote:
SELECT
Volume, REPLACE(Volume,'.','')
FROM MyTable
The data in my table looks like this:
88.97
448.58 and etc
i want to show like this with out the period:
8897
44858
I have tried to use different ways but still getting the error i hope
Ken Tanzer wrote
ets_reach= SELECT 'found' WHERE 'test' = ANY( (SELECT
ARRAY['test','pass','fail']) );
ERROR: array value must start with { or dimension information
LINE 1: SELECT 'found' WHERE 'test' = ANY( (SELECT ARRAY['test','pas...
^
Per documentation of
On 09/16/2013 04:55 PM, karinos57 wrote:
SELECT
Volume, REPLACE(Volume,'.','')
FROM MyTable
The data in my table looks like this:
88.97
448.58 and etc
i want to show like this with out the period:
8897
44858
I have tried to use different ways but still getting the error i
Thanks for the explanation. I think I at least understand what it's doing
now. I'm either surprised or confused though, as I was under the
impression that you could substitute a subquery for a value pretty much
anywhere, but I guess that's not the case?
Cheers,
Ken
On Mon, Sep 16, 2013 at
On Mon, Sep 16, 2013 at 6:36 PM, Ken Tanzer ken.tan...@gmail.com wrote:
Thanks for the explanation. I think I at least understand what it's doing
now. I'm either surprised or confused though, as I was under the
impression that you could substitute a subquery for a value pretty much
OK I tried that and see it works with the cast. But now I'm confused about
both what exactly is failing without the cast, and about the resulting
error message.
Is the query failing because PG doesn't understand the subquery is yielding
an array? Seems unlikely. But if the problem is a type
Well I partially take back my last question. In the error message, I
missed the non-array / array part of integer = text[]
But I'm still confused. My subselect returns an array. If I cast it to a
text array, ANY is happy. But if I don't do so, what exactly does Postgres
think my subquery has
Ken Tanzer wrote
Well I partially take back my last question. In the error message, I
missed the non-array / array part of integer = text[]
But I'm still confused. My subselect returns an array. If I cast it to a
text array, ANY is happy. But if I don't do so, what exactly does
Postgres
karinos57 wrote
SELECT
Volume, REPLACE(Volume,'.','')
FROM MyTable
The data in my table looks like this:
88.97
448.58 and etc
i want to show like this with out the period:
8897
44858
I have tried to use different ways but still getting the error i hope
someone
Buenas...
Estoy desarrollando una tarea en la cual necesito saber cómo comparar el
resultado de dos consultas...
He pensado en crear un procedimiento el cual reciba por parámetros ambas
consultas respectivamente. Luego de alguna forma poder ejecutar las
consultas y devolver si ambas tienen el
29 matches
Mail list logo