Re: create_immv issue on aws Ubuntu even after create extention

Then deal with the fact it is no longer installed to pg_control but instead pgivm. With usual schema qualifications or search_path techniques. Thank you, it worked.  now pgivm.create_immv works. I should have got it before. Did you not read my previous post? -- Email Signature *Kris

Re: create_immv issue on aws Ubuntu even after create extention

On 3/2/25 08:44, Adrian Klaver wrote: Then deal with the fact it is no longer installed to pg_control but instead pgivm. With usual schema qualifications or search_path techniques. Thank you, it worked.  now pgivm.create_immv works. I should have got it before. Did you not read my previ

Re: Please implement a catch-all error handler per row, for COPY

me nefcanto writes: > Can you please provide a row-level catch-all handler for the copy command? Very unlikely to happen. COPY is not intended as a general purpose ETL mechanism, and we don't want to load it down with features that would create substantial performance penalties. Which that woul

Re: Version compatibility

Hi, Adrian, On Sat, Mar 1, 2025 at 12:31 PM Adrian Klaver wrote: > > On 3/1/25 14:17, Igor Korot wrote: > > Reply to list also. > Ccing list. > > Comments inline. > > > Hi, Adrian, > > On Sat, Mar 1, 2025 at 11:23 AM Adrian Klaver > > wrote: > > > > On 3/1/

Re: create_immv issue on aws Ubuntu even after create extention

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 what extensions are installed and in what s

Re: create_immv issue on aws Ubuntu even after create extention

On 3/2/25 07:03, Adrian Klaver wrote: On 3/1/25 17:25, Krishnakant Mane wrote: On 3/1/25 22:17, Adrian Klaver wrote: On 2/28/25 21:29, Krishnakant Mane wrote: All done, but no result. I feel it is possible that the latest code must be flawed or something. Well, as a matter of fact, I nev

Re: create_immv issue on aws Ubuntu even after create extention

On 3/1/25 17:25, Krishnakant Mane wrote: On 3/1/25 22:17, Adrian Klaver wrote: On 2/28/25 21:29, Krishnakant Mane wrote: All done, but no result. I feel it is possible that the latest code must be flawed or something. Well, as a matter of fact, I never had to compile the extention on my loc

Re: create_immv issue on aws Ubuntu even after create extention

On 3/1/25 22:17, Adrian Klaver wrote: On 2/28/25 21:29, Krishnakant Mane wrote: All done, but no result. I feel it is possible that the latest code must be flawed or something. Well, as a matter of fact, I never had to compile the extention on my local ubuntu 24.04 machine. How did you ins

Re: create_immv issue on aws Ubuntu even after create extention

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 what extensions are installed and in what schema. 2) show search_path; 3) \df *.c

Re: create_immv issue on aws Ubuntu even after create extention

Yes perfect thank you. Besides, I will soon switch over to Mac air m3 and voice over does not have such problems. This screen reader Orca is great as well and I am very sure, that it being open source, will have the issue fixed at the earliest. Regards. On 3/2/25 09:53, Adrian Klaver wrote

Re: Version compatibility

On 3/1/25 21:17, Igor Korot wrote: Do you have a $HOME/.odbc.ini? Also in odbc.ini, per man odbc.ini, I believe you have to have something like: [ODBC Data Sources] Postgresql = This is my Postgres DSN. I added it and now my odbc.n look like this: [code] igor@IgorsGentoo ~/dbhandler/Debug

Re: create_immv issue on aws Ubuntu even after create extention

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

Re: create_immv issue on aws Ubuntu even after create extention

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 w

Re: create_immv issue on aws Ubuntu even after create extention

On Saturday, March 1, 2025, Krishnakant Mane wrote: > > pg_ivm | 1.10 | pg_catalog > > plpgsql | 1.0 | pg_catalog. > > > 2) show search_path; > "$user" public. > 3) \df *.create_immv > pgivm | create_immv | bigint | text, text | func. > Provide the outputs from the above three commands in your re

Re: create_immv issue on aws Ubuntu even after create extention

