Re: Postgresql database encryption

Hi, Vikas, On Fri, Apr 20, 2018 at 10:24 AM, Vikas Sharma wrote: > Hello Guys, > > Could someone throw light on the postgresql instance wide or database wide > encryption please? Is this possible in postgresql and been in use in > production?. > > This is a requirement in our production implement

Add schema to the query

Hi, ALL, Is there an easy way to add the schema to the following query: SELECT u.usename FROM pg_class c, pg_user u WHERE u.usesysid = c.relowner AND relname = ? Thank you.

Re: Add schema to the query

Hi, Melvin, On Sun, May 6, 2018 at 9:37 PM, Melvin Davidson wrote: > > > On Sun, May 6, 2018 at 10:33 PM, Melvin Davidson > wrote: >> >> >> >> On Sun, May 6, 2018 at 10:19 PM, Igor Korot wrote: >>> >>> Hi, ALL, >>> &g

Re: Add schema to the query

Rob, On Sun, May 6, 2018 at 11:54 PM, Rob Sargent wrote: > > >> On May 6, 2018, at 8:19 PM, Igor Korot wrote: >> >> Hi, ALL, >> >> Is there an easy way to add the schema to the following query: >> >> SELECT u.usename FROM pg_class c, pg_use

Reset the cursor to start from the record 1

Hi, ALL, I'd like to do the following: [code] PGresult res = PQprepare(); if( PQresultStatus( res ) != PGRES_COMMAND_OK ) { // error handling } else { PGresult res1 = PQexecPrepared(); status = PQresultStatus( res1 ); if( status != PGRES_COMMAND_OK && status != PGRES_TUPLES_OK ) {

Is there a way to be notified on the CREATE TABLE execution?

Hi, ALL, Consider a scenario: 1. A software that uses libpq is executing. 2. Someone opens up a terminal and creates a table. 3. A software needs to know about this new table. I presume this is a DBMS-specific... Thank you.

Re: Is there a way to be notified on the CREATE TABLE execution?

Hi, David, On Tue, Jun 19, 2018 at 5:13 PM, David G. Johnston wrote: > On Tuesday, June 19, 2018, Igor Korot wrote: >> >> Hi, ALL, >> Consider a scenario: >> >> 1. A software that uses libpq is executing. >> 2. Someone opens up a terminal and creates

Re: Is there a way to be notified on the CREATE TABLE execution?

On Wed, Jun 20, 2018 at 5:20 PM, Igor Korot wrote: >>> https://www.postgresql.org/docs/10/static/sql-createeventtrigger.html >>> Your scenario suggests you may wish to avail yourself of the Listen and >>> Notify commands as well. >> >> I did look at the Lis

Re: Is there a way to be notified on the CREATE TABLE execution?

Hi, Francisco, On Wed, Jun 20, 2018 at 12:22 PM, Francisco Olarte wrote: > Igor: > > On Wed, Jun 20, 2018 at 7:07 PM, Igor Korot wrote: >> Just one more question: >> This page https://www.postgresql.org/docs/current/static/xfunc-c.html#DFUNC >> does not reference >

How to watch for schema changes

Hi, ALL, Is there any trigger or some other means I can do on the server which will watch for CREATE/ALTER/DROP TABLE command and after successful execution of those will issue a NOTIFY statement? Thank you.

Re: How to watch for schema changes

Adrian, On Tue, Jul 3, 2018 at 12:32 PM, Adrian Klaver wrote: > On 07/03/2018 10:21 AM, Igor Korot wrote: >> >> Hi, ALL, >> Is there any trigger or some other means I can do on the server >> which will watch for CREATE/ALTER/DROP TABLE command and after successful

Re: How to watch for schema changes

Adrian, On Tue, Jul 3, 2018 at 1:24 PM, Adrian Klaver wrote: > On 07/03/2018 11:15 AM, Igor Korot wrote: >> >> Adrian, >> >> On Tue, Jul 3, 2018 at 12:32 PM, Adrian Klaver >> wrote: >>> >>> On 07/03/2018 10:21 AM, Igor Korot wrote: >>>

Re: How to watch for schema changes

Hi Melvin On Tue, Jul 3, 2018, 2:00 PM Melvin Davidson wrote: > > > >Unfortunately I'm stuck with 9.1. > > Have you thought about just setting *log_statement = 'ddl'* in > postgresql.conf > and just greping the log for CREATE and ALTER? > That going to be not that simple. I'm writing a clie

