work here:
USING (one.get_country('one','activity'))
as what USING will see is a string not the evaluation of 1=1 hence the
error you get:
ERROR: invalid input syntax for type boolean: "1=1" CONTEXT: PL/pgSQL
function function name(name,name) while casting r
On 4/23/25 13:02, Pawel Veselov wrote:
On Wed, Apr 23, 2025 at 9:13 PM Adrian Klaver wrote:
On 4/23/25 11:46, Pawel Veselov wrote:
Hello.
So, how come older software (according to versions) produces dump
files with a greater version
than the newer software can understand? Is this Ubuntu
have found that it is best to be explicit using the --cluster option.
Thank you,
Pawel.
--
Adrian Klaver
adrian.kla...@aklaver.com
at would be just super-helpful in finding the right combination of tools.
I ended up running PGDG's 16 pg_dump ((PostgreSQL) 16.8 (Ubuntu
16.8-1.pgdg22.04+1))
on Ubuntu, which produced a 1.15-0 dump.
Thank you,
Pawel.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 4/22/25 01:31, Anton Shepelev wrote:
Adrian Klaver:
There is something different about your setup, as here on
Ubuntu(which uses the Debian packaging) I see:
[...]
Yes. It is on on your side, and pgsql shows NULL values as
NULL. Can the latter be due to a differnce in Postgres
NULL
pending_restart | f
--
Adrian Klaver
adrian.kla...@aklaver.com
On 4/21/25 09:26, Anton Shepelev wrote:
Adrian Klaver:
Found it. It is coming from the Debian postgresql-common
packaging.
/usr/bin/pg_config is wrapper that contains:
#!/bin/sh
# If postgresql-server-dev-* is installed, call pg_config from the latest
# available one. Otherwise fall back
On 4/21/25 09:12, Thiemo Kellner wrote:
I wonder if that is a corner case. Updating a unique key sounds to me like a
design flaw in the first place.
Check out this the thread below for discussion on that topic:
https://www.postgresql.org/message-id/dkbnfi$7g5$1...@sea.gmane.org
--
Adrian
ost=0.00..1487.00
rows=10 width=10)
(10 rows)
and then:
with a as (select id from id_update where id > 9 order by id desc
for update) update id_update as t set id = a.id + 1 from a where a.id =
t.id;
UPDATE 1
Though at this point I would agree with you on the no guarantee point.
hjp
--
Adrian Klaver
adrian.kla...@aklaver.com
hjp
[1]
https://www.cybertec-postgresql.com/en/comparison-of-the-transaction-systems-of-oracle-and-postgresql/
--
Adrian Klaver
adrian.kla...@aklaver.com
On 4/17/25 15:25, Anton Shepelev wrote:
Adrian Klaver to Anton Shepelev:
Yet that is what we get for `pg_config --version' on the
affected system. A nearly identical error message seems to
come up while installing psycopg2 -- a Python library for
Postgres, e.g.:
&
On 4/17/25 14:23, Anton Shepelev wrote:
Adrian Klaver to Anton Shepelev:
db=# show shared_preload_libraries;
shared_preload_libraries
---
online_analyze, plantuner
Are you running PostgresPro?
Both those modules are associated with it:
https
r tech support.
db=# \dx
List of installed extensions
Name | Version | Schema | Description
-+-++--
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
--
Adrian Klaver
adrian.kla...@aklaver.com
/plantuner/blob/master/plantuner.c
Could not see PGC_S_OVERRIDE in it.
For online_analyze the only code I could find is old:
https://github.com/postgrespro/pgwininstall/blob/master/patches/postgresql/9.6/online_analyze.patch
Again no PGC_S_OVERRIDE.
regards, tom lane
-
On 4/16/25 09:25, Anton Shepelev wrote:
Adrian Klaver:
Anton Shepelev:
This shows a setting of 'on' not the 'off' you mention in
the first paragraph.
I beg pardon. Having no immediate access to the system in
question, I confess to having mocked up those results from
a
me| track_counts
setting | on
source | override
This shows a setting of 'on' not the 'off' you mention in the first
paragraph.
What does 'override' mean in the 'source' column? How can I
find where in the system this setting is overridden?
--
Adrian Klaver
adrian.kla...@aklaver.com
On 4/15/25 11:35, David G. Johnston wrote:
On Tue, Apr 15, 2025 at 11:20 AM Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
1) Try connecting(not using single user mode) to a cluster without them.
First I have had this discussion before and was not successful and I
On 4/15/25 09:48, David G. Johnston wrote:
On Tue, Apr 15, 2025 at 9:31 AM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
Agreed.
The fact that initdb creates the template0, template1 and postgres
databases and you can't change that makes them s
CREATE DATABASE test WITH TEMPLATE = template0 ...
Kind of a predefined set of databases…
As an example - there is a database called Postgres. It is created when
the server runs for the first time, whether I as a user like it or not.
Thank you.
David J.
--
Adrian Klaver
adrian.kla...@aklaver.com
false.
Or it can be determined ony by name?
Thank you.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 4/14/25 08:20, Dimitrios Apostolou wrote:
On Mon, 14 Apr 2025, Adrian Klaver wrote:
On 4/14/25 08:07, Laurenz Albe wrote:
On Mon, 2025-04-14 at 17:05 +0200, Dimitrios Apostolou wrote:
I meant the *referencing* table has just been
populated. I'm trying to delete the *referenced*
ileges; it should be done with caution since of
course the integrity of the constraint cannot be guaranteed if the
triggers are not executed."
Yours,
Laurenz Albe
--
Adrian Klaver
adrian.kla...@aklaver.com
On 4/13/25 06:03, 贾明伟 wrote:
hi，
I'm sorry to bother ， this is a test email
Testing what?
This is not the list for patches, I believe you are looking for:
https://www.postgresql.org/list/pgsql-hackers/
--
Adrian Klaver
adrian.kla...@aklaver.com
On 4/11/25 23:05, David G. Johnston wrote:
On Friday, April 11, 2025, Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 4/11/25 22:06, sivapostg...@yahoo.com
<mailto:sivapostg...@yahoo.com> wrote:
Either my command should be wrong or I'm missing s
On 4/11/25 22:06, sivapostg...@yahoo.com wrote:
Either my command should be wrong or I'm missing something.
This was explained in my post as quoted below.
Happiness Always
BKR Sivaprakash
On Friday 11 April, 2025 at 08:31:31 pm IST, Adrian Klaver
wrote:
On 4/11/25 05:55, siva
Couldn't figure it out. Any help is appreciated.
Happiness Always
BKR Sivaprakash
--
Adrian Klaver
adrian.kla...@aklaver.com
ntended recipient and contains
information that may be privileged and/or confidential. If you are not an
intended recipient, please notify the sender by return e-mail and delete this
e-mail and any attachments. Certain required legal entity disclosures can be
accessed on our website:
https://www.thomsonreuters.com/en/resources/disclosures.html
--
Adrian Klaver
adrian.kla...@aklaver.com
quot;, immutable function marked as immutable
function can not be inlined, but exactly the same function marked as
volatile do.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 4/10/25 08:48, Nico Williams wrote:
On Wed, Apr 09, 2025 at 02:43:11PM -0700, Adrian Klaver wrote:
On 4/9/25 14:21, Nico Williams wrote:
That to_char is not immutable is not documented though. Though it's
clear when looking at the docs for the `jsonb_.*_tz()` functions.
From
.
Is there a way to capture both IP address and hostname in the log
messages? Or must we choose “one or the ootehr”?
I see the same thing. It seems either or.
Thanks,
Mike Tefft
(We are using PG14 and PG16, but the docs say the same thing, as does PG17)
--
Adrian Klaver
adri
host connection parameter.
...
"
So if you have PGHOST set to say localhost it would be added to:
psql -Upostgres
Danny
*From:*David G. Johnston
*Sent:* Wednesday, April 9, 2025 10:34 PM
*To:* Abraham, Danny
*Cc:* Adrian Klaver ; Francisco Olarte
; pgsql-general@lists.postgresql.org
*Su
able” functions, whose results (for fixed inputs) do not
change within a scan."
Nico
--
Adrian Klaver
adrian.kla...@aklaver.com
a) Set log_connections and log_disconnections to on if they are not
already and reload the server conf.
b) Then look at Postgres log to see what the connection settings are for
the connections in question.
Danny
--
Adrian Klaver
adrian.kla...@aklaver.com
so are you editing the correct pg_hba.conf?
How did you install Postgres and what Linux distro(& version) are you using?
Thanks
Danny
--
Adrian Klaver
adrian.kla...@aklaver.com
-h localhost will use the host line, psql -h
/socket/path will go to the local one, and no -h defaults to socket.
On a windows host it default to tcp/ip to localhost.
Francisco Olarte.
--
Adrian Klaver
adrian.kla...@aklaver.com
ocal all all trust
#local all dbauser peer
OK
#hostall all 127.0.0.1/32 trust
--
Adrian Klaver
adrian.kla...@aklaver.com
encrypted or non-GSSAPI encrypted connection attempts.
On a unix host psql -h localhost will use the host line, psql -h
/socket/path will go to the local one, and no -h defaults to socket.
On a windows host it default to tcp/ip to localhost.
Francisco Olarte.
--
Adrian Klaver
adrian.kla...@aklaver.com
AL>
[2]:
https://www.postgresql.org/docs/current/protocol-logical-replication.html#PROTOCOL-LOGICAL-REPLICATION-PARAMS
<https://www.postgresql.org/docs/current/protocol-logical-replication.html#PROTOCOL-LOGICAL-REPLICATION-PARAMS>
--
Willy-Bas Loos
--
Adrian Klaver
adrian.kla...@aklaver.com
looking at DB settings and Statistic settings
I am at a loss/
Simon
--
Adrian Klaver
adrian.kla...@aklaver.com
On 3/24/25 08:51, Dimitrios Apostolou wrote:
On Mon, 24 Mar 2025, Adrian Klaver wrote:
On 3/24/25 07:24, Dimitrios Apostolou wrote:
On Sun, 23 Mar 2025, Laurenz Albe wrote:
On Thu, 2025-03-20 at 23:48 +0100, Dimitrios Apostolou wrote:
Performance issues: (important as my db size is >
On 4/2/25 10:39 AM, Adrian Klaver wrote:
--clean will drop the object entirely not TRUNCATE.
I'm guessing that this is being done by you per:
https://www.postgresql.org/message-id/53760c70-4a87-a453-9e02-57abc9cb2e54%40gmx.net
"After each failed attempt, I need to issue
on-rows tables?
COPY is all or none(version 17+ caveat(see
https://www.postgresql.org/docs/current/sql-copy.html ON_ERROR)), so if
the data dump fails in --single-transaction everything rolls back.
Thank you,
Dimitris
--
Adrian Klaver
adrian.kla...@aklaver.com
I
You could borrow from here:
https://github.com/postgresql-interfaces/psqlodbc/blob/main/pgtypes.h
--
Adrian Klaver
adrian.kla...@aklaver.com
This would speed
up the process quite a bit.
Any feedback for improving my process? Should I put these ideas somewhere
as ideas for improvement on pg_restore?
Thank you in advance,
Dimitris
--
Adrian Klaver
adrian.kla...@aklaver.com
at is going on behind the scenes.
Well, PostgreSQL certainly can read faster than 34MB/s off of disk. With the
data you've given, I can't really say if it's purely an EBS issue.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 3/20/25 05:58, Siraj G wrote:
Hello Laurenz
As per my understanding coming to a proper conclusion wrt RPO
You still have not defined what RPO is.
--
Adrian Klaver
adrian.kla...@aklaver.com
answers to the first
two questions.
Thank you.
--
Adrian Klaver
adrian.kla...@aklaver.com
PLACE ] [ CONSTRAINT ] TRIGGER name ..."
--
Adrian Klaver
adrian.kla...@aklaver.com
On 4/4/25 9:45 AM, Ron Johnson wrote:
TRUNCATE statements inside of "toc.dat" files? I'm skeptical.
See my post here:
https://www.postgresql.org/message-id/7be2dcc6-3ba4-4e3f-a154-8d13d816aa9b%40aklaver.com
--
Adrian Klaver
adrian.kla...@aklaver.com
On 4/4/25 08:09, Dimitrios Apostolou wrote:
On Fri, 4 Apr 2025, Adrian Klaver wrote:
On 4/4/25 06:13, Dimitrios Apostolou wrote:
On Wed, 2 Apr 2025, Dimitrios Apostolou wrote:
Bug? This happened on a postgres compiled from last week's master
branch.
Are you talking about th
s
Dimitris
--
Adrian Klaver
adrian.kla...@aklaver.com
iled attempt, I need to issue a TRUNCATE table1,table2,...
before I try again. "
Thanks in advance,
Dimitris
--
Adrian Klaver
adrian.kla...@aklaver.com
ch as .20
i.e 13.20
Also working on the steps for db migration from ver 13.X to ver 14.X
We are also update with respective AWS based EC2 server based OS patches
--
Adrian Klaver
adrian.kla...@aklaver.com
, you are going to need to reach out
to their tech support.
Thanks a lot! 😊
--
Adrian Klaver
adrian.kla...@aklaver.com
n, they all
say "def", as in default. Further, the identifier used in CREATE
DATABASE will show up in INFORMATION_SCHEMA tables in *_SCHEMA columns.
--
Adrian Klaver
adrian.kla...@aklaver.com
query ends
up doing:
"[...] If the first updater commits, the second updater will ignore the
row if the first updater deleted it, [...]"
Hence the DELETE 0 and the PK violation because the INSERT in terminal 1
already created a row with id=1.
Thanks in advance!
Kind Regards
Sasa Vilic
essShareLock
entity | AccessShareLock
| ExclusiveLock
--
Adrian Klaver
adrian.kla...@aklaver.com
usage of pg_restore that I have is not to save me from
emergencies but to populate the dev database with recent data.
Regards,
Dimitris
--
Adrian Klaver
adrian.kla...@aklaver.com
lem, I cannot access any file from:
projects/postgresql.git/tree
It would help to also bring this up on:
https://www.postgresql.org/list/pgsql-www/
Thanks,
Mano Chandar
_/
/_
_/
/_
_/
/_
--
Adrian Klaver
adrian.kla...@aklaver.com
takes all available space.
You are going to need to show the complete process you are using as well
as the error messages you get in the Postgres log.
Thanks. Daniil Rozanov
--
Adrian Klaver
adrian.kla...@aklaver.com
g/docs/17/libpq-exec.html#LIBPQ-PQFTYPE
the suggested way to get type information is:
"You can query the system table pg_type to obtain the names and
properties of the various data types. "
And still, I do not trust the content.
Then do as suggested above.
Seb
--
Adrian Klaver
adrian.kla...@aklaver.com
need this process to incrementally update the customer database
can you help us in this regard .
Thanks & Regards,
Puspendu
--
Adrian Klaver
adrian.kla...@aklaver.com
r instance unless required.
This is a cloud managed SQL and we do not have any custom setting on the
vacuum part.
To be clear the issue is in the Google Cloud SQL instance?
Or are you seeing the problem on the Postgres instance the data is
coming from?
On Wed, Mar 19, 2025 at 10:47 PM Adr
338 GB
pg_attribute_relid_attnam_index
117 GB
pg_attribute_relid_attnum_index
69 GB
I think this table must have tons of dead tuples. Please suggest to me
if we can purge any data/shrink the size of this table.
REgards
Siraj
--
Adrian Klaver
adrian.kla...@aklaver.com
After building PostgreSQL *17.4* from the sources, I cannot find this
pg_type_d.h header file in the installation directory. Maybe I am
missing some configure option?
Went I built from source in ended up in:
/usr/local/pgsql/include/server/catalog/
--
Adrian Klaver
adrian.kla...@aklaver.com
sch;
ALTER SCHEMA other_sch OWNER TO postgres;
--
-- Name: public; Type: SCHEMA; Schema: -; Owner: pg_database_owner
--
CREATE SCHEMA public;
ALTER SCHEMA public OWNER TO pg_database_owner;
[...]
What is the complete command you are using for the pg_dump?
What Postgres version(s) are you using?
Cheers,
Sylvain
--
Adrian Klaver
adrian.kla...@aklaver.com
Id = $6 AND MarketId = $7 LIMIT ?)
Regards
Durga Mahesh
--
Adrian Klaver
adrian.kla...@aklaver.com
fewer columns in the test version, like so:
Where *node_id* is a foreign key in dataset, and *node_type* is not.
Best regards,
Mark Brady
--
Adrian Klaver
adrian.kla...@aklaver.com
_amazon.com/author/markjbrady <https://amazon.com/author/markjbrady>_
--------
--
Adrian Klaver
adrian.kla...@aklaver.com
uthor/markjbrady>_
--
Adrian Klaver
adrian.kla...@aklaver.com
coming.
Best regards,
Mark Brady
_amazon.com/author/markjbrady <https://amazon.com/author/markjbrady>_
--
Adrian Klaver
adrian.kla...@aklaver.com
On 3/12/25 13:55, Paul Foerster wrote:
Hi Adrian,
On 12 Mar 2025, at 21:26, Adrian Klaver wrote:
A good summary of the glibc issue:
https://wiki.postgresql.org/wiki/Locale_data_changes
With distro information:
https://wiki.postgresql.org/wiki/Locale_data_changes
.
Cheers,
Paul
--
Adrian Klaver
adrian.kla...@aklaver.com
On 3/11/25 13:24, Adrian Klaver wrote:
On 3/11/25 12:55, mark bradley wrote:
It happened again. Now there are no sequences (although there once was).
Read my previous post and provide the information requested.
Mark sent me the below, which answers some of the questions, namely
there is
On 3/12/25 08:46, Adrian Klaver wrote:
On 3/11/25 13:24, Adrian Klaver wrote:
On 3/11/25 12:55, mark bradley wrote:
It happened again. Now there are no sequences (although there once
was).
Read my previous post and provide the information requested.
Mark sent me the below, which answers
or/markjbrady>_
----
*From:* Adrian Klaver
*Sent:* Tuesday, March 11, 2025 3:37 PM
*To:* mark bradley
*Cc:* pgsql-general
*Subject:* Re: Duplicate Key Values
On 3/11/25 11:52, mark bradley wrote:
there is an index on node
ever run VALIDATE CONSTRAINT against them?
Is there anything in Postgres log at the time you did the above that
showed it did more then a REINDEX?
Not that I can tell.
Best regards,
Mark Brady
_amazon.com/author/markjbrady <https://amazon.com/author/markjbrady>_
--
Adrian
relationships between tables in the markdown file...
I hope the above outline is understandable and am interested in comments and
thoughts on my above approach.
Thanks.
--
Adrian Klaver
adrian.kla...@aklaver.com
. We have a lot of databases, some of them
need to be highly available and some are large too.
Are there any obstacles that definitely make that a no-go? Do I risk
corruption? It's both Linux, just a different distribution.
Cheers,
Paul
--
Adrian Klaver
adrian.kla...@aklaver.com
mazon.com/author/markjbrady>_
--------
*From:* Adrian Klaver
*Sent:* Tuesday, March 11, 2025 11:12 AM
*To:* mark bradley
*Cc:* pgsql-general
*Subject:* Re: Duplicate Key Values
On 3/11/25 08:05, mark bradley wrote:
The rows that were preserved in the nodes tabl
ady>_
*From:* Adrian Klaver
*Sent:* Tuesday, March 11, 2025 10:56 AM
*To:* mark bradley
*Cc:* pgsql-general
*Subject:* Re: Duplicate Key Values
On 3/11/25 07:28, mark bradley wrote:
An "interesting" effect of reindexing is that all the records that w
on.com/author/markjbrady>_
--
Adrian Klaver
adrian.kla...@aklaver.com
. Is there a known
issue like this affecting others?
The solution:
https://www.postgresql.org/docs/current/app-psql.html
If that is not suitable then I would suggest asking here:
https://www.postgresql.org/list/pgadmin-support/
Regards,
Graeme
OFFICIAL
--
Adrian Klaver
adrian.kla
_57rQ%40mail.gmail.com
Best regards,
Mark Brady
_amazon.com/author/markjbrady <https://amazon.com/author/markjbrady>_
----
*From:* Adrian Klaver
*Sent:* Friday, March 7, 2025 10:55 AM
*To:* mark bradley
*Cc:* pgsql-general
*S
solve it.
Best regards,
Mark Brady
--
Adrian Klaver
adrian.kla...@aklaver.com
the Postgres server or the underlying OS?
4) Have you tried reindexing the node_id field?
Mark Brady,
_amazon.com/author/markjbrady <https://amazon.com/author/markjbrady>_
--
Adrian Klaver
adrian.kla...@aklaver.com
) NOT VALID
Inherits: node
Best regards,
Mark Brady
_amazon.com/author/markjbrady <https://amazon.com/author/markjbrady>_
*From:* Adrian Klaver
*Sent:* Thursday, March 6, 2025 3:03 PM
*To:* mark bradley
*Subject:* Re: Duplica
rkjbrady>_
----
*From:* Adrian Klaver
*Sent:* Thursday, March 6, 2025 1:22 PM
*To:* mark bradley ; Ron Johnson
; pgsql-general
*Subject:* Re: Duplicate Key Values
On 3/6/25 10:11, mark bradley wrote:
Here is the table definition:
And here is the error message I
the
non-key for some unknown reason. Here is a screenshot. The key is
node_id, which I have specified as a key and unique identifier.
--
Adrian Klaver
adrian.kla...@aklaver.com
uldn't
perform as well as in SQL Server if you use schemas instead of
databases.
Yours,
Laurenz Albe
--
Adrian Klaver
adrian.kla...@aklaver.com
.com <http://www.mokadb.com>
--
Adrian Klaver
adrian.kla...@aklaver.com
quot;).
2. Selected categories (e.g., "casual" and "sports").
3. Selected attributes (e.g., "color: blue" and "size: large")
Regards
Saeed
--
Adrian Klaver
adrian.kla...@aklaver.com
quote]
Is there any way to suppress this NOTICE message?
From here:
https://www.postgresql.org/docs/current/runtime-config-client.html
SET set client_min_messages = ;
You could that for just the session.
Thank you.
--
Adrian Klaver
adrian.kla...@aklaver.com
r the distro.
Also, does this mean the driver is incompatible with the server version
on the protocol used?
Thank you.
>
> Thank you.
>
>>
>>>
--
Adrian Klaver
adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com
On 3/4/25 3:00 PM, Igor Korot wrote:
Hi, Adrian,
On Sat, Mar 1, 2025 at 7:06 PM Adrian Klaver wrote:
On 3/
Did the connection work after making the change?
Sorry somehow missed that reply,
No still getting the same error...
This thread:
https://forums.gentoo.org/viewtopic-p-8856135
://www.postgresql.org/docs/current/ddl-schemas.html#DDL-SCHEMAS-PATH
It explains search_path and how to modify it.
--
Adrian Klaver
adrian.kla...@aklaver.com
well under way. The chances of it making
it in given the time frame is slim, so that pushes a practicable
deadline until Fall of 2026.
3) As I mentioned in a previous post there are packages already out
there that may get you want you want now.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 3/1/25 19:35, Krishnakant Mane wrote:
For my future reference does something like this response work better?
--
Adrian Klaver
adrian.kla...@aklaver.com
*Krishnakant Mane*
Software Architecture Design & Implementation Specialist
--
Adrian Klaver
adrian.kla...@aklaver.com
On 3/1/25 18:14, Krishnakant Mane wrote:
On 3/2/25 07:23, Adrian Klaver wrote:
On 3/1/25 17:39, Krishnakant Mane wrote:
But when I try creating the same immv on the server it says
function create_immv (unknown, unknown ) does not exist.
Connect with psql then do:
1) \dx
This will show
1 - 100 of 3740 matches
Mail list logo
