Re: MERGE ... RETURNING

2023-01-09 Thread Dean Rasheed
re standard-looking RETURNING list, without a WITH clause. Regards, Dean

Re: [PATCH] random_normal function

2023-01-09 Thread Dean Rasheed
On Mon, 9 Jan 2023 at 15:26, Tom Lane wrote: > > Dean Rasheed writes: > > So IMO all pseudorandom functions should share the same PRNG state and > > seed-setting functions. That would mean they should all be in the same > > (new) C file, so that the PRNG state can be k

Re: MERGE ... RETURNING

2023-01-09 Thread Dean Rasheed
gt; returning list expands to all the source columns, followed by all the >> target columns. > > Does this lead to a problem in the event there are same-named columns between > source and target? > Not really. It's exactly the same as doing "SELECT * FROM src JOIN tgt ON ...". That may lead to duplicate column names in the result, but that's not necessarily a problem. Regards, Dean

Re: [PATCH] random_normal function

2023-01-09 Thread Dean Rasheed
se to add a new "Random Functions" section to the docs, and move the descriptions of random(), random_normal() and setseed() there. That way, all the functions affected by setseed() can be kept together on one page (future random functions may not all be sensibly classified as "mathematic

[pve-devel] [PATCH docs 0/1] fix #4456: move apidata into seperate json file

2023-01-09 Thread Dean Galvin via pve-devel
icer experience to allow the use of the raw json. This adds a new buildartifact that was previously a static file apidata.js and creates a new staticfile apidata.json which is what is utilized to create apidata.js at build time (make/apidata.js). Dean Galvin (1): fix #4456: move apidata into sepe

MERGE ... RETURNING

2023-01-08 Thread Dean Rasheed
ke a good point to stop playing around and get feedback on whether this seems useful, or if anyone has other ideas. Regards, Dean diff --git a/doc/src/sgml/ref/merge.sgml b/doc/src/sgml/ref/merge.sgml new file mode 100644 index 0995fe0..4fc0a65 --- a/doc/src/sgml/ref/merge.sgml +++ b/doc/src/sgml/ref/merge.

Re: MERGE ... WHEN NOT MATCHED BY SOURCE

2023-01-07 Thread Dean Rasheed
On Thu, 5 Jan 2023 at 13:21, Dean Rasheed wrote: > > On Thu, 5 Jan 2023 at 11:03, Alvaro Herrera wrote: > > > > > + /* Join type required */ > > > + if (left_join && right_join) > > > + qry->mergeJoinType = JOIN_FULL; >

Re: add \dpS to psql

2023-01-07 Thread Dean Rasheed
On Sat, 7 Jan 2023 at 00:36, Nathan Bossart wrote: > > On Fri, Jan 06, 2023 at 06:52:33PM +, Dean Rasheed wrote: > > > > So I think we should use the same SQL clauses as every other psql > > command that supports "S", namely: >

pgsql: psql: Add support for \dpS and \zS.

2023-01-07 Thread Dean Rasheed
psql: Add support for \dpS and \zS. This allows an optional "S" modifier to be added to \dp and \z, to have them include system objects in the list. Note that this also changes the behaviour of a bare \dp or \z without the "S" modifier to include temp objects in the list, and exclude

Re: [GNC] Request for Automatic Reconciliation Function

2023-01-06 Thread Dean Gibson
You are asking for the impossible.  It is not possible to predict all the possible ways a computer program could make a mistake.  It's just not knowable. On 2023-01-06 17:22, Bite Gao wrote: GnuCash Developers and Maintainers:   ...   Personally, I do not found that how computer program

Re: add \dpS to psql

2023-01-06 Thread Dean Rasheed
search_path. So I think we should use the same SQL clauses as every other psql command that supports "S", namely: if (!showSystem && !pattern) appendPQExpBufferStr(, " AND n.nspname <> 'pg_catalog'\n" " AND n.nspname &

Re: [PATCH] psql: Add tab-complete for optional view parameters

2023-01-06 Thread Dean Rasheed
both create view and > alter view. > Hmm, I don't think we should be offering "check_option" as a tab completion for CREATE VIEW at all, since that would encourage users to use non-SQL-standard syntax, rather than CREATE VIEW ... WITH [CASCADED|LOCAL] CHECK OPTION. Regards, Dean

Re: Improve tab completion for ALTER FUNCTION/PROCEDURE/ROUTINE

2023-01-06 Thread Dean Rasheed
On Thu, 5 Jan 2023 at 12:52, Dean Rasheed wrote: > > While playing around with this, I noticed that the "... SET SCHEMA" > case offers "FROM CURRENT" and "TO" as completions, which is > incorrect. It should really offer to complete with a list of schem

pgsql: Fix tab completion of ALTER FUNCTION/PROCEDURE/ROUTINE ... SET S

2023-01-06 Thread Dean Rasheed
Fix tab completion of ALTER FUNCTION/PROCEDURE/ROUTINE ... SET SCHEMA. The ALTER DATABASE|FUNCTION|PROCEDURE|ROLE|ROUTINE|USER ... SET case in psql tab completion failed to exclude = "SCHEMA", which caused ALTER FUNCTION|PROCEDURE|ROUTINE ... SET SCHEMA to complete with "FROM CURRENT" and "TO",

pgsql: Fix tab completion of ALTER FUNCTION/PROCEDURE/ROUTINE ... SET S

2023-01-06 Thread Dean Rasheed
Fix tab completion of ALTER FUNCTION/PROCEDURE/ROUTINE ... SET SCHEMA. The ALTER DATABASE|FUNCTION|PROCEDURE|ROLE|ROUTINE|USER ... SET case in psql tab completion failed to exclude = "SCHEMA", which caused ALTER FUNCTION|PROCEDURE|ROUTINE ... SET SCHEMA to complete with "FROM CURRENT" and "TO",

pgsql: Fix tab completion of ALTER FUNCTION/PROCEDURE/ROUTINE ... SET S

2023-01-06 Thread Dean Rasheed
Fix tab completion of ALTER FUNCTION/PROCEDURE/ROUTINE ... SET SCHEMA. The ALTER DATABASE|FUNCTION|PROCEDURE|ROLE|ROUTINE|USER ... SET case in psql tab completion failed to exclude = "SCHEMA", which caused ALTER FUNCTION|PROCEDURE|ROUTINE ... SET SCHEMA to complete with "FROM CURRENT" and "TO",

pgsql: Fix tab completion of ALTER FUNCTION/PROCEDURE/ROUTINE ... SET S

2023-01-06 Thread Dean Rasheed
Fix tab completion of ALTER FUNCTION/PROCEDURE/ROUTINE ... SET SCHEMA. The ALTER DATABASE|FUNCTION|PROCEDURE|ROLE|ROUTINE|USER ... SET case in psql tab completion failed to exclude = "SCHEMA", which caused ALTER FUNCTION|PROCEDURE|ROUTINE ... SET SCHEMA to complete with "FROM CURRENT" and "TO",

pgsql: Fix tab completion of ALTER FUNCTION/PROCEDURE/ROUTINE ... SET S

2023-01-06 Thread Dean Rasheed
Fix tab completion of ALTER FUNCTION/PROCEDURE/ROUTINE ... SET SCHEMA. The ALTER DATABASE|FUNCTION|PROCEDURE|ROLE|ROUTINE|USER ... SET case in psql tab completion failed to exclude = "SCHEMA", which caused ALTER FUNCTION|PROCEDURE|ROUTINE ... SET SCHEMA to complete with "FROM CURRENT" and "TO",

pgsql: Fix tab completion of ALTER FUNCTION/PROCEDURE/ROUTINE ... SET S

2023-01-06 Thread Dean Rasheed
Fix tab completion of ALTER FUNCTION/PROCEDURE/ROUTINE ... SET SCHEMA. The ALTER DATABASE|FUNCTION|PROCEDURE|ROLE|ROUTINE|USER ... SET case in psql tab completion failed to exclude = "SCHEMA", which caused ALTER FUNCTION|PROCEDURE|ROUTINE ... SET SCHEMA to complete with "FROM CURRENT" and "TO",

Re: Improve tab completion for ALTER FUNCTION/PROCEDURE/ROUTINE

2023-01-06 Thread Dean Rasheed
On Fri, 6 Jan 2023 at 02:38, vignesh C wrote: > > On Thu, 5 Jan 2023 at 18:22, Dean Rasheed wrote: > > > > That leads to the attached, which barring objections, I'll push shortly. > > The changes look good to me. > Pushed. Regards, Dean

pgsql: Improve tab completion for ALTER FUNCTION/PROCEDURE/ROUTINE.

2023-01-06 Thread Dean Rasheed
Improve tab completion for ALTER FUNCTION/PROCEDURE/ROUTINE. This adds psql tab completion for each of the actions supported by ALTER FUNCTION/PROCEDURE/ROUTINE. Vignesh C, reviewed by Dong Wook Lee, Michael Paquier, Melih Mutlu and me. Discussion:

[knotes] [Bug 463906] New: New note from clipboard doesn't 'paste' the content correctly

2023-01-05 Thread Dean
https://bugs.kde.org/show_bug.cgi?id=463906 Bug ID: 463906 Summary: New note from clipboard doesn't 'paste' the content correctly Classification: Applications Product: knotes Version: 5.22.0 Platform: Manjaro

[knotes] [Bug 463906] New: New note from clipboard doesn't 'paste' the content correctly

2023-01-05 Thread Dean
https://bugs.kde.org/show_bug.cgi?id=463906 Bug ID: 463906 Summary: New note from clipboard doesn't 'paste' the content correctly Classification: Applications Product: knotes Version: 5.22.0 Platform: Manjaro

[webkit-changes] [WebKit/WebKit] 9b251c: Revert 8c5dd8c31d25. rdar://problem/103764832

2023-01-05 Thread Dean Jackson
/258220@main Canonical link: https://commits.webkit.org/257979.13@safari-7615.1.16.1-branch Commit: 7fa55dd58256b342bb5da5737bf07db8e6db74bf https://github.com/WebKit/WebKit/commit/7fa55dd58256b342bb5da5737bf07db8e6db74bf Author: Dean Jackson Date: 2023-01-05 (Thu, 05 Jan 2023

Re: MERGE ... WHEN NOT MATCHED BY SOURCE

2023-01-05 Thread Dean Rasheed
tainly not the same, but > it makes me a bit unconfortable. Maybe it's OK, though. > Yeah I agree, it's a bit ugly. Perhaps a better solution would be to do away with that field entirely and just make the decision in transform_MERGE_to_join() by examining the action list again. That would require making MergeAction's "matched" field a MergeMatchKind rather than a bool, but maybe that's not so bad, since retaining that information might prove useful one day. Regards, Dean

Re: Improve tab completion for ALTER FUNCTION/PROCEDURE/ROUTINE

2023-01-05 Thread Dean Rasheed
" and "TO" as completions, which is incorrect. It should really offer to complete with a list of schemas. However, since that's a pre-existing bug in a different region of the code, I think it's best addressed in a separate patch, which probably ought to be back-patched. Regards,

Re: [go-nuts] go get created directories with exclamation points

2023-01-04 Thread Dean Schulze
etBrains, since it knows how to > handle those escaped capital letters. > > -- Marcin > > On Wed, Jan 4, 2023 at 8:30 AM Dean Schulze wrote: > >> I did go get to download some Azure SDK for Go modules. This created >> directories with exclamation points in their names.

Re: [lace] Here we go!

2023-01-04 Thread Muir Dean
Hello on the new domain! Thank you, Liz, for keeping the list going. I’m getting back to my lacemaking on a much more consistent basis and I look forward to conversations here. Best, Muir/ Francesca Sent from my iPad > On Jan 4, 2023, at 6:46 AM, Elizabeth Reynolds wrote: > > Happy New Year!

[webkit-changes] [WebKit/WebKit] 60f0ca: Safari should pass current URL to ARQL when using ...

2023-01-04 Thread Dean Jackson
Branch: refs/heads/main Home: https://github.com/WebKit/WebKit Commit: 60f0cac6d918171da9beae365f712a3ac1166bd1 https://github.com/WebKit/WebKit/commit/60f0cac6d918171da9beae365f712a3ac1166bd1 Author: Dean Jackson Date: 2023-01-04 (Wed, 04 Jan 2023) Changed paths: M

Re: Underscores in numeric literals

2023-01-04 Thread Dean Rasheed
Oh, one other minor nit -- in parser/scan.l: -real ({decinteger}|{numeric})[Ee][-+]?{decdigit}+ +real ({decinteger}|{numeric})[Ee][-+]?{decinteger}+ the final "+" isn't necessary now. Regards, Dean

Re: Underscores in numeric literals

2023-01-04 Thread Dean Rasheed
utines, rather than having it distributed. Regards, Dean diff --git a/doc/src/sgml/syntax.sgml b/doc/src/sgml/syntax.sgml new file mode 100644 index 956182e..27e53b4 --- a/doc/src/sgml/syntax.sgml +++ b/doc/src/sgml/syntax.sgml @@ -729,6 +729,20 @@ $function$ + For visual g

Re: [chirp_users] New chirp-next build

2023-01-03 Thread Dean Berglund
Chirp often, it has been a nice program to go to when i needed it and when helping others get their HTs programmed. 73, Dean - KC9REN On 1/2/2023 10:21 AM, Ken Hansen wrote: Dean, Your Win7 license/COA allows you to upgrade your Win7 machine to Win10 for free. If your machine is incapable

Re: Connection hangs over CGNAT (Starlink)

2023-01-02 Thread Dean Davis
ween new and established/related ( can not confirm ) ugly but works for me regards dean On Thu, 2022-12-15 at 21:12 -0500, Nikolay Martynov wrote: > Hi! > > I'm experiencing strange behaviour with wireguard: from time to time > connection 'freezes'. > Most often I'm observing this o

Re: MERGE ... WHEN NOT MATCHED BY SOURCE

2023-01-02 Thread Dean Rasheed
On Fri, 30 Dec 2022 at 16:56, Dean Rasheed wrote: > > Attached is a WIP patch. > Updated patch attached, now with updated docs and some other minor tidying up. Regards, Dean diff --git a/doc/src/sgml/mvcc.sgml b/doc/src/sgml/mvcc.sgml new file mode 100644 index b87ad5c..1482ede ---

Re: [chirp_users] New chirp-next build

2023-01-02 Thread Dean Berglund
wrote: To be more accurate, it is made for Linux, Mac OS-X and Windows. Microsoft no longer support Windows 7. On Mon, 2 Jan 2023 at 14:31, Dean Berglund wrote: I would think it would be good to make it clear this "next" version of Chirp is made for Windows 10 and do

Re: [chirp_users] New chirp-next build

2023-01-02 Thread Dean Berglund
I would think it would be good to make it clear this "next" version of Chirp is made for Windows 10 and doesn't work on Windows 7. Dean - KC9REN On 1/2/2023 6:25 AM, Rich NE1EE wrote: > On 2023-01-02 02:09:-0800, you wrote: >> http://trac.chirp.danplanet.com/chirp_next/ &g

Bug in check for unreachable MERGE WHEN clauses

2023-01-02 Thread Dean Rasheed
Re-reading my latest MERGE patch, I realised there is a trivial, pre-existing bug in the check for unreachable WHEN clauses, which means it won't spot an unreachable WHEN clause if it doesn't have an AND condition. So the checks need to be re-ordered, as in the attached. Regards, Dean diff --git

Re: review for kivy/2.1.0-1

2022-12-31 Thread Dean Serenevy
Hi, thanks! > * Copyright: try using standard license shortnames [1] where > possible: Easing appears identical to BSD-3-clause; Khronos looks > a lot like Expat. You're right, the wording differed from the sample text, so I used different names, but the differences are not enough to

Re: [chirp_users] What's next for CHIRP

2022-12-31 Thread Dean Berglund
I want to thank all of you that are working on Chirp. Amazing! Dean - KC9REN On 12/31/2022 7:30 PM, Dan Smith via chirp_users wrote: > Hi all, > > I'd like to announce the availability of what I'm calling the "CHIRP-next" > build for the new year. If you're not aware,

MERGE ... WHEN NOT MATCHED BY SOURCE

2022-12-30 Thread Dean Rasheed
ached is a WIP patch. I haven't updated the docs yet, and there are probably a few other things to tidy up and test, but the basic functionality is there. Regards, Dean diff --git a/src/backend/optimizer/prep/prepjointree.c b/src/backend/optimizer/prep/prepjointree.c new file mode 100644 in

Re: [netmod] WG adoption call: draft-dbb-netmod-acl-03

2022-12-26 Thread Dean Bogdanovic
Support the adoption Dean On 19 Dec 2022, at 18:00, Lou Berger wrote: > Hello, > > This email begins a 3-week adoption poll for: > https://datatracker.ietf.org/doc/draft-dbb-netmod-acl/ > > Please voice your support or technical objections to adoption on the > list by th

Integrated: 8296409: Multiple copies of accelerator change listeners are added to MenuItems, but only 1 is removed

2022-12-19 Thread Dean Wookey
On Fri, 4 Nov 2022 16:07:54 GMT, Dean Wookey wrote: > When menu buttons are added and removed from the scene, an accelerator change > listener is added to each menu item in the menu. There is nothing stopping > the same change listener being added multiple times. > > MenuButto

Bug#985189: ITP: et -- Eternal Terminal (ET) is a remote shell that automatically reconnects without interrupting the session.

2022-12-17 Thread Dean Hamstead
Hopefully this effort hasnt stalled On Sun, 14 Mar 2021 09:17:06 -0500 Jason Gauci wrote: > I'm fine with changing the name. > > On Sun, Mar 14, 2021, 8:44 AM Gard Spreemann wrote: > > > > > Jason Gauci writes: > > > > > Package name : et > > > Version : 6.1.4 > > > Upstream Author : Jason

Bug#985189: ITP: et -- Eternal Terminal (ET) is a remote shell that automatically reconnects without interrupting the session.

2022-12-17 Thread Dean Hamstead
Hopefully this effort hasnt stalled On Sun, 14 Mar 2021 09:17:06 -0500 Jason Gauci wrote: > I'm fine with changing the name. > > On Sun, Mar 14, 2021, 8:44 AM Gard Spreemann wrote: > > > > > Jason Gauci writes: > > > > > Package name : et > > > Version : 6.1.4 > > > Upstream Author : Jason

[webkit-changes] [WebKit/WebKit] 5ba9be: Catalyst build is broken

2022-12-15 Thread Dean Jackson
Branch: refs/heads/main Home: https://github.com/WebKit/WebKit Commit: 5ba9bec9bc99aed57025dcc971f6a226215293d6 https://github.com/WebKit/WebKit/commit/5ba9bec9bc99aed57025dcc971f6a226215293d6 Author: Dean Jackson Date: 2022-12-15 (Thu, 15 Dec 2022) Changed paths: M

[webkit-changes] [WebKit/WebKit] 7b47f8: [iOS EWS] TestWebKitAPI.ProcessSwap.CrossOriginSys...

2022-12-13 Thread Dean Jackson
Branch: refs/heads/main Home: https://github.com/WebKit/WebKit Commit: 7b47f891dd8ef065e9ac7656f30975acca997ef9 https://github.com/WebKit/WebKit/commit/7b47f891dd8ef065e9ac7656f30975acca997ef9 Author: Dean Jackson Date: 2022-12-13 (Tue, 13 Dec 2022) Changed paths: M

[GNC] Mutual fund price computation incorrect

2022-12-13 Thread Dean Jagels
. For example, entering 474.228 shares and a Buy amount of 11153.85, I see a Price field that reads "1101/79038". Any hints on what's up? Thanks, Dean ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription p

[webkit-changes] [WebKit/WebKit] 82b61e: P3 colorspace support for WebGL canvas on iOS

2022-12-12 Thread Dean Jackson
Branch: refs/heads/main Home: https://github.com/WebKit/WebKit Commit: 82b61e28388d39958b3747cd2c88781c07b82489 https://github.com/WebKit/WebKit/commit/82b61e28388d39958b3747cd2c88781c07b82489 Author: Dean Jackson Date: 2022-12-12 (Mon, 12 Dec 2022) Changed paths: M

Re: RFR: 8296409: Multiple copies of accelerator change listeners are added to MenuItems, but only 1 is removed [v3]

2022-12-10 Thread Dean Wookey
doesn't > remove the additional instance. > > This pull request just removes the redundant code in the MenuButtonSkinBase. Dean Wookey has updated the pull request with a new target base due to a merge or a rebase. The pull request now contains four commits: - Implemented alternative

Re: RFR: 8296409: Multiple copies of accelerator change listeners are added to MenuItems, but only 1 is removed [v2]

2022-12-10 Thread Dean Wookey
On Mon, 7 Nov 2022 12:03:38 GMT, Dean Wookey wrote: >> When menu buttons are added and removed from the scene, an accelerator >> change listener is added to each menu item in the menu. There is nothing >> stopping the same change listener being added multiple times. >>

Re: Documenting MERGE INTO ONLY ...

2022-12-09 Thread Dean Rasheed
On Fri, 9 Dec 2022 at 10:02, Alvaro Herrera wrote: > > On 2022-Dec-08, Nathan Bossart wrote: > > > On Thu, Dec 08, 2022 at 03:26:52PM +, Dean Rasheed wrote: > > > While testing MERGE, I noticed that it supports inheritance > > > hierarchies and the ONLY k

pgsql: Update MERGE docs to mention that ONLY is supported.

2022-12-09 Thread Dean Rasheed
specified. Update merge.sgml to mention this, and while at it, add some regression tests to cover it. Dean Rasheed, reviewed by Nathan Bossart. Backpatch to 15, where MERGE was added. Discussion: https://postgr.es/m/CAEZATCU0XM-bJCvpJuVRU3UYNRqEBS6g4-zH%3Dj9Ye0caX8F6uQ%40mail.gmail.com Branch

pgsql: Update MERGE docs to mention that ONLY is supported.

2022-12-09 Thread Dean Rasheed
specified. Update merge.sgml to mention this, and while at it, add some regression tests to cover it. Dean Rasheed, reviewed by Nathan Bossart. Backpatch to 15, where MERGE was added. Discussion: https://postgr.es/m/CAEZATCU0XM-bJCvpJuVRU3UYNRqEBS6g4-zH%3Dj9Ye0caX8F6uQ%40mail.gmail.com Branch

Documenting MERGE INTO ONLY ...

2022-12-08 Thread Dean Rasheed
ONLY, and it would be a pain to make them that. Regards, Dean diff --git a/doc/src/sgml/ref/merge.sgml b/doc/src/sgml/ref/merge.sgml new file mode 100644 index e07adda..bc7f4b4 --- a/doc/src/sgml/ref/merge.sgml +++ b/doc/src/sgml/ref/merge.sgml @@ -22,13 +22,13 @@ PostgreSQL documentation

[webkit-changes] [WebKit/WebKit] 407bf5: Add more deprecation guards for AVFoundation

2022-12-07 Thread Dean Jackson
Branch: refs/heads/main Home: https://github.com/WebKit/WebKit Commit: 407bf5b3e4df1c25be1ac59021623d370e2f435c https://github.com/WebKit/WebKit/commit/407bf5b3e4df1c25be1ac59021623d370e2f435c Author: Dean Jackson Date: 2022-12-07 (Wed, 07 Dec 2022) Changed paths: M

[webkit-changes] [WebKit/WebKit] ce361a: Add deprecation guards for various AVFoundation calls

2022-12-05 Thread Dean Jackson
Branch: refs/heads/main Home: https://github.com/WebKit/WebKit Commit: ce361abc6ad80a0353e8af5115af58af333c1dd4 https://github.com/WebKit/WebKit/commit/ce361abc6ad80a0353e8af5115af58af333c1dd4 Author: Dean Jackson Date: 2022-12-05 (Mon, 05 Dec 2022) Changed paths: M

Re: Improve performance of pg_strtointNN functions

2022-12-04 Thread Dean Rasheed
it's morally wrong, and it risks breaking when Peter commits his patch. Regards, Dean

Request to join the team or Request for sponsor

2022-12-03 Thread Dean Serenevy
, I have prepared the kivy upgrade in my personal fork[2] and would like to request a sponsor to merge these changes into the team repository. Thanks! Dean Serenevy (duelafn) [1] https://salsa.debian.org/python-team/tools/python-modules/blob/master/policy.rst [2] https://salsa.debian.org

pgsql: Fix DEFAULT handling for multi-row INSERT rules.

2022-12-03 Thread Dean Rasheed
Fix DEFAULT handling for multi-row INSERT rules. When updating a relation with a rule whose action performed an INSERT from a multi-row VALUES list, the rewriter might skip processing the VALUES list, and therefore fail to replace any DEFAULTs in it. This would lead to an "unrecognized node type"

pgsql: Fix DEFAULT handling for multi-row INSERT rules.

2022-12-03 Thread Dean Rasheed
Fix DEFAULT handling for multi-row INSERT rules. When updating a relation with a rule whose action performed an INSERT from a multi-row VALUES list, the rewriter might skip processing the VALUES list, and therefore fail to replace any DEFAULTs in it. This would lead to an "unrecognized node type"

pgsql: Fix DEFAULT handling for multi-row INSERT rules.

2022-12-03 Thread Dean Rasheed
Fix DEFAULT handling for multi-row INSERT rules. When updating a relation with a rule whose action performed an INSERT from a multi-row VALUES list, the rewriter might skip processing the VALUES list, and therefore fail to replace any DEFAULTs in it. This would lead to an "unrecognized node type"

pgsql: Fix DEFAULT handling for multi-row INSERT rules.

2022-12-03 Thread Dean Rasheed
Fix DEFAULT handling for multi-row INSERT rules. When updating a relation with a rule whose action performed an INSERT from a multi-row VALUES list, the rewriter might skip processing the VALUES list, and therefore fail to replace any DEFAULTs in it. This would lead to an "unrecognized node type"

pgsql: Fix DEFAULT handling for multi-row INSERT rules.

2022-12-03 Thread Dean Rasheed
Fix DEFAULT handling for multi-row INSERT rules. When updating a relation with a rule whose action performed an INSERT from a multi-row VALUES list, the rewriter might skip processing the VALUES list, and therefore fail to replace any DEFAULTs in it. This would lead to an "unrecognized node type"

pgsql: Fix DEFAULT handling for multi-row INSERT rules.

2022-12-03 Thread Dean Rasheed
Fix DEFAULT handling for multi-row INSERT rules. When updating a relation with a rule whose action performed an INSERT from a multi-row VALUES list, the rewriter might skip processing the VALUES list, and therefore fail to replace any DEFAULTs in it. This would lead to an "unrecognized node type"

Re: Improve performance of pg_strtointNN functions

2022-12-01 Thread Dean Rasheed
irly trivial task to > rebase. > > If the consensus is that we should fix this afterwards, then I'm happy to > delay. > I feel like it should be done afterwards, so that any performance gains can be measured for all bases. Otherwise, we won't really know, or have any record of, how much faster this was for other bases, or be able to go back and test that. Regards, Dean

Re: Allow round() function to accept float and double precision

2022-12-01 Thread Dean Rasheed
at > > positions to the left of the decimal point (this is undocumented though...) > > which the actual cast cannot do, but that seems like a marginal case. Note that, as of PG15, "n" can be negative in such typemods, if you want to round before the decimal point. The fact that passing a negative scale to round() isn't documented does seem like an oversight though... Regards, Dean

[webkit-changes] [WebKit/WebKit] ef3a06: Show thumbnail when navigating to a USDZ file

2022-11-30 Thread Dean Jackson
Branch: refs/heads/main Home: https://github.com/WebKit/WebKit Commit: ef3a06e1f3c35d4776583f03ec9688f6e9f9152c https://github.com/WebKit/WebKit/commit/ef3a06e1f3c35d4776583f03ec9688f6e9f9152c Author: Dean Jackson Date: 2022-11-30 (Wed, 30 Nov 2022) Changed paths: M

Re: RFR: JDK-8286666: JEP 429: Implementation of Scoped Values (Incubator) [v33]

2022-11-30 Thread Dean Long
On Tue, 29 Nov 2022 11:49:10 GMT, Andrew Haley wrote: >> Andrew Haley has updated the pull request incrementally with one additional >> commit since the last revision: >> >> Unused variable > > src/jdk.incubator.concurrent/share/classes/jdk/incubator/concurrent/ScopedValue.java > line 385:

Re: RFR: JDK-8286666: JEP 429: Implementation of Scoped Values (Incubator) [v33]

2022-11-30 Thread Dean Long
On Thu, 24 Nov 2022 14:05:41 GMT, Andrew Haley wrote: >> JEP 429 implementation. > > Andrew Haley has updated the pull request incrementally with one additional > commit since the last revision: > > Unused variable I made a few minor suggestions, but overall the HotSpot changes look good.

Re: RFR: JDK-8286666: JEP 429: Implementation of Scoped Values (Incubator) [v33]

2022-11-30 Thread Dean Long
On Thu, 24 Nov 2022 14:05:41 GMT, Andrew Haley wrote: >> JEP 429 implementation. > > Andrew Haley has updated the pull request incrementally with one additional > commit since the last revision: > > Unused variable src/hotspot/share/prims/jvm.cpp line 1385: > 1383: vframeStream

Re: RFR: JDK-8286666: JEP 429: Implementation of Scoped Values (Incubator) [v33]

2022-11-30 Thread Dean Long
On Thu, 24 Nov 2022 14:05:41 GMT, Andrew Haley wrote: >> JEP 429 implementation. > > Andrew Haley has updated the pull request incrementally with one additional > commit since the last revision: > > Unused variable src/hotspot/share/classfile/javaClasses.cpp line 1731: > 1729: } > 1730: >

Re: RFR: JDK-8286666: JEP 429: Implementation of Scoped Values (Incubator) [v33]

2022-11-30 Thread Dean Long
On Thu, 24 Nov 2022 14:05:41 GMT, Andrew Haley wrote: >> JEP 429 implementation. > > Andrew Haley has updated the pull request incrementally with one additional > commit since the last revision: > > Unused variable src/hotspot/cpu/aarch64/aarch64.ad line 3635: > 3633: } > 3634: }

