Обсуждение: table dependencies

Поиск
Список
Период
Сортировка

table dependencies

От
"FarjadFarid\(ChkNet\)"
Дата:
No worries.

I found a way.

Best Regards

Farjad

Re: table dependencies

От
Raymond O'Donnell
Дата:
On 06/09/2015 22:59, FarjadFarid(ChkNet) wrote:
> No worries.
>
> I found a way.
>

Would you share it, for the archives?

Ray.


--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

Re: table dependencies

От
"FarjadFarid\(ChkNet\)"
Дата:
Sure,

I would have but I am not sure if it would add any value. As I have a customised network adaptor and sql classes
coveringdifferent databases.  

Best Regards


Farjad


-----Original Message-----
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Raymond O'Donnell
Sent: 07 September 2015 08:45
To: FarjadFarid(ChkNet); 'pgsql-general'
Subject: Re: [GENERAL] table dependencies

On 06/09/2015 22:59, FarjadFarid(ChkNet) wrote:
> No worries.
>
> I found a way.
>

Would you share it, for the archives?

Ray.


--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: table dependencies

От
Gavin Flower
Дата:
On 07/09/15 19:44, Raymond O'Donnell wrote:
> On 06/09/2015 22:59, FarjadFarid(ChkNet) wrote:
>> No worries.
>>
>> I found a way.
>>
> Would you share it, for the archives?
>
> Ray.
>
>
I think I can do it relatively simply, in a reasonable general fashion.

if it is of real interest let me know, and I'll see if I can find time
to try and implement  it.


Cheers,
Gavin

Re: table dependencies

От
Melvin Davidson
Дата:
All,
fwiw,  I once wrote a plpgsql function to assist in generating slony set adds.
It grabs all the tables in pg_class and sorts them by foreign key count.
You can pull the main query logic from it and modify to suit your needs.

I've attached for your convenience.


On Mon, Sep 7, 2015 at 6:27 AM, Gavin Flower <GavinFlower@archidevsys.co.nz> wrote:
On 07/09/15 19:44, Raymond O'Donnell wrote:
On 06/09/2015 22:59, FarjadFarid(ChkNet) wrote:
No worries.

I found a way.

Would you share it, for the archives?

Ray.


 I think I can do it relatively simply, in a reasonable general fashion.

if it is of real interest let me know, and I'll see if I can find time to try and implement  it.


Cheers,
Gavin



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.
Вложения

Re: table dependencies

От
"FarjadFarid\(ChkNet\)"
Дата:

Thanks Melvin. Much appreciate it.

 

 

From: Melvin Davidson [mailto:melvin6925@gmail.com]
Sent: 07 September 2015 14:38
To: Gavin Flower
Cc: rod@iol.ie; FarjadFarid(ChkNet); pgsql-general
Subject: Re: [GENERAL] table dependencies

 

All,
fwiw,  I once wrote a plpgsql function to assist in generating slony set adds.

It grabs all the tables in pg_class and sorts them by foreign key count.

You can pull the main query logic from it and modify to suit your needs.

I've attached for your convenience.

 

 

On Mon, Sep 7, 2015 at 6:27 AM, Gavin Flower <GavinFlower@archidevsys.co.nz> wrote:

On 07/09/15 19:44, Raymond O'Donnell wrote:

On 06/09/2015 22:59, FarjadFarid(ChkNet) wrote:

No worries.

I found a way.

Would you share it, for the archives?

Ray.

I think I can do it relatively simply, in a reasonable general fashion.

if it is of real interest let me know, and I'll see if I can find time to try and implement  it.


Cheers,
Gavin




--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




--

Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.