Leon P Smith
Leon P Smith
Ok, now I'd move the ToField/FromField instances into the Geometry module as well, as that's more in keeping with similar such modules. Also, I really don't see any reason why...
See also #97
Well, now that we have `FromField` and `ToField` instances for `Scientific`, it would make sense to also modify these instances when pgmp support gets added.
Also, we should revisit #146 and consider adding a ToField instance for Rational once this issue is tackled.
Postgresql-simple does support the `COPY FROM STDIN` interface, see the `Copy` module. You don't have to read stuff in from a file to use this interface, but you'll have to...
More reading regarding bulk inserts that might be benefitial: https://github.com/lpsmith/postgresql-simple/issues/67#issuecomment-114037553 https://stackoverflow.com/questions/20169372/postgresql-copy-method-enter-valid-entries-and-discard-exceptions
I dunno if @joeyadams is still active in the community, but he did have some code for generating data syntax for `COPY FROM STDIN`. I certainly wouldn't be opposed to...
Well, Joey's code is still available here: lpsmith/postgresql-libpq#3
The issue is that the string escape syntax depends on the `standard_conforming_strings` connection variable, which as of 8.2 or 8.3 can be set on a per-connection basis. IIUC, that variable...
You are very welcome! Of course, postgresql-simple really _should_ support the option of protocol-level parameters, which avoids some of these issues and avoids the need for escaping altogether, and allows...