Re: How to read an external pdf file from postgres?

2022-01-12 Thread Peter Eisentraut
On 12.01.22 12:16, Amine Tengilimoglu wrote:      I want to read an external pdf file from postgres. pdf file will exist on the disk. postgres only know the disk full path as metadata. Is there any software or extension that can be used for this? Or do we have to develop software for it?  Or w

Re: Strange results when casting string to double

2022-02-18 Thread Peter Eisentraut
On 16.02.22 14:27, Carsten Klein wrote: AFAIK, this conversion is done by internal function float8in, which, when called directly, yields the same results: SELECT float8in('1.56'); --> 1.55   (wrong!)   on one server, and --> 1.56   (correct!) on all other servers. fl

Re: Future of PlPython2

2017-12-09 Thread Peter Eisentraut
On 12/9/17 12:15, Boshomi DeWiki wrote: > Python 2.7 will not be maintained past 2020.[1]  > > Python2 is still default for Postgres 10. CREATE EXTENSION PLPYTHONU > results in installation of PLPYTHON2U. > > As of now SUSE does not support PLPYTHON3U. (This will change soon) > > Are there any p

Re: How to see index was rejected for seq scan?

2017-12-16 Thread Peter Eisentraut
e the costs. If the planner still gives you a sequential scan, then the index was not applicable for other reasons. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: characters converted to ??? in postgres

2018-01-11 Thread Peter Eisentraut
your libedit library. Try running psql with the -n option. If that helps, then look into building psql with libreadline instead. Because libedit is terrible. > - case 2 is fine > - echo -n '≤' |hexdump -C > e2 89 a4 |...| &g

Re: characters converted to ??? in postgres

2018-01-12 Thread Peter Eisentraut
ad conversion happens, in other > words it passes to the backend the ?? characters > Any similar trick I could use on the postgres jdbc driver ? That appears to be a completely separate issue. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: Changing locale/charset

2018-01-22 Thread Peter Eisentraut
probably had a locale of xx_XX.utf8, so it had the UTF8 encoding. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: Slow alter sequence with PG10.1

2018-01-22 Thread Peter Eisentraut
On 1/22/18 17:11, Michael Krüger wrote: > I do not fully understand the reasoning of making sequences > transactional in the first place. It was sequence DDL that was made transactional. Sequence use is still nontransactional. -- Peter Eisentraut http://www.2ndQuadra

Re: Postgres for hadoop

2018-01-25 Thread Peter Eisentraut
traut.org/blog/2015/08/14/have-problems-with-postgresql-try-using-hive/ -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: PostgreSQL 9.6: view based on sequence

2018-01-25 Thread Peter Eisentraut
a system table, then you'll get whatever types the system table uses. There is nothing from with that. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: pg10 logical replication set schema

2018-01-30 Thread Peter Eisentraut
ld use the table > some_schema.test_table_replication instead of > public.test_table_replication? No. > I can't find any reference in the docs > about tables or schemas in subscriptions. Here: https://www.postgresql.org/docs/10/static/logical-replication-subscription.html --

Re: session_replication_role meaning?

2018-01-30 Thread Peter Eisentraut
changes, e.g., https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/backend/replication/logical/worker.c;h=eedc3a8816bc2f157e62a664bcc57b5f87530be9;hb=958fe549884928cd3bdf009993e9a05df5fd6cee#l1521 -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: PostgreSQL Kerberos Authentication

2018-01-30 Thread Peter Eisentraut
found in Kerberos database Check that your DNS resolves everything correctly. You can find some ideas about this error in the internet. It's not a problem specific to PostgreSQL. It looks like you have things set up correctly. -- Peter Eisentraut http://www.2ndQuadrant.com/

Re: Unexpected ErrorMessage reply to SSLRequest

2018-02-02 Thread Peter Eisentraut
lso says that you should handle it nonetheless. ;-) -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: Ensure extension exists

2018-02-02 Thread Peter Eisentraut
t up in a way that it blows away your database on each run. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: Documentation section F

2018-02-07 Thread Peter Eisentraut
ut the modules themselves are still extensions that you need to install into the databases. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: Another documentation issue

2025-04-24 Thread Peter Eisentraut
On 23.04.25 11:14, Daniel Gustafsson wrote: On 23 Apr 2025, at 09:16, Laurenz Albe wrote: On Wed, 2025-04-23 at 00:21 -0500, Igor Korot wrote: However, this page https://www.postgresql.org/docs/current/runtime-config-resource.html#GUC-EFFECTIVE-IO-CONCURRENCY describes both default and mn/max

<    1   2