On Wed, May 30, 2001 at 12:30:23PM -0400, Tom Lane wrote:
> Actually that's the least of the issues. The real problem is that
> because of function overloading, myfunc(int4) and myfunc(int2) (for
> example) are considered completely different functions. It is thus
> not at all clear what should
Ian Lance Taylor <[EMAIL PROTECTED]> writes:
> It is desirable to have some reasonable mechanism for changing the
> schema without requiring data to be dumped and reloaded. Otherwise it
> is very difficult to upgrade a system which needs to be up 24/7, such
> as many web sites today.
> It is not
Ian Lance Taylor <[EMAIL PROTECTED]> writes:
> I have a meta-point: the choices to be made here are not all that
> interesting. They do have to be defined. But almost any definition
> is OK.
Well, that implicit assumption is exactly the one I was questioning;
*is* it OK not to be very concerned
Bruce Momjian <[EMAIL PROTECTED]> writes:
> I think the major problem was that our pg_proc table doesn't have any
> way of handling arg changes. In fact, we need a ALTER FUNCTION
> capability first so we can recreate functions in place with the same
> OID.
Actually that's the least of the issues
> On Sat, Apr 28, 2001 at 06:45:39PM -0400, Bruce Momjian wrote:
> >
> > Sorry, only in 7.2. No new features in minor releases unless they are
> > very safe.
>
> So how was that patch not safe?
> It sure would make porting Oracle apps to PostgreSQL _much_ easier.
> How far dow
On Sat, Apr 28, 2001 at 06:45:39PM -0400, Bruce Momjian wrote:
>
> Sorry, only in 7.2. No new features in minor releases unless they are
> very safe.
So how was that patch not safe?
It sure would make porting Oracle apps to PostgreSQL _much_ easier.
How far down the line
> > Using %TYPE makes it easier to write a function which is independent
> > of the definition of a table. That is, minor changes to the types
> > used in the table may not require changes to the function.
>
> Wow! This would be _very_ useful! It's something I wish PostgreSQL
> had and I
On Fri, Apr 27, 2001 at 08:45:25PM -0700, Ian Lance Taylor wrote:
> This patch adds support for %TYPE in CREATE FUNCTION argument and
> return types.
>
> %TYPE is already supported by PL/pgSQL when declaring variables.
> However, that does not help with the argument and return types in
> CREATE F
This patch adds support for %TYPE in CREATE FUNCTION argument and
return types.
%TYPE is already supported by PL/pgSQL when declaring variables.
However, that does not help with the argument and return types in
CREATE FUNCTION.
Using %TYPE makes it easier to write a function which is independent