[webkit-changes] [WebKit/WebKit] ca0682: Closing ARQL results in an empty view with a spinner

2022-11-30 Thread Dean Jackson
Branch: refs/heads/main Home: https://github.com/WebKit/WebKit Commit: ca068233ac864da83dc48c89a51cc9d7f4ee05e8 https://github.com/WebKit/WebKit/commit/ca068233ac864da83dc48c89a51cc9d7f4ee05e8 Author: Dean Jackson Date: 2022-11-30 (Wed, 30 Nov 2022) Changed paths: M

Re: Non-decimal integer literals

2022-11-30 Thread Dean Rasheed
ly(acc >= cutoff)) goto out_of_range; acc = acc * 10 + (*ptr - '0'); ptr++; } and similar for other bases, allowing the coding for all bases to be kept similar. I think it's probably best to consider this as a follow-on patch though. It shouldn't delay getting the main feature committed. Regards, Dean

Re: Non-decimal integer literals

2022-11-29 Thread Dean Rasheed
sn't correct, because those functions are meant to accumulate a negative number in "tmp". The overflow check can't just ignore the final digit either, so I'm not sure how much this would end up saving once those issues are fixed. Regards, Dean

[webkit-changes] [WebKit/WebKit] 8537f7: Media fullscreen banner showing when gesture is di...

