557 questions
1
vote
0
answers
17
views
How do I keep dml objects from moving when I convert from PowerPoint to Google Slides?
I'm automating powerpoint slides, and I want users to be able to edit the ggplots I have. As a result, I'm saving them as dml objects using the rvg package.
When I export it as a PowerPoint, all looks ...
- 2,576
0
votes
1
answer
145
views
Postgres logical replication, need to get only the changed column values, not all column values, on update event row
I am writing a client implementation of the Postgres logical replication protocol, but I encountered an unexpected behavior, in the DML UPDATE event
I always get all the values of the table columns, ...
- 91
-1
votes
1
answer
26
views
How to make sure that the data modification events are delivered to SQS or Kinesis in correct order?
Let's assume the following situation:
There is a backend service, and it has CRUD endpoints for "insert", "update" and "delete" requests.
Each endpoint updates relational ...
- 3,554
0
votes
0
answers
45
views
getting an error when trying to duplicate table with DML
I was trying to duplicate data from an existing table to an empty table in different schema (all in the same database) and got an error. (PostgreSQL 16):
This is for specific exercise, so I have to ...
- 1
-2
votes
1
answer
64
views
Create new tables & columns from XML data in SQL columns
I have a table in a SQL Server 2019 database with 5 XML typed columns and one key. This data is in CLIXML format. It is of course marketing information that is not within my control, and the rub -- I ...
- 13
1
vote
1
answer
279
views
What is the best way to call a Snowflake stored procedure that performs DML and returns multiple values?
Below is a simple example. The final CALL fails with an error
SQL compilation error: Invalid statement type 'INSERT' for child job from stored procedure in FROM clause on TABLE 'EXAMPLE'
The ...
- 8,579
0
votes
1
answer
54
views
Security.stripInaccessible() remove a field that I need
This method is removing a field that I need to make the upsert, is a field that isn't writable but is stuffed in the code.
if(customFee.orderFee.Quote__c == null){
customFee.orderFee.Quote__c =...
0
votes
0
answers
71
views
Converting basic update logic from a table to a view in Snowflake
I'm working on converting something that's currently in a table in snowflake into a view. One of the big issues I've run into is that the code I was provided to build the table uses the SQL UPDATE ...
0
votes
2
answers
177
views
DML operation error handling in record trigger flow
I have created record trigger flow on account object. my requirement is when specific filed is update on the account record then all related custom object record status goes change. Now, on custom ...
0
votes
0
answers
26
views
Hive ParseException-Unable to load Hive target table on Informatica PowerCenter
I am getting the following error when trying to load a Hive table using PowerCenter (ODBC connection):
: Rowdata: (Row Type=0(insert) Src Rowid=4 Targ Rowid=4
)
LIBRARY_NAME (LIBRARY_NAME:UniChar. 100:...
3
votes
1
answer
1k
views
Setting the column COMPRESSION to LZ4 does not seem to work?
Working with Postgres 16.2 for Windows, I am attempting to set LZ4 compression on a column within one of our tables.
message text COMPRESSION lz4,
When I perform the following query:
SELECT attname,...
- 31
1
vote
1
answer
57
views
How to write sql query that will output currency on each 1st date of every month in 2024?
I need to write a query so that there are 12 lines with the current exchange rate on the 1st day of each month 2024. I need to show all 12 months if some information is missing, I need to take ...
- 13
0
votes
0
answers
142
views
MariaDB ColumnStore Internal error: CAL0001: Insert Failed: a BRM Begin copy error
I'm using ColumnStore 11.1.4-MariaDB-1:11.1.4+maria~deb12 and while I'm doing many inserts (one by one) I gained this type of error:
1815 - Internal error: CAL0001: Insert Failed: MCS-2009: Unable to ...
1
vote
1
answer
75
views
dummy dml after with's in plpgsql
Sometimes it is useful to use dml in with-blocks, e.g.
with
common_data_for_ins_and_upd as (
select ...
),
ins as (
insert into some_table(...)
),
upd as (
update some_table ...
- 111
0
votes
1
answer
34
views
List all of the members' first name, last name and total loan book. Member's First name order by ascending
SELECT
MemberFirstName, MemberLastName, COUNT(*) AS TotalBookOnLoan
FROM
Member
JOIN
Loan ON Member.MemberID= Loan.MemberID
WHERE
LoanDate IS NOT NULL
GROUP BY
Member....
- 1