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
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
, but no luck.
Is there a way to declare such a pseudo-type variable inside the stored
procedure?
Thank you in advance,
Kaarel
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Would PostgreSQL be a good enough choise for GnuCash (or Quickbooks or
the likes) type of program?
What could be the potential drawbacks of using PostgreSQL (perhaps its
big size)?
What would be a better database for that kind of job?
Kaarel
---(end of broadcast
if you will) of
any other database.
Kaarel
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
ould a perl application using DBI have a similar problem? Or how would
one then legally use PHP with MySQL without GPL-ing your product and
without buying MySQL commercial license?
Kaarel
t a small discussion which in the end would
explain the cases when the licensing aspect of these two concrete
products will play an important role in developing software.
Kaarel
---(end of broadcast)---
TIP 8: explain analyze is your friend