2022-11-28 Thread Dean Jackson
Branch: refs/heads/main Home: https://github.com/WebKit/WebKit Commit: 8537f74a00cdbcc63ca53257f9924200e8214319 https://github.com/WebKit/WebKit/commit/8537f74a00cdbcc63ca53257f9924200e8214319 Author: Dean Jackson Date: 2022-11-28 (Mon, 28 Nov 2022) Changed paths: M

Re: Another multi-row VALUES bug

2022-11-28 Thread Dean Rasheed
t of the rtable. Of course that would break if we ever changed the way rewriteRuleAction() worked, but at least it only depends on that one other place in the code, which has been stable for a long time, so the risk of future breakage seems managable. Regards, Dean diff --git a/src/backend/rewrite/rewrite

Re: Bug in MERGE's test for tables with rules

2022-11-25 Thread Dean Rasheed
On Wed, 23 Nov 2022 at 15:32, Tom Lane wrote: > > Not quite sure the added test case is worth the cycles. > No, probably not, for such a trivial change. Pushed to HEAD and 15, without the test. Thanks for looking! Regards, Dean

pgsql: Fix rule-detection code for MERGE.

2022-11-25 Thread Dean Rasheed
Fix rule-detection code for MERGE. Use the relation's rd_rules structure to test whether it has rules, rather than the relhasrules flag, which might be out of date. Reviewed by Tom Lane. Backpatch to 15, where MERGE was added. Discussion:

