Re: [Cscwg-public] Voting Begins Ballot CSC-23: Marking the EV Code Signing Guidelines SUPERCEDED

2024-03-25 Thread Dean Coclin via Cscwg-public
Reminder: Voting on this ballot ends tomorrow. We still need a vote from a Certificate Consumer. Dean From: Cscwg-public On Behalf Of Dimitris Zacharopoulos (HARICA) via Cscwg-public Sent: Tuesday, March 19, 2024 1:29 AM To: cscwg-public@cabforum.org Subject: [Cscwg-public

Re: [OMPI users] UFLM only works on a single node???

2024-03-24 Thread Dean Anderson via users
,self, tcp BTL and the OB1 PML.  George.On Sat, Mar 23, 2024 at 6:33 PM Dean Anderson via users <users@lists.open-mpi.org> wrote:If someone could take a look at https://github.com/open-mpi/ompi/issues/11404 and provide some guidance or a work around, I’d appreciate it. The SC-22 Tutorials wor

Stus-List Re: Hints on swapping winches?

2024-03-23 Thread Dean McNeill via CnC-List
Thanks everyone, some great hints and suggestions here. I’m a little less worried about the switch after reading all these comments. I’ll be sure to let you all know how it works out! Cheers, Dean Barrawind 1980 C 34 Halifax, NS _ Please show your appreciation for this list and the Photo

[OMPI users] UFLM only works on a single node???

2024-03-23 Thread Dean Anderson via users
If someone could take a look at https://github.com/open-mpi/ompi/issues/11404 and provide some guidance or a work around, I’d appreciate it. The SC-22 Tutorials work just fine, but only on a single node. If you arrange multiple nodes, it hangs in MPI_Finalize. I attended the SC22 Tutorial and

Stus-List Hints on swapping winches?

2024-03-22 Thread Dean McNeill via CnC-List
other hints and tips? Thanks, Dean BarraWind 1980 C 34 Halifax, NS Please show your appreciation for this list and the Photo Album site and help me pay the associated bills. Make a contribution at: https://www.paypal.me/stumurray Thanks for your help. Stu

Re: Issue with tomcat version of GWT 2.11 for class javax.validation.Path

2024-03-20 Thread Dean Zarras
For whatever it might be worth... I just went through a possibly similar exercise, getting my 2.11 GWT-RPC-based app to run with Tomcat 10. I had to run around my codebase and replace 'javax' with 'jakarta', but the last key step was ensuring that my GWTRPC services inherited from this class:

Re: Catalog domain not-null constraints

2024-03-20 Thread Dean Rasheed
Looking in the SQL spec, it seems to only mention adding CHECK constraints to domains, so the option to add NOT NULL constraints should probably be listed in the "Compatibility" section. Regards, Dean

Re: Proposal to include --exclude-extension Flag in pg_dump

2024-03-20 Thread Dean Rasheed
d I'm enthusiastic about making further meaningful contributions > to PostgreSQL in the future. > Committed. Congratulations on your first contribution to PostgreSQL! May it be the first of many to come. Regards, Dean

pgsql: Add "--exclude-extension" to pg_dump's options.

2024-03-20 Thread Dean Rasheed
Add "--exclude-extension" to pg_dump's options. This option (or equivalently specifying "exclude extension pattern" in a filter file) allows extensions matching the specified pattern to be excluded from the dump. Ayush Vatsa, reviewed by Junwang Zhao, Dean Rasheed, a

Re: Improving EXPLAIN's display of SubPlan nodes

2024-03-19 Thread Dean Rasheed
y other queries, and we've not gotten questions > about them. > Fair enough. I have no further comments. Regards, Dean

Re: Improving EXPLAIN's display of SubPlan nodes

2024-03-19 Thread Dean Rasheed
r if we should output "ARRAY((SubPlan 1).col1)" to make it clearer. Since ARRAY_SUBLINK is a special case, which always collects the first column's values, we could just always output "col1" for ARRAY. Regards, Dean

Re: RFR: 8327964: Simplify BigInteger.implMultiplyToLen intrinsic [v2]

2024-03-19 Thread Dean Long
On Tue, 19 Mar 2024 19:06:36 GMT, Yudi Zheng wrote: >> Moving array construction within BigInteger.implMultiplyToLen intrinsic >> candidate to its caller simplifies the intrinsic implementation in JIT >> compiler. > > Yudi Zheng has updated the pull request incrementally with one additional >

Re: RFR: 8327964: Simplify BigInteger.implMultiplyToLen intrinsic [v2]

2024-03-19 Thread Dean Long
On Tue, 19 Mar 2024 19:06:36 GMT, Yudi Zheng wrote: >> Moving array construction within BigInteger.implMultiplyToLen intrinsic >> candidate to its caller simplifies the intrinsic implementation in JIT >> compiler. > > Yudi Zheng has updated the pull request incrementally with one additional >

[kwin] [Bug 483229] Sometimes unable to bring background apps to the front while Chrome/Chromium is running

2024-03-19 Thread Dean Hoover
https://bugs.kde.org/show_bug.cgi?id=483229 --- Comment #8 from Dean Hoover --- The only apps that I've been able to recreate this is Google Chrome and UnGoogled Chromium. I don't use any other Chromium-based browser, and it doesn't seem to happen with Firefox. It's almost as if the browser

Re: Proposal to include --exclude-extension Flag in pg_dump

2024-03-19 Thread Dean Rasheed
space issues and added another test for the filter option, based on the test case you added. I'm marking this ready-for-commit (which I'll probably do myself in a day or two, unless anyone else claims it first). Regards, Dean From f757ebe748ab47d1e1ab40b343af2a43a9183287 Mon Sep 17 00:00:00 2001

