Thanks Melvin. Much appreciate it.
From: Melvin Davidson [mailto:melvin6...@gmail.com]
Sent: 07 September 2015 14:38
To: Gavin Flower
Cc: r...@iol.ie; FarjadFarid(ChkNet); pgsql-general
Subject: Re: [GENERAL] table dependencies
All,
fwiw, I once wrote a plpgsql function to assist in
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
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
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?
R
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
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
No worries.
I found a way.
Best Regards
Farjad
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi,
For data insertion purposes I need to identify "the lowest ranking tables"
(e.g. with least dependencies) to fill and work my way up.
I have looked a number of blogs but unfortunately these didn't work.
Is there a function or view to report dependencies of tables ? I have
Postgresql 9.4
Thank you.
That worked for me :)
Kaarel
Pavel Stehule wrote:
Hello
no
but, you can search tablename in source code - all stored procedures
store src in pg_proc.prosrc column
regards
Pavel Stehule
2009/4/14 Kaarel Kitsemets :
Hi
I need to make a change to a table that many stored proced
In response to Kaarel Kitsemets :
> Hi
>
> I need to make a change to a table that many stored procedures depend
> on. Is there an automatic way of finding all the functions that depend
> on a certain table?
Not really, but for functions written not in C you can ask the column
prosrc from the t
Hello
no
but, you can search tablename in source code - all stored procedures
store src in pg_proc.prosrc column
regards
Pavel Stehule
2009/4/14 Kaarel Kitsemets :
> Hi
>
> I need to make a change to a table that many stored procedures depend on. Is
> there an automatic way of finding all the f
Hi
I need to make a change to a table that many stored procedures depend
on. Is there an automatic way of finding all the functions that depend
on a certain table?
I have tried the dependents and dependencies report in pgAdmin but these
do not include functions.
Thank you in advance,
Kaarel
11 matches
Mail list logo