pgsql: Fix rule-detection code for MERGE.

2022-11-25 Thread Dean Rasheed
Fix rule-detection code for MERGE. Use the relation's rd_rules structure to test whether it has rules, rather than the relhasrules flag, which might be out of date. Reviewed by Tom Lane. Backpatch to 15, where MERGE was added. Discussion:

Re: Another multi-row VALUES bug

2022-11-23 Thread Dean Rasheed
uld work. Possibly we could identify the VALUES RTE while building the product query, but that looks pretty messy. Regards, Dean

Re: Non-decimal integer literals

2022-11-23 Thread Dean Rasheed
e T_Float case, causing it to fall through to numeric_in() and fail: SELECT -0x8000; ERROR: invalid input syntax for type numeric: "-0x8000" ^ Regards, Dean

Bug in MERGE's test for tables with rules

2022-11-23 Thread Dean Rasheed
So it actually needs to examine rd_rules. Technically, I think that it would be sufficient to just test whether rd_rules is non-NULL, but I think it's more robust and readable to check rd_rules->numLocks, as in the attached patch. Regards, Dean diff --git a/src/backend/parser/parse_merge.c b/src/b

Another multi-row VALUES bug

2022-11-23 Thread Dean Rasheed
whether any of this applies to MERGE. The answer is "no", because MERGE actions don't allow multi-row inserts, so I think it's worth updating that comment to make that clearer. Regards, Dean diff --git a/src/backend/rewrite/rewriteHandler.c b/src/backend/rewrite/rewriteHandler.c new file m

