pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedview function on pg_toast
5+ messages / 3 participants
[nested] [flat]
* view function on pg_toast
@ 2005-03-23 03:39 bandeng <postgredb@gmail.com>
0 siblings, 2 replies; 5+ messages in thread
From: bandeng @ 2005-03-23 03:39 UTC (permalink / raw)
To: pgsql-sql
hello guys,
I need help. I have functions but it is saved to pg_toast, when I
dump the database, the function from pg_toast is not copied. so is
there any sql or syntax to view function data ?
Thanks
Ricky
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: view function on pg_toast
@ 2005-03-23 04:51 Michael Fuhr <mike@fuhr.org>
parent: bandeng <postgredb@gmail.com>
1 sibling, 0 replies; 5+ messages in thread
From: Michael Fuhr @ 2005-03-23 04:51 UTC (permalink / raw)
To: bandeng <postgredb@gmail.com>; +Cc: pgsql-sql
On Wed, Mar 23, 2005 at 11:39:31AM +0800, bandeng wrote:
> I need help. I have functions but it is saved to pg_toast, when I
> dump the database, the function from pg_toast is not copied. so is
> there any sql or syntax to view function data ?
What exactly do you mean by "it is saved to pg_toast" and how do
you know that?
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: view function on pg_toast
@ 2005-03-23 05:01 Mihail Nasedkin <m.nasedkin.perm@mail.ru>
parent: bandeng <postgredb@gmail.com>
1 sibling, 1 reply; 5+ messages in thread
From: Mihail Nasedkin @ 2005-03-23 05:01 UTC (permalink / raw)
To: bandeng <postgredb@gmail.com>; +Cc: pgsql-sql
Hello, bandeng.
March, 23 2005, 8:39:31:
b> hello guys,
b> I need help. I have functions but it is saved to pg_toast, when I
b> dump the database, the function from pg_toast is not copied. so is
b> there any sql or syntax to view function data ?
xxx:=\d pg-catalog.pg_proc
xxx:=select procsrc from pg-catalog.pg_proc where proname=... and
pronamespace=...;
--
Regards,
Mihail Nasedkin mailto:m.nasedkin.perm@mail.ru
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: view function on pg_toast
@ 2005-03-23 05:09 Mihail Nasedkin <m.nasedkin.perm@mail.ru>
parent: Mihail Nasedkin <m.nasedkin.perm@mail.ru>
0 siblings, 1 reply; 5+ messages in thread
From: Mihail Nasedkin @ 2005-03-23 05:09 UTC (permalink / raw)
To: bandeng <postgredb@gmail.com>; +Cc: pgsql-sql
MN> March, 23 2005, 8:39:31:
b>> hello guys,
b>> I need help. I have functions but it is saved to pg_toast, when I
b>> dump the database, the function from pg_toast is not copied. so is
b>> there any sql or syntax to view function data ?
MN> xxx:=\d pg-catalog.pg_proc
xxx:=\d pg_catalog.pg_proc
MN> xxx:=select procsrc from pg-catalog.pg_proc where proname=... and
MN> pronamespace=...;
xxx:=select procsrc from pg_catalog.pg_proc where proname=... and
pronamespace=...;
--
Regards,
Mihail Nasedkin mailto:m.nasedkin.perm@mail.ru
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: view function on pg_toast
@ 2005-03-23 20:53 bandeng <postgredb@gmail.com>
parent: Mihail Nasedkin <m.nasedkin.perm@mail.ru>
0 siblings, 0 replies; 5+ messages in thread
From: bandeng @ 2005-03-23 20:53 UTC (permalink / raw)
To: pgsql-sql
to Michael,
We use pg manager from EMS and misstype. it should be created on
public but on pg_toast
On Wed, 23 Mar 2005 10:09:19 +0500, Mihail Nasedkin
<m.nasedkin.perm@mail.ru> wrote:
> MN> March, 23 2005, 8:39:31:
>
> b>> hello guys,
>
> b>> I need help. I have functions but it is saved to pg_toast, when I
> b>> dump the database, the function from pg_toast is not copied. so is
> b>> there any sql or syntax to view function data ?
>
> MN> xxx:=\d pg-catalog.pg_proc
> xxx:=\d pg_catalog.pg_proc
>
> MN> xxx:=select procsrc from pg-catalog.pg_proc where proname=... and
> MN> pronamespace=...;
> xxx:=select procsrc from pg_catalog.pg_proc where proname=... and
> pronamespace=...;
>
> --
> Regards,
> Mihail Nasedkin mailto:m.nasedkin.perm@mail.ru
>
>
--
Gutten Aben Sugeng Sonten, Jangane Kurang Santen
bandeng....................
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2005-03-23 20:53 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-03-23 03:39 view function on pg_toast bandeng <postgredb@gmail.com>
2005-03-23 04:51 ` Michael Fuhr <mike@fuhr.org>
2005-03-23 05:01 ` Mihail Nasedkin <m.nasedkin.perm@mail.ru>
2005-03-23 05:09 ` Mihail Nasedkin <m.nasedkin.perm@mail.ru>
2005-03-23 20:53 ` bandeng <postgredb@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox