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

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

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

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

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

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

<    1   2   3