Re: [OAUTH-WG] Call for adoption: Cross-Device Flows

2022-11-22 Thread Saxe, Dean
+1 – I support adoption. Thanks, -dhs -- Dean H. Saxe, CIDPRO<https://idpro.org/cidpro/> (he/him) Senior Security Engineer, AWS Identity Trust Team | Amazon Web Services (AWS) E: deans...@amazon.com<mailto:deans...@amazon.com> | M: 206-659-7293 From: OAuth on behalf of Rifaat

RE: [MORPHMET2] Measurement error in geometric morphometrics

2022-11-18 Thread Adams, Dean [EEOB]
: ‘digitizing bias’, ‘bias in digitizing error’, ‘systematically-biased measurement error’, ‘systematic measurement error’. Dean Dr. Dean C. Adams (he/him) Distinguished Professor of Evolutionary Biology Department of Ecology, Evolution, and Organismal Biology Iowa State University https

[webkit-changes] [WebKit/WebKit] 703520: Zillow.com: Scrolling or pinching the map causes p...

2022-11-18 Thread Dean Jackson
Branch: refs/heads/main Home: https://github.com/WebKit/WebKit Commit: 70352065621e3f98e7e61e75ecb52943d16037ed https://github.com/WebKit/WebKit/commit/70352065621e3f98e7e61e75ecb52943d16037ed Author: Dean Jackson Date: 2022-11-18 (Fri, 18 Nov 2022) Changed paths: M

