On 2023-11-20 02:59 +00:00 GMT, "Erik Wienhold" wrote:
> On 2023-11-19 21:37 +0100, PGUser2020 wrote:
>
> Technically speaking, UTF-8 is an 8-bit encoding. But I guess that
> application would then show mojibake if UTF-8 were stored.
>
Yes sorry, I should have said single byte rather than 8
Hello,
We're facing in a customer installation (PostgreSQL 13.1 on Linux) the
following problem for the first time and not reproducible:
The effective part of our backup script contains:
...
test -d ${BACKUPWAL}-${DATE}-${NUM}/ || mkdir -p ${BACKUPWAL}-${DATE}-${NUM}/
# kick to archive the cur
On 2023-11-19 21:37 +0100, PGUser2020 wrote:
> I have a database for a legacy application that requires an 8 bit
> database (i.e. the application itself won't function on a UTF8
> database).
Technically speaking, UTF-8 is an 8-bit encoding. But I guess that
application would then show mojibake if
Hello. Hopefully I can explain myself
I have a database for a legacy application that requires an 8 bit database
(i.e. the application itself won't function on a UTF8 database).
Looking at ways to extend the functionality to be able to handle a few
specified fields in Unicode.
Had the idea to
On Sun, Nov 19, 2023 at 11:09 AM Francisco Olarte
wrote:
> IIRC it does it once per
> transaction, but it should be in the docs.
>
There is no external caching for executing a CALL; the runtime executes the
procedure afresh each time. If it were any different that would have to be
documented.
On Sunday, 19 November 2023 at 18:09, Francisco Olarte
wrote:
>
>
> Hi Simon:
>
> On Sun, 19 Nov 2023 at 18:30, Simon Connah
> simon.n.con...@protonmail.com wrote:
>
> > I was reading about prepared statements and how they allow the server to
> > plan the query in advance so that if you
Hi Simon:
On Sun, 19 Nov 2023 at 18:30, Simon Connah
wrote:
> I was reading about prepared statements and how they allow the server to plan
> the query in advance so that if you execute that query multiple times it gets
> sped up as the database has already done the planning work.
But bear in
On Sun, Nov 19, 2023 at 10:30 AM Simon Connah
wrote:
> My question is this. If I make a stored procedure doesn't the database
> already pre-plan and optimise the query because it has access to the whole
> query?
No. Planning isn't about the text of the query, it's about the current
state of th
Hi,
First of all please forgive me. I'm not very experienced with databases.
I was reading about prepared statements and how they allow the server to plan
the query in advance so that if you execute that query multiple times it gets
sped up as the database has already done the planning work.
M
Στις 19/11/23 13:42, ο/η Anthony Apollis έγραψε:
For sample data in Excel see
https://drive.google.com/file/d/17aOmG-Ynx-6U05wNNrHXJG7iywgCMiuy/view?usp=sharing
Please note that you can increase the chances of having your thoughts be
read if you describe your problem using SQL or something t
For sample data in Excel see
https://drive.google.com/file/d/17aOmG-Ynx-6U05wNNrHXJG7iywgCMiuy/view?usp=sharing
(1) The fact table is from SAP.
(2) Dimension Tables are named "B Masked". Please note that none of the
tables had primary keys, I had to bring them in myself. In the Bracs
Mapping tab
11 matches
Mail list logo