Re: Improving EXPLAIN's display of SubPlan nodes

2024-03-18 Thread Dean Rasheed
of a user-defined > function named "rescan()". I think we'd be better off with the > all-caps "RESCAN()". > Or perhaps move the parentheses, and write "(rescan SubPlan N)" or "(reset SubPlan N)". Dunno. Regards, Dean

Re: RFR: 8327964: Simplify BigInteger.implMultiplyToLen intrinsic

2024-03-18 Thread Dean Long
On Tue, 12 Mar 2024 10:44:54 GMT, Yudi Zheng wrote: > Moving array construction within BigInteger.implMultiplyToLen intrinsic > candidate to its caller simplifies the intrinsic implementation in JIT > compiler. src/hotspot/share/opto/library_call.cpp line 5934: > 5932: // 'y_start'

Re: Improving EXPLAIN's display of SubPlan nodes

2024-03-18 Thread Dean Rasheed
tableoid, i.ctid I think "RESET()" or "RESCAN()" or something like that is better than "INGORE()", because it indicates that it is actually doing something. I don't really have a better idea. Perhaps not all uppercase though, since that seems to go against the rest of the EXPLAIN output. Regards, Dean

Re: MERGE ... RETURNING

2024-03-18 Thread Dean Rasheed
On Fri, 15 Mar 2024 at 17:14, Jeff Davis wrote: > > On Fri, 2024-03-15 at 11:20 +, Dean Rasheed wrote: > > > So barring any further objections, I'd like to go ahead and get this > > patch committed. > > I like this feature from a user perspective. So +1 f

[Cscwg-public] CSCWG Agenda March 21, 2024

2024-03-17 Thread Dean Coclin via Cscwg-public
4th 10. Adjourn Dean Coclin CSCWG Chair smime.p7s Description: S/MIME cryptographic signature ___ Cscwg-public mailing list Cscwg-public@cabforum.org https://lists.cabforum.org/mailman/listinfo/cscwg-public

pgsql: Fix PDF doc generation.

2024-03-17 Thread Dean Rasheed
Fix PDF doc generation. Commit c649fa24a4 broke PDF generation, due to a misplaced id attribute. Per buildfarm member crake. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/7eb9a8201890f3b208fd4c109a5b08bf139b692a Modified Files --

pgsql: Add RETURNING support to MERGE.

2024-03-17 Thread Dean Rasheed
of a MERGE query's RETURNING list. Dean Rasheed, reviewed by Isaac Morland, Vik Fearing, Alvaro Herrera, Gurjeet Singh, Jian He, Jeff Davis, Merlin Moncure, Peter Eisentraut, and Wolfgang Walther. Discussion: http://postgr.es/m/CAEZATCWePEGQR5LBn-vD6SfeLZafzEm2Qy_L_Oky2=qw2w3...@mail.gmail.com

pgsql: Fix EXPLAIN output for subplans in MERGE.

2024-03-17 Thread Dean Rasheed
Fix EXPLAIN output for subplans in MERGE. Given a subplan in a MERGE query, EXPLAIN would sometimes fail to properly display expressions involving Params referencing variables in other parts of the plan tree. This would affect subplans outside the topmost join plan node, for which expansion of

pgsql: Fix EXPLAIN output for subplans in MERGE.

2024-03-17 Thread Dean Rasheed
Fix EXPLAIN output for subplans in MERGE. Given a subplan in a MERGE query, EXPLAIN would sometimes fail to properly display expressions involving Params referencing variables in other parts of the plan tree. This would affect subplans outside the topmost join plan node, for which expansion of

pgsql: Fix EXPLAIN output for subplans in MERGE.

2024-03-17 Thread Dean Rasheed
Fix EXPLAIN output for subplans in MERGE. Given a subplan in a MERGE query, EXPLAIN would sometimes fail to properly display expressions involving Params referencing variables in other parts of the plan tree. This would affect subplans outside the topmost join plan node, for which expansion of