Re: [MORPHMET2] measuring morphological diversity

2022-11-18 Thread Adams, Dean [EEOB]
Fabio, A quantification and comparison of morphological disparity among groups may be accomplished in geomorph or RRPP on R. Dean Get Outlook for Android<https://aka.ms/AAb9ysg> From: morphmet2@googlegroups.com on behalf of Fabio Pinheiro Sent:

[plasmashell] [Bug 461609] When panel loads, it displaces widgets an amount equal to its height

2022-11-17 Thread dean . yeager4
https://bugs.kde.org/show_bug.cgi?id=461609 --- Comment #10 from dean.yeag...@gmail.com --- BTW & REF plasma 5.26.3 not only fixed this problem but a problem where sound would not work on reboot - only after a restart and where Spectacle randomly, most of the time had the Spectacle widow

[Spectacle] [Bug 461608] Randomly, usually at first snapshot, the Spectacle window is overlays the snapshot-ed window

2022-11-17 Thread dean . yeager4
https://bugs.kde.org/show_bug.cgi?id=461608 dean.yeag...@gmail.com changed: What|Removed |Added Resolution|--- |FIXED Status|REPORTED

[Spectacle] [Bug 461608] Randomly, usually at first snapshot, the Spectacle window is overlays the snapshot-ed window

