Hmm but if I exclude the src_host and dst_host from the aggregation the counts
should be summarized over destination/source and only one entry should appear
in the insert statements (for the primary key I defined in the sql-schema). Or
in other words, if the aggregations match the primary key (i
On 03/24/2013 12:07:01 PM, Gsell Reto (rgs...@hsr.ch) wrote:
> Hi,
>
> I have a problem with duplicated key entries in postgresql 9.2.
> On every INSERT/COPY I get the following error in the db:
>
> --
> 2013-03-24 15:51:01 CET ERROR: duplicate key value violates unique
> cons
Hi,
I have a problem with duplicated key entries in postgresql 9.2. I tried to
increase the sql_cache_entries, but there was no change to the result. If I ad
src_host and dst_host to the aggregation list it works, but the table size
explodes and this won't be a solution in my case. There is ipv