On 07-03-2017 09:02, Panagiotis Atmatzidis wrote:
Hello,
I have 2 RDS instances on AWS running PSQL 9.4.7.
I want to make a clone of database1 which belongs to user1, to
database2 which belongs to user2. Database1 has 20+ tables. I want to
avoid copying the DATA sitting on 5 tables on database1
On 07-03-2017 09:02, Panagiotis Atmatzidis wrote:
Hello,
I have 2 RDS instances on AWS running PSQL 9.4.7.
I want to make a clone of database1 which belongs to user1, to
database2 which belongs to user2. Database1 has 20+ tables. I want to
avoid copying the DATA sitting on 5 tables on database1
Hello,
I have 2 RDS instances on AWS running PSQL 9.4.7.
I want to make a clone of database1 which belongs to user1, to database2 which
belongs to user2. Database1 has 20+ tables. I want to avoid copying the DATA
sitting on 5 tables on database1 (many Gigs).
I've read one too many posts about
Good morning,
Sorry for delay. I looked at your suggestions and also tried all of them.
Charles, thank you for your advise. I changed my function structure as you
said and I executed the function as Samed mentioned so It works now. I did
not want to use cast for varchar parameters cause in my pre
Hallo Adrian
> -Original Message-
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Adrian Klaver
> Sent: Montag, 6. März 2017 15:13
> To: Günce Kaya ; Charles Clavadetscher
>
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL]
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
Hello Günce
> -Original Message-
> 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:37
> To: Charles Clavadetscher
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Fwd: parameter type
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 and It works.
Regards,
Gunce
2017-03-06 15:
=?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
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,
Hi Ray,
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.
you can see changes as I emphasized as bold.
create or replac
Hi Charles,
Thank you for your response. I used pg_typeof() function to show parameters
type.
select pg_typeof('asdasdasd');
result -> "unknown"
but I can use this parameter without custom function as successfully and
using cast is doesn't work to get result as successful.
do you have any advi
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
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 funct
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
15 matches
Mail list logo