Re: How to watch for schema changes

Hi, Melvin, On Tue, Jul 3, 2018 at 6:48 PM, Melvin Davidson wrote: > >>I'm writing a client in C++ with libpq. So I will have to do a lot of >> polling . > Can't you just run a cron job? And what? As I said I'm writing the client application with libpq/ODBC. How will I get the results? Thank yo

Re: How to watch for schema changes

Hi, David, On Tue, Jul 3, 2018 at 1:46 PM, David G. Johnston wrote: > On Tue, Jul 3, 2018 at 11:41 AM, Igor Korot wrote: >> >> >> I presume threre is a query which check for the function/trigger >> existence? Something like: >> >> IF NOT EXIST(SEL

Re: How to watch for schema changes

David, On Thu, Jul 5, 2018 at 11:49 AM, David G. Johnston wrote: > On Thu, Jul 5, 2018 at 8:40 AM, Igor Korot wrote: >> >> Hi, David, >> >> On Tue, Jul 3, 2018 at 1:46 PM, David G. Johnston >> wrote: >> > On Tue, Jul 3, 2018 at 11:41 AM, Igor Korot wr

Re: How to watch for schema changes

Hi, Adrian On Tue, Jul 3, 2018 at 1:24 PM, Adrian Klaver wrote: > On 07/03/2018 11:15 AM, Igor Korot wrote: >> >> Adrian, >> >> On Tue, Jul 3, 2018 at 12:32 PM, Adrian Klaver >> wrote: >>> >>> On 07/03/2018 10:21 AM, Igor Korot wrote: >&g

Re: How to watch for schema changes

Hi, guys, On Mon, Jul 9, 2018 at 5:38 PM, Adrian Klaver wrote: > On 07/09/2018 01:49 PM, Igor Korot wrote: >> >> Hi, Adrian >> >> On Tue, Jul 3, 2018 at 1:24 PM, Adrian Klaver >> wrote: >>> >>> On 07/03/2018 11:15 AM, Igor Korot wrote: >>

Re: ODBC - Getting CONN ERROR: errmsg='The buffer was too small for the InfoValue'

,Hi, On Wed, Jul 11, 2018 at 10:33 PM, Edgard Battisti Guimarães wrote: > I've ported a powerbuilder application to postgresql. Tested ok on windows > 10 64, was installed on two win10-64 other computers, all connecting the > postgresql database in the localhost with access via odbc. The third o

Re: How to watch for schema changes

Hi, Adrian, On Wed, Jul 11, 2018 at 11:12 PM, Adrian Klaver wrote: > On 07/11/2018 08:46 PM, Igor Korot wrote: >> >> Hi, guys, >> >> >> On Mon, Jul 9, 2018 at 5:38 PM, Adrian Klaver >> wrote: >>> >>> On 07/09/2018 01:49 PM, Igor Korot

Re: How to watch for schema changes

Hi, On Thu, Jul 12, 2018 at 12:16 PM, David G. Johnston wrote: > On Thu, Jul 12, 2018 at 8:50 AM, Igor Korot wrote: >> >> > No, see: >> > >> > https://www.postgresql.org/docs/10/static/sql-createtrigger.html >> > >> > AFTER trigger on view

Re: How to watch for schema changes

Hi, On Thu, Jul 12, 2018 at 7:45 PM, Rob Sargent wrote: > >> [code] >> MyMac:/ igorkorot$ find . -name postgresql.conf >> find: ./.DocumentRevisions-V100: Permission denied >> find: ./.fseventsd: Permission denied >> find: ./.Spotlight-V100: Permission denied >> find: ./.Trashes: Permission deni

Problem building libpq

Hi, I recently updated my compiler going from MSVC 2010 to MSVC 2017. Now I'm trying to re-build the libpq with it. [code] NMAKE : fatal error U1064: MAKEFILE not found and no target specified Stop. C:\Program Files (x86)\Microsoft Visual Studio\2017\Community>cd c:\Users\Igor c:\Users\Igor>nmak

Re: PostgreSQL C Language Extension with C++ Code

Hi, On Sun, Aug 12, 2018 at 12:05 PM, TalGloz wrote: > Hi, > > I've searched information about my problem in the archives and on the > internet, but it didn't help. I have this small myfunc.cpp > > 1: #include > 2: #include > 3: #include > 4: #include > 5: #include > 6: #include

Re: How to watch for schema changes

Hi, Melvin, On Tue, Jul 3, 2018 at 2:00 PM Melvin Davidson wrote: > > > > >Unfortunately I'm stuck with 9.1. > > Have you thought about just setting log_statement = 'ddl' in postgresql.conf > and just greping the log for CREATE and ALTER? Is there a way to query a server for a place where the

Re: How to watch for schema changes

Hi, On Mon, Sep 17, 2018 at 9:19 PM Christophe Pettus wrote: > > > > On Sep 17, 2018, at 07:09, Igor Korot wrote: > > > > Is there a way to query a server for a place where the log file is? > > SHOW log_directory; > > It's either relative to the PGDA

Fwd: What is the problem with this code?

Does anybody have an idea why the code below fails? Thank you. -- Forwarded message - From: Igor Korot Date: Thu, Oct 18, 2018 at 11:49 PM Subject: What is the problem with this code? To: PostgreSQL ODBC list Hi, ALL, [code] std::wstring query1 = L"SHOW log_dire

Re: Query plan: SELECT vs INSERT from same select

Hi, On Tue, Jul 23, 2019 at 3:29 PM Alexander Voytsekhovskyy wrote: > > I have quite complicated query: > > SELECT axis_x1, axis_y1, SUM(delivery_price) as v_1 FROM ( > SELECT to_char(delivery_data.delivery_date, '-MM') as axis_x1, > clients.id_client as axis_y1, delivery_data.amount * prod

Re: Recomended front ends?

Hi, On Wed, Aug 7, 2019 at 1:57 PM stan wrote: > > I am in the process of defining an application for a very small company > that uses Postgresql for the backend DB. This DB will eventually run on a > hosted machine. As you imagine all of the employees have Windows machines > for their normal wor

Re: Recomended front ends?

Hi, On Wed, Aug 7, 2019 at 1:57 PM stan wrote: > > I am in the process of defining an application for a very small company > that uses Postgresql for the backend DB. This DB will eventually run on a > hosted machine. As you imagine all of the employees have Windows machines > for their normal wor

Re: Problems modifyiong view

Hi, On Thu, Nov 14, 2019 at 7:54 AM stan wrote: > > I am trying to add columns to a view using CREATE OR REPLACE VIEW, and I am > getting the following error: > > ERROR: cannot change name of view column "descrip" to "contact_person_1" > > I suppose I can drop the view, and recreate it, but tha

Re: Connecting Powerbuilder / EAserver to PostgreSQL server 11 via ODBC or JDBC

Hi, On Fri, Jun 26, 2020, 8:31 AM Matthias Apitz wrote: > > Hello, > > After the very successful migration of our Library Management System > (which uses ESQL/C, DBI, JDBC) together with PostgreSQL 11.4, we want to > do the > same with another LMS written in Powerbuild, running in an EAServer

Re: Need free PG odbc driver for Windows 10

Hi, On Tue, Jul 28, 2020 at 11:40 AM David Gauthier wrote: > > Hi: > > I need a free odbc driver for PG to be installed on Windows 10 that my user > community can easily install. By "easily install" I mean no binaries, no > zipped file, etc... just point-click-install (with the usual confirmat

How to write such a query

Hi, Consider following [code] CREATE TABLE X(id INTEGER PRIMARY KEY, field1 char(50), field2 int); CREATE TABLE Y(id INTEGER PRIMARY KEY, field1 char, field2 double(10, 2)); SELECT X.field1, Y.field2 from X, Y WHERE X.id = Y.id; [/code] Assuming that the SELECT return 10 rows, I want to update X.

Re: How to write such a query

Hi, Paul On Fri, Sep 18, 2020 at 12:34 PM Paul Förster wrote: > > Hi Igor, > > > On 18. Sep, 2020, at 19:29, Igor Korot wrote: > > > > Hi, > > Consider following > > > > [code] > > CREATE TABLE X(id INTEGER PRIMARY KEY, field1 char(50), fie

Re: How to write such a query

gic? Thank you. > - Jon > > <https://www.linkedin.com/in/jonstrong/> > <https://www.jonathanrstrong.com> > > *Jonathan Strong* > > CIO / CTO / Consultant > > *P:* 609-532-1715 *E:* jonathanrstr...@gmail.com > > *Quora Top Writer <https://www.quora

Re: How to write such a query

Hi, Adrian, On Fri, Sep 18, 2020 at 12:58 PM Adrian Klaver wrote: > > On 9/18/20 10:46 AM, Igor Korot wrote: > > Hi, Johnathan, > > > > On Fri, Sep 18, 2020 at 12:34 PM Jonathan Strong > > mailto:jonathanrstr...@gmail.com>> wrote: > > > > Ar

Re: How to write such a query

Hi, Ken, On Fri, Sep 18, 2020 at 2:46 PM Ken Tanzer wrote: > > How to find what the primary key (or UNIQUE identifier) value is >> > for row 5 in the recordset? >> >> You're missing the point: as mentioned before, there is no "row 5". To >> update the 5th record that you've fetched, you incremen

Re: How to write such a query

Ken, On Fri, Sep 18, 2020 at 3:35 PM Ken Tanzer wrote: > On Fri, Sep 18, 2020 at 1:26 PM Ron wrote: > >> On 9/18/20 3:18 PM, Igor Korot wrote: >> > Thank you for the info. >> My problem is that I want to emulate Access behavior. >> >> As I said - Ac

Can't query system tables during transaction

Hi, ALL, I'm trying to execute following: SELECT 1 FROM pg_class c, pg_namespace n WHERE n.oid = c.relnamespace AND c.relname = 'foo' AND n.nspname = public; inside the transaction. I'm getting the following error: ERROR: current transaction is aborted, commands ignored until end of transactio

Re: Can't query system tables during transaction

Hi, On Sun, Oct 4, 2020 at 3:30 PM Tom Lane wrote: > > Igor Korot writes: > > I'm trying to execute following: > > > SELECT 1 FROM pg_class c, pg_namespace n WHERE n.oid = c.relnamespace > > AND c.relname = 'foo' AND n.nspname = public; > > I sup

Failed to compile libpq

Hi, ALL, I just tried to compile libpq on latest Solaris x86 (12.4) with Solaris compiler (Sollaris Studio) version 12.6. Configure succeeded, but running "make" failed with [quote] make: Fatal error in reader ../../../src/Makefile.global, line 45: Unexpected end of line seen [/quote] Is there a

Re: Failed to compile libpq

Tom et al, On Thu, Oct 15, 2020 at 12:01 AM Tom Lane wrote: > > Igor Korot writes: > > Configure succeeded, but running "make" failed with > > > [quote] > > make: Fatal error in reader ../../../src/Makefile.global, line 45: > > Unexpected end of

Re: Failed to compile libpq

Tom, On Thu, Oct 15, 2020 at 12:16 AM Tom Lane wrote: > > Igor Korot writes: > > On Thu, Oct 15, 2020 at 12:01 AM Tom Lane wrote: > >> Kinda looks like you're using some non-GNU make. > > > Correct. > > It is from Solaris Studio compiler. > > &g

Attaching database

Hi, IIUC, PostgreSQL does not support attaching a database to an existing connection. However I was told that I can use this: https://www.postgresql.org/docs/9.3/postgres-fdw.html. Is it the same thing? Why there is no simple ATTACH AS ? Thank you.

Re: Attaching database

Hi, Pavel, On Mon, Oct 19, 2020 at 12:51 PM Pavel Stehule wrote: > > Hi > > po 19. 10. 2020 v 19:40 odesílatel Igor Korot napsal: >> >> Hi, >> IIUC, PostgreSQL does not support attaching a database to an existing >> connection. >> Howeve

Building for 64-bit platform

Hi, I build libpq with the standard configure/dmake. Now I realize I need t build it for a 64-bit platform. My questions are: Is it enough to ust do [code] cd libpq CFLAGS="-m64" LDFLAGS="-m64" ./configure dmake [/code] or I have to do: [code] dmake clean [/code] ? 2. Is my configure line abo

Re: Building for 64-bit platform

Thx. On Sun, Nov 8, 2020 at 12:15 AM Tom Lane wrote: > > Igor Korot writes: > > I build libpq with the standard configure/dmake. > > Now I realize I need t build it for a 64-bit platform. > > > My questions are: > > Is it enough to ust do > > Do &qu

Different bitness

Hi, ALL, [code] CC -m64 -std=c++11 -o dist/Debug/OracleDeveloperStudio-Solaris-x86/liblibpostgres.so build/Debug/OracleDeveloperStudio-Solaris-x86/database_postgres.o -L../postgresql/src/interfaces/libpq -lpq -m64 -std=c++11 -G -KPIC -norunpath -h liblibpostgres.so ld: fatal: file ../postgresql

Re: Different bitness

Thx, Tom. On Sun, Nov 8, 2020 at 2:21 PM Tom Lane wrote: > > Igor Korot writes: > > ld: fatal: file ../postgresql/src/interfaces/libpq/libpq.so: wrong ELF > > class: ELFCLASS32 > > That path doesn't seem to quite agree with this one: > > > igor@solaris:~/d

Re: copy command - something not found

Hi You could try to do "set +x" before running the script... Thank you. On Tue, Dec 29, 2020, 2:23 PM David G. Johnston wrote: > On Tue, Dec 29, 2020 at 1:01 PM Susan Hurst < > susan.hu...@brookhurstdata.com> wrote: > >> Actually, the -c was in an example of a copy command that I found while >

Get the table creation DDL

Hi, Is there a query I can execute that will give me CREATE TABLE() command used to create a table? Thank you.

Re: Get the table creation DDL

Hi, Michael, On Sun, Jul 10, 2022 at 11:13 AM Michael Nolan wrote: > > > > On Sun, Jul 10, 2022 at 10:28 AM Igor Korot wrote: >> >> Hi, >> Is there a query I can execute that will give me CREATE TABLE() command >> used to create a table? So there is no &q

Re: Get the table creation DDL

Hi, On Sun, Jul 10, 2022 at 11:47 AM Igor Korot wrote: > > Hi, Michael, > > On Sun, Jul 10, 2022 at 11:13 AM Michael Nolan wrote: > > > > > > > > On Sun, Jul 10, 2022 at 10:28 AM Igor Korot wrote: > >> > >> Hi, > >> Is there

Re: Get the table creation DDL

Hi, On Sun, Jul 10, 2022 at 12:47 PM Ray O'Donnell wrote: > > On 10/07/2022 17:47, Igor Korot wrote: > > Hi, Michael, > > > > On Sun, Jul 10, 2022 at 11:13 AM Michael Nolan wrote: > >> > >> > >> > >> On Sun, Jul 10, 2022 at 10:

Re: Get the table creation DDL

Hi, On Sun, Jul 10, 2022 at 2:27 PM Mladen Gogala wrote: > > On 7/10/22 12:47, Igor Korot wrote: > > So there is no "query" per se? > Also how do I pass the table name? > > Thank you. > > You can create one from the catalog tables. Personally, I would use &

Re: Get the table creation DDL

Hi, On Sun, Jul 10, 2022 at 7:02 PM Mladen Gogala wrote: > > On 7/10/22 17:00, Igor Korot wrote: > > I understand. > The Problem is that I need to put this inside the C/ODBC interface for > my project. > > I'm sure it is not a problem when people are working out of p

Re: Get the table creation DDL

Hi, On Sun, Jul 10, 2022 at 8:09 PM Rob Sargent wrote: > > > > > On Jul 10, 2022, at 6:16 PM, Igor Korot wrote: > > > > Hi, > > > >> On Sun, Jul 10, 2022 at 7:02 PM Mladen Gogala > >> wrote: > >> > >> On 7/10/22 17:00, Igor

Re: Get the table creation DDL

Hi, On Sun, Jul 10, 2022 at 8:14 PM Mladen Gogala wrote: > > On 7/10/22 21:13, Igor Korot wrote: > > How should I do that? > > Thank you. > > Oh boy! I give up. Does he mean I need to make it as a GitHub module? Can I even do that given that you use GitLab and my proj

Re: Get the table creation DDL

Hi, On Mon, Jul 11, 2022 at 7:56 AM Rob Sargent wrote: > > On 7/11/22 06:31, Mladen Gogala wrote: > > On 7/10/22 22:52, Rob Sargent wrote: > >> Are you alone or on a team? No, this is my personal project. Thank you. > > > > What are your pronouns? > > > This did make me chuckle, but no I am ju

Getting the table ID

Hi, guys, In the database theory each table is identified as "schema_name"."table_name". When I tried to look at how to get the table id inside the PostgreSQL, I saw that I needed to look at the pg_class table. SELECT oid FROM pg_class WHERE relname = "table_name"; However that query will give

Re: Getting the table ID

Hi, guys, On Tue, Jul 19, 2022 at 4:42 AM Walter Dörwald wrote: > > On 19 Jul 2022, at 5:10, Igor Korot wrote: > > Hi, guys, > > In the database theory each table is identified as "schema_name"."table_name". > > When I tried to look at how to get the

Logging the query executed on the server

Hi, Is it possible to log the query that will be executed on the server? I'm writing an application that connects to the server through ODBC and libpq. For some reason ODBC interface is failing - it desn't return any rows So I'm thinking if I have a proof that the query I am actually executing is

Re: Logging the query executed on the server

logfile with: > > b2bcreditonline=# select pg_current_logfile(); > pg_current_logfile > > /log/pg.csv 2 things: 1. How do I turn this off? ;-) 2. The log does show the query but it shows it with the placeholders. Is there a way to see the actual query? Thank you

Is ODBC list still alive?

Thank you.

Is ODBC list dead?

Hi, If the list IS dead - where can I get help on the topic... Thank you.

Is there Postgres ODBC binary for OSX?

Hi, ALL, Is building it myself the only option? Thank you.

Re: Is there Postgres ODBC binary for OSX?

Hi, On Fri, Sep 30, 2022 at 10:41 AM Daniel Gustafsson wrote: > > > On 30 Sep 2022, at 17:36, Igor Korot wrote: > > > Is building it myself the only option? > > A quick googling indicates that there are options in the macOS package > managers: > >

Re: Attaching database

Hi, guys, On Sun, Oct 25, 2020 at 1:27 PM Peter J. Holzer wrote: > > On 2020-10-19 20:21:05 +0200, Pavel Stehule wrote: > > po 19. 10. 2020 v 20:18 odesílatel Igor Korot napsal: > > On Mon, Oct 19, 2020 at 12:51 PM Pavel Stehule > > wrote: > >

Re: Attaching database

Hi, David et al, On Fri, Oct 14, 2022 at 11:39 PM David G. Johnston wrote: > > On Fri, Oct 14, 2022 at 9:17 PM Igor Korot wrote: >> >> Hi, guys, >> >> On Sun, Oct 25, 2020 at 1:27 PM Peter J. Holzer wrote: >> > >> > On 2020-10-19 20:21:05 +0200,

Re: Attaching database

Hi, Adrian, On Sat, Oct 15, 2022, 10:51 AM Adrian Klaver wrote: > On 10/15/22 08:20, Adrian Klaver wrote: > > On 10/14/22 21:46, Igor Korot wrote: > > > > > >> Making catalog current means switching between DBs. > >> Remember initially I connected to (fi

Re: Attaching database

; > Regards, > > On 10/15/22 02:06, Julien Rouhaud wrote: > > Hi, > > > > On Fri, Oct 14, 2022 at 11:16:44PM -0500, Igor Korot wrote: > >> Sorry for resurrecting this old thread... > >> If an attaching the DB creates new connection which will be cmpletely >

List user databases

Hi, ALL, According to https://chartio.com/resources/tutorials/how-to-list-databases-and-tables-in-postgresql-using-psql/, there are generally 3 system DBs. However I'm confused with the word general. How many system databases can be made on a PG server? Thank you.

Printf-like function

Hi, ALL, Is there a printf-lilke function inside libpq that can be used to create a proper query string with the proper quoting of the literal? Or I will need to use sprintf()? Thank you.

Re: Printf-like function

Thank you. On Fri, Nov 11, 2022 at 11:12 PM Tom Lane wrote: > > Igor Korot writes: > > Is there a printf-lilke function inside libpq that can be used > > to create a proper query string with the proper quoting of the > > literal? > > No. You'd be better off

Get table catalog from pg_indexes

Hi, ALL, Table pg_indexes does not contain a field for a catalog. So how do I get that? SELECT 1 FROM pg_indexes WHERE indexname = $1 AND tablename = $2 AND schemaname = $3 Thank you.

Re: Get table catalog from pg_indexes

Hi, Erik, On Sun, Nov 27, 2022 at 11:59 AM Erik Wienhold wrote: > > > On 27/11/2022 18:22 CET Igor Korot wrote: > > > > Table pg_indexes does not contain a field for a catalog. > > > > So how do I get that? > > > > SELECT 1 FROM pg_indexe

Re: Get table catalog from pg_indexes

Hi, Christopher, On Sun, Nov 27, 2022 at 12:45 PM Christophe Pettus wrote: > > > > > On Nov 27, 2022, at 10:42, Igor Korot wrote: > > > > It doesn't say anything about "current" DB - only the DB. > > In PostgreSQL terminology, a single Postgr

Re: Get table catalog from pg_indexes

Thx, Adrian. On Sun, Nov 27, 2022 at 3:56 PM Adrian Klaver wrote: > > On 11/27/22 13:31, Ron wrote: > > On 11/27/22 11:22, Igor Korot wrote: > >> Hi, ALL, > >> Table pg_indexes does not contain a field for a catalog. > >> > >> So how do I ge

Re: Get table catalog from pg_indexes

David, On Sun, Nov 27, 2022 at 12:55 PM David G. Johnston wrote: > > On Sun, Nov 27, 2022 at 11:42 AM Igor Korot wrote: >> >> >> It doesn't say anything about "current" DB - only the DB. > > > Yes, but you must be connected to some database in

Re: Get table catalog from pg_indexes

Ron, On Sun, Nov 27, 2022 at 4:10 PM Ron wrote: > > On 11/27/22 15:55, Adrian Klaver wrote: > > On 11/27/22 13:31, Ron wrote: > >> On 11/27/22 11:22, Igor Korot wrote: > >>> Hi, ALL, > >>> Table pg_indexes does not contain a field fo

Fwd: Log file

I initially sent this to the ODBC list.' Thank you for any suggestions. -- Forwarded message - From: Igor Korot Date: Sun, Oct 28, 2018 at 11:03 PM Subject: Log file To: PostgreSQL ODBC list Hi, ALL, I'm trying to test the functionality of logging on my olde

Re: Fwd: Log file

Hi, Tom, On Mon, Oct 29, 2018 at 1:56 PM Tom Lane wrote: > > Igor Korot writes: > > I'm trying to test the functionality of logging on my older Mac with > > PostgreSQL 9.1. > > I see that the logile is created with the owner of postgres and the > > group of

Re: Fwd: Log file

Hi, Tom, On Mon, Oct 29, 2018 at 5:08 PM Tom Lane wrote: > > Igor Korot writes: > > On Mon, Oct 29, 2018 at 1:56 PM Tom Lane wrote: > >> You can set up the log files as readable by the OS group of the server > >> (see log_file_mode), and then grant membership in t

Re: Fwd: Log file

Now is there a command to flush the log - delete the content of it? All I'm looking for in the log are DDL commands - CREATE/ALTER/DELETE ones. On Wed, Oct 31, 2018 at 12:32 AM Igor Korot wrote: > > Hi, Tom, > > On Mon, Oct 29, 2018 at 5:08 PM Tom Lane wrote: > >

Re: Fwd: Log file

Hi, guys, For some reason this reply was in my "Spam" folder (gmail service). I guess moving to the new mailer service is not completely safe for "Spam". So replying now - apologies to be late. On Wed, Oct 31, 2018 at 2:00 AM Laurenz Albe wrote: > > Igor Korot wrote:

Re: How to watch for schema changes

Hi, Adrian, Sorry for the delay to come back to this. I was busy doing other things. On Tue, Jul 3, 2018 at 12:32 PM Adrian Klaver wrote: > > On 07/03/2018 10:21 AM, Igor Korot wrote: > > Hi, ALL, > > Is there any trigger or some other means I can do on the server > > whi

Re: How to watch for schema changes

Hi, Adrian, On Mon, Dec 3, 2018 at 9:17 AM Adrian Klaver wrote: > > On 12/2/18 5:24 AM, Igor Korot wrote: > > Hi, Adrian, > > Sorry for the delay to come back to this. I was busy doing other things. > > > > On Tue, Jul 3, 2018 at 12:32 PM Adrian Klaver > >

Re: How to watch for schema changes

On Mon, Dec 3, 2018 at 11:29 AM Adrian Klaver wrote: > > On 12/3/18 8:16 AM, Igor Korot wrote: > > Hi, Adrian, > > > > On Mon, Dec 3, 2018 at 9:17 AM Adrian Klaver > > wrote: > >> > >> On 12/2/18 5:24 AM, Igor Korot wrote: > >>> Hi, A

Re: How to watch for schema changes

Hi, Adrian, On Mon, Dec 3, 2018 at 11:59 AM Adrian Klaver wrote: > > On 12/3/18 9:53 AM, Igor Korot wrote: > >> So event triggers are associated with > >> events(www.postgresql.org/docs/9.6/event-trigger-matrix.html) in a > >> particular database. A rough descrip

Re: How to watch for schema changes

Hi, Adrian, On Mon, Dec 3, 2018 at 4:10 PM Adrian Klaver wrote: > > On 12/3/18 1:53 PM, Igor Korot wrote: > > Hi, Adrian, > > >> Why? Just create the trigger once in a script. Event triggers are an > >> attribute of the database and stay with it until they are

Re: How to watch for schema changes

Hi, Adrian, On Mon, Dec 3, 2018 at 5:15 PM Adrian Klaver wrote: > > On 12/3/18 3:00 PM, Igor Korot wrote: > > Hi, Adrian, > > > > On Mon, Dec 3, 2018 at 4:10 PM Adrian Klaver > > wrote: > >> > >> On 12/3/18 1:53 PM, Igor Korot wrote: > >&

Re: How to watch for schema changes

Igor, On Tue, Dec 4, 2018 at 8:20 AM Igor Neyman wrote: > > > -Original Message- > From: Igor Korot [mailto:ikoro...@gmail.com] > Sent: Monday, December 03, 2018 8:29 AM > To: Adrian Klaver > Cc: pgsql-general > Subject: Re: How to

IF NOT EXIST

Hi, ALL, I have a following statement: IF NOT EXIST( SELECT 1 SELECT 1 FROM pg_proc AS proc, pg_namespace AS ns ) CREATE FUNCTION(); Unfortunately trying to execute it thru the ODBC interface with: ret = SQLExecDirect( m_hstmt, query, SQL_NTS ); gives syntax error near IF. What is the proper w

NOTIFY/LISTEN with ODBC interface

Hi, Is there a way to write a code found at https://www.postgresql.org/docs/9.1/libpq-example.html Example 2 with the ODBC interface? Thank you.

Re: NOTIFY/LISTEN with ODBC interface

hat can retrieve this. So can this be done with ODBC interface, and if yes - how? Thank you. > > -----Original Message- > From: Igor Korot > Sent: Sunday, December 23, 2018 9:37 PM > To: PostgreSQL ODBC list ; pgsql-general > > Subject: NOTIFY/LISTEN with ODBC int

Re: NOTIFY/LISTEN with ODBC interface

Hi, Clemens, et al, On Tue, Dec 25, 2018 at 12:23 AM Clemens Ladisch wrote: > > Igor Korot wrote: > >Is there a way to write [LISTEN/NOTIFY] with the ODBC interface? > > At the moment, no. > > ODBC is a standard interface, so there are no functions for this defined. >

Error on Windows

Hi, ALL, The following code compiles and executes but returns an error: [quote] Invalid byte sequence for encoding UTF8 [/quote] [code] char *values[2]; values[0] = NULL, values[1] = NULL; values[0] = new char[schemaName.length() + 1]; values[1] = new char[tableName.length() + 1];

libpq bug?

Hi, ALL, Following code: int PostgresDatabase::GetTableOwner (const std::wstring &schemaName, const std::wstring &tableName, std::wstring &owner, std::vector &errorMsg) { int result = 0; std::wstring query = L"SELECT u.usename FROM pg_class c, pg_user u, pg_namespace n WHERE n.oid = c.relna

Re: libpq bug?

Hi, On Fri, Dec 28, 2018 at 4:51 PM patrick keshishian wrote: > > > On Fri, Dec 28, 2018 at 2:00 PM Igor Korot wrote: >> >> Hi, ALL, >> Following code: >> >> int PostgresDatabase::GetTableOwner (const std::wstring &schemaName, >> const std

  1   2   3   >