= NEW in .ctl file, it's guaranteed that
the value 0.00 will be overwritten with 100.00? Or pg_bulkload can't
guarantee this order?
Thanks!
Leandro Guimarães
reSQL 9.4. I've searched about theses
errors but it ways advice to change the C code in files but I'm not sure to
do this in a tool like pg_bulkload.
Leandro Guimarães
On Mon, Jun 17, 2019 at 3:56 PM Adrian Klaver
wrote:
> On 6/17/19 10:04 AM, Leandro Guimarães wrote:
> > Hi A
Hi Adrian,
Yes, that's the problem!
I'm testing now the pg_bulkload but I'm facing some issues to install it
on Postgresql 9.4.
Leandro Guimarães
On Mon, Jun 17, 2019 at 1:22 PM Adrian Klaver
wrote:
> On 6/17/19 9:06 AM, Leandro Guimarães wrote:
> Please reply
Hi Adrian,
You are right, these fields are in CHECK CONSTRAiNTS and they are not
formally defined as Primary Keys.
Thanks!
Leandro Guimarães
On Sat, Jun 15, 2019 at 10:45 AM Adrian Klaver
wrote:
> On 6/14/19 7:24 PM, Leandro Guimarães wrote:
> > Hi Tim, thanks for you answer!
&g
Hi Adrian,
I'll take a look about pg_bulkload, but I populate the database via a
Java application with JDBC.
I'll try the query you kindly sent to me!
Thanks!
Leandro Guimarães
On Fri, Jun 14, 2019 at 6:59 PM Adrian Klaver
wrote:
> On 6/14/19 2:04 PM, Leandro Guimarães
and customer_id (it works great) the
problem is just the duplicated key situation that I'm really worried about.
I populate the database via a Java Application with JDBC.
Maybe this info could help to provide some light!
Thanks Again!
Leandro Guimarães
On Fri, Jun 14, 2019 at 7:39 P
solve
this situation? I need to ignore duplicates instead to have some error.
I'm using* PostgreSQL 9.4* so I can't use "ON CONFLICT" and upgrade is not
an option.
Thanks and Kind Regards!
Leandro Guimarães
meter hardcoded, it works fine.
Any idea how could I solve this? Follow my query example:
SELECT customer_id,
date_id,
kpi AS kpi_value
FROM schema1.table1
WHERE date_id >= *To_char*(( current_date - interval '30' day ) :: DATE,
'MMDD')::INTEGER
Thanks!
Leandro Guimarães