On 3/2/25 07:54, David G. Johnston wrote: On Saturday, March 1, 2025, Krishnakant Mane wrote: pg_ivm | 1.10 | pg_catalog plpgsql | 1.0 | pg_catalog. 2) show search_path; "$user" public. 3) \df *.create_immv pgivm | create_immv | bigint | text, text | func. Prov

Re: create_immv issue on aws Ubuntu even after create extention

On 3/2/25 07:54, David G. Johnston wrote: On Saturday, March 1, 2025, Krishnakant Mane wrote: pg_ivm | 1.10 | pg_catalog plpgsql | 1.0 | pg_catalog. 2) show search_path; "$user" public. 3) \df *.create_immv pgivm | create_immv | bigint | text, text | func. Prov

Re: create_immv issue on aws Ubuntu even after create extention

On Saturday, March 1, 2025, Krishnakant Mane wrote: > > Can you tell me how exactly should the syntax be? > https://www.postgresql.org/docs/current/ddl-schemas.html > Is my function definition wrong? > It isn’t a function definition, it is a function call. David J.

Re: create_immv issue on aws Ubuntu even after create extention

On 2/28/25 21:29, Krishnakant Mane wrote: All done, but no result. I feel it is possible that the latest code must be flawed or something. Well, as a matter of fact, I never had to compile the extention on my local ubuntu 24.04 machine. How did you install Postgres on the AWS EC2 instance?

Re: Please implement a catch-all error handler per row, for COPY

On 3/1/25 07:18, me nefcanto wrote: Hello All of these scenarios are such that data sanitation is difficult if not possible before doing the bulk operation (copy). I realized that when we specify `on_error ignore` it just handles a handful of errors. I thought this was a bug and sent an ema

Version compatibility

Hi, ALL, I have PostgreSQL version 13 and ODBC driver version 11 on my Gentoo box. Are they compatible? Can I still connect to the server? Thank you. P.S.: Sorry if the question belongs to DBC ML. it's hard to make a distinction...

Re: Please implement a catch-all error handler per row, for COPY

FYI the -bugs thread in question: https://www.postgresql.org/message-id/flat/CAEHBEOBCweDWGNHDaUk4%3D10HG0QXXJJAGXbEnFLMB30M%2BQw%2Bdg%40mail.gmail.com seems to imply the primary blocker was a unique constraint. Cheers, Greg -- Crunchy Data - https://www.crunchydata.com Enterprise Postgres Soft

Re: Please implement a catch-all error handler per row, for COPY

On Sat, Mar 1, 2025 at 9:20 AM Tom Lane wrote: > me nefcanto writes: > > Can you please provide a row-level catch-all handler for the copy > command? > > Very unlikely to happen. COPY is not intended as a general purpose > ETL mechanism, and we don't want to load it down with features that > wo

Re: Version compatibility

On 3/1/25 13:15, Igor Korot wrote: Hi, ALL, I have PostgreSQL version 13 and ODBC driver version 11 on my Gentoo box. Are they compatible? Can I still connect to the server? Have you tried to make a connection? Is there some sort of issue that prevents you from updating the ODBC driver on Ge

Re: create_immv issue on aws Ubuntu even after create extention

All done, but no result. I feel it is possible that the latest code must be flawed or something. Well, as a matter of fact, I never had to compile the extention on my local ubuntu 24.04 machine. I just did a create extention and it worked just fine. But on my aws server I had to compile it m

Please implement a catch-all error handler per row, for COPY

Hello Please consider these scenarios: - I want to create a million fake products, sometimes even 100 million (we're on MariaDB now and we plan to migrate to Postgres). My team uses fake data for performance tests and other use cases. - Another scenario is translations. Even in production, we hav

Re: Version compatibility

On 3/1/25 14:17, Igor Korot wrote: Reply to list also. Ccing list. Comments inline. Hi, Adrian, On Sat, Mar 1, 2025 at 11:23 AM Adrian Klaver > wrote: On 3/1/25 13:15, Igor Korot wrote: > Hi, ALL, > I have PostgreSQL version 13 and ODBC driver