Re: when does a function name get mapped to an OID?

From: Fran Fabrizio <ffabrizio(at)mmrd(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: when does a function name get mapped to an OID?
Date: 2002-04-23 19:54:01
Message-ID: 3CC5BBD9.5070003@mmrd.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I should say what I mean and mean what I say. :-) In an effort for
brevity, my example included the simplest functions I could think of off
the top of my head. In reality, they are large PL/PgSQL beasties. Good
to know that it won't work for plain ole SQL functions, though...we've
got some of those too. Thus, I'll have to enforce the loading order
after all. Thanks for the info Tom.

-Fran

>>drop function bar();
>>drop function foo();
>>create function foo() returns int4 as '
>> select bar();
>>' language 'sql';
>>create function bar() returns int4 as '
>> select 1234;
>>' language 'sql';
>
>
>>This loads into the db just fine.
>
>
> It does?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-04-23 20:58:41 Re: Returns from ExecTuplesOk()
Previous Message Jan Wieck 2002-04-23 19:46:07 Re: PostgreSQL and bytea