Re: Improving EXPLAIN's display of SubPlan nodes

2024-03-17 Thread Dean Rasheed
eve your quick hack in get_parameter() is not > correct in detail, but for the moment I didn't bother to debug it. Yeah, that's exactly what it was, a quick hack. I just wanted to get some output to see what it would look like in a few real cases. Overall, I think this is heading in the right direction. I think we just need a good way to say "the n'th output column of the subplan", that can't be confused with anything else in the output. Regards, Dean

[kwin] [Bug 483229] Unable to click background app/window to foreground using mouse

2024-03-16 Thread Dean Hoover
https://bugs.kde.org/show_bug.cgi?id=483229 --- Comment #6 from Dean Hoover --- Let's try it over Google Drive. Also - I was able to recreate it with UnGoogled-Chromium - just much smaller area than with Google Chrome. Google-Chrome-switching-screens.webm <https://drive.google.com/fil

[kwin] [Bug 483229] Unable to click background app/window to foreground using mouse

2024-03-16 Thread Dean Hoover
https://bugs.kde.org/show_bug.cgi?id=483229 --- Comment #5 from Dean Hoover --- Hello Nate, I was definitely able to recreate it, but playing around a bit I think this might have something to do with Google Chrome. I can't recreate it if I'm using Firefox or even UnGoogled Chromium. I

Re: MERGE ... RETURNING

2024-03-15 Thread Dean Rasheed
On Fri, 15 Mar 2024 at 11:06, Dean Rasheed wrote: > > Updated patch attached. > I have gone over this patch again in detail, and I believe that the code is in good shape. All review comments have been addressed, and the only thing remaining is the syntax question. To recap, this add

[kwin] [Bug 483229] Unable to click background app/window to foreground using mouse

2024-03-14 Thread Dean Hoover
https://bugs.kde.org/show_bug.cgi?id=483229 --- Comment #3 from Dean Hoover --- Sorry Nate - haven't forgot about you. I did play with the new user, and I couldn't seem to recreate it. That being said, I have only gotten to test it for about 5-10 minutes. I hope to dig more into it tonight

Re: MERGE ... WHEN NOT MATCHED BY SOURCE

2024-03-13 Thread Dean Rasheed
Rebased version attached. Regards, Dean diff --git a/doc/src/sgml/mvcc.sgml b/doc/src/sgml/mvcc.sgml new file mode 100644 index f8f83d4..380d0c9 --- a/doc/src/sgml/mvcc.sgml +++ b/doc/src/sgml/mvcc.sgml @@ -394,10 +394,14 @@ conditions for each action are re-evaluated on the updated version

Re: MERGE ... RETURNING

2024-03-13 Thread Dean Rasheed
On Wed, 13 Mar 2024 at 08:58, Dean Rasheed wrote: > > I think I'll go make those doc changes, and back-patch them > separately, since they're not related to this patch. > OK, I've done that. Here is a rebased patch on top of that, with the other changes you suggested. Regards, Dea

pgsql: doc: Improve a couple of places in the MERGE docs.

2024-03-13 Thread Dean Rasheed
doc: Improve a couple of places in the MERGE docs. In the synopsis, make the syntax for merge_update consistent with the syntax for a plain UPDATE command. It was missing the optional "ROW" keyword that can be used in a multi-column assignment, and the option to assign from a multi-column

pgsql: doc: Improve a couple of places in the MERGE docs.

2024-03-13 Thread Dean Rasheed
doc: Improve a couple of places in the MERGE docs. In the synopsis, make the syntax for merge_update consistent with the syntax for a plain UPDATE command. It was missing the optional "ROW" keyword that can be used in a multi-column assignment, and the option to assign from a multi-column

pgsql: doc: Improve a couple of places in the MERGE docs.

2024-03-13 Thread Dean Rasheed
doc: Improve a couple of places in the MERGE docs. In the synopsis, make the syntax for merge_update consistent with the syntax for a plain UPDATE command. It was missing the optional "ROW" keyword that can be used in a multi-column assignment, and the option to assign from a multi-column

Re: MERGE ... RETURNING

2024-03-13 Thread Dean Rasheed
make those doc changes, and back-patch them separately, since they're not related to this patch. Regards, Dean

Broken EXPLAIN output for SubPlan in MERGE

2024-03-12 Thread Dean Rasheed
be INNER_VAR references to the targetlist of the join node immediately under the ModifyTable node. So I think we want to do something like the attached. Regards, Dean diff --git a/src/backend/utils/adt/ruleutils.c b/src/backend/utils/adt/ruleutils.c new file mode 100644 index 2a1ee69..2231752 ---

[kwin] [Bug 483229] Unable to click background app/window to foreground using mouse

