Re: How to properly fix memory leak

David et al, On Fri, Apr 25, 2025 at 10:48 PM David G. Johnston wrote: > > On Friday, April 25, 2025, Igor Korot wrote: >> >> >> for( int i = 0; i < PQntuples( res ); i++ ) >> { >> auto temp1 = m_pimpl->m_m

Re: How to get the data from the query

|7 | NO benchplayers | integer | | |32 | 2 | 0 | YES | |8 | NO (8 rows) lines 1-12/12 (END) Thank you. On Sat, Apr 26, 2025 at 8:06 PM David G. Johnston wrote: > > On Saturday, April 26, 2025, I

Re: How to get the data from the query

0 | YES | |8 (8 rows) [/code] Thank you. On Sat, Apr 26, 2025 at 8:06 PM David G. Johnston wrote: > > On Saturday, April 26, 2025, Igor Korot wrote: >> >> but the size comes out "" (empty) >> > > What is the value you are expect

Re: How to get the data from the query

Hi, David, On Sat, Apr 26, 2025 at 8:06 PM David G. Johnston wrote: > > On Saturday, April 26, 2025, Igor Korot wrote: >> >> but the size comes out "" (empty) >> > > What is the value you are expecting? Expecting to have "100". What is the m

How to get the data from the query

Hi, ALL, [code] std::wstring query2 = L"SELECT DISTINCT column_name, data_type, character_maximum_length, character_octet_length, numeric_precision, numeric_precision_radix, numeric_scale, is_nullable, column_default, CASE WHEN column_name IN (SELECT ccu.column_name FROM information_schema.con

Re: How to properly fix memory leak

Hi, Tom, On Sat, Apr 26, 2025 at 4:34 PM Tom Lane wrote: > Igor Korot writes: > >>>> auto temp1 = m_pimpl->m_myconv.from_bytes( PQgetvalue( > >>>> res, i, 1 ) ); > >>>> m_tablespaces.push

Re: How to properly fix memory leak

Hi, Lauren’s, On Sat, Apr 26, 2025 at 3:30 PM Laurenz Albe wrote: > On Fri, 2025-04-25 at 22:24 -0500, Igor Korot wrote: > > Hi, ALL, > > > > [code] > > auto res = PQexec( m_db, m_pimpl->m_myconv.to_bytes( query.c_str() > > ).c_str() ); /*

Re: How to properly fix memory leak

Hi, David, On Fri, Apr 25, 2025 at 11:55 PM David G. Johnston wrote: > > On Friday, April 25, 2025, Igor Korot wrote: >> >> >> And the error case was handled correctly, right? > > > Seems like answering that requires knowing what the query is or can be. I &

Re: How to properly fix memory leak

Hi, David, On Fri, Apr 25, 2025 at 10:48 PM David G. Johnston wrote: > > On Friday, April 25, 2025, Igor Korot wrote: >> >> >> for( int i = 0; i < PQntuples( res ); i++ ) >> { >> auto temp1 = m_pimpl->m_m

How to properly fix memory leak

Hi, ALL, [code] auto res = PQexec( m_db, m_pimpl->m_myconv.to_bytes( query.c_str() ).c_str() ); /* ask for binary results */ if( PQresultStatus( res ) != PGRES_TUPLES_OK ) { auto err = m_pimpl->m_myconv.from_bytes( PQerrorMessage( m_db ) ); errorMsg.push_back( L"Up

Re: Another documentation issue

Hi, David, On Thu, Apr 24, 2025 at 12:23 AM David G. Johnston wrote: > > On Wednesday, April 23, 2025, Igor Korot wrote: >> >> >> How do you handle sch situation from the client POV? > > > Get the current value. If it’s non-zero the system definitely supports

Re: Another documentation issue

Hi, Laurenz, On Wed, Apr 23, 2025 at 2:16 AM Laurenz Albe wrote: > > On Wed, 2025-04-23 at 00:21 -0500, Igor Korot wrote: > > On the page > > https://www.postgresql.org/docs/current/runtime-config-query.html#GUC-SEQ-PAGE-COST > > > > it is only given the d

Re: Another documentation issue

Tom, On Wed, Apr 23, 2025 at 1:40 PM Tom Lane wrote: > > Igor Korot writes: > > On Wed, Apr 23, 2025 at 1:28 PM Tom Lane wrote: > >> If we do anything about this, I'd just say "systems that have > >> posix_fadvise()". If we write something more

Re: Another documentation issue

Tom, On Wed, Apr 23, 2025 at 1:40 PM Tom Lane wrote: > Igor Korot writes: > > On Wed, Apr 23, 2025 at 1:28 PM Tom Lane wrote: > >> If we do anything about this, I'd just say "systems that have > >> posix_fadvise()". If we write something more specifi

Re: Another documentation issue

Hi, Tom, On Wed, Apr 23, 2025 at 1:28 PM Tom Lane wrote: > Daniel Gustafsson writes: > >> On 23 Apr 2025, at 09:16, Laurenz Albe > wrote: > >> On Wed, 2025-04-23 at 00:21 -0500, Igor Korot wrote: > >>> No explanation of what is "supported system"

Another documentation issue

Hi, ALL, On the page https://www.postgresql.org/docs/current/runtime-config-query.html#GUC-SEQ-PAGE-COST it is only given the default value of this parameter. No min/max values are provided.. The same can be sad about https://www.postgresql.org/docs/current/runtime-config-query.html#GUC-RANDOM

Re: Clarification on the docs

David, On Sat, Apr 19, 2025, 7:21 PM David G. Johnston wrote: > On Sat, Apr 19, 2025 at 4:17 PM Igor Korot wrote: > >> >> Could you indicate the default value for every option here? >> >>> >>> > The descriptions clearly indicate the defaults for n

Re: Clarification on the docs

Hi, Dvid, On Fri, Apr 11, 2025, 9:04 PM David G. Johnston wrote: > On Fri, Apr 11, 2025 at 6:49 PM Igor Korot wrote: > >> Hi, ALL, >> On the >> https://www.postgresql.org/docs/17/sql-createindex.html#SQL-CREATEINDEX-STORAGE-PARAMETERS >> its said: >> &g

Fwd: Identify system databases

-- Forwarded message - From: Igor Korot Date: Tue, Apr 15, 2025 at 11:16 AM Subject: Re: Identify system databases To: Adrian Klaver Hi, Adrian, On Tue, Apr 15, 2025 at 10:07 AM Adrian Klaver wrote: > On 4/15/25 07:48, Igor Korot wrote: > > Hi, ALL, > > Is t

Fwd: Identify system databases

-- Forwarded message - From: Igor Korot Date: Tue, Apr 15, 2025 at 11:15 AM Subject: Re: Identify system databases To: David G. Johnston Hi, David, On Tue, Apr 15, 2025 at 9:56 AM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Tuesday, April 15, 2025, I

Identify system databases

Hi, ALL, Is there a field in the pg_databases table which indicates that particular DB is a system one? Or it can be determined ony by name? Thank you.

Re: Clarification on the docs

Hi, David, On Fri, Apr 11, 2025 at 9:04 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Fri, Apr 11, 2025 at 6:49 PM Igor Korot wrote: > >> Hi, ALL, >> On the >> https://www.postgresql.org/docs/17/sql-createindex.html#SQL-CREATEINDEX-STORAGE-PARAME

Clarification on the docs

Hi, ALL, On the https://www.postgresql.org/docs/17/sql-createindex.html#SQL-CREATEINDEX-STORAGE-PARAMETERS its said: [quote] The optional WITH clause specifies storage parameters for the index. Each index method has its own set of allowed storage parameters. The B-tree, hash, GiST and SP-GiST ind

Re: Determine server version from psql script

wrong? Thank you. On Sun, Mar 23, 2025 at 12:53 PM David G. Johnston wrote: > > On Sunday, March 23, 2025, David G. Johnston > wrote: >> >> On Sunday, March 23, 2025, Igor Korot wrote: >>> >>> >>> 2. Is there a way to do CREATE TRIGGER IF NOT EXIST

Re: Determine server version from psql script

Hi, Tom, On Sat, Mar 22, 2025, 10:01 PM Tom Lane wrote: > Igor Korot writes: > > On Sat, Mar 22, 2025, 8:58 PM David G. Johnston < > david.g.johns...@gmail.com> > > wrote: > >> Then read the psql docs. Your version has \if and you’ll find server > >&

Re: Determine server version from psql script

ON playersinleague WHEN new.curren... ^ [/code] What is the problem niw? Thank you. On Sun, Mar 23, 2025 at 2:27 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > > On Sunday, March 23, 2025, Pavel Stehule wrote: >> >> Hi >> >> ne 23. 3

Re: Determine server version from psql script

Hi, David, On Sat, Mar 22, 2025, 8:58 PM David G. Johnston wrote: > On Saturday, March 22, 2025, Igor Korot wrote: > >> >> >>> Is it actually running in psql? >>> >> >> Yes, i run "psql - d draft -a -f >> > > Then read the

Re: Determine server version from psql script

Hi, Adrian, On Sat, Mar 22, 2025, 7:42 PM Adrian Klaver wrote: > On 3/22/25 17:31, Igor Korot wrote: > > Hi, All, > > I have a big script that populated the DB for me. > > The language used for the script? > What do you mean? Its just a text file with bunch of create

Determine server version from psql script

Hi, All, I have a big script that populated the DB for me. I made it based on the latest available version. However, i have version 13 installed on my Linux box and so trying to execute "CREATE OR REPLACE TRIGGER..." will fail. Is there a way to determine the server version from such a script?

Big script execution

Hi, ALL, I am trying to execute a huge script (~40K lines) that will populate my database. The script starts with "BEGIN TRANSACTION" and will end with "COMMIT". however I'd like to rollback if there is an error encounter. When I execute it from the Terminal I do use -v ON_ERROR_STOP=1 but I'd

Re: Big script execution

Hi, Laurenz, On Mon, Mar 10, 2025, 11:31 AM Laurenz Albe wrote: > On Mon, 2025-03-10 at 16:42 -0500, Igor Korot wrote: > > I am trying to execute a huge script (~40K lines) that will populate > > my database. > > > > The script starts with "BEGIN TRANSACTIO

Re: Big script execution

Thank you! On Mon, Mar 10, 2025, 11:37 AM Christophe Pettus wrote: > > > > On Mar 10, 2025, at 09:35, Igor Korot wrote: > > > > Will the tables also be deleted? > > The CREATE TABLE statements are part of this big transaction. > > Yes. DDL is transactional in PostgreSQL just like DML. >

Re: Error on query execution

H, On Tue, Mar 4, 2025 at 8:37 PM Tom Lane wrote: > > Igor Korot writes: > > binaryIntVal = htonl( (uint32_t) type ); > > paramValues[0] = (char *) &binaryIntVal; > > paramLengths[0] = sizeof( binaryIntVal ); > > paramFormats[0] = 1; > &g

Re: Quesion about querying distributed databases

Hi, On Thu, Mar 6, 2025, 7:32 AM Greg Sabino Mullane wrote: > On Wed, Mar 5, 2025 at 9:44 PM me nefcanto wrote: > >> Anyway, that's why I asked you guys. However, encouraging me to go back >> to monolith without giving solutions on how to scale, is not helping. >> > > We did. In addition to the

Re: Quesion about querying distributed databases

r example, creating all databases and tables and database objects > on MariaDB takes more than 400 seconds, while the same took 80 seconds on > Postgres. So amazing performance on DDL. > Also, 1 million records in bulk insertion take almost one-sixth to > on-fourth of the time on MariaDB.

Re: Quesion about querying distributed databases

Hi, On Wed, Mar 5, 2025, 8:44 PM me nefcanto wrote: > I once worked with a monolithic SQL Server database with more than 10 > billion records and about 8 Terabytes of data. A single backup took us more > than 21 days. It was a nightmare. Almost everybody knows that scaling up > has a ceiling, bu

Re: Error on query execution

Tom, On Tue, Mar 4, 2025, 8:37 PM Tom Lane wrote: > Igor Korot writes: > > binaryIntVal = htonl( (uint32_t) type ); > > paramValues[0] = (char *) &binaryIntVal; > > paramLengths[0] = sizeof( binaryIntVal ); > > paramFormats[0] = 1; > >

Re: Error on query execution

Hi, Tom, On Tue, Mar 4, 2025 at 8:37 PM Tom Lane wrote: > > Igor Korot writes: > > binaryIntVal = htonl( (uint32_t) type ); > > paramValues[0] = (char *) &binaryIntVal; > > paramLengths[0] = sizeof( binaryIntVal ); > > paramFormats[0] = 1; &g

Error on query execution

Hi, ALL, [code] type = 80; uint32_t binaryIntVal; const char *paramValues[1]; int paramLengths[1]; int paramFormats[1]; binaryIntVal = htonl( (uint32_t) type ); paramValues[0] = (char *) &binaryIntVal; paramLengths[0] = sizeof( binaryIntVal ); paramFormats[0] = 1

Re: Messages o Terminal

Please ignore my previous message Works like a charm. Thank you. On Tue, Mar 4, 2025 at 7:13 PM Adrian Klaver wrote: > > On 3/4/25 22:28, Igor Korot wrote: > > Hi, ALL, > > I'm trying to execute: > > > > [code] > > queries.push_back( L&quo

Re: Messages o Terminal

Adran, On Tue, Mar 4, 2025 at 7:13 PM Adrian Klaver wrote: > > On 3/4/25 22:28, Igor Korot wrote: > > Hi, ALL, > > I'm trying to execute: > > > > [code] > > queries.push_back( L"CREATE TABLE IF NOT EXISTS .. > > [/code] > >

Messages o Terminal

Hi, ALL, I'm trying to execute: [code] queries.push_back( L"CREATE TABLE IF NOT EXISTS .. [/code] However, when I run my profeam second tme I see n the Terminal: [quote] NOTICE: relation "abcatcol" already exists, skipping [/quote] Is there any way to suppress this NOTICE message? Tha

Re: Version compatibility

Hi, Adrian, On Tue, Mar 4, 2025, 3:00 PM Adrian Klaver wrote: > > > On 3/4/25 3:00 PM, Igor Korot wrote: > > Hi, Adrian, > > > > On Sat, Mar 1, 2025 at 7:06 PM Adrian Klaver > wrote: > >> > >> On 3/ > >> > >> Did the connecti

Re: Version compatibility

Hi, Adrian, On Sat, Mar 1, 2025 at 7:06 PM Adrian Klaver wrote: > > 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: &

Re: Error on the query

Hi, Pavel, On Tue, Mar 4, 2025 at 11:36 AM Pavel Stehule wrote: > > Hi > > út 4. 3. 2025 v 18:30 odesílatel Igor Korot napsal: >> >> Hi, ALL, >> Trying to execute following query: >> >> [code] >> queries.push_back( L"DO $$ BEGIN IF NO

Error on the query

Hi, ALL, Trying to execute following query: [code] queries.push_back( L"DO $$ BEGIN IF NOT EXISTS( SELECT 1 FROM pg_class c, pg_namespace n WHERE n.oid = c.relnamespace AND c.relname = \'abcatc_x\' AND n.nspname = \'public\' ) THEN CREATE UNIQUE INDEX \"abcatc_x\" ON \"abcatcol\"(\"abc_tna

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 > <mailto:adrian.kla.

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: How to get a notification

Hi, Adrian, On Fri, Feb 7, 2025, 1:13 PM Adrian Klaver wrote: > > > On 2/7/25 11:02 AM, Igor Korot wrote: > > Hi, Adrian, > > > > On Fri, Feb 7, 2025 at 11:07 AM Adrian Klaver > wrote: > >> > >> On 2/5/25 23:21, Igor Korot wrote: >

Re: How to get a notification

Hi, Adrian, On Fri, Feb 7, 2025 at 11:07 AM Adrian Klaver wrote: > > On 2/5/25 23:21, Igor Korot wrote: > > Hi, ALL, > > In my code I'm running following: > > > > queries.push_back( L"CREATE FUNCTION > > __watch_schema_changes() RETURNS

How to get a notification

Hi, ALL, In my code I'm running following: queries.push_back( L"CREATE FUNCTION __watch_schema_changes() RETURNS event_trigger LANGUAGE plpgsql AS $$ BEGIN NOTIFY tg_tag; END; $$;" ); queries.push_back( L"CREATE EVENT TRIGGER schema_change_notify ON ddl_command_end WHEN TAG

Fwd: Lock in postgreSQL

Hi, ALL, This concern both libpq and DBC API. Hopefully I can get answers on both. Than yu. -- Forwarded message - From: Igor Korot Date: Tue, Jan 14, 2025 at 12:50 AM Subject: Lock in postgreSQL To: pgsql-generallists.postgresql.org , PostgreSQL ODBC list Hi, ALL, https

Re: Postgres do not support tinyint?

Hi, Christopphe, On Wed, Jan 8, 2025 at 1:34 PM Christophe Pettus wrote: > > > > > On Jan 8, 2025, at 11:30, Igor Korot wrote: > > There is no boolean - it is 0-4 inclusive. > > Unless you have somehow gotten PostgreSQL running on an IBM 7070, the range > 0-4 can

Re: Postgres do not support tinyint?

Hi, Christophe, On Wed, Jan 8, 2025 at 12:49 AM Christophe Pettus wrote: > > > > > On Jan 7, 2025, at 22:44, David G. Johnston > > wrote: > > > > You suggest a type with a minimum size of 6 bytes when the complaint is > > that the otherwise acceptable 2 byte data type is too large? > > Althoug

Re: Postgres do not support tinyint?

Hi, Ron, On Tue, Jan 7, 2025 at 11:24 PM Ron Johnson wrote: > > On Wed, Jan 8, 2025 at 12:06 AM Igor Korot wrote: >> >> Hi, ALL, >> According to https://www.postgresql.org/docs/9.1/datatype-numeric.html, the >> smallest numeric type supports numbers from -32768 t

Postgres do not support tinyint?

Hi, ALL, According to https://www.postgresql.org/docs/9.1/datatype-numeric.html, the smallest numeric type supports numbers from -32768 to 32767/ My data will be in a range of [0..4], and so I guess my DB table will waste space, right? Thank you.

Re: Insert records in the tavke only if they are not exist

Hi, Adrian, On Sat, Dec 7, 2024 at 5:07 PM Adrian Klaver wrote: > > On 12/7/24 12:17, Igor Korot wrote: > > Hi, Adrian, > > > > On Sat, Dec 7, 2024 at 12:32 PM Adrian Klaver > > wrote: > >> > >> On 12/7/24 09:59, Igor Korot wrote: > >>

Re: Insert records in the tavke only if they are not exist

Hi, Adrian, On Sat, Dec 7, 2024 at 12:32 PM Adrian Klaver wrote: > > On 12/7/24 09:59, Igor Korot wrote: > > Hi, Adrian, > > > > On Sat, Dec 7, 2024 at 11:18 AM Adrian Klaver > > wrote: > >> > >> On 12/6/24 19:36, Igor Korot wrote: > >>

Re: Insert records in the tavke only if they are not exist

Hi, Adrian, On Sat, Dec 7, 2024 at 11:18 AM Adrian Klaver wrote: > > On 12/6/24 19:36, Igor Korot wrote: > > Hi, All, > > > > When my application starts up, ot creates some tables and insert records > > in them. > > > > When the app starts for the

Re: Insert records in the tavke only if they are not exist

Hi, Dvid, On Fri, Dec 6, 2024, 9:55 PM David G. Johnston wrote: > On Friday, December 6, 2024, Igor Korot wrote: >> >> When my application starts up, ot creates some tables and insert records >> in them. >> >> When the app starts for the second time it shou

Insert records in the tavke only if they are not exist

Hi, All, When my application starts up, ot creates some tables and insert records in them. When the app starts for the second time it should check if the tables and the records in them are exist and skip the process. Everything is good, except what if I have a connection from 2 different users?

Re: Find out the version of the server

Thx. On Fri, Nov 29, 2024, 2:03 PM Tom Lane wrote: > Adrian Klaver writes: > > On 11/29/24 11:15 AM, Igor Korot wrote: > >> Are you saying that the current version can connect even to 9.6.1 > >> server? (I have a really old Mac with the 9.6.1 version installed). &

Re: Find out the version of the server

Hi, Adrian, On Fri, Nov 29, 2024, 1:24 PM Adrian Klaver wrote: > Reply to list also > > Ccing list > > On 11/29/24 11:15 AM, Igor Korot wrote: > > Hi, Adrian, > > > > On Fri, Nov 29, 2024 at 10:12 AM Adrian Klaver > > wrote: > >> > > &g

Find out the version of the server

Hi, ALL, In April of 2017 I got the source code of the Postgresql, build the libpq and then deleted everything else. I was using MSVC 3010 at the time. Now I moved to MSVC 2017 but unfortunately I can't reuse the library built, since MSVC changed one of its headers. Is it possible to find what

Link error on Release mode

Hi, ALL. Today for the first time I tried to build my software in Release mode. This is the command MSVC generates: /OUT:"..\dbhandler\vc_mswudll\postgres_dll.dll" /MANIFEST /NXCOMPAT /PDB:"vc_mswudll\my_dll.pdb" /DYNAMICBASE "dbinterface.lib" "libpq.lib" "kernel32.lib" "user32.lib" "gdi32.lib" "

Re: Assistance Required: Timeout or Buffer Overflow Issue in PostgreSQL Client Application

Hi, Is this a complete backtrace? Can you post a complete backtrace? We need to see if there is a reference to your application code? What language is it written in? What operation this thread was performing? Thank you. On Thu, Oct 24, 2024 at 11:12 AM Sasmit Utkarsh wrote: > > Dear PostgreSQL

Re: update faster way

Hii, On Fri, Sep 13, 2024 at 10:22 PM yudhi s wrote: > > Hello, > We have to update a column value(from numbers like '123' to codes like 'abc' > by looking into a reference table data) in a partitioned table with billions > of rows in it, with each partition having 100's millions rows. As we te

PQconnect()

Hi, ALL, In the https://www.postgresql.org/docs/8.1/libpq.html#LIBPQ-CONNECT it gives the "options" parameter", but it doesn't specify what options are available. Could someone please reference this? I am specifically looking for the "KeepAlive" option... Thank you.

Re: Detecting PostgreSQL client library

On Wed, Jul 10, 2024 at 11:11 AM Pavel Stehule wrote: > > Hi > > st 10. 7. 2024 v 18:07 odesílatel Igor Korot napsal: >> >> Hi, ALL, >> Is there an explicit autotools macro that can tell >> the presence of PostgreSQL client library? >> And that can b

Detecting PostgreSQL client library

Hi, ALL, Is there an explicit autotools macro that can tell the presence of PostgreSQL client library? And that can be used with "configure" script. Or I should be using AC_CHECK_MODULE() one? Thank you.

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

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

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

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

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

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: 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

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.

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.

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 >

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

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, 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: 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: > >

Is there Postgres ODBC binary for OSX?

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

Is ODBC list dead?

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

Is ODBC list still alive?

Thank you.

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

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: 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

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: 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

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 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 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 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 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 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, 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

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.

  1   2   3   >