Alvaro Herrera wrote:
>> would someone with the appropriate authority please unsubscribe this
>> person's email address from this list so we don't all get a bounce message
>> after every email we send to the list? Thanks.
> Just did it. In the future, please email sysadm...@postgresql.org with
Hi,
I've been working on this for quite awhile now and don't seem to get the
proper query.
I have basically 4 tables.
1. Table john_test contains the numbers of the calls.
2. Table john_country contains the country with prefix.
3. Table john_clients contains the clients and their sub_id's
On Thursday, January 12, 2012 9:02:35 am David Johnston wrote:
>
>
> Adrian, you are not helping...if ON UPDATE CASCADE was enabled on "orders"
> the error in question would never have appeared and the UPDATE would have
> succeeded. Carlos' goal is to cha
-Original Message-
From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org]
On Behalf Of Adrian Klaver
Sent: Thursday, January 12, 2012 11:55 AM
To: pgsql-sql@postgresql.org
Cc: Carlos Mennens
Subject: Re: [SQL] Unable To Modify Table
>
> How does one accomplish my goal
-Original Message-
From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org]
On Behalf Of Carlos Mennens
Sent: Thursday, January 12, 2012 11:43 AM
To: PostgreSQL (SQL)
Subject: [SQL] Unable To Modify Table
I seem to have an issue where I can't modify a table due to anoth
On Thursday, January 12, 2012 8:42:59 am Carlos Mennens wrote:
> I seem to have an issue where I can't modify a table due to another
> tables foreign key association:
>
> [CODE]trinity=# \d developers
> Table "public.developers"
> Column| Type | Modifiers
> -
On 01/12/2012 08:42 AM, Carlos Mennens wrote:
I seem to have an issue where I can't modify a table due to another
tables foreign key association:
...
How does one accomplish my goal? Is this difficult to change or once
that foreign key is created, are you stuck with that particular
constraint?
I seem to have an issue where I can't modify a table due to another
tables foreign key association:
[CODE]trinity=# \d developers
Table "public.developers"
Column| Type | Modifiers
--++---
id | character(10) | not null
name
El mié, 11-01-2012 a las 10:40 -0500, Tom Lane escribió:
> Gerardo Herzig writes:
> > Hi all. Im working on a 'simple' query with 7, 8 left joins. After the
> > 9nth join or so, explain analyze became to show the plan with many
> > tables being read in sequential fashion. Of course, this slows dow