2024-03-11 Thread Dean Hoover
https://bugs.kde.org/show_bug.cgi?id=483229 --- Comment #2 from Dean Hoover --- Hello Nate, I've been using Wayland for quite a while now. Once I'm finished with something else I'll test with a clean use account. Thanks - Dean On Mon, Mar 11, 2024 at 3:09 PM Nate Graham wrote: > ht

[Active Window Control] [Bug 483229] New: Unable to click background app/window to foreground using mouse

2024-03-11 Thread Dean Hoover
https://bugs.kde.org/show_bug.cgi?id=483229 Bug ID: 483229 Summary: Unable to click background app/window to foreground using mouse Classification: Plasma Product: Active Window Control Version: unspecified Platform:

RE: [MORPHMET2] Error attempting running 'plotAllSpecimens()' function in geomorph R package

2024-03-09 Thread Adams, Dean [EEOB]
For reasons due to CRAN becoming more stringent with S3-type function calls, we needed to change the plot.param to: plot_param … (the previous no looks for an object or function called ‘param’). Dean Dr. Dean C. Adams Distinguished Professor of Evolutionary Biology Department of Ecology

Re: Improving EXPLAIN's display of SubPlan nodes

2024-03-09 Thread Dean Rasheed
Index Cond: (pguser = CURRENT_USER) but I think that's useful extra clarification. Regards, Dean diff --git a/contrib/postgres_fdw/expected/postgres_fdw.out b/contrib/postgres_fdw/expected/postgres_fdw.out new file mode 100644 index c355e8f..f0ff936 --- a/contrib/postgres_fdw/expected/post

Re: Dump-restore loosing 'attnotnull' bit for DEFERRABLE PRIMARY KEY column(s).

2024-03-08 Thread Dean Rasheed
be reset in load_relcache_init_file(), alongside rd_pkindex, though I don't think it can matter in practice. Regards, Dean

[ccp4bb] EM maps

2024-03-08 Thread Dean Derbyshire
Hi, I'm almost certain this has been addressed before so apologies... but is there a trick to import EM map files into COOT, it keeps crashing when I've tried. Ta muchly in advance Dean To unsubscribe from the CCP4BB list

Re: vacuumdb/clusterdb/reindexdb: allow specifying objects to process in all databases

2024-03-08 Thread Dean Rasheed
ach listed object as well as the system > catalogs. OK, that looks useful, especially given that most people will still probably use this against a single database, and it's making that more flexible. I think this is good to go. Regards, Dean

Re: [Infrastructure] Meeting recordings

2024-03-07 Thread Dean Coclin via Infrastructure
Is there anything that prevents those recipients from downloading and storing those recordings indefinitely? From: Martijn Katerbarg Sent: Thursday, March 7, 2024 8:56 AM To: Dean Coclin ; infrastructure@cabforum.org Subject: Re: Meeting recordings Dean, During the F2F

Re: [Infrastructure] Meeting recordings

2024-03-07 Thread Dean Coclin via Infrastructure
Recordings are only used by the minute takers to assist in that task. After that they should be destroyed. I’m currently receiving recording emails after the CSCWG and the regular CABF meetings Dean Coclin From: Infrastructure On Behalf Of Martijn Katerbarg via

Re: Dump-restore loosing 'attnotnull' bit for DEFERRABLE PRIMARY KEY column(s).

2024-03-07 Thread Dean Rasheed
e thing. So can we get away with making sure that RelationGetIndexList() doesn't set relation->rd_replidindex to a deferrable PK, while still allowing relation->rd_pkindex to be one? Regards, Dean

Re: bug report: some issues about pg_15_stable(8fa4a1ac61189efffb8b851ee77e1bc87360c445)

2024-03-07 Thread Dean Rasheed
On Tue, 5 Mar 2024 at 13:55, Dean Rasheed wrote: > > > If I only execute merge , I will get the following error: > > merge into tgt a using src1 c on a.a = c.a when matched then update > > set b = c.b when not matched then insert (a,b) values(c.a,c.b); -- excute &

pgsql: Fix handling of self-modified tuples in MERGE.

2024-03-07 Thread Dean Rasheed
Fix handling of self-modified tuples in MERGE. When an UPDATE or DELETE action in MERGE returns TM_SelfModified, there are 2 possible causes: 1). The target tuple was already updated or deleted by the current command. This can happen if the target row joins to more than one source row,

pgsql: Fix handling of self-modified tuples in MERGE.

2024-03-07 Thread Dean Rasheed
Fix handling of self-modified tuples in MERGE. When an UPDATE or DELETE action in MERGE returns TM_SelfModified, there are 2 possible causes: 1). The target tuple was already updated or deleted by the current command. This can happen if the target row joins to more than one source row,

pgsql: Fix handling of self-modified tuples in MERGE.

