On Thu, Mar 27, 2008 at 5:52 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> No, the above is entirely wrong. typtypmod is the typmod that goes with
> the domain's base type, not with the domain itself. You got away with
> this mistaken code before 8.3 because format_type just silently ignored
> i
Cc: Eric P. Melbardis; pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #4056: problem creating function with domain
argument
"Dave Page" <[EMAIL PROTECTED]> writes:
> On Tue, Mar 25, 2008 at 5:37 AM, Tom Lane <[EMAIL PROTECTED]> wrote:
>> ... It looks to me like pgAdmi
"Dave Page" <[EMAIL PROTECTED]> writes:
> On Tue, Mar 25, 2008 at 5:37 AM, Tom Lane <[EMAIL PROTECTED]> wrote:
>> ... It looks to me like pgAdmin is mistakenly
>> thinking that a domain has type modifiers.
> pgAdmin is using format_type() with a query like:
> postgres=# SELECT oid, format_type(oi
On Tue, Mar 25, 2008 at 5:37 AM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "eric melbardis" <[EMAIL PROTECTED]> writes:
> > Description:problem creating function with domain argument
>
> AFAICT this example works fine in psql. You need to take it up
> on the pgAdmin mailing list. It looks
"eric melbardis" <[EMAIL PROTECTED]> writes:
> Description:problem creating function with domain argument
AFAICT this example works fine in psql. You need to take it up
on the pgAdmin mailing list. It looks to me like pgAdmin is mistakenly
thinking that a domain has type modifiers.
The following bug has been logged online:
Bug reference: 4056
Logged by: eric melbardis
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.1
Operating system: windows xp sp 2
Description:problem creating function with domain argument
Details:
hi when i execute