2022-11-16 Thread dean . yeager4
https://bugs.kde.org/show_bug.cgi?id=461608 --- Comment #2 from dean.yeag...@gmail.com --- Can you please close this problem? It disappeared on a plasma upgrade to 5.26.3 -- You are receiving this mail because: You are watching all bug changes.

Re: [LincolnTalk] Black Lives Matter sign vandalized

2022-11-16 Thread dean stillings
I believe Rodney King said “Can’t we all get along”. Vandalism is going to happen on any side. It is unfortunate and a reality. Let’s try to find common ground and be respectful and civil. Thank you Dean On Wed, Nov 16, 2022 at 10:38 AM Katrin Roush wrote: > There is only one side of rac

[plasmashell] [Bug 461609] When panel loads, it displaces widgets an amount equal to its height

2022-11-15 Thread dean . yeager4
https://bugs.kde.org/show_bug.cgi?id=461609 --- Comment #8 from dean.yeag...@gmail.com --- (In reply to Nate Graham from comment #6) > Thank you. I thought they might. This confirms my theory that it's the panel > which is pushing them up when it appears > > I *think* we may have fixed with in

[plasmashell] [Bug 461609] When panel loads, it displaces widgets an amount equal to its height

2022-11-15 Thread dean . yeager4
https://bugs.kde.org/show_bug.cgi?id=461609 --- Comment #7 from dean.yeag...@gmail.com --- Created attachment 153766 --> https://bugs.kde.org/attachment.cgi?id=153766=edit info panel for plasma 5.26.2 upgrade info panel for plasma 5.26.2 upgrade -- You are receiving this mail because: You