2024-03-07 Thread Dean Rasheed
Fix handling of self-modified tuples in MERGE. When an UPDATE or DELETE action in MERGE returns TM_SelfModified, there are 2 possible causes: 1). The target tuple was already updated or deleted by the current command. This can happen if the target row joins to more than one source row,

Re: RFR: 8308745: ObjArrayKlass::allocate_objArray_klass may call into java while holding a lock [v2]

2024-03-06 Thread Dean Long
On Thu, 7 Mar 2024 01:38:56 GMT, Coleen Phillimore wrote: >> This change creates a new sort of native recursive lock that can be held >> during JNI and Java calls, which can be used for synchronization while >> creating objArrayKlasses at runtime. >> >> Passes tier1-7. > > Coleen Phillimore

Re: RFR: 8308745: ObjArrayKlass::allocate_objArray_klass may call into java while holding a lock

2024-03-06 Thread Dean Long
On Tue, 6 Feb 2024 22:59:04 GMT, Coleen Phillimore wrote: > This change creates a new sort of native recursive lock that can be held > during JNI and Java calls, which can be used for synchronization while > creating objArrayKlasses at runtime. > > Passes tier1-7. Marked as reviewed by dlong

Re: RFR: 8308745: ObjArrayKlass::allocate_objArray_klass may call into java while holding a lock

2024-03-06 Thread Dean Long
On Tue, 6 Feb 2024 22:59:04 GMT, Coleen Phillimore wrote: > This change creates a new sort of native recursive lock that can be held > during JNI and Java calls, which can be used for synchronization while > creating objArrayKlasses at runtime. > > Passes tier1-7.

Re: RFR: 8308745: ObjArrayKlass::allocate_objArray_klass may call into java while holding a lock

2024-03-06 Thread Dean Long
On Tue, 6 Feb 2024 22:59:04 GMT, Coleen Phillimore wrote: > This change creates a new sort of native recursive lock that can be held > during JNI and Java calls, which can be used for synchronization while > creating objArrayKlasses at runtime. > > Passes tier1-7.

Re: RFR: 8308745: ObjArrayKlass::allocate_objArray_klass may call into java while holding a lock

2024-03-06 Thread Dean Long
On Wed, 6 Mar 2024 23:47:01 GMT, Coleen Phillimore wrote: >> src/hotspot/share/runtime/mutex.cpp line 537: >> >>> 535: // can be called by jvmti by VMThread. >>> 536: if (current->is_Java_thread()) { >>> 537: _sem.wait_with_safepoint_check(JavaThread::cast(current)); >> >> Why

Re: RFR: 8308745: ObjArrayKlass::allocate_objArray_klass may call into java while holding a lock

2024-03-06 Thread Dean Long
On Tue, 6 Feb 2024 22:59:04 GMT, Coleen Phillimore wrote: > This change creates a new sort of native recursive lock that can be held > during JNI and Java calls, which can be used for synchronization while > creating objArrayKlasses at runtime. > > Passes tier1-7. OK, that makes sense about

Re: MERGE ... RETURNING

2024-03-06 Thread Dean Rasheed
ysis to turn them into MergeFunc nodes (not quite a complete revert back to an earlier version of the patch, but not far off). Regards, Dean [1] https://www.postgresql.org/message-id/flat/CAEZATCWx0J0-v=Qjc6gXzR=KtsdvAE7Ow=D=mu50agoe+pv...@mail.gmail.com

[MORPHMET2] new measurement error paper and methods

2024-03-06 Thread Adams, Dean [EEOB]
e a recent example, identifying some cases that could elucidate digitizing issues (and could be revisited). All of these tools (both statistical and graphical) are available in the latest versions of geomorph and RRPP, now found on CRAN. Dean Adams and Mike Collyer Dr. Dean C. Adams Distinguished

Re: Proposal to include --exclude-extension Flag in pg_dump

2024-03-06 Thread Dean Rasheed
d be extended to support "exclude extension pattern" lines in the filter file. That syntax is already accepted, but it throws a not-supported error, but it's hopefully not too hard to make that work now. 2). It ought to have some tests in the test script. Regards, Dean

Re: vacuumdb/clusterdb/reindexdb: allow specifying objects to process in all databases

2024-03-05 Thread Dean Rasheed
l these changes are, but I don't really object. You need to update the synopsis section of the docs though. Regards, Dean

Re: RFR: 8308745: ObjArrayKlass::allocate_objArray_klass may call into java while holding a lock

2024-03-05 Thread Dean Long
On Tue, 6 Feb 2024 22:59:04 GMT, Coleen Phillimore wrote: > This change creates a new sort of native recursive lock that can be held > during JNI and Java calls, which can be used for synchronization while > creating objArrayKlasses at runtime. > > Passes tier1-7. Is the caller always a

Stus-List Re: C Rugby Shirt

