Re: Dynamic procedure execution

Hi David, As I am not bit Clea, let me know what I have to do. If possible, please re- write my program. Regards Muthu On Mon, Dec 14, 2020, 11:43 AM David G. Johnston wrote: > On Sunday, December 13, 2020, Muthukumar.GK wrote: > >> >> v_query := ' OPEN C1 FOR SELECT * FROM public."Bankdetail

Re: Dynamic procedure execution

On Sunday, December 13, 2020, Muthukumar.GK wrote: > > v_query := ' OPEN C1 FOR SELECT * FROM public."Bankdetails"'; > > > > EXECUTE (v_query); > > > You put the pl/pgsql OPEN command into a string and sent it to the SQL engine via EXECUTE and the SQL engine is complaining that it has no idea wha

Dynamic procedure execution

Hi team, When I am trying to implement belwo dynamic concept in postgreSql, getting some error. Kindly find the below attached program and error. Please advise me what is wrong here.. CREATE OR REPLACE PROCEDURE DynamicProc() AS $$ DECLARE v_query TEXT; C1 refcursor := 'result1'; begin v_q

Re: Potential BRIN Index Corruption

Hi Tomas The records have a timestamp column so we do know the time they were written. We didn't find any I/O issues that match that time but unfortunately as it's been a while we are not confident with that finding. > Are there any other corrupted indexes on the table? That was one of my first

Re: Is there a way to dump schema to files on disk and keep them in sync

I mean, you want to dump a schema into a directory. Alembic, sqlalchemy and pathlib will do that in a few minutes. If you want to sync changes then write alembic change scripts and reflect those changes in the ORM, alembic does that. Modifying the ORM and reflecting those changes is a terrible idea

Re: Is there a way to dump schema to files on disk and keep them in sync

On 12/13/20 1:04 PM, Tim Uckun wrote: pgAdmin does not create directories, it just organizes the contents of the system catalogs into GUI elements. I realize that :). I meant organized in the same way but on disk. Nothing that I know of. You could do a pg_dump -d some_db -s/--schema-only a

Re: Is there a way to dump schema to files on disk and keep them in sync

>pgAdmin does not create directories, it just organizes the contents of the system catalogs into GUI elements. I realize that :). I meant organized in the same way but on disk.

Re: Is there a way to dump schema to files on disk and keep them in sync

My primary use case for this is for development and experimentation, I have no intent on using it on production servers :) I normally use migrations for those. On Sun, Dec 13, 2020 at 9:04 PM Ron wrote: > > On 12/12/20 8:58 PM, Tim Uckun wrote: > > I want to dump my postgres schema to disk in ne

Re: pg_restore fails when psql succeeds

The exact command is nothing fancy really. The complete exact command is below export PGPASSWORD=xxx pg_restore --verbose --no-password --clean --if-exists -h 111.111.111.111 -p 5432 -U user -d blankdbfromstandardtemplate0 /PATH/EXPORTEDDIR 2>&1 | tee logfile I was able to import

Re: Is there a way to dump schema to files on disk and keep them in sync

On 12/13/20 10:03 AM, Benedict Holland wrote: You want Alembic and an afternoon of python writing. You just described an ORM. In other words out of the frying pan and into the fire. On Sun, Dec 13, 2020, 12:53 PM Tomas Vondra mailto:tomas.von...@enterprisedb.com>> wrote: On 12/13/20

Re: Is there a way to dump schema to files on disk and keep them in sync

You want Alembic and an afternoon of python writing. You just described an ORM. On Sun, Dec 13, 2020, 12:53 PM Tomas Vondra wrote: > On 12/13/20 6:34 PM, Adrian Klaver wrote: > > On 12/12/20 6:58 PM, Tim Uckun wrote: > >> I want to dump my postgres schema to disk in neat directories like > >> pg

Re: pg_restore fails when psql succeeds

On 12/12/20 12:39 PM, Cherio wrote: I install PostgreSQL from "apt.postgresql.org " repository: $ /usr/lib/postgresql/13/bin/postgres --version postgres (PostgreSQL) 13.1 (Ubuntu 13.1-1.pgdg20.04+1) It runs in a VM, the most recent & updated version of Ubuntu LTS 20.0

Re: Is there a way to dump schema to files on disk and keep them in sync

On 12/13/20 6:34 PM, Adrian Klaver wrote: > On 12/12/20 6:58 PM, Tim Uckun wrote: >> I want to dump my postgres schema to disk in neat directories like >> pgadmin presents. Then I want to be able to edit the files and sync >> changes to the database and ideally if changes were made in the >> databa

Re: Is there a way to dump schema to files on disk and keep them in sync

On 12/12/20 6:58 PM, Tim Uckun wrote: I want to dump my postgres schema to disk in neat directories like pgadmin presents. Then I want to be able to edit the files and sync changes to the database and ideally if changes were made in the database to sync them back to the disk. Is there a tool tha

Re: Is there a way to dump schema to files on disk and keep them in sync

On 12/12/20 8:58 PM, Tim Uckun wrote: I want to dump my postgres schema to disk in neat directories like pgadmin presents. Then I want to be able to edit the files and sync changes to the database and ideally if changes were made in the database to sync them back to the disk. That could get rea