FAQ

PostgreSQL > pgsql-interfaces

Search Discussions

5,266 discussions - 14,916 posts

  • Greetings, I'm trying to determine how to pass "NULL" to a variable, specifically in the conditional section of a SQL statement: SELECT moo FROM foo aa WHERE field1 = ? AND field2 = ? Sometimes at ...
    Max PyziurMax Pyziur
    Aug 21, 2013 at 9:06 pm
    Aug 24, 2013 at 9:53 pm
  • Hi , We have SUN Solaris 10 sparc 64 system and we need to install odbc driver for postgres to access data through SAS/Access. But when we downloaded driver from below Link But when we installed it ...
    Laxman DamodarLaxman Damodar
    Jul 19, 2013 at 9:22 am
    Jul 23, 2013 at 7:57 pm
  • Dear List, I'm trying to copy an unknown amount of data from a file to a table unsing a copy command. This is working without any problems. Now I want to get the number of copied rows. In psql this ...
    Rene GrünRene Grün
    May 24, 2013 at 2:42 pm
    May 27, 2013 at 7:13 am
  • Hi All, I know that PostgreSQL versions 8.3.X are no longer supported but I’ll very appreciate if one of you can help me regarding building libpq library for Windows 64bit. I’m trying to use ...
    David PatimerDavid Patimer
    May 23, 2013 at 8:17 am
    May 23, 2013 at 8:17 am
  • Hi, I'm trying a simple pgsql program with PQexecPrepared and have a few questions. I have seen the example but didn't find the answer there. googled too ...
    Neeraj RaiNeeraj Rai
    May 22, 2013 at 1:26 am
    May 22, 2013 at 11:55 pm
  • Hi, guys. I have a program in C, the createas a connection, do stuff, fork, exit child and continues life. Supose that when I create de PGconn, I have 1 active connection in postgres. When I fork, ...
    Rodrigo BarbozaRodrigo Barboza
    May 8, 2013 at 1:30 pm
    May 8, 2013 at 2:07 pm
  • Hello friends, I am new to postgres. I am doing Project on Image processing in OpenCV(IDE i am using is Visual C++ 2010). I have downloaded PostgreSQL 8.4 and installed it successfully. I want to ...
    Dhaval257Dhaval257
    Mar 4, 2013 at 9:00 am
    Mar 4, 2013 at 9:00 am
  • Hi, My main goal is to do a "select" in the Informix DB and be able to import that information directly into the DBPostgreSQL / PostGIS, from what I understand DBI-Link is the right tool for this ...
    Pedro FerroPedro Ferro
    Feb 28, 2013 at 3:25 pm
    Feb 28, 2013 at 3:25 pm
  • I'm trying to create a connection to my database with libpq. Bellow is my code: PGconn *connect(char *file_path) { const char **keywords; const char **values; char *line = malloc(LINE_SIZE); char ...
    Andrei Petru MuraAndrei Petru Mura
    Feb 25, 2013 at 10:42 am
    Feb 25, 2013 at 11:13 am
  • I'm trying to create a database connection with libpq from C. If I create the same connection with PQconnectdb, everything works fine, but if I create it with PQconnectdbParams function, I get a ...
    Andrei Petru MuraAndrei Petru Mura
    Feb 23, 2013 at 9:42 am
    Feb 23, 2013 at 11:12 am
  • psql is too complex for me to analyze and I believe it's multithreaded but anyway Ic ouldn't fathom anything substantially different when the function PQsetdbLogin() is called (file startup.c). It ...
    RajashekarRajashekar
    Dec 6, 2012 at 4:19 am
    Dec 6, 2012 at 4:19 am
  • Postgres does not support shared-disk clustering. -- Jonah H. Harris Blog: http://www.oracle-internals.com/
    Jonah H. HarrisJonah H. Harris
    Dec 1, 2012 at 3:58 pm
    Dec 1, 2012 at 3:58 pm
  • Hi, all. The Npgsql Development Team is proud to announce the Npgsql2 2.0.12 stable release. Npgsql is a .Net Data provider written 100% in C# which allows .net programs to talk to postgresql ...
    Francisco Figueiredo Jr.Francisco Figueiredo Jr.
    Sep 3, 2012 at 1:54 am
    Sep 3, 2012 at 1:54 am
  • 0

    .

    Please, accept my best wishes! http://polisidea.eu/bgohey.php?potjrankpage=671 Fri, 27 Jul 2012 1:26:23 Les go and do it. almendra alburn
    Mario MoraMario Mora
    Jul 27, 2012 at 12:26 am
    Jul 27, 2012 at 12:26 am
  • Hi, all!! The Npgsql Development Team is proud to announce the Npgsql2 2.0.12 beta4 release! Npgsql is a .Net Data provider written 100% in C# which allows .net programs to talk to postgresql ...
    Francisco Figueiredo Jr.Francisco Figueiredo Jr.
    Jul 7, 2012 at 3:08 am
    Jul 7, 2012 at 1:26 pm
  • Version 2.19.1 of DBD::Pg, the Perl interface to PostgreSQL, has just been released. This (and 2.19.0) fixes some serious bugs, so upgrading is recommended for all users. You can find it at your ...
    Greg Sabino MullaneGreg Sabino Mullane
    Mar 11, 2012 at 11:00 pm
    Mar 11, 2012 at 11:00 pm
  • Hi, all!! The Npgsql Development Team is proud to announce the Npgsql2 2.0.12 beta3 release! Npgsql is a .Net Data provider written 100% in C# which allows .net programs to talk to postgresql ...
    Francisco Figueiredo Jr.Francisco Figueiredo Jr.
    Feb 22, 2012 at 3:31 am
    Feb 22, 2012 at 3:31 am
  • http://orcunbabak.com/show_news.php?uid=17&detail=442&catalog=73&top=247&article=67
    Gouse shaikGouse shaik
    Dec 3, 2011 at 2:38 am
    Dec 3, 2011 at 2:38 am
  • http://exclusivelines.co.uk/poret12.html
    Andy ChambersAndy Chambers
    Nov 16, 2011 at 10:36 am
    Nov 16, 2011 at 10:36 am
  • Hi, all!! The Npgsql Development Team is proud to announce the Npgsql2 2.0.12 beta2 release! Npgsql is a .Net Data provider written 100% in C# which allows .net programs to talk to postgresql ...
    Francisco Figueiredo Jr.Francisco Figueiredo Jr.
    Sep 29, 2011 at 3:33 am
    Sep 29, 2011 at 3:33 am
  • I couldnt even afford groceries for the month despite the circumstances I remained hopeful because of this im always one step ahead!! http://part41.com//IanWright81.html I love not having ...
    Miguel GarcíaMiguel García
    Jul 5, 2011 at 12:07 am
    Jul 5, 2011 at 12:07 am
  • Greetings, I would like to use a bind variable with a LIKE operator. An example of the query that I'm trying to use is the following: SELECT ? , aa.f1, aa.f2, aa.f3, aa.f4 FROM orgs aa WHERE aa.f1 ...
    Max PyziurMax Pyziur
    Jul 4, 2011 at 1:42 pm
    Jul 5, 2011 at 2:31 pm
  • http://agriturismovalledelpesipe.it/indexz29X.php
    Miguel GarcíaMiguel García
    Jun 2, 2011 at 1:13 pm
    Jun 23, 2011 at 10:26 am
  • Hello. I'm some kind of PQdeleteTuple function will be very usefull in libpq. Because right now after deleting some record I need refetch result set, or mark tuple as deleted and this is headache for ...
    Pavel GolubPavel Golub
    Jun 1, 2011 at 3:43 pm
    Jun 3, 2011 at 5:54 am
  • hi, i need to know how to write cgi script written in c that is hosted under apache and deal with postgresql 8.4.8 in a stable way can any body give me a sample code or direct me where to ask or ...
    Hatem gamal elzanatyHatem gamal elzanaty
    May 16, 2011 at 3:20 am
    May 16, 2011 at 3:20 am
  • hi, i'm new to postgresql programming in c language the following code give the following error beneath and no reason for that error : in consice the code i brought from the net and try to change it ...
    Hatem gamal elzanatyHatem gamal elzanaty
    May 12, 2011 at 10:45 pm
    May 12, 2011 at 10:53 pm
  • Hi, all!! The Npgsql Development Team is proud to announce the Npgsql2 2.0.12 beta1 release! Npgsql is a .Net Data provider written 100% in C# which allows .net programs to talk to postgresql ...
    Francisco Figueiredo Jr.Francisco Figueiredo Jr.
    Mar 25, 2011 at 2:39 am
    Mar 25, 2011 at 2:39 am
  • Hi, all!! The Npgsql Development Team is proud to announce the Npgsql2 2.0.11 release! Npgsql is a .Net Data provider written 100% in C# which allows .net programs to talk to postgresql backends. ...
    Francisco Figueiredo Jr.Francisco Figueiredo Jr.
    Nov 6, 2010 at 1:16 am
    Nov 6, 2010 at 1:16 am
  • If you want this reviewed, please send in a patch of the source code you changed.
    Peter EisentrautPeter Eisentraut
    Sep 26, 2010 at 2:32 pm
    Sep 28, 2010 at 10:01 am
  • I would like to help too. -- Bruce Momjian <bruce@momjian.us http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +
    Bruce MomjianBruce Momjian
    Aug 12, 2010 at 1:47 am
    Aug 12, 2010 at 1:47 am
  • Hi, This is probably an FAQ but is there any direct support of large objects in ECPG? TIA. Bosco.
    Bosco RamaBosco Rama
    Aug 5, 2010 at 10:23 pm
    Aug 26, 2010 at 5:28 pm
  • Dear All, How can I detect if a certain field of a record returned by a query is NULL ? I'm sure there must be a direct way of doing this, but I googled up and down, back and forth and was unable to ...
    Oliveiros d'Azevedo CristinaOliveiros d'Azevedo Cristina
    Aug 3, 2010 at 3:26 pm
    Aug 5, 2010 at 2:01 pm
  • Hi all, I have a question on parsing an "interval" binary form. I'm working on ECPG/SQLDA things, and being stuck in front of retreiving "interval" values. Through SQLDA, "interval" values are ...
    Satoshi NagayasuSatoshi Nagayasu
    Jun 23, 2010 at 2:43 am
    Jun 23, 2010 at 2:43 am
  • Hi all, I'm trying SQLDA features, and I'm encountered strange thing which I can't solve. In my sample code, I retreived some records from the pg_database table, and dump all columns of the records. ...
    Satoshi NagayasuSatoshi Nagayasu
    Jun 22, 2010 at 7:57 am
    Jun 23, 2010 at 1:36 am
  • When using the initdb command-line utility to create a new PostgreSQL database cluster, is there any way to specify the starting size used on disk? By default it seems to take around 38MB. -- ...
    Murray CummingMurray Cumming
    Jun 20, 2010 at 12:14 am
    Jun 20, 2010 at 3:11 pm
  • Hi all, I'm trying to improve the ECPG documents for the ECPG application developrs, because some of my clients want more detailed information when they develop (or migrate) an embeded SQL ...
    Satoshi NagayasuSatoshi Nagayasu
    Jun 17, 2010 at 9:07 am
    Jul 29, 2010 at 4:23 pm
  • Version 2.17.0 of DBD::Pg, the Perl interface to Postgres, has just been released. In addition to some minor bug fixes, the primary difference is that a pg_cancel will no longer automatically do a ...
    Greg Sabino MullaneGreg Sabino Mullane
    Apr 6, 2010 at 7:07 pm
    Apr 6, 2010 at 7:07 pm
  • DBD::Pg has been ready since 2008, if you need something to test with. :) Usage is: while (my $notify = $dbh- pg_notifies) { my ($name, $pid, $payload) = @$notify; print qq{I received notice "$name" ...
    Greg Sabino MullaneGreg Sabino Mullane
    Feb 17, 2010 at 7:48 pm
    Feb 18, 2010 at 10:13 pm
  • Howdy folks, I have an application that works just fine in PG 8.3. We've installed 8.4 on another machine to perform pre- migration testing. When we tried to compile our ecpg stuff under 8.4 the ...
    Bosco RamaBosco Rama
    Nov 20, 2009 at 8:02 pm
    Nov 24, 2009 at 3:44 pm
  • Sorry if this is in the wrong list, but this is the closest I could find... I have a 8.2.4 database and I installed 8.3.7 and tried using the same /pgsql/data/base directory and got an error about ...
    Mark RichardsonMark Richardson
    Nov 11, 2009 at 6:38 pm
    Nov 14, 2009 at 10:42 pm
  • Hello, I have a problem on a test directory on my trigger function. For information, i use a 8.0.21 version of perl. To make things simple, i make a perlu function trigger on when i modify a row, i ...
    Piaff33zPiaff33z
    Sep 5, 2009 at 5:18 am
    Sep 5, 2009 at 5:53 pm
  • The code now stores bigint values (8 bytes long) in a floating point variable (NV). Most perl's are configured with the NV type being a simple C 'double' which is typically 8 bytes: $ perl ...
    Tim BunceTim Bunce
    Jul 28, 2009 at 4:53 pm
    Jul 28, 2009 at 5:07 pm
  • Hello, I am wirting an application that uses the libpq interface to access the PostgreSQL database. My system is Mac OS X. I have set up my project in Xcode and everything works fine. DB access is ...
    Ralf HasemannRalf Hasemann
    Jul 23, 2009 at 7:48 pm
    Jul 23, 2009 at 9:39 pm
  • I'd like to use type information in a query result to convert its elements to more appropriate types if necessary. Can I embed the types I'm interested in into my program, or should I query the ...
    Florian WeimerFlorian Weimer
    Jun 3, 2009 at 7:01 pm
    Jun 7, 2009 at 11:00 am
  • Hello, pgsql-interfaces. I found solution how to implement keep alive through sockets in archive: http://archives.postgresql.org/pgsql-interfaces/2006-11/msg00014.php However, it is dated 2006 year ...
    Pavel GolubPavel Golub
    May 27, 2009 at 10:34 am
    May 27, 2009 at 10:34 am
  • Hello, I try to use the new 8.4 INTERVAL type with libpq, but get crazy with the input formatting rules... I use PQprepare() / PQexecPrepared() with parameter list, binding the INTERVAL values with ...
    Sebastien FLAESCHSebastien FLAESCH
    May 19, 2009 at 8:12 am
    May 19, 2009 at 8:12 am
  • Version 2.13.1 of DBD::Pg has just been released. You can find it at: http://search.cpan.org/dist/DBD-Pg/ 2.13.1 addressed a minor leak in pg_warn. 2.13.0 applied better SQLSTATE codes 2.12.0 changed ...
    Greg Sabino MullaneGreg Sabino Mullane
    Apr 24, 2009 at 7:12 pm
    Apr 24, 2009 at 7:12 pm
  • Hello, I have created a function (on Windows XP) in PostgreSQL 8.3.6 with 2 inout parameters. His code is : CREATE OR REPLACE FUNCTION add_one(INOUT arg1 integer, INOUT arg2 integer) RETURNS record ...
    Ben Ali RachidBen Ali Rachid
    Mar 18, 2009 at 1:18 pm
    Mar 18, 2009 at 1:18 pm
  • Hello, Is there a function similar to pg_get_indexdef that will return the create statement for a table? TIA... David
    David SaraciniDavid Saracini
    Mar 8, 2009 at 10:38 pm
    Mar 8, 2009 at 10:38 pm
  • Sorry if this double posts. My first attempt was stalled because I was not a member of the list. So now I am. I'm starting to experiment with writing some stored functions in C and find it really ...
    Bob HenkelBob Henkel
    Feb 24, 2009 at 1:04 am
    Feb 25, 2009 at 3:54 pm
Latest
Group Navigation
period‹ prev | Latest | first ›
Group Overview
grouppgsql-interfaces @
categoriespostgresql
discussions5,266
posts14,916
users3,319
websitepostgresql.org
irc#postgresql

Top users

Tom Lane: 1056 posts Bruce Momjian: 397 posts Meskes: 313 posts Thomas G. Lockhart: 307 posts Peter Mount: 265 posts Peter Mount: 250 posts Marc G. Fournier: 223 posts Byron Nikolaidis: 206 posts Teo: 201 posts Dave Page: 191 posts Jtv: 166 posts Peter Eisentraut: 133 posts Peter Mount: 101 posts Ken: 98 posts Bruce Momjian: 93 posts David Hartwig: 87 posts Michael Fuhr: 81 posts Adam Lang: 78 posts Herouth maoz: 74 posts Lamar Owen: 69 posts
show more
Archives