On 4/9/24 9:16 AM, Lok P wrote:
On Tue, Apr 9, 2024 at 9:26 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 4/9/24 08:43, Lok P wrote:
> Hi All,
> It's version 15.4 of postgresql database. Every "date/time" data
type
ount of transactions from a table-
transaction_tab and share it with another person/customer who is in the
EST timezone, so basically the transaction has to be shown or displayed
the EST timezone.
What is the datatype for the create_timestamp?
What does SHOW timezone; return on the server?
On 4/9/24 08:12, Thiemo Kellner wrote:
Thanks for taking this up.
Am 09.04.2024 um 17:09 schrieb Adrian Klaver:
On 4/9/24 07:59, Thiemo Kellner wrote:
[Code: 0, SQL State: 0A000] ERROR: References to other databases are
not implemented: pg_catalog.pg_roles.rolname
Position: 298 [Script
cute V_SQL_STATEMENT;
commit;
return;
end;
$body$;
--
Adrian Klaver
adrian.kla...@aklaver.com
hat PostgreSQL version are you using? The feature was introduced
in v11.
How exactly is the publication defined? Perhaps TRUNCATE is excluded.
Yours,
Laurenz Albe
--
Adrian Klaver
adrian.kla...@aklaver.com
should reach out to their tech support.
Thanks!
--
Adrian Klaver
adrian.kla...@aklaver.com
On 4/6/24 13:04, yudhi s wrote:
On Sat, Apr 6, 2024 at 10:25 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
Your original problem description was:
"Then subsequently these rows will be inserted/updated based on the
delta number of rows that got in
hard rule, then yes up to some point just
replacing the data in mass would be the simplest/fastest method. You
could cut a step out by doing something like TRUNCATE target_tab and
then COPY target_tab FROM 'source.csv' bypassing the INSERT INTO source_tab.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 4/5/24 02:39, Adnan Dautovic wrote:
Dear Adrian,
Adrian Klaver wrote:
Define 'read-only', especially as it applies to the privileges on the
public schema.
I am not quite sure which information you are looking for
exactly. According to this [1], I ran the following query:
WITH "
On 4/4/24 13:42, yudhi s wrote:
On Thu, Apr 4, 2024 at 9:04 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 4/3/24 22:24, yudhi s wrote:
>
> On Thu, Apr 4, 2024 at 10:16 AM Adrian Klaver
mailto:adrian.kla...@aklaver.com>
&g
On 4/3/24 22:24, yudhi s wrote:
On Thu, Apr 4, 2024 at 10:16 AM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 4/3/24 20:54, yudhi s wrote:
> On Thu, Apr 4, 2024 at 2:41 AM Adrian Klaver
mailto:adrian.kla...@aklaver.com>
> <mailto:adri
or me?
Kind regards,
Adnan Dautovic
--
Adrian Klaver
adrian.kla...@aklaver.com
On 4/3/24 20:54, yudhi s wrote:
On Thu, Apr 4, 2024 at 2:41 AM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 4/3/24 13:38, yudhi s wrote:
> Hi All,
> It's postgresql database version 15.4. We have a requirement in
which
> we will be ini
records faster in the target database, while making the
system online to the users?
Regards
Yudhi
--
Adrian Klaver
adrian.kla...@aklaver.com
'pandora distrib'?
--
Adrian Klaver
adrian.kla...@aklaver.com
log 1' create_date.
Read:
https://www.postgresql.org/docs/current/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT
--
Adrian Klaver
adrian.kla...@aklaver.com
ds,
Venkat
Internal Use - Confidential
-Original Message-----
From: Adrian Klaver
Sent: Wednesday, March 27, 2024 9:32 PM
To: Bandi, Venkataramana - Dell Team ; Greg Sabino
Mullane
Cc: pgsql-general@lists.postgresql.org; Kishore, Nanda - Dell Team
; Alampalli, Kishore
Subject:
out with an access denied message. So I wanted to understand the
cause of this and how we should fix it , such that anybody logging in
through that role can see/fetch the data from the cron and partman
schema tables.
grant select on cron.job to ;
grant select on cron.job_run_details to ;
grant
want to stay with DBeaver post the actual complete error
message here.
Thanks,
Arun
--
Adrian Klaver
adrian.kla...@aklaver.com
.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 3/28/24 07:25, Daniel Gustafsson wrote:
On 28 Mar 2024, at 15:22, Adrian Klaver wrote:
On 3/28/24 04:56, 김명준 wrote:
Hello,
I am deeply fascinated by the powerful features and flexibility of PostgreSQL
and wish to share it with more Korean speakers. I am interested in contributing
being done:
https://babel.postgresql.org/
Translator mailing list:
https://www.postgresql.org/list/pgsql-translators/
Translator Wiki:
https://wiki.postgresql.org/wiki/NLS
Thank you.
--
Adrian Klaver
adrian.kla...@aklaver.com
le True:
rows = cursor.fetch(batch_size)
if not rows:
break
for row in rows:
if row['num'] % 2:
odd += 1
The last is:
plpy_cursor.close()
I don't know how to proceed further.
--
Adrian Klaver
adrian.kla...@aklaver.com
cursor.
I would start with:
def logging(comment):
global database
<...>
--
Adrian Klaver
adrian.kla...@aklaver.com
please do not top post, use either bottom or inline posting per:
https://en.wikipedia.org/wiki/Posting_style
Regards,
Venkat
--
Adrian Klaver
adrian.kla...@aklaver.com
On 3/25/24 00:18, Bandi, Venkataramana - Dell Team wrote:
Hi,
Please find my inline comments for your questions.
Regards,
Venkat
Internal Use - Confidential
-Original Message-
From: Adrian Klaver
Sent: Tuesday, March 19, 2024 9:33 PM
To: Bandi, Venkataramana - Dell Team ; Greg
:3: HINWEIS: materialisierte Sicht
»query_per_task⠒mv« existiert nicht, wird übersprungen
DROP MATERIALIZED VIEW
SELECT 0
REFRESH MATERIALIZED VIEW
COMMENT
COMMIT
COMMIT
--
Adrian Klaver
adrian.kla...@aklaver.com
On 3/24/24 13:58, Thiemo Kellner wrote:
Am 24.03.2024 um 21:50 schrieb Adrian Klaver:
On 3/24/24 13:36, Thiemo Kellner wrote:
It does depending on the order of viewing. Namely if you viewed the
'old' empty MV in the outside session before you dropped/created the
'new' MV and committed
On 3/24/24 13:36, Thiemo Kellner wrote:
Am 24.03.2024 um 21:30 schrieb Adrian Klaver:
On 3/24/24 13:11, Thiemo Kellner wrote:
Confirmed in the same session that created it or in a different session?
Different session, not knowing what that mattered
It does depending on the order of viewing
actually is created (confirmed by being empty).
Confirmed in the same session that created it or in a different session?
I can't find any materialized view in your archive.
Oh sh*. That is the file, I forgot to commit. Please find it attached now.
--
Adrian Klaver
adrian.kla...@aklaver.com
mpty. You might want to have a look at the code attached.
That does not contain the statements mentioned above. Provide a simple
test case as code inline to your reply.
Kind regards
Thiemo
--
Adrian Klaver
adrian.kla...@aklaver.com
ease do not get me wrong. I can totally understand that something
needs to much work to implement. I am just puzzled.
--
Adrian Klaver
adrian.kla...@aklaver.com
and timing needs to be applied before it is run.
On Fri, Mar 22, 2024 at 12:32 PM Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
On 3/22/24 09:25, Fred Habash wrote:
> Facing an issue where sometimes humans login to a database and
run DDL
> statements causing
. Automatically time out a blocker
2. A metric that shows how many waiters for a blocker?
Thanks
--
Thank you
--
Adrian Klaver
adrian.kla...@aklaver.com
erhaps some feature that I can enable that logs which processes use
these 2 files?
Thanks,
Nick Renders
--
Adrian Klaver
adrian.kla...@aklaver.com
On 3/20/24 15:52, Jeff Ross wrote:
On 3/20/24 16:25, Adrian Klaver wrote:
On 3/20/24 15:18, Jeff Ross wrote:
Greetings!
I built a trigger fired process that copies an "order" from our
production database to our dev database. An order, in this case, is
an initial row from a tab
On 3/20/24 15:52, Jeff Ross wrote:
On 3/20/24 16:25, Adrian Klaver wrote:
On 3/20/24 15:18, Jeff Ross wrote:
Greetings!
I built a trigger fired process that copies an "order" from our
production database to our dev database. An order, in this case, is
an initial row from a tab
a function that uses both plython3u
and psycopg2. I can supply the source code if that will help.
I think that will help, especially the interaction between psycopg2 and
plpython3u.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 3/20/24 13:00, Celia McInnis wrote:
On Wed, Mar 20, 2024 at 2:15 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
__
On 3/20/24 10:54 AM, Celia McInnis wrote:
Comments below more to sort out the process in my head then anything
else.
fully, but when I then did
select * from tempview:
"
Where the select would have been on the regular view named tempview.
Thanks,
Celia McInnis
On Wed, Mar 20, 2024 at 1:01 PM Adrian Klaver
wrote:
On 3/20/24 09:51, Celia McInnis wrote:
> The view is being used in some web q
.
Have you run EXPLAIN ANALYZE on the problem query?
On Wed, Mar 20, 2024 at 11:46 AM Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
On 3/20/24 08:39, Celia McInnis wrote:
> Ok, thanks - so I guess that means that if there is both a
temporary and
> a non te
elect from the regular view?
Thanks,
Celia McInnis
--
Adrian Klaver
adrian.kla...@aklaver.com
-connection.html#RUNTIME-CONFIG-CONNECTION-SSL
--
Adrian Klaver
adrian.kla...@aklaver.com
. But you can track exactly what your
application is doing.
Cheers,
Greg
--
Adrian Klaver
adrian.kla...@aklaver.com
NEGATOR = <>,
RESTRICT = eqsel,
JOIN = eqjoinsel,
HASHES, MERGES
);
Thanks,
Rajesh S
--
Adrian Klaver
adrian.kla...@aklaver.com
creating the function
and operator, psql shows the error "operator is only a shell:
character varying = numeric
Your operator has numeric on the left and varchar on the right. But
your query is doing numeric on the RIGHT. Probably want to make a
matching one to cover both cases.
Cheers,
Greg
--
Adrian Klaver
adrian.kla...@aklaver.com
application which is in power builder.
Thanks,
On Fri, 15 Mar, 2024, 11:09 pm Adrian Klaver,
wrote:
On 3/15/24 3:40 AM, vedant patel wrote:
Hello There,
Recently, we've encountered some performance issues with the ODBC
driver provided by Postgres. Upon investigation, we noticed
ternal Use - Confidential
--
Adrian Klaver
adrian.kla...@aklaver.com
or suggestions you
could offer would be immensely helpful in resolving this performance
issue.
This will probably get a better answer quicker over at the ODBC list:
https://www.postgresql.org/list/pgsql-odbc/
Let me know in case of any questions or concerns.
Thanks,
--
Adrian Klaver
auxiliary structures like dblink and views to accommodate for a
"single" query solution. My two dimes.
--
Adrian Klaver
adrian.kla...@aklaver.com
monitor see all the objects of
the cluster? Background is that I was hoping to create a query to spit
out the size of tables in the cluster.
Kind regards
Thiemo
--
Adrian Klaver
adrian.kla...@aklaver.com
or bellasadie@gmail.com
<mailto:bellasadie@gmail.com>
You will find your receipt for this payment in the attached file.
Thank you!
PostgreSQL US
--
Adrian Klaver
adrian.kla...@aklaver.com
On 3/12/24 02:57, Nick Renders wrote:
On 11 Mar 2024, at 16:04, Adrian Klaver wrote:
On 3/11/24 03:11, Nick Renders wrote:
Thank you for your reply Laurenz.
I don't think it is related to any third party security software. We have
several other machines with a similar setup
workaround to this issue?
--
Domenico L.
per stupire mezz'ora basta un libro di storia,
io cercai di imparare la Treccani a memoria... [F.d.A.]
--
Adrian Klaver
adrian.kla...@aklaver.com
g? It does not occur with every restore, but it
seems to be related anyway.
Thanks,
Nick Renders
--
Adrian Klaver
adrian.kla...@aklaver.com
On 3/10/24 11:34, sud wrote:
On Sun, Mar 10, 2024 at 11:31 PM Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
1) The partition will be across one day(24 hours) it is just the times
may confuse people. Per you example 2024-03-07 00:00:00+00 is the same
time as 2024
On 3/10/24 10:51, sud wrote:
On Sun, Mar 10, 2024 at 10:32 PM Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
On 3/10/24 05:12, sud wrote:
>
> In my example in the first post, I see, if someone connected to a
RDS
> Postgres database and run the c
t_val" is showing as local
timezone only. If we set the timezone to a different value than the
local timezone then it gets updated on the "setting".
Regards
Sud
--
Adrian Klaver
adrian.kla...@aklaver.com
oject a is no longer receiving data and its records
are static. Further assuming there is a PK that you could order by, then
it would seem the way to go would be to delete in batches as determined
by the PK.
--
Adrian Klaver
adrian.kla...@aklaver.com
believer in coincidences, that you reported a problem and
then the problem disappeared.
I now have 418M+ rows in the table that it got stuck on.
:shrug:
Thanks Adrian and Jeff for responding.
Steve
Jeff
--
Adrian Klaver
adrian.kla...@aklaver.com
ill also depend on your tuning. Supporting
transactions, users or bulk processing are 3x sides of a compromise.
you should perhaps consider that insert is for inserting a few rows
into live tables ... you might be better using copy or \copy,
pg_dump if you are just trying to replicate a
On 3/8/24 14:04, Steve Baldwin wrote:
On Sat, Mar 9, 2024 at 8:56 AM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
What are the rest of the values in pg_replication_slots?
b2bcreditonline=> select * from pg_replication_slots;
On 3/8/24 14:04, Steve Baldwin wrote:
On Sat, Mar 9, 2024 at 8:56 AM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
What are the rest of the values in pg_replication_slots?
b2bcreditonline=> select * from pg_replication_slots;
ect * from pg_settings where name = 'TimeZone';
to see where the 'default' is set.
--
Adrian Klaver
adrian.kla...@aklaver.com
on AWS RDS, so I have no access to the servers,
but if that's the only way to diagnose the issue, I can create a support
case.
Does anyone have any suggestions as to where I should look for the issue?
Thanks,
Steve
--
Adrian Klaver
adrian.kla...@aklaver.com
On 3/8/24 09:09, Adrian Klaver wrote:
On 3/8/24 08:57, David Gauthier wrote:
Thanks for the reply.
When you say "dump/restore" do you mean pg_dump then running the
resulting SQL into the destination DB?
I like the replication option myself best (min downtime), especially
as we use
Services: https://aws.amazon.com <https://aws.amazon.com>
--
Adrian Klaver
adrian.kla...@aklaver.com
the dump with the 16.2 sql command will work.
Any comments?
matthias
--
Adrian Klaver
adrian.kla...@aklaver.com
each day.
Any clue as to what's happening or how to investigate this further?
Thanks,
Jay
--
Adrian Klaver
adrian.kla...@aklaver.com
On 3/7/24 12:20, Achilleas Mantzios wrote:
Στις 7/3/24 21:29, ο/η Adrian Klaver έγραψε:
On 3/7/24 10:13, Achilleas Mantzios wrote:
Στις 7/3/24 18:44, ο/η Robert Treat έγραψε:
I am not talking for fun. I am talking about the future programmers
of this world. Teaching Python or C to them
to tackle this from the other end, that is what are
you looking for in a first language?
What do UNIs in USA or Europe or Asia teach in 1st semester ?
line isn't strictly one of them.
Robert Treat
https://xzilla.net
--
Adrian Klaver
adrian.kla...@aklaver.com
should have in order to be taught as an
introductory language. But it lacks IO and file handling.
So, I ask, have there been any efforts to bring PL/PGSQL to the terminal?
Thanks!
--
Adrian Klaver
adrian.kla...@aklaver.com
h fewer steps.
So the question is... option 1 or 2 ? Or does it matter, either can work ?
If it where me it would be 1) as that gives you a fallback provision to
the original 11 instance.
--
Adrian Klaver
adrian.kla...@aklaver.com
ons.
Any other suggestions ?
Thanks for any advise/help !
--
Adrian Klaver
adrian.kla...@aklaver.com
tion Lir (in trigger? check? else?), Lir must be
create before Bar.
--
Adrian Klaver
adrian.kla...@aklaver.com
does
select proname, prosrc, provolatile from pg_proc where proname = 'extract';
return?
Thanks,
Michal
--
Adrian Klaver
adrian.kla...@aklaver.com
hat.
You could talk about the interaction with the "timezone" parameter, and
that it is not so much a timestamp with time zone, but an "absolute timestamp",
and in combination with "timestamp" a great way to let the database handle
the difficult task of time zone conversion for you.
Yours,
Laurenz Albe
--
Adrian Klaver
adrian.kla...@aklaver.com
databases and arguably deviates from the SQL standard.
Perhaps it would be good to warn people about using data types like
"character", "time with time zone" and "money".
Yours,
Laurenz Albe
--
Adrian Klaver
adrian.kla...@aklaver.com
>> wrote:
What is the difference between High Availability and Replication?
The former is a goal, the later is a technique.
David J.
--
Adrian Klaver
adrian.kla...@aklaver.com
.
I would suggest asking over on:
https://www.postgresql.org/list/pgsql-pkg-yum/
they maybe able to sort it out better for you.
--
Adrian Klaver
adrian.kla...@aklaver.com
mation provided below.
You would have a better luck here:
https://www.postgresql.org/list/pgadmin-support/
or at the company that supports it's development:
https://www.enterprisedb.com/
Very Respectfully,
Anthony Codjoe
anthony.cod...@gsa.gov <mailto:anthony.cod...@gsa.gov>
--
A
error, please inform the sender and delete this message and all
attachments.
--
Adrian Klaver
adrian.kla...@aklaver.com
ss.relfilenode contains zero. The actual filenode number of these
catalogs is stored in a lower-level data structure, and can be obtained
using the pg_relation_filenode() function.
--
Adrian Klaver
adrian.kla...@aklaver.com
you that with the Schemas(2) in the Object Explorer.
will make next time i verify with this details first, switching between
different DBs and machines got my mind diverted
image.png
Regards,
Sasmit Utkarsh
+91-7674022625
--
Adrian Klaver
adrian.kla...@aklaver.com
On Wed, Feb 28, 2024 at 10:35 PM Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
On 2/28/24 08:52, Sasmit Utkarsh wrote:
> Hi Adrian,
>
> Thanks for the info, But I have another question: I could see the
below
> functions list with the help
a search_path issue.
In psql do:
SHOW search_path;
then do:
\df *.sql_insert_data_procedure
Then see if the schema shown in the second command is in the search_path
returned by the first command.
Regards,
Sasmit Utkarsh
+91-7674022625
--
Adrian Klaver
adrian.kla...@aklaver.com
lic schema you are looking at in pgAdmin4. They where in the
shc(?) schema which I am pretty sure is the second schema in the
Schemas(2) in the object tree.
Thet
image.png
Regards,
Sasmit Utkarsh
+91-7674022625
--
Adrian Klaver
adrian.kla...@aklaver.com
ocedure |
(4 rows)
Regards,
Sasmit Utkarsh
+91-7674022625
--
Adrian Klaver
adrian.kla...@aklaver.com
On 2/27/24 14:38, Thiemo Kellner wrote:
Am 27.02.2024 um 23:20 schrieb Adrian Klaver:
I am not sure, what you want me to show with your test case. And I am
not sure whether I could not make myself clear. Please bear with me if I
try to make things clearer with an example.
Your comment
On 2/27/24 14:11, Thiemo Kellner wrote:
Am 27.02.2024 um 21:42 schrieb Adrian Klaver:
Also not sure what this:
select NODE_TYPE⠒NAME into V⠒NODE_TYPE⠒NAME
from NODE⠒V
where 1 = 1
and ID = new.NODE⠒ID
and 1 = 1;
is supposed
/predefined-roles.html
Regards
Veem
--
Adrian Klaver
adrian.kla...@aklaver.com
: INFO: new.NODE⠒ID:
e8d2c14d-37bd-4c11-a3c6-55cd382fd414
psql:insert_data/NODE_GOOD⠒V.pg_sql:27: INFO: new.TASK_NAME:
psql:insert_data/NODE_GOOD⠒V.pg_sql:27: INFO: V⠒NODE_TYPE⠒NAME: Pick-up
psql:insert_data/NODE_GOOD⠒V.pg_sql:27: INFO: Going to leave the
trigger function "NODE_GOOD⠒TR_B_IU_R"
INSERT 0 0
COMMIT
--
Adrian Klaver
adrian.kla...@aklaver.com
that
used to take 2 seconds is now taking around 8 - 10secs in AlloyDB. We
are trying to close this gap. Any help would be appreciated.
https://wiki.postgresql.org/wiki/Slow_Query_Questions
Regards
Siraj
--
Adrian Klaver
adrian.kla...@aklaver.com
/high-availability.html
--
Adrian Klaver
adrian.kla...@aklaver.com
characters
in the names, rather about search_path not including the NODE⠒V view.
Consider schema-qualifying the view name, or attaching a "SET
search_path" clause to the function.
regards, tom lane
--
Adrian Klaver
adrian.kla...@aklaver.com
regards, tom lane
--
Adrian Klaver
adrian.kla...@aklaver.com
SQL_select_size_procedure($1, $2, NULL)
You might try:
CALL SQL_select_size_procedure($1, $2, NULL::text)
2) Any clue as to where this:
"...failed for RIAT..."
is comimg from?
--
Adrian Klaver
adrian.kla...@aklaver.com
with some more testing. Thanks for now!
--
Adrian Klaver
adrian.kla...@aklaver.com
tps://www.postgresql.org/docs/devel/functions-json.html#FUNCTIONS-SQLJSON-PATH-OPERATORS>
[2] - https://www.postgresql.org/about/featurematrix/
<https://www.postgresql.org/about/featurematrix/>
regards
Marcos
--
Adrian Klaver
adrian.kla...@aklaver.com
apt update" to update the index.
hp
--
Adrian Klaver
adrian.kla...@aklaver.com
201 - 300 of 4188 matches
Mail list logo