Gilles Darold comments

Results 346 comments of


                                            Gilles Darold

Parallel Data Load with Table Partitions is Not Working [Range]

Unfortunately I do not have a lot of spare time in 2019-2020, I will have some holidays in September but I'm not sure that this topic will be in top...

Outgoing traffic from client

Yes it is possible and I agree it should be done, but it need lot of work to append a new storage/report field. Regards,

Export overloaded function

The problem is that we use a hash with the name of the function as key to store the definition, this is why only the last definition is exported. Changing...

Export overloaded function

Yes, this was what I have deduced too.

Table partition schema generation issue.

You are using an obsolete version of Ora2Pg, please use latest development code and don't forget to set PG_VERSION to the target PostgreSQL database release in ora2pg.conf. This will helps...

HINT: "SR" <-- parse error at position 2 within geometry

Hi, thanks for the report. Can you provide me the value of GEOMETRY_EXPORT_TYPE in your ora2Pg.conf?

HINT: "SR" <-- parse error at position 2 within geometry

Sorry, this is GEOMETRY_EXTRACT_TYPE

HINT: "SR" <-- parse error at position 2 within geometry

Can you post the configuration with the usual anonymization?

HINT: "SR" <-- parse error at position 2 within geometry

The problem is probably because you are using an ST_GEOMETRY data type and the method to retrieve the SRID is not compatible and commit ec400ad is of no help in...

Bad indentation for CTE and `Count(*) AS` in return query statement

Yes there is a major formatting issue with CTE, I'm still missing time to work on it but it is in my todo list.