2024-03-05 Thread Dean McNeill via CnC-List
Just got my Rugby shirt… LOVE IT! Super great quality. Thanks JFK, Very impressed. Dean C 34 Halifax, NS > On Feb 29, 2024, at 1:16 PM, Motion Designs Limited via CnC-List > wrote: > > What Jeff said :-) > > JKC > www.candcyachts.com > Motion Designs Limited >

Re: Dump-restore loosing 'attnotnull' bit for DEFERRABLE PRIMARY KEY column(s).

2024-03-05 Thread Dean Rasheed
dexList() by b0e96f311985 need reverting. Regards, Dean

Re: bug report: some issues about pg_15_stable(8fa4a1ac61189efffb8b851ee77e1bc87360c445)

2024-03-05 Thread Dean Rasheed
te changes to other rows."))); return false; My initial reaction is that neither of those blocks of code is entirely correct, and that they should both be doing both of those checks. I.e., something like the attached (which probably needs some additional test cases). Regards, Dean

[Elecraft] UNSUBSCRIBE!!! Recipient deceased

2024-03-04 Thread Dean Sanders
Sent from my iPhone __ Elecraft mailing list Home: http://mailman.qth.net/mailman/listinfo/elecraft Help: http://mailman.qth.net/mmfaq.htm Post: mailto:Elecraft@mailman.qth.net This list hosted by: http://www.qsl.net Please help

Re: Dump-restore loosing 'attnotnull' bit for DEFERRABLE PRIMARY KEY column(s).

2024-03-04 Thread Dean Rasheed
PKs, so we still want the throwaway NOT NULL constraints in that case, otherwise we'd be hurting performance of restore. Regards, Dean

pgsql: Fix doc omission for MERGE into updatable views.

2024-03-04 Thread Dean Rasheed
Fix doc omission for MERGE into updatable views. Commit 5f2e179bd3 missed one place in rules.sgml that should have mentioned MERGE. Also, be more specific when saying that MERGE doesn't support rules, since it does support SELECT rules. Branch -- master Details ---

Re: [VOTE] Require Java 17 for Maven 4

2024-03-02 Thread Robert Dean
+1 On Wed, Feb 28, 2024 at 2:32 AM Benjamin Marwell wrote: > > Hi Maven Devs/Users/Committers and PMC members! > > After several discussions on the mailing lists, I would like to > start a vote in favour of setting the minimal Java bytecode target > of Maven-Core 4 to 17 and hence require Java

Re: Supporting MERGE on updatable views

2024-02-29 Thread Dean Rasheed
On Thu, 29 Feb 2024 at 09:50, Alvaro Herrera wrote: > > By all means let's get the feature out there. It's not a frequently > requested thing but it does seem to come up. > Pushed. Thanks for reviewing. Regards, Dean

pgsql: Support MERGE into updatable views.

2024-02-29 Thread Dean Rasheed
there is no rewriter support for non-SELECT rules with MERGE operations. Dean Rasheed, reviewed by Jian He and Alvaro Herrera. Discussion: https://postgr.es/m/CAEZATCVcB1g0nmxuEc-A+gGB0HnfcGQNGYH7gS=7rq0u0zo...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg

pgsql: Remove field UpdateContext->updated in nodeModifyTable.c

2024-02-29 Thread Dean Rasheed
ate(), ensuring that ExecUpdateEpilogue() is always called if ExecUpdateAct() returns TM_Ok, reducing the chance of bugs. Dean Rasheed, reviewed by Alvaro Herrera. Discussion: https://postgr.es/m/CAEZATCWGGmigGBzLHkJm5Ccv2mMxXmwi3%2Buq0yhwDHm-tsvSLg%40mail.gmail.com Branch -- master Deta

Re: NullPointer this.layoutCache is null

2024-02-29 Thread Dean Wookey
e on the wrong thread");//set break point on this line and view the stack to see what's causing it } This might not be the cause of your problem, but if you have instances where things are done in the wrong thread, you'll definitely hit sporadic issues. Dean On Thu, Feb 29, 2024 at 9:16 AM Kri

Re: [Cscwg-public] Notice of IPR review Ballots CSCWG 21 and 22

2024-02-28 Thread Dean Coclin via Cscwg-public
The review period for CSCWG 21 and 22 has concluded. No essential claims were filed. Corey-please create the final guideline, based on the drafts, and publish to the website. The effective date will be today. Thank you, Dean Coclin CSCWG Chair From: Cscwg-public On Behalf

Re: bug report: some issues about pg_15_stable(8fa4a1ac61189efffb8b851ee77e1bc87360c445)

2024-02-28 Thread Dean Rasheed
that I might be overlooking something, particularly in relation to what might get added to the targetlist at various stages during planning for different types of query. Regards, Dean

[Cscwg-public] CSCWG meeting minutes Feb 8, 2024

