Re: CommandStatus from insert returning when using a portal.

2023-07-14 Thread chap
spec, but the latter seems perhaps safer to me. Regards, -Chap

Re: CommandStatus from insert returning when using a portal.

2023-07-14 Thread chap
a caller's expectation that the whole outcome is known by that point. Regards, -Chap

Re: CommandStatus from insert returning when using a portal.

2023-07-14 Thread chap
On 2023-07-14 14:19, David G. Johnston wrote: Is there some magic set of arguments I should be using besides: tcpdump -Ar filename ? I opened it with Wireshark, which has a pgsql protocol decoder. Regards, -Chap

Re: CommandStatus from insert returning when using a portal.

2023-07-14 Thread chap
in the suspended-cursor case before executeUpdate returns, but keeping the cursor around for getGeneratedKeys() to use, so executeUpdate returns -1 before even having seen the later command complete, and would still do that even if the command complete message had the right count. Regards, -Chap

Re: CommandStatus from insert returning when using a portal.

2023-07-14 Thread chap
, but if the portal gets suspended, then the later command completion reports a zero count? Regards, -Chap

Re: CommandStatus from insert returning when using a portal.

2023-07-14 Thread chap
different operations, say one an INSERT RETURNING and the other something else? Regards, -Chap

Re: CommandStatus from insert returning when using a portal.

2023-07-12 Thread chap
is an INSERT RETURNING? execute() -> true getResultSet() -> the rows getMoreResults() -> false getUpdateCount() -> number inserted? It seems that would fit the portal's behavior easily enough. Or is the JDBC spec insisting on some other order? Regards, -Chap

Re: COPY table FROM STDIN via SPI

2023-07-12 Thread chap
on the server and has the same format that COPY FROM expects? Regards, -Chap

Re: When IMMUTABLE is not.

2023-06-15 Thread chap
presto, the VOLATILE ones all work, and the IMMUTABLE ones aren't there yet. Regards, -Chap

Re: When IMMUTABLE is not.

2023-06-15 Thread chap
y because it depends on a fetch /of its own implementation/, and overall its behavior is better described by marking it IMMUTABLE. Regards, -Chap

Re: When IMMUTABLE is not.

2023-06-15 Thread chap
tion means to the optimizer. (And also influences what snapshot the function is looking at, and therefore what it can see, which has also struck me more as a tacked-on effect than something inherent in the declaration's meaning.) Regards, -Chap

Re: Let's make PostgreSQL multi-threaded

2023-06-06 Thread chap
t trickier, and there may be some incentive to to include, say, sepgsql in the picture. Sure, even access to a file API can be game over, depending on what file you open, but that's already the risk for every PL with an 'untrusted' flavor. Regards, -Chap

Re: Let's make PostgreSQL multi-threaded

2023-06-06 Thread chap
, how many JVMs) get fired up, and have each sharing sessions that have something in common. Or, would that just require all the complexity of both approaches to synchronization, with no sufficient benefit? Regards, -Chap [1] https://docs.oracle.com/en/java/javase/17/docs/specs/jni/invocation.h

Re: Documentation about PL transforms

2022-07-29 Thread chap
, they are necessary to allow one inline handler to serve more than one PL. ok I will probably be unable to produce a new patch for this CF. Family obligation. Regards, -Chap

Re: Documentation about PL transforms

2022-07-27 Thread chap
to serve more than one PL. Regards, -Chap

Re: timezones BCE

2022-04-13 Thread chap
> java.time.ZoneId.of("America/Toronto"). ...> getRules(). ...> nextTransition(java.time.Instant.parse("0101-01-01T00:00:00Z")) $1 ==> Transition[Gap at 1895-01-01T00:00-05:17:32 to -05:00] Regards, -Chap

Re: timezones BCE

2022-04-13 Thread chap
actual longitude. Regards, -Chap

Re: Documentation about PL transforms

2022-04-07 Thread chap
On 2022-02-22 12:59, Chapman Flack wrote: It would have been painful to write documentation of get_func_trftypes saying its result isn't what get_transform_{from.to}sql expect, so patch 1 does add a get_call_trftypes that returns a List *. Patch 2 then updates the docs as discussed in this

Re: test/isolation/expected/stats_1.out broken for me

2022-04-07 Thread chap
On 2022-04-07 15:04, Andres Freund wrote: And done. Chap, could you confirm this fixes the issue for you? Looks good from here. One installcheck-world with no failures; previously, it failed for me every time. Regards, -Chap

Re: test/isolation/expected/stats_1.out broken for me

2022-04-07 Thread chap
-g3 -fno-omit-frame-pointer' Regards, -Chap

test/isolation/expected/stats_1.out broken for me

2022-04-07 Thread chap
ers. So a2f433f seems to have silenced all the rest of those, but not this one. If I build from ad40166, installcheck-world passes. That's as far as I have pursued it. Regards, -Chap

Re: trigger example for plsample

2022-04-07 Thread chap
streamline the example to leave out the pfree calls, and be an illustration of best practice in letting the memory context machinery handle all the deallocation at once, where there isn't a special need to free something, like an especially large allocation, at retail. Regards, -Chap

Re: PostgreSQL shutdown modes

2022-04-02 Thread chap
umn for current_timestamp - state_change. Regards, -Chap