Re: [GENERAL] Fwd: parameter type is unknown error

2017-03-06 Thread Günce Kaya
detsc...@swisspug.org> > > Cc: pgsql-general@postgresql.org > > Subject: Re: [GENERAL] Fwd: parameter type is unknown error > > > > On 03/06/2017 04:36 AM, Günce Kaya wrote: > > > Hi Charles, > > > > > > You are right about parameter types. When I

Re: [GENERAL] Fwd: parameter type is unknown error

2017-03-06 Thread Charles Clavadetscher
t; Subject: Re: [GENERAL] Fwd: parameter type is unknown error > > On 03/06/2017 04:36 AM, Günce Kaya wrote: > > Hi Charles, > > > > You are right about parameter types. When I use function with cast as > > you mentioned, I don't see "unknown". I see d

Re: [GENERAL] Fwd: parameter type is unknown error

2017-03-06 Thread Adrian Klaver
On 03/06/2017 04:36 AM, Günce Kaya wrote: Hi Charles, You are right about parameter types. When I use function with cast as you mentioned, I don't see "unknown". I see data types. but still doesn't insert with my custom function. It's really weird cause I did same thing for different function an

Re: [GENERAL] Fwd: parameter type is unknown error

2017-03-06 Thread Charles Clavadetscher
gsql-general-ow...@postgresql.org> [mailto:pgsql-general- > ow...@postgresql.org <mailto:pgsql-general-ow...@postgresql.org> ] On Behalf > Of Günce Kaya > Sent: Montag, 6. März 2017 13:01 > To: Charles Clavadetscher <mailto:clavadetsc...@swisspug.org

Re: [GENERAL] Fwd: parameter type is unknown error

2017-03-06 Thread Günce Kaya
; *Cc:* pgsql-general@postgresql.org > *Subject:* Re: [GENERAL] Fwd: parameter type is unknown error > > > > Hi Charles, > > > > Thank you for your response. I used pg_typeof() function to show > parameters type. > > > > select pg_typeof('asdasda

Re: [GENERAL] Fwd: parameter type is unknown error

2017-03-06 Thread Tom Lane
=?UTF-8?Q?G=C3=BCnce_Kaya?= writes: > I think the problem is not associated with you suggestion cause I changed > both of two parameter type as varchar(by the way, I deleted address column > and I only have two column that got me crazy!) still doesn't insert any > data. There are a lot of moving

Re: [GENERAL] Fwd: parameter type is unknown error

2017-03-06 Thread Charles Clavadetscher
Hello Günce From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Günce Kaya Sent: Montag, 6. März 2017 13:01 To: Charles Clavadetscher Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Fwd: parameter type is unknown error Hi Charles

Re: [GENERAL] Fwd: parameter type is unknown error

2017-03-06 Thread Günce Kaya
> Regards, > > Gunce > > 2017-03-06 14:51 GMT+03:00 Charles Clavadetscher < > clavadetsc...@swisspug.org>: > >> Hello >> >> >> >> *From:* pgsql-general-ow...@postgresql.org [mailto:pgsql-general-owner@po >> stgresql.org] *On Behalf Of

Re: [GENERAL] Fwd: parameter type is unknown error

2017-03-06 Thread Günce Kaya
6 > *To:* pgsql-general@postgresql.org > *Subject:* [GENERAL] Fwd: parameter type is unknown error > > > > Hi all, > > > > I created a dummy table and related function that include insert script. > When I execute the function I'm getting error like bellow; >

Re: [GENERAL] Fwd: parameter type is unknown error

2017-03-06 Thread Raymond O'Donnell
On 06/03/17 11:36, Günce Kaya wrote: Hi all, I created a dummy table and related function that include insert script. When I execute the function I'm getting error like bellow; ERROR: function cargo.insertinvoice(integer, integer, integer, *unknown, unknown, unknown*, integer, timestamp with t

Re: [GENERAL] Fwd: parameter type is unknown error

2017-03-06 Thread Charles Clavadetscher
Hello From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Günce Kaya Sent: Montag, 6. März 2017 12:36 To: pgsql-general@postgresql.org Subject: [GENERAL] Fwd: parameter type is unknown error Hi all, I created a dummy table and related

[GENERAL] Fwd: parameter type is unknown error

2017-03-06 Thread Günce Kaya
Hi all, I created a dummy table and related function that include insert script. When I execute the function I'm getting error like bellow; ERROR: function cargo.insertinvoice(integer, integer, integer, *unknown, unknown, unknown*, integer, timestamp with time zone, integer, integer, money, time