Hi,
On Fri, Dec 28, 2018 at 5:07 PM Igor Korot wrote:
>
> 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:
> >
m_bytes( PQgetvalue( res, 0, 0 ) );
}
return result;
}
The charlength2 variable contains the value of 8 and I'm still getting
the same error.
Any idea?
Thank you.
On Fri, Dec 28, 2018 at 5:40 PM patrick keshishian wrote:
>
> On Fri, Dec 28, 2018 at 3:07 PM Igor K
Hi,
On Sat, Dec 29, 2018 at 1:37 AM patrick keshishian wrote:
>
> On Fri, Dec 28, 2018 at 5:40 PM Igor Korot wrote:
>>
>> Hi, Patrick,
>>
>> Here is my new code:
>>
>> int PostgresDatabase::GetTableOwner (const std::wstring
&schemaName,
>>
Hi,
So, does anybody have an idea?
I do have following code at the beginning of the cpp file:
#ifdef WIN32
#include
#pragma execution_character_set("utf-8")
#endif
but even running it on OSX, I am getting this same error.
Thank you.
On Fri, Dec 28, 2018 at 11:30 PM Igor Korot wro
Hi, Rich,
On Fri, Jan 4, 2019 at 10:53 AM Rich Shepard wrote:
>
>I have a projects table that includes these two columns:
>
> start_date date DEFAULT CURRENT_DATE,
> end_date date
> CONSTRAINT valid_start_date
> CHECK (start_date <= end_date),
>
>1. Do I need a DEFAULT val
Hi, ALL,
I tried to follow an instructions at
https://www.postgresql.org/ftp/binary/v9.6.1/solaris/solaris11/i386/
in the README but I received following:
[code]
igor@solaris:/usr$ sudo bunzip2 < postgresql-9.6.1-S11.i386-64.tar.bz2
| tar xpf -
tar: postgres: Permission denied
tar: postgres: Permi
Hi
On Sat, Mar 23, 2019 at 9:25 AM Ron wrote:
>
> On 3/23/19 8:58 AM, Adrian Klaver wrote:
>
> On 3/22/19 11:59 PM, Igor Korot wrote:
>
> Hi, ALL,
> I tried to follow an instructions at
> https://www.postgresql.org/ftp/binary/v9.6.1/solaris/solaris11/i386/
> i
Hi,
On Sat, Mar 23, 2019 at 9:55 AM Michael Loftis wrote:
>
>
>
> On Sat, Mar 23, 2019 at 08:48 Igor Korot wrote:
>>
>>
>> > [code]
>> > igor@solaris:/usr$ sudo bunzip2 < postgresql-9.6.1-S11.i386-64.tar.bz2
>>
>> You mean even running a
Hi,
On Sat, Mar 23, 2019 at 10:17 AM Ron wrote:
>
> On 3/22/19 9:50 PM, Igor Korot wrote:
>
> Hi
>
> On Sat, Mar 23, 2019 at 9:25 AM Ron wrote:
>
> On 3/23/19 8:58 AM, Adrian Klaver wrote:
>
> On 3/22/19 11:59 PM, Igor Korot wrote:
>
> Hi, ALL,
> I tri
Hi,
On Sat, Mar 23, 2019 at 10:36 AM Hans Schou wrote:
>
>
>
> On Sat, Mar 23, 2019 at 3:48 PM Igor Korot wrote:
>>
>>
>> You mean even running as "sudo"?
>
>
> igor@solaris:/usr$ sudo bunzip2 < postgresql-9.6.1-S11.i386-64.tar.bz2
> | t
Hi,
On Sat, Mar 23, 2019 at 10:42 AM Tom Lane wrote:
>
> Igor Korot writes:
> >>>> igor@solaris:/usr$ sudo bunzip2 < postgresql-9.6.1-S11.i386-64.tar.bz2
> >>>> | tar xpf -
>
> > On Sat, Mar 23, 2019 at 9:25 AM Ron wrote:
> >> Off hand
Hi, ALL,
On Fri, Mar 22, 2019 at 11:32 PM Igor Korot wrote:
>
> Hi,
>
> On Sat, Mar 23, 2019 at 10:42 AM Tom Lane wrote:
> >
> > Igor Korot writes:
> > >>>> igor@solaris:/usr$ sudo bunzip2 < postgresql-9.6.1-S11.i386-64.tar.bz2
> > >>>
Hi,
[quote]
igor@solaris:~/dbhandlerSol/postgresql$ ./configure
checking build system type... i386-pc-solaris2.11
checking host system type... i386-pc-solaris2.11
checking which template to use... solaris
checking whether to build with 64-bit integer date/time support... yes
checking whether NLS is
Hi,
On Fri, May 3, 2019 at 11:20 AM Michael Nolan wrote:
>
>
>
> I'm still not clear what the backslash is for, it is ONLY to separate first
> and last name? Can you change it to some other character?
>
> Others have suggested you're in a Windows environment, that might limit your
> options.
Hi, ALL,
How do I insert the png file (content, not a name) into the BLOB field
in the table i PostgreSQL DB?
Thank you.
Hi, Adrian,
On Sun, Jun 9, 2019 at 11:14 PM Adrian Klaver wrote:
>
> On 6/9/19 8:28 AM, Igor Korot wrote:
> > Hi, ALL,
> > How do I insert the png file (content, not a name) into the BLOB field
> > in the table i PostgreSQL DB?
>
> Are you talking ab
Hi, Adrian,
On Mon, Jun 10, 2019 at 8:38 AM Adrian Klaver wrote:
>
> On 6/9/19 10:06 AM, Igor Korot wrote:
> > Hi, Adrian,
> >
> > On Sun, Jun 9, 2019 at 11:14 PM Adrian Klaver
> > wrote:
> >>
> >> On 6/9/19 8:28 AM, Igor Korot wrote:
> >&
Hi, Adrian,
On Mon, Jun 10, 2019 at 7:03 PM Adrian Klaver wrote:
>
> On 6/10/19 9:30 AM, Igor Korot wrote:
>
> >
> > According to
> > https://stackoverflow.com/questions/16048649/postgresql-9-x-pg-read-binary-file-inserting-files-into-bytea,
> > the file needs
Hi, David,
On Mon, Jun 10, 2019 at 10:45 PM David G. Johnston
wrote:
>
> On Mon, Jun 10, 2019 at 8:32 PM Rob Sargent wrote:
>>
>> > On Jun 10, 2019, at 6:40 AM, Igor Korot wrote:
>> >
>> > Hi, Adrian,
>> >
>> >> On Mon, Jun 10, 2019
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.
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
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.
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
Hi, ALL,
Documentation for PQprepare states:
[quote]
As with PQexec, the result is normally a PGresult object whose
contents indicate server-side success or failure. A null result
indicates out-of-memory or inability to send the command at all. Use
PQerrorMessage to get more information about suc
Thx, David.
I need to get some sleep. ;-)
On Tue, Mar 16, 2021 at 12:35 AM David G. Johnston
wrote:
>
> On Monday, March 15, 2021, Igor Korot wrote:
>>
>> [quote]
>> As with PQexec, the result is normally a PGresult object whose
>> contents indicate server-s
Hi, ALL,
I have an image on my hard drive and I'd like to store it in the BLOB
column of the images table.
Is there a simple SQL to do that in PostgreSQL?
Thank you.
Hi, David,
On Sun, Apr 11, 2021 at 6:24 PM David G. Johnston
wrote:
>
> On Sun, Apr 11, 2021 at 2:04 PM Igor Korot wrote:
>>
>> Hi, ALL,
>> I have an image on my hard drive and I'd like to store it in the BLOB
>> column of the images table.
>>
>>
Hi, David,
On Sun, Apr 11, 2021 at 6:57 PM David G. Johnston
wrote:
>
> On Sunday, April 11, 2021, Igor Korot wrote:
>>
>> Hi, David,
>>
>>
>> On Sun, Apr 11, 2021 at 6:24 PM David G. Johnston
>> wrote:
>>
>> > If you can decide
Hi, guys,
On Sun, Apr 11, 2021 at 7:08 PM Igor Korot wrote:
>
> Hi, David,
>
> On Sun, Apr 11, 2021 at 6:57 PM David G. Johnston
> wrote:
> >
> > On Sunday, April 11, 2021, Igor Korot wrote:
> >>
> >> Hi, David,
> >>
> >>
>
Hi,
On Fri, Jul 2, 2021, 5:24 AM Atul Kumar wrote:
> Hi,
>
> I have one query like below :
>
>
> SELECT
> m.iMemberId "memberId",
> m.cFirstName "firstName",
> m.cLastName "la
Hi,
On Wed, Sep 1, 2021, 07:32 obi reddy wrote:
> Hi everyone
>
> is there any one working on PostgreSQL windows machine.
>
You mean server installed on Windows? Or client? If the client - which one?
And what is your question?
Thank you.
> Thank you & Regards
> Obireddy.G
>
On Wed, 1 Sep 2021, 6:21 pm Igor Korot, wrote:
>>
>> Hi,
>>
>>
>>
>> On Wed, Sep 1, 2021, 07:32 obi reddy wrote:
>>>
>>> Hi everyone
>>>
>>> is there any one working on PostgreSQL windows machine.
>>
>>
Hi,
On Wed, Sep 1, 2021 at 9:37 AM obi reddy wrote:
>
> Windows version:10
> Postgresql version:13.
>
> On Wed, 1 Sep 2021, 6:47 pm Igor Korot, wrote:
>>
>> Hi,
>>
>> On Wed, Sep 1, 2021 at 7:57 AM obi reddy wrote:
>> >
>> > 1.How to set
Hi, ALL,
I wonder who ade the decision not to provide an independent build
of the client library of PostgreSQL? And what was the reason behind it?
Its very annoying to build the whole server, just to create a client library
to connect to a remote DB. And then kill the build after the install as
us
Hi Tom,
On Sun, Oct 3, 2021 at 3:11 PM Tom Lane wrote:
>
> Igor Korot writes:
> > I wonder who ade the decision not to provide an independent build
> > of the client library of PostgreSQL? And what was the reason behind it?
>
> It wasn't worth the maintenance trou
Hi, Adrian,
On Sun, Oct 3, 2021 at 3:28 PM Adrian Klaver wrote:
>
> On 10/3/21 1:20 PM, Igor Korot wrote:
> > Hi Tom,
> >
> > On Sun, Oct 3, 2021 at 3:11 PM Tom Lane wrote:
> >>
> >> Igor Korot writes:
> >>> I wonder who ade the decision n
Hi, Tom,
On Sun, Oct 3, 2021 at 5:27 PM Tom Lane wrote:
>
> Igor Korot writes:
> > Imagine you are a developer/maintainer of sme software. This software needs
> > to
> > connect to different DBMSes perform soe operations and then disconnect.
> > It is very easy
Hi, ALL,
In SQLite you can write:
SELECT a, b, c FROM foo WHERE id = :id;
where ":id" is the named parameter.
The query above is similar to
SELECT a,b,c FROM foo WHERE id = ?;
except that the parameter has a name.
Is there a way to write such a SELECT statement with the
named parameter in Pos
Hi, Ron,
On Thu, Jan 6, 2022 at 1:01 AM Ron wrote:
>
> On 1/6/22 12:39 AM, Igor Korot wrote:
> > Hi, ALL,
> > In SQLite you can write:
> >
> > SELECT a, b, c FROM foo WHERE id = :id;
> >
> > where ":id" is the named parameter.
> >
>
Hi, David,
On Thu, Jan 6, 2022 at 1:00 AM David G. Johnston
wrote:
>
> On Wednesday, January 5, 2022, Igor Korot wrote:
>>
>>
>> Is there a way to write such a SELECT statement with the
>> named parameter in PostgreSQL?
>
>
> The server, and its prepared S
FROM foo WHERE id = ?;
i.e. using unnamed parameter.
Thank you.
>
> On Thu, Jan 6, 2022 at 12:10 PM Igor Korot wrote:
> >
> > Hi, ALL,
> > In SQLite you can write:
> >
> > SELECT a, b, c FROM foo WHERE id = :id;
> >
> > where ":id&
Hi,
I'm curious - what was the problem in the first place?
Why people who performed the change couldn't create a mail template
where the "Subscribe/Unsubscribe"
links would be visible at the bottom of the e-mail?
There has to be a way of doing this sort of things. Especially if you
as a user have
Andrew,
On Tue, Nov 21, 2017 at 12:50 PM, Andrew Sullivan wrote:
> Hi,
>
> On Tue, Nov 21, 2017 at 12:44:48PM -0600, Igor Korot wrote:
>> Why people who performed the change couldn't create a mail template
>> where the "Subscribe/Unsubscribe"
>> links wo
Hi,
On Tue, Nov 21, 2017 at 2:15 PM, Jerry Regan
wrote:
> I kind of agree with both. Personally, my strengths are data communication.
> Databases are frequent end points. Mailing lists? Have never had a need to
> work with them, so they’re in the, “don’t care” bucket so long as they work.
>
>
Hi,
On Thu, Feb 8, 2018 at 2:24 PM, Igal @ Lucee.org wrote:
> Is there a rational reason why Day of the Week is 0-based, i.e. Sunday (0)
> to Saturday (6) instead of the more intuitive Sunday (1) to Saturday (7)?
>
> SELECT date_part('dow', current_date);
>
> https://www.postgresql.org/docs/c
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
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" "
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
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).
&
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
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:
> >>
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
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:
> >>
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
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
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
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:
>
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?
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
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
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
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
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.
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
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.
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
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
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
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
|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
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
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
&
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
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
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
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
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"
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
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
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
-- 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
-- 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
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() ); /*
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
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
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
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.
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
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
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
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.
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
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;
>
>
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
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
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
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.
>
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
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...
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
101 - 200 of 211 matches
Mail list logo