2024-02-27 Thread Dean Coclin via Cscwg-public
Attendees: Abhishek Bhat (eMudhra), Ben Dewberry (Keyfactor), Brianca Martin (Amazon), Bruce Morton (Entrust), Corey Bonnell (DigiCert), Dean Coclin (DigiCert), Dimitris Zacharopoulos (HARICA), Ian McMillan (Microsoft), Inaba Atsushi (GlobalSign), Inigo Barreira (Sectigo), Keshava Nagaraju

Re: Functions to return random numbers in a given range

2024-02-27 Thread Dean Rasheed
On Sat, 24 Feb 2024 at 17:10, Tomas Vondra wrote: > > Hi Dean, > > I did a quick review and a little bit of testing on the patch today. I > think it's a good/useful idea, and I think the code is ready to go (the > code is certainly much cleaner than anything I'd writt

Re: bug report: some issues about pg_15_stable(8fa4a1ac61189efffb8b851ee77e1bc87360c445)

2024-02-27 Thread Dean Rasheed
d better to build the projection in the executor rather than the planner, since then the extra work can be avoided, if EPQ is not invoked. It seems to work (it passes the isolation tests, and I couldn't break it in ad hoc testing), but it definitely needs tidying up, and it's hard to be sure that

Re: RFR: 8326524: Rename agent_common.h

2024-02-23 Thread Dean Long
On Thu, 22 Feb 2024 19:38:26 GMT, Kim Barrett wrote: > Please review this trivial change that renames the file > test/hotspot/jtreg/vmTestbase/nsk/share/jvmti/agent_common/agent_common.h to > agent_common.hpp. > > The #include updates were performed mechanically, and builds would fail if >

Re: RangeTblEntry.inh vs. RTE_SUBQUERY

2024-02-23 Thread Dean Rasheed
nly need * to build RelOptInfos for them, which is done by expand_appendrel_subquery. */ > Is this something we should explain the RangeTblEntry comments? > +1 Regards, Dean

Re: RFR: 8326524: Rename agent_common.h

2024-02-22 Thread Dean Long
On Thu, 22 Feb 2024 19:38:26 GMT, Kim Barrett wrote: > Please review this trivial change that renames the file > test/hotspot/jtreg/vmTestbase/nsk/share/jvmti/agent_common/agent_common.h to > agent_common.hpp. > > The #include updates were performed mechanically, and builds would fail if >

Re: [DISCUSS] Java version for Maven

2024-02-22 Thread Robert Dean
, if retiring Java 8 and lower output support allows Maven to shed technical debt and deliver improvements faster, I'd get over my disappointment. :) Regards, Robert Dean On Thu, Feb 22, 2024 at 3:49 PM Tamás Cservenák wrote: > > I think this starts to make reasonable picture: > > If you are on

Re: bug report: some issues about pg_15_stable(8fa4a1ac61189efffb8b851ee77e1bc87360c445)

2024-02-22 Thread Dean Rasheed
ble is subject to concurrent inserts (or primary key updates), it might be better to use INSERT ... ON CONFLICT DO UPDATE [2] instead of MERGE. That would avoid inserting duplicates (though I can't say how compatible that is with anything in Oracle). Regards, Dean [1] https://w

Re: bug report: some issues about pg_15_stable(8fa4a1ac61189efffb8b851ee77e1bc87360c445)

2024-02-21 Thread Dean Rasheed
On Tue, 20 Feb 2024 at 14:49, Dean Rasheed wrote: > > On the face of it, the simplest fix is to tweak is_simple_union_all() > to prevent UNION ALL subquery pullup for MERGE, forcing a > subquery-scan plan. A quick test shows that that fixes the reported > issue. > >

Re: [Infrastructure] Vote tracking excel

2024-02-21 Thread Dean Coclin via Infrastructure
We use the tool in the membership management portal now to track the votes. Dean Coclin Sr. Director Business Development M 1.781.789.8686 From: Infrastructure On Behalf Of Inigo Barreira via Infrastructure Sent: Wednesday, February 21, 2024 7:48 AM To: Ben Wilson via

Re: numeric_big in make check?

2024-02-20 Thread Dean Rasheed
On Tue, 20 Feb 2024 at 15:16, Tom Lane wrote: > > Dean Rasheed writes: > > Looking at the script itself, the addition, subtraction, > > multiplication and division tests at the top are probably pointless, > > since I would expect those operations to be tested adequatel

Re: bug report: some issues about pg_15_stable(8fa4a1ac61189efffb8b851ee77e1bc87360c445)

2024-02-20 Thread Dean Rasheed
On Tue, 20 Feb 2024 at 14:49, Dean Rasheed wrote: > > Also, if the concurrent update were an update of a key > column that was included in the join condition, the re-scan would > follow the update to a new matching source row, which is inconsistent > with what would happen if

Re: bug report: some issues about pg_15_stable(8fa4a1ac61189efffb8b851ee77e1bc87360c445)

2024-02-20 Thread Dean Rasheed
e of a key column that was included in the join condition, the re-scan would follow the update to a new matching source row, which is inconsistent with what would happen if it were a join to a regular relation. Thoughts? Regards, Dean

Re: numeric_big in make check?

2024-02-20 Thread Dean Rasheed
basic arithmetic operations internally. We might want to check that I/O of large numerics is still being tested properly though. If we did that, numeric_big would be even further down the list of expensive tests, and I'd say it should be run by default. Regards, Dean

Re: numeric_big in make check?

2024-02-19 Thread Dean Rasheed
f the top of my head, I can't say to what extent that's true, but it wouldn't surprise me if at least some of the tests added in the last 4 commits to touch that file aren't covered by tests elsewhere. Indeed that certainly looks like the case for 18a02ad2a5. I'm sure those tests could be pared down though. Regards, Dean

[ccp4bb] Structural Biology Workshop, June 10-12 2024

2024-02-15 Thread Myles, Dean A A
Dear All, We would like to bring to your attention the 2024 Neutrons in Structural Biology workshop. This workshop will highlight the need for next-generation instruments and toolsets for structural biology, with a focus on neutrons and other complementary techniques, and the development of

[Cscwg-public] Final CSCWG Minutes Jan 25, 2024

2024-02-08 Thread Dean Coclin via Cscwg-public
Here are the final minutes of the subject call: CSCWG Conference Call-2024/01/25 Attendees: Scott Rea, Corey Bonnell, Thomas Zermeno, Bruce Morton, Atsushi Inaba, Mohit Kumar, Dean Coclin, Brianca Martin, Martijn Katerbarg, Bhat Abhishek, Trevoli Ponds-White, Tim Crawford

RE: [MORPHMET2] related question on comparative methods using fossils

2024-02-08 Thread Adams, Dean [EEOB]
fossils) is preferable than using a fossil-only backbone phylogeny, as the problem you outlined can be more pronounced with the latter approach. Dean Dr. Dean C. Adams Distinguished Professor of Evolutionary Biology Department of Ecology, Evolution, and Organismal Biology Iowa State University

[Cscwg-public] CSCWG Agenda February 8, 2024

2024-02-05 Thread Dean Coclin via Cscwg-public
-stamp Requirements update. 6. Discussions for F2F 7. Other business 8. Next meeting - February 22nd (Should we cancel since F2F is the following week?) 9. Adjourn Dean Coclin CSCWG Chair smime.p7s Description: S/MIME cryptographic signature

RE: [MORPHMET2] ontogenetic trajectories and phylogenetic hierarchy

2024-02-05 Thread Adams, Dean [EEOB]
Evolutionary Biology. 10(216):1-10. Dean Dr. Dean C. Adams Distinguished Professor of Evolutionary Biology Department of Ecology, Evolution, and Organismal Biology Iowa State University https://faculty.sites.iastate.edu/dcadams/ phone: 515-294-3834 -Original Message- From: morphmet2@googlegroups.com

Re: bug report: some issues about pg_15_stable(8fa4a1ac61189efffb8b851ee77e1bc87360c445)

2024-02-05 Thread Dean Rasheed
stent with what both Oracle and Postgres do if you replace the merge command with the equivalent standalone update for that row: "update mergeinto_0023_tb01 set year = 30 where id = 2" in the second session. So I'd say that this is an Oracle bug. Regards, Dean

Re: Functions to return random numbers in a given range

2024-01-30 Thread Dean Rasheed
(0.5). They're useful for a quick visual check of the results, and confirming the expected number of digits after the decimal point in the numeric case. However, I think those tests are insufficient on their own. Regards, Dean

Re: Functions to return random numbers in a given range

2024-01-29 Thread Dean Rasheed
gly, the cfbot didn't pick up on the fact that it needed rebasing. Anyway, the copyright years in the new file's header comment needed updating, so here is a rebase doing that. Regards, Dean From 15d0ba981ff03eca7143726fe7512adf00ee3a84 Mon Sep 17 00:00:00 2001 From: Dean Rasheed Date: Fri, 25 Au

Re: Functions to return random numbers in a given range

2024-01-29 Thread Dean Rasheed
_MIN/MAX as arguments to these functions, if that's what you need. I think if we were going to have a shorthand for getting full-range random integers, it would probably be better to introduce separate no-arg functions for that. I'm not really sure if that's a sufficiently common use case to justify the effort though. Regards, Dean

Re: MERGE ... WHEN NOT MATCHED BY SOURCE

2024-01-29 Thread Dean Rasheed
d on the plan chosen. I think the best (and probably simplest) solution is to always opt for a NOT MATCHED BY TARGET action in this case, so then the result is predictable, and we can document what is expected to happen. Regards, Dean

<    1   2   3   4   5   6   7   8   9   10   >