Re: Bug: SQL pane: schema-prefix of composite types

From: Dave Page <dpage(at)postgresql(dot)org>
To: Erwin Brandstetter <brandstetter(at)falter(dot)at>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Bug: SQL pane: schema-prefix of composite types
Date: 2006-11-07 21:11:40
Message-ID: 4550F68C.2020506@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Erwin Brandstetter wrote:
> Hi Dave!
>
> I am afraid I have encountered another one of those undead bugs.
> It would seem that the case where the return type of a function is
> specified via OUT-parameter has slipped through:
> That's what I get for one of my real functions (note the duplicated
> schema-name with the OUT-parameter!):
>
> CREATE OR REPLACE FUNCTION cp.f_todo_interesse(OUT t cp."cp.t_todo")
> RETURNS SETOF cp.t_todo AS
> $BODY$
> (...)

Blergh!! I've gone over the code and ripped out a bunch of stuff that
used to be there to manually quote things. Now it's gone, there's no way
anything in that area could end up being double quoted without raising a
compiler error.

As always, thanks for the report - I'll probably cut an RC2 build tomorrow.

Regards, Dave

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Erwin Brandstetter 2006-11-07 21:42:27 Edit grid: quirk in boolean fields
Previous Message Melvin Davidson 2006-11-07 20:37:16 Re: About debugging trigger