• Tom Lane's avatar
    Fix contrib/dblink to handle inconsistent DateStyle/IntervalStyle safely. · 8a3b6772
    Tom Lane authored
    If the remote database's settings of these GUCs are different from ours,
    ambiguous datetime values may be read incorrectly.  To fix, temporarily
    adopt the remote server's settings while we ingest a query result.
    
    This is not a complete fix, since it doesn't do anything about ambiguous
    values in commands sent to the remote server; but there seems little we
    can do about that end of it given dblink's entirely textual API for
    transmitted commands.
    
    Back-patch to 9.2.  The hazard exists in all versions, but this patch
    would need more work to apply before 9.2.  Given the lack of field
    complaints about this issue, it doesn't seem worth the effort at present.
    
    Daniel Farina and Tom Lane
    8a3b6772
dblink.c 73 KB