Re: [BUGS] BUG #4056: problem creating function with domain argument

2008-03-27 Thread Dave Page
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

Re: [BUGS] BUG #4056: problem creating function with domain argument

2008-03-27 Thread Eric P. Melbardis
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

Re: [BUGS] BUG #4056: problem creating function with domain argument

2008-03-27 Thread Tom Lane
"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

Re: [BUGS] BUG #4056: problem creating function with domain argument

2008-03-27 Thread Dave Page
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

Re: [BUGS] BUG #4056: problem creating function with domain argument

2008-03-24 Thread Tom Lane
"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.

[BUGS] BUG #4056: problem creating function with domain argument

2008-03-24 Thread eric melbardis
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