Re: Query about foreign key details for php framework - Mailing list pgsql-sql

From Stuart
Subject Re: Query about foreign key details for php framework
Date
Msg-id CALmuyMr84Lj-Y3NEkyHHLY8OKqmXbm41nAcvOve7AaKm8gq9GQ@mail.gmail.com
Whole thread Raw
In response to Re: Query about foreign key details for php framework  (David Binney <donkeysoft@gmail.com>)
List pgsql-sql
David,

Ok,sorry about that I'm not sure if its in 9.4 or just new to 9.5.

On Mon, Feb 29, 2016 at 3:55 AM, David Binney <donkeysoft@gmail.com> wrote:
Hey Stuart, 

The my postgres version 9.3 does not seem to like the "cardinality" function in that query. 



On Mon, 29 Feb 2016 at 09:42 David Binney <donkeysoft@gmail.com> wrote:
Hey adrian, 

  rc.constraint_name AS name,
  tc.constraint_type AS type,
  kcu.column_name,
  rc.match_option AS match_type,
  rc.update_rule AS on_update,
  rc.delete_rule AS on_delete,
  kcu.table_name AS references_table,
  kcu.column_name AS references_field,
  kcu.ordinal_position

Those are the columns that i need as a minimum, but as you know they are all easy apart from the rules "on update" from the "RC" table. 

I did start having a crack at the catalog tables but that is pretty complicated.
 

On Sun, 28 Feb 2016 at 01:21 Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 02/26/2016 08:29 PM, David Binney wrote:
> Hey adrian,
>
> You are correct that the distinct will chomp the resultset down to the
> correct count, I am just concerned that there will be cases where it
> might not be accurate between the "rc" and the "kcu" joins as there is
> no table reference. I have simplified the query right down to just the
> join that i am unsure about. You can see below that as soon as i add the
> rc.unique_constraint_name, the distinct is no longer returning one row.
> In this case its fine because the rc values are the same and would
> distinct away, but there might be a case where they are diferent and you
> would have two rows and not know which values are correct?
>

Well it comes down to the question that was asked several times upstream:

what is the information you want to see?

I am not talking about a query, but a description of what attributes you
want on what database objects.

Also given, from previous post:

"I am a little in the dark as well since this is just a broken piece of
ORM i am attempting to fix, in the framework."

Is this not something that should be discussed with the framework
developers, or are we already doing that:)?



--
Adrian Klaver
adrian.klaver@aklaver.com
--
Cheers David Binney
--
Cheers David Binney

pgsql-sql by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Need documentation for PostgreSQL Replication support.
Next
From: Adrian Klaver
Date:
Subject: Re: Query about foreign key details for php framework