Re: RFR: JDK-8286666: JEP 429: Implementation of Scoped Values (Incubator)

2022-11-15 Thread Dean Long
On Fri, 4 Nov 2022 09:53:39 GMT, Andrew Haley wrote: >> src/java.base/share/classes/java/lang/Thread.java line 1610: >> >>> 1608: ensureMaterializedForStackWalk(bindings); >>> 1609: task.run(); >>> 1610: Reference.reachabilityFence(bindings); >> >> This 

Re: RFR: JDK-8286666: JEP 429: Implementation of Scoped Values (Incubator)

2022-11-15 Thread Dean Long
On Fri, 4 Nov 2022 09:53:39 GMT, Andrew Haley wrote: >> src/java.base/share/classes/java/lang/Thread.java line 1610: >> >>> 1608: ensureMaterializedForStackWalk(bindings); >>> 1609: task.run(); >>> 1610: Reference.reachabilityFence(bindings); >> >> This 

Re: RFR: JDK-8286666: JEP 429: Implementation of Scoped Values (Incubator)

2022-11-15 Thread Dean Long
On Fri, 4 Nov 2022 09:53:39 GMT, Andrew Haley wrote: >> src/java.base/share/classes/java/lang/Thread.java line 1610: >> >>> 1608: ensureMaterializedForStackWalk(bindings); >>> 1609: task.run(); >>> 1610: Reference.reachabilityFence(bindings); >> >> This 

Re: RFR: JDK-8286666: JEP 429: Implementation of Scoped Values (Incubator)

2022-11-15 Thread Dean Long
On Wed, 2 Nov 2022 16:23:34 GMT, Andrew Haley wrote: > JEP 429 implementation. src/hotspot/share/prims/jvm.cpp line 1410: > 1408: loc = 3; > 1409: } else if (method == resolver.thread_run_method) { > 1410: loc = 2; This depends on how javac numbers locals, right? It seems a

Re: RFR: JDK-8286666: JEP 429: Implementation of Scoped Values (Incubator)

2022-11-15 Thread Dean Long
On Wed, 2 Nov 2022 16:23:34 GMT, Andrew Haley wrote: > JEP 429 implementation. src/hotspot/share/prims/jvm.cpp line 1410: > 1408: loc = 3; > 1409: } else if (method == resolver.thread_run_method) { > 1410: loc = 2; This depends on how javac numbers locals, right? It seems a

Re: RFR: JDK-8286666: JEP 429: Implementation of Scoped Values (Incubator)

2022-11-15 Thread Dean Long
On Wed, 2 Nov 2022 16:23:34 GMT, Andrew Haley wrote: > JEP 429 implementation. src/hotspot/share/prims/jvm.cpp line 1410: > 1408: loc = 3; > 1409: } else if (method == resolver.thread_run_method) { > 1410: loc = 2; This depends on how javac numbers locals, right? It seems a

<    3   4   5   6   7   8   9   10   11   12   >