stem to v16.
I often resort to \conninfo, but it's less automatic and
harder to visually parse (IMHO) compared to a custom ad-hoc prompt.
For me that shows the user that connected(session_user) not the
current_user.
Therefore I want to respectfully re-iterate my interest in this enhan
-17-HIGHLIGHTS
Add a builtin platform-independent collation provider (Jeff Davis)
This supports C and C.UTF-8 collations.
Cheers,
Paul
--
Adrian Klaver
adrian.kla...@aklaver.com
On 9/21/24 22:21, Lok P wrote:
On Sun, Sep 22, 2024 at 12:46 AM Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
Thank you. So if I get it correct, if the client app(from which the data
is getting streamed/inserted) is in the same data center/zone as the
database (wh
cute_batch() and execute_values()
from:
https://www.psycopg.org/docs/extras.html#fast-execution-helpers
On my laptop, method2 is about twice as fast as method3. But if I
connect to a database on the other side of the city, method2 is now more
than 16 times faster than method3 . Simply because the delay in
communication is now large compared to the time it takes to insert those
rows.
hp
--
Adrian Klaver
adrian.kla...@aklaver.com
played
for which the deadlock error happens , as I think during a deadlock
error, one session gets terminated by postgres and that messages perhap
we can save in some exception table and then replay?
--
Adrian Klaver
adrian.kla...@aklaver.com
On 9/20/24 1:01 PM, veem v wrote:
On Thu, 19 Sept, 2024, 8:40 pm Adrian Klaver, <mailto:adrian.kla...@aklaver.com>> wrote:
On 9/19/24 05:24, Greg Sabino Mullane wrote:
> On Thu, Sep 19, 2024 at 5:17 AM veem v mailto:veema0...@gmail.com>
> This is really dif
IS_PROJ P0,
TMP_IS_SEC_FILT T0,
EM_MD R0
WHERE
T0.IS_REPOSITORY_GUID = R0.REP_GUID
AND T0.IS_PROJ_GUID = P0.IS_PROJ_GUID
AND P0.IS_REPOSITORY_ID = R0.REP_ID);
Regards
Siraj
--
Adrian Klaver
adrian.kla...@aklaver.com
describing exactly what your application does, and how it is doing it.
Switch from reactive to proactive.
+1
Cheers,
Greg
--
Adrian Klaver
adrian.kla...@aklaver.com
r, but includes some
generic tips that could prove useful.
The glibc change log below might also be useful:
https://sourceware.org/glibc/wiki/Release
Paul
--
Adrian Klaver
adrian.kla...@aklaver.com
e?
2) What are the table schemas?
3) What is the code that is generating the error?
Overall it looks like this process needs a top to bottom audit to map
out what is actually being done versus what needs to be done.
--
Adrian Klaver
adrian.kla...@aklaver.com
ed (pg_hba)?
On Tue, Sep 17, 2024 at 7:10 PM Andy Hartman <mailto:hartman60h...@gmail.com>> wrote:
I'll echo vars and see if something looks strange.
THanks.
On Tue, Sep 17, 2024 at 3:46 PM Rob Sargent mailto:robjsarg...@gmail.com>> wrote:
> On Sep
On 9/17/24 12:34, veem v wrote:
On Tue, 17 Sept 2024 at 21:24, Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
Which means you need to on Flink end:
1) Use Flink async I/O .
2) Find a client that supports async or fake it by using multiple
synchronou
On 9/17/24 09:21, Andy Hartman wrote:
The command work outside of powershell yes
Then you are going to need to use whatever debugging tools PowerShell
has available to step through the script to figure out where the problem is.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 9/16/24 20:55, veem v wrote:
On Tue, 17 Sept 2024 at 03:41, Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
Are you referring to this?:
https://nightlies.apache.org/flink/flink-docs-release-1.20/docs/dev/datastream/operators/asyncio/
<https://nightlie
o the commands work when run in psql or supplied directly to psql
outside of PowerShell?
On Tue, Sep 17, 2024 at 11:23 AM Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
On 9/17/24 08:13, Andy Hartman wrote:
> Still when I try to run from my powershell s
On 9/17/24 08:13, Andy Hartman wrote:
Still when I try to run from my powershell script it hangs...
And the Postgres log shows?
--
Adrian Klaver
adrian.kla...@aklaver.com
ecause of this:
sed -i "s/old_name/new_name/g"
--
Death to , and butter sauce.
Don't boil me, I'm still alive.
crustacean!
--
Adrian Klaver
adrian.kla...@aklaver.com
want to understand , how asynch io can be enabled and if
any downsides of doing this?
Are you referring to this?:
https://nightlies.apache.org/flink/flink-docs-release-1.20/docs/dev/datastream/operators/asyncio/
If not then you will need to be more specific.
Regards
Veem
--
Adrian K
can't step you through the process, I can
point you at:
https://www.postgresql.org/docs/current/multibyte.html#MULTIBYTE-AUTOMATIC-CONVERSION
Others will be able to answer the specifics.
--
Adrian Klaver
adrian.kla...@aklaver.com
case that is:
1) Crawl. Connect using psql and run the \copy in it with hard coded values.
2) Walk. Use psql with the -c argument and supply the command again with
hard coded values
3) Run. Then use PowerShell and do the variable substitution.
On Mon, Sep 16, 2024 at 12:17 PM Adrian
cutable must parse. Given the amount of quoting, -a
and -e will let you see the commands are properly sent, and if it is
trying to read something what it is.
I will also try to substitute the -c with a pipe. If it heals, it is
probably a quoting issue.
Also, I just caught Ron&
s and -c command.
Table layout
image.png
--
Adrian Klaver
adrian.kla...@aklaver.com
erent size.
Thanks,
Vinay kumar
On Sat, Sep 14, 2024, 10:59 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 9/14/24 10:19, Vinay Oli wrote:
> Hi Team
>
> I have been using PostgreSQL for the past 6 years. PostgreSQL has
> sign
ed by a Patroni cluster with etcd.
Thanks,
Vinay Kumar
--
Adrian Klaver
adrian.kla...@aklaver.com
On 9/13/24 07:50, Adrian Klaver wrote:
On 9/13/24 02:58, Juan Rodrigo Alejandro Burgos Mella wrote:
Hello, I find it unlikely that the trigger will work properly, since
the reserved fields of the OLD subset have no value in an INSERT
I'm not seeing that the OP is asking for OLD.* values,
esult of a lookup on another table in the INSERT.
Atte
JRBN
--
Adrian Klaver
adrian.kla...@aklaver.com
ct_ph_number
contact_email --Can be null
It can get more involved then this, depends on how flexible you want to get.
TIA,
Rich
--
Adrian Klaver
adrian.kla...@aklaver.com
On 9/12/24 10:06, François SIMON wrote:
Le Thu, Sep 12, 2024 at 06:03:47PM +0200, François SIMON a écrit :
Le Thu, Sep 12, 2024 at 08:20:59AM -0700, Adrian Klaver a écrit :
On 9/12/24 03:58, François SIMON wrote:
Hello All,
So the problem seems to come from xlc, and only at initdb step.
I
On 9/12/24 09:03, François SIMON wrote:
Le Thu, Sep 12, 2024 at 08:20:59AM -0700, Adrian Klaver a écrit :
On 9/12/24 03:58, François SIMON wrote:
Hello All,
A normal user account.
Is that the account you did the make install as?
PGDATA is set to a subdirectory of $HOME for this user
On 9/9/24 08:35, Thürmann, Andreas wrote:
Adrian Klaver (adrian.kla...@aklaver.com
<mailto:adrian.kla...@aklaver.com>) asked:
Postgres version?
PostgreSQL 16 with pgAdmin 16 4.2.2
Have you tried tried this using psql?
Have you looked at Postgres log for errors?
I run initdb with -n option, I can see that files in
PGDATA directory seem to have expected permissions.
I have tried to install PostgreSQL 15.1, 16.0 and 16.3
but got the same error with all these versions.
Any help would be appreciated.
François
--
Adrian Klaver
adrian.kla...@aklaver.com
nt role "dd_owner"
DETAIL: Only roles with the ADMIN option on role "dd_owner" may grant
this role.
test=> create role dd_user;
CREATE ROLE
test=> grant dd_admin to dd_user;
ERROR: permission denied to grant role "dd_admin"
DETAIL: Only roles with the ADMIN option on role "dd_admin" may grant
this role.
--
Adrian Klaver
adrian.kla...@aklaver.com
ng to a
database, even if the password will not be used.
Can anybody straighten me out?
Thanks for the help,
--
Chris.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 9/10/24 08:29, Rich Shepard wrote:
On Tue, 10 Sep 2024, Adrian Klaver wrote:
Is there a Primary Key or Unique index on this table?
Adrian,
No. It didn't occur to me to make the project number a PK as this table is
not related to others in the database.
But, yesterday it occurred
0-28 | Consol Energy |
4242.01 | Expert witness | 2008-10-15 | 2008-10-28 | Consol Energy |
4242.01 | Expert witness | 2008-10-15 | 2008-10-28 | Consol Energy |
(4 rows)
How do I clean this up so there's only a single row for this project
number?
TIA,
Rich
--
Adrian Klaver
adrian.kla...@aklaver.com
On 9/10/24 07:47, Fabrice Chapuis wrote:
Reply to list also
Ccing list
no trigger on theses tables
On Mon, Sep 9, 2024 at 5:00 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 9/9/24 07:55, Fabrice Chapuis wrote:
> Hi,
>
> table a and
I posted above, I don't think
it would work, since we'd no longer have a `NOT MATCHED` on `t2`'s
`(3, '1.3 v2')` row.
[1]: https://www.postgresql.org/docs/current/sql-merge.html
[2]:
https://www.postgresql.org/message-id/flat/CANP8%2BjKitBSrB7oTgT9CY2i1ObfOt36z0XMraQc%2BXrz8QB0nXA%40mail.gmail.com
--
Adrian Klaver
adrian.kla...@aklaver.com
On 9/9/24 03:24, Achilleas Mantzios - cloud wrote:
On 9/8/24 23:46, Adrian Klaver wrote:
On 9/8/24 13:04, Achilleas Mantzios wrote:
Hi
for remote DDL execution (such as CREATE TABLE) is dblink my only
option?
You will need to define in what context you are considering options.
For
id you get it from?
How do you know you are not making a connection?
Have you looked at Postgres log for errors?
andreas.thuerm...@schoenmackers.de
<mailto:andreas.thuerm...@schoenmackers.de>
--
Adrian Klaver
adrian.kla...@aklaver.com
b.col2 = a.col2)
Do you have an UPDATE trigger on table_a?
Regards,
Fabrice
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Adrian Klaver
adrian.kla...@aklaver.com
;nyc_taxi.csv' with csv header
COPY 2846722
Time: 10042.129 ms (00:10.042)
copy nyc_duplicate from '/tmp/nyc_taxi.csv' with csv header;
COPY 2846722
Time: 8422.503 ms (00:08.423)
hp
--
Adrian Klaver
adrian.kla...@aklaver.com
using -s/-a.
Regards,
Samson G
--
Adrian Klaver
adrian.kla...@aklaver.com
On 9/4/24 18:29, Peter L Martin wrote:
Please remove p...@mipta.com from the List
Follow instructions here:
https://lists.postgresql.org/unsubscribe/
--
Adrian Klaver
adrian.kla...@aklaver.com
re ... --section=pre-data -f ddl_defs.sql
Search/replace ddl_defs.sql
psql ... -f ddl_defs.sql
pg_restore ... --section=data
pg_restore ... --section=post-data
Thanks,
Samson G
--
Adrian Klaver
adrian.kla...@aklaver.com
solution 1. Since solution 1 is
using sql file load and solution 2 is using pg_restore directly.
Kindly recommend what to choose, solution 1 or solution 2 or any other
workaround to restore.
Personally I would go with solution 1 with the modifications I suggested.
Thanks,
Samson G
specific. If a new application/client starts hitting the database and it
did not get the memo about the audit fields they won't be filled in.
2) I would recommend setting up a some realistic tests and see if the
overhead of the update triggers would be a concern.
--
Adrian Klaver
adria
On 9/3/24 09:37, Adrian Klaver wrote:
On 9/3/24 09:25, Muhammad Usman Khan wrote:
Hi,
You need to install plpython3u on your new server and also make sure
to use python3. You need to make changes to your functions also to
make them compatible with python3
That only works if the dump from
;*
How to change plpythonu to plpython3u in the dump file before
pg_restore. or Does postgres have any option to handle directly via
config.
Thanks in Advance
Thanks,
Samson G
--
Adrian Klaver
adrian.kla...@aklaver.com
the dump file before
pg_restore. or Does postgres have any option to handle directly via config.
Thanks in Advance
Thanks,
Samson G
--
Adrian Klaver
adrian.kla...@aklaver.com
On 8/31/24 11:02, Peter J. Holzer wrote:
On 2024-08-31 10:35:01 -0700, Adrian Klaver wrote:
On 8/31/24 09:54, Peter J. Holzer wrote:
'Tis the season again.
Ubuntu 24.04.1 has just been released, so many Ubuntu LTS users will now
be prompted to upgrade from 22.04 to 24.04.
Which I i
nd the scenes to the Postgres instance(s) would disturb me.
Regards and best wishes,
Justin Clift
--
Adrian Klaver
adrian.kla...@aklaver.com
t then leads to the question of how to do that and
retain the 'correct' information from the selection of rows for each
transaction_id.
Note-its 15.4 postgres database.
Regards
Veem
--
Adrian Klaver
adrian.kla...@aklaver.com
nt wrong (I got some conflicts during the
upgrade and maybe I shouldn't have invoked apt autoremove?), and you may
not have this problem, but make sure you have a backup before the
upgrade.
hp
--
Adrian Klaver
adrian.kla...@aklaver.com
On 8/27/24 11:16 AM, Adrian Klaver wrote:
On 8/27/24 11:13 AM, Jean-Christophe BOGGIO wrote:
Le 27/08/2024 à 19:51, Torsten Förtsch a écrit :
I guess this query comes back non-empty:
SELECT * FROM paliers JOIN tmp_limitcontrats USING(idcontrat) WHERE
qtep1 >= qtep2
Yes, it is empty
003
Otherwise, you are right, there are irregular data but not that I'm
concerned with in that particular case.
?:
SELECT numrange( qtep1+1 , qtep2, '[]') AS rangep FROM paliers JOIN
tmp_limitcontrats USING(idcontrat) where qtep1+1 < qtep2
--
Adrian Klaver
adrian.kla...@aklaver.com
ne 3 and comment out line 2, I get the
correct behavior. Very strange thing is that tmp_limitcontrats has only
one row which contains "idcontrat=1003".
What does:
SELECT numrange( qtep1+1 , qtep2, '[]') AS rangep FROM paliers WHERE
idcontrat=1003
return?
This fails o
/routine-vacuuming.html
Read the following sections:
25.1.5. Preventing Transaction ID Wraparound Failures
25.1.6. The Autovacuum Daemon
Regards,
Ram Pratap.
--
Adrian Klaver
adrian.kla...@aklaver.com
e
to
"*SELECT* 1".conname = ("*SELECT* 1_1".constraint_name)::name
is more of a change then I would expect.
Or
Buffers: shared hit=34,675
vs
Buffers: shared hit=5,153,054
indicates a hardware/configuration difference.
Are both instances running on the same machin
s
into why PostgreSQL 16 might be slower for this query? Any advice or
suggestions for optimization would be greatly appreciated.
Yes when ANALYZE was not run on a new instance.
Thank you!
NOTE:- PFA the raw file of explain and analyze below.
--
Adrian Klaver
adrian.kla...@aklaver.com
find the binary installation files for
PostgreSQL 17 beta for Windows.
Not released yet. Check the link below for release:
https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
Thank you once again for your continued support.
Best regards,
Jyoti
--
Adrian Klaver
denied for table
pg_class", even if I try it only for tables the user owns.
As I understand it this issue came up in:
https://github.com/mzabani/codd
I would think that the queries in that case would be running as a
superuser in order to do the migrations.
--
Adrian Klaver
adrian.kla...@aklaver.com
.
Merge?:
https://www.postgresql.org/docs/current/sql-merge.html
Thank you
--
Adrian Klaver
adrian.kla...@aklaver.com
www.postgresql.org/docs/current/view-pg-replication-slots.html
https://www.postgresql.org/docs/current/catalog-pg-subscription-rel.html
Am I getting that wrong? Is my understanding mistaken?
Regards,
Koen De Groote
--
Adrian Klaver
adrian.kla...@aklaver.com
On 8/23/24 09:51, Adrian Klaver wrote:
On 8/23/24 09:33, Matthew Tice wrote:
On Fri, Aug 23, 2024 at 10:26 AM Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
https://www.postgresql.org/docs/current/pgstattuple.html
<https://www.postgresql.org/docs/current/pgstatt
On 8/23/24 09:33, Matthew Tice wrote:
On Fri, Aug 23, 2024 at 10:26 AM Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
https://www.postgresql.org/docs/current/pgstattuple.html
<https://www.postgresql.org/docs/current/pgstattuple.html>
pgstattuple_app
bably need to reach out to Google to see what
that means for this situation.
> select version();
-[ RECORD 1 ]-
version | PostgreSQL 14.10 on x86_64-pc-linux-gnu, compiled by Debian
clang version 12.0.1, 64-bit
SELECT 1
--
Adrian Klaver
adrian.kla...@aklaver.com
l apply
* worker: start_lsn, end_lsn and send_time. Because we have updated these
* statistics in the leader apply worker, we can ignore these fields in the
* parallel apply worker (see function LogicalRepApplyLoop).
*/
Regards,
Koen De Groote
--
Adrian Klaver
adrian.kla...@aklaver.com
or add in PATH.
Hope this helps.
No what you want to do is read:
man pg_wrapper
and the other Debian specific commands
man pg_lscluster, pg_ctlcluster, pg_dropcluster, etc.
Learn what the packaging provides instead of fighting it.
Regards,
Ikram
Muhammad Ikram
--
Adrian Klaver
On 8/22/24 19:21, Tom Lane wrote:
Adrian Klaver writes:
On 8/22/24 17:36, Arbol One wrote:
After installing PostgreSQL on my Debian-12 machine, I typed 'postgres
--version' and got this msg:
*bash: postgres: command not found*
'psql --version', however, does work and g
ArbolOne on Java Development is in progress [ í ]
--
Adrian Klaver
adrian.kla...@aklaver.com
is going to
depend on a more detailed explanation on your part of what you expect
from the dump/restore process.
--
Adrian Klaver
adrian.kla...@aklaver.com
public.projection ( ...
[...]
REFRESH MATERIALIZED VIEW public.prj_mv;
It is done for you.
Thanks.
--
Adrian Klaver
adrian.kla...@aklaver.com
ersion "1.6" to version
"1.6.1"|
Which is true:
name | default_version | installed_version |
pg_cron | 1.6 | 1.6
You can't update as it does not exist.
How did you do the upgrade from 12.7 to 16.1?
FYI, per here:
https://docs.aws.amazon.com/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-release-calendar.html
RDS is up to Postgres 16.4, which is the latest minor release and what
you should be using.
--
Adrian Klaver
adrian.kla...@aklaver.com
ould say you
need to keep up with the minor version releases of whatever Postgres
version you have installed. For example for Postgres 16 that would be
16.4. If I remember correctly that will update the pgAdmin4 version.
--
Adrian Klaver
adrian.kla...@aklaver.com
lookup error: psql: undefined symbol: PQmblenBounded
```
Could you please assist in resolving this issue?
Best bet you are using the 13.8 version of psql to work on 15.6 instance
of Postgres.
Do
psql -V
to verify what you are running.
Thanks and regards,
Vivek Gadge
--
Adrian
gAdmin4?
Any tips or advice on how to do this safely? Thanks in advance!
--
Adrian Klaver
adrian.kla...@aklaver.com
On 8/11/24 03:09, Alban Hertroys wrote:
On 10 Aug 2024, at 22:23, yudhi s wrote:
On Sat, Aug 10, 2024 at 8:22 PM Adrian Klaver wrote:
MERGE INTO tab1 AS target
USING (VALUES ('5efd4c91-ef93-4477-840c-a723ae212d99', 123,
'2024-08-09T11:33:49.402585600Z','2024-08-09T
On 8/10/24 13:23, yudhi s wrote:
On Sat, Aug 10, 2024 at 8:22 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
Why not use INSERT ... ON CONFLICT instead of MERGE?
>
> MERGE INTO tab1 AS target
> USING (VALUES ('5efd4c91-ef93-4477-
cre_ts)
ON target.id <http://target.id> = source.id <http://source.id>
WHEN MATCHED THEN
UPDATE SET mid = source.mid
WHEN NOT MATCHED THEN
INSERT (id, mid, txn_timestamp, cre_ts)
VALUES (source.id <http://source.id>,source.mid,
source.txn_timestamp, source.cre_ts);
--
Adrian Klaver
adrian.kla...@aklaver.com
e for all:
SELECT * FROM machines
WHERE ip_address IN (VALUES('192.168.0.1'::inet), ('192.168.0.10'),
('192.168.1.43'));
"
The VALUES is not directly attached to the INSERT, you will need to do
explicit casts:
VALUES ('5efd4c91-ef93-4477-840c-a723ae212d66', 123,
'2024-08-09T11:33:49.402585600Z'::timestamptz,
'2024-08-09T11:33:49.402585600Z'::timestamptz)
--
Adrian Klaver
adrian.kla...@aklaver.com
you the vacuum/analyze that has been done on a table.
Jim Vanns
Principal Production Engineer
Industrial Light & Magic, London
--
Adrian Klaver
adrian.kla...@aklaver.com
On 8/8/24 11:07, Anthony Apollis wrote:
The same code bring in values for FY24, 23 etc. Dont understand why
FY25's values are 0.
Because something changed. You will need to go through the process step
by step and verify that the code is current with what is in the FY25 data.
--
A
uot;Condition Amount" into 0.
I would start by running the SELECT that this is part of and seeing what
it does to the data and if that is what you want it to do.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Adrian Klaver
adrian.kla...@aklaver.com
On 8/2/24 9:55 AM, Andy Hartman wrote:
How do I get latest and greatest?
Go to the previously shown link and read the Installation section.
On Fri, Aug 2, 2024 at 12:52 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 8/2/24 9:47 AM, Andy Hartman wrote:
On 8/2/24 9:47 AM, Andy Hartman wrote:
Please don't top post. Use inline or bottom posting.
Looks like 4.5
From here:
https://www.npgsql.org/doc/performance.html
Release notes
I see 4.1 and 5.0, no 4.5
My bet 4.5 is the NET version you are working with.
--
Adrian Klaver
adria
on is reported there.
Thanks.
On Fri, Aug 2, 2024 at 12:18 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 8/2/24 9:00 AM, Andy Hartman wrote:
Reply to list also.
Ccing list.
> I changed to md5 and I can connect via HeideSQL interface no problem
On 8/2/24 9:00 AM, Andy Hartman wrote:
Reply to list also.
Ccing list.
I changed to md5 and I can connect via HeideSQL interface no problem
Changed what to md5?
The issue is with Npgsql(?) though.
What is the Npgsql version?
On Fri, Aug 2, 2024 at 11:05 AM Adrian Klaver
is as a bug. Please keep us updated.
That should be done here:
https://www.postgresql.org/account/submitbug/
FYI, you will need to set up a community account to do that.
Regards,
Sindhu
SB Logo
SINDHU SELVARAJ
POSTGRESQL DBA
STARLING BANK
--
Adrian Klaver
adrian.kla...@aklaver.com
quot;Open" with "0" argument(s): "Authentication method
not supported (Received: 10)"
Best bet old library that does not understand scram-sha-256 authentication.
Any ideas?
Thanks.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 8/1/24 15:13, Jim Vanns wrote:
PG 15.4
Community edition or some variant?
--
Adrian Klaver
adrian.kla...@aklaver.com
to believe. Can you provide a self-contained test
case?
Would also be nice to know what version of Postgres and where you are
running the server?
regards, tom lane
--
Adrian Klaver
adrian.kla...@aklaver.com
plied function/procedure:
Insert
Data is sent to audit table using table_audit()
Update
Data is sent to audit table using table_audit()
Delete
Data is sent to audit table using table_audit()
See function specific documentation below
[...]
"
David J.
--
Adrian Klaver
adrian.kla...@aklaver.com
ut rather should be done
through database procedure/functions. Hope this understanding correct.
Triggers have to use procedures/functions so I am not understanding the
issue.
Regards
Sud
--
Adrian Klaver
adrian.kla...@aklaver.com
-datetime.html
For JSON types :
https://www.postgresql.org/docs/current/datatype-json.html
Thanks, I will work through those.
On Tue, 2024-07-23 at 23:52 +0200, Dominique Devienne wrote:
On Tue, Jul 23, 2024 at 10:35 PM Adrian Klaver
wrote:
Just know that SQLite does not enforce types [...]
That
query works in SQLite, all you have to do is read those, and try to
port; if it fails, read them again. Also search the archives of the
pgsql-general list, many answers in there
--
Adrian Klaver
adrian.kla...@aklaver.com
On 7/22/24 13:34, Ertan Küçükoglu wrote:
Adrian Klaver <mailto:adrian.kla...@aklaver.com>>, 22 Tem 2024 Pzt, 23:18 tarihinde
şunu yazdı:
It would seem to me the process would be:
1) Create Windows VM
2) Run the localizer tool in the VM to get the old locale name in plac
On 7/22/24 13:15, Ertan Küçükoglu wrote:
Adrian Klaver <mailto:adrian.kla...@aklaver.com>>, 22 Tem 2024 Pzt, 22:56 tarihinde
şunu yazdı:
Why not use that?
There was already an installed PostgreSQL just failing to start.
I used that localization tool and it started again.
Thi
On 7/22/24 11:48, Ertan Küçükoglu wrote:
Adrian Klaver <mailto:adrian.kla...@aklaver.com>>, 22 Tem 2024 Pzt, 21:10 tarihinde
şunu yazdı:
I am getting out of my depth here, but I am pretty sure that:
ENCODING = 'UTF8' LOCALE_PROVIDER = libc LOCALE = 'Turkish_
1 - 100 of 3315 matches
Mail list logo