[no subject]

PG 14.10 (and 9.6.24, which we're migrating off of). EXPLAIN SELECT works inside a FOR loop, but only the first line of the EXPLAIN output is stored. What's the magic sauce for seeing the whole EXPLAIN output? (The purpose is to generate many queries and see how the BIND and SELECT times change

Re: Subject: FATAL: cache lookup failed for relation 1247

Israr Khan writes: > I am facing the postgresql database access issue after doing vacuum on a > table. There has to have been more to it than that. > Error : FATAL: cache lookup failed for relation 1247 1247 is pg_type, so this looks like rather nasty catalog corruption. If you're really

Subject: FATAL: cache lookup failed for relation 1247

Hey PgSQL , I am facing the postgresql database access issue after doing vacuum on a table. Please help and suggest as soon as possible. Error : FATAL: cache lookup failed for relation 1247 Thank you Israr -- Disclaimer : This message (including any attachments) is sent on behalf of Amnex

[no subject]

Hi Team, 1. We are using Windows server . How to set up Kerberos authentication? 2.How to set up/create/use SSPI authentication? 3.Like MSSQL server windows authentication is it possible in postgresql server? I tried to search through Google,youtube and chatgpt also. I'm unable to get clarity on

[no subject]

I am using postgres v.14 on rhel8 I enabled the track_commit_timestamp parameter. postgres [379418]=# show track_commit_timestamp ; ┌┐ │ track_commit_timestamp │ ├┤ │ on │ └┘ (1 row) I performed a recover

[no subject]

Good morning to all. I'd need some advice. I'm trying to install PgAdmin4 from its repository, on Debian 11, by the instructions in the concerning page in www.postgresql.org. The installation fails, as the packages cannot be verified. What shoud I do? I tried using deb [trusted=yes], but

[no subject]

Hi all, How to take a table backup using directory format? I am having huge size of table when I am using a pg_dump it tooks more time kindly suggest me

Re: Outer joins and NULLs (old subject "ERROR: failed to find conversion function from key_vals_nn to record[]")

> david.g.johns...@gmail.com wrote: > > Allowing domains to be defined as not null at this point is simply something > that we don't support but don't error out upon in the interest of backward > compatibility. (IMO, the documentation is not this strongly worded.) It, as > you note, has some

Re: Outer joins and NULLs (old subject "ERROR: failed to find conversion function from key_vals_nn to record[]")

On Sun, Jun 19, 2022 at 2:31 PM Bryn Llewellyn wrote: > It would be foolish, therefore, to define the target table for > "insert-select" using "CTAS where false". > SQL is a strongly typed language where the structure of the query output is determined without any consideration of whether said

Re: Outer joins and NULLs (old subject "ERROR: failed to find conversion function from key_vals_nn to record[]")

Bryn Llewellyn writes: > Self-evidently, a view does *not* inherit constraints from the columns of its > base table(s). Check. > A view on a single table doesn't necessarily inherit the data types of its > base table's columns. Rather, the view compilation's analysis is *sometimes* > clever

Outer joins and NULLs (old subject "ERROR: failed to find conversion function from key_vals_nn to record[]")

> b...@yugabyte.com wrote: > >> david.g.johns...@gmail.com wrote: >> >>> b...@yugabyte.com wrote: >>> >>> Can anybody show me an implementation of a realistic use case that follows >>> proper practice — like "every table must a

[no subject]

Hi , What type of temp database should i use to maintain logs or export logs? Thanks Rama-krishnan

[no subject]

Hi - Does anyone use the gawk extension? I think it is the coolest thing. I see that it installed .so files on my system from the fedora package manager but there is no .sql file or control file in the extension directory. I searched with kfind utility and didn't find anything. I can't seem to

[no subject]

Hi, After pg_repack do we face any perfomancr issue or any other issues in production DB

[no subject]

Hi All, How to install pg_repack and use? Thanks RamaKrishnan

[no subject]

Hi, Can I add custom sqls for regression tests (pg_regress) ? If it can be added how? Dennis

[no subject]

Postgres 9.6. We're attempting to delete some old users from a DB. Log into DB as masteruser. Run this block of commands (the_schema=public, and it's the only schema in this particular DB): REVOKE ALL PRIVILEGES ON DATABASE the_database FROM old_role; REVOKE USAGE ON SCHEMA the_schema FROM

[no subject]

[no subject]

Hi everyone is there any one working on PostgreSQL windows machine. Thank you & Regards Obireddy.G

[no subject]

Hi everyone. how to take incremental backup in postgresql windows machine. Thank you And Regards Obireddy.G

[no subject]

How measure table total pages (block) count? would be this correct way? : SELECT pg_table_size('my_table'::regclass) / current_setting('block_size')::BIGINT;

[no subject]

Igor Korot writes: > On Fri, Jul 2, 2021, 5:24 AM Atul Kumar wrote: >> -> Seq Scan on sam_participant pp (cost=0.00..777393.87 rows=56113 >> width=10) (actual time=0.277..10869.750 rows=2335154 loops=1) >> Filter: ((igroupid)::integer = >>

[no subject]

Hi, I have one query like below : SELECT m.iMemberId "memberId", m.cFirstName "firstName", m.cLastName "lastName", m.cFirstName || ' '

[no subject]

"David G. Johnston" writes: > Given this, should the configuration description for this include the "This > parameter can only be set in postgresql.conf file or on the server command > line." comment, Hmm, yeah, it does lack the standard boilerplate for a PGC_POSTMASTER GUC. I wonder which

[no subject]

"David G. Johnston" writes: > On Monday, May 17, 2021, Tom Lane wrote: >> It looks like it won't be started if you set >> max_logical_replication_workers = 0. > I was wondering about that. Would you mind posting a link to the code > where that is checked? I actually looked though admittedly

[no subject]

"David G. Johnston" writes: > On Sunday, May 16, 2021, Loles wrote: >> I don't understand why the server starts that process if I'm not using >> replication of any kind. > It starts the process because at any time someone can execute a “create > subscription” command. If no one does so the

[no subject]

Hi! Let's see if someone can answer my question. In a default PostgreSQL 13 installation, starting the server starts a process called "logical replication launcher". I know what logical replication is but I don't know what this process does on the server. Even if you change the default setting

[no subject]

Hello All, I have the following table: postgres=# \d so_rum; Table "public.so_rum" Column | Type | Collation | Nullable | Default ---+-+---+--+- id| integer

[no subject]

subscribeend  

[no subject]

Hello, I am running postgres 11.5 and we were having issues with shared segments. So I increased the max_connection as suggested by you guys and reduced my work_mem to 600M. Right now instead, it is the second time I see this error : ERROR: could not resize shared memory segment

[no subject]

Hi, I am new to this list and reaching out because I am having troubles setting up a local PostgreSQL database on my laptop. Maybe, as a preamble, I should say that I am pretty much a novice trying to teach myself and get practical experience about database and SQL queries (I have some general

[no subject]

Hello , does postgresql with react native allow us to create chat applications?

[no subject]

Is there any option to run reindex or vaccum in background? Every time the session gets logged off in between.

Re: Subject: Re: constrain with MATCH full and NULL values in referenced table

On Mon, Aug 12, 2019 at 10:40:20AM -0700, Adrian Klaver wrote: > On 8/12/19 10:30 AM, stan wrote: > > > > The task_instance table is the one the original question was in > > > > reference > > > > to. > > > > > > > > CREATE TABLE employee ( > > > > employee_keyinteger DEFAULT >

Re: Subject: Re: constrain with MATCH full and NULL values in referenced table

On 8/12/19 10:30 AM, stan wrote: The task_instance table is the one the original question was in reference to. CREATE TABLE employee ( employee_keyinteger DEFAULT nextval('employee_key_serial') PRIMARY KEY , id varchar(5) NOT NULL UNIQUE ,

Re: Subject: Re: constrain with MATCH full and NULL values in referenced table

On Mon, Aug 12, 2019 at 10:16:41AM -0700, Adrian Klaver wrote: > On 8/12/19 10:06 AM, stan wrote: > > Cc: pgsql-general.lists.postgresql@panix.com > > Subject: Re: constrain with MATCH full and NULL values in referenced table > > User-Agent: Mutt/1.12.1 (2019-06-1

Re: Subject: Re: constrain with MATCH full and NULL values in referenced table

On 8/12/19 10:06 AM, stan wrote: Cc: pgsql-general.lists.postgresql@panix.com Subject: Re: constrain with MATCH full and NULL values in referenced table User-Agent: Mutt/1.12.1 (2019-06-15) X-Editor: gVim On Mon, Aug 12, 2019 at 06:22:54PM +0200, Francisco Olarte wrote: Stan: On Mon, Aug

Subject: Re: constrain with MATCH full and NULL values in referenced table

Cc: pgsql-general.lists.postgresql@panix.com Subject: Re: constrain with MATCH full and NULL values in referenced table User-Agent: Mutt/1.12.1 (2019-06-15) X-Editor: gVim On Mon, Aug 12, 2019 at 06:22:54PM +0200, Francisco Olarte wrote: > Stan: > > On Mon, Aug 12, 2019 at 5:1

[no subject]

Hi Team, We are getting below error while during import the csv file please do the needful. CREATE TABLE ujshjk ( pod_id bigint NOT NULL, src_id smallint, eff_strt_dt date,eff_end_dt date,ins_dt timestamp without time zone,updt_dt timestamp without time zone,nat_key_1 character(50),nat_key_2

[no subject]

Hello All, Is it possible check privileges of all the users or roles, and what are the objects owned by user and role with their privileges. I am getting the output which want from information_schema.roles_usage_grants, but as I not running the query as a superuser so I am able to see only one

[no subject]

Hi All, In order to implment connection pool mechanisam, we have decided to use pg_bouncer. But due to some dependent software's like openssl we are not going to use pg_bouncer. Therefore we are planning to use pgpool to implement the connection pool mechanisam in my applicaiton. We don't have

[no subject]

Can I split a large file into multiple files and then run copy using each file.  The table does not contain any serial or sequence column which may need serialization. Let us say I split a large file to 4 files.  Will theperformance boost by close to 4x??

[no subject]

Hi, is there a way to find if a certain page in a data file is referenced by a btree index? I found a few completely empty pages in one of my tables. I am not sure if that's corruption or just bloat. Now I am thinking I could use an index, the PK for instance, and see if it references these

[no subject]

Dont mail me plase unsubscribe

[no subject]

ÑAO EÑTENĎI

[no subject]

Hi friends, This is Ramar and i have accidentally deleted database in postgresql through pg admin. My backup restore not working. Can i recover my deleted database in postgresql. Anyone having solution kindly reply me. Thanks & Regards, Ramar D