Search Discussions
-
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 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 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ü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 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 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 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 ...
Dhaval257
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 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 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 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 ...
Rajashekar
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. 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.
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 alburnMario 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.
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 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.
Feb 22, 2012 at 3:31 am
Feb 22, 2012 at 3:31 am -
0
Fwd:
http://orcunbabak.com/show_news.php?uid=17&detail=442&catalog=73&top=247&article=67Gouse shaik
Dec 3, 2011 at 2:38 am
Dec 3, 2011 at 2:38 am -
http://exclusivelines.co.uk/poret12.html
Andy 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.
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í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 Pyziur
Jul 4, 2011 at 1:42 pm
Jul 5, 2011 at 2:31 pm -
http://agriturismovalledelpesipe.it/indexz29X.php
Miguel 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 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 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 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.
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.
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 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 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 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 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 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 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 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 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 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 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 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 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 ...
Piaff33z
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 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 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 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 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 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 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 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 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 Henkel
Feb 24, 2009 at 1:04 am
Feb 25, 2009 at 3:54 pm
Group Overview
group | pgsql-interfaces |
categories | postgresql |
discussions | 5,266 |
posts | 14,916 |
users | 3,319 |
website | postgresql.org |
irc | #postgresql |
Top users
Archives
- August 2013 (3)
- July 2013 (4)
- May 2013 (11)
- March 2013 (1)
- February 2013 (5)
- December 2012 (2)
- September 2012 (1)
- July 2012 (3)
- March 2012 (1)
- February 2012 (1)
- December 2011 (1)
- November 2011 (1)
- September 2011 (1)
- July 2011 (3)
- June 2011 (13)
- May 2011 (3)
- March 2011 (1)
- November 2010 (1)
- September 2010 (2)
- August 2010 (10)
- June 2010 (18)
- April 2010 (1)
- February 2010 (5)
- November 2009 (12)
- September 2009 (3)
- July 2009 (5)
- June 2009 (6)
- May 2009 (2)
- April 2009 (1)
- March 2009 (6)
- February 2009 (8)
- January 2009 (12)
- December 2008 (22)
- November 2008 (1)
- October 2008 (15)
- September 2008 (3)
- August 2008 (23)
- July 2008 (17)
- June 2008 (15)
- May 2008 (19)
- April 2008 (13)
- March 2008 (4)
- February 2008 (9)
- January 2008 (20)
- December 2007 (13)
- November 2007 (20)
- October 2007 (18)
- September 2007 (5)
- August 2007 (29)
- July 2007 (9)
- June 2007 (15)
- May 2007 (62)
- April 2007 (19)
- March 2007 (45)
- February 2007 (23)
- January 2007 (42)
- December 2006 (44)
- November 2006 (19)
- October 2006 (32)
- September 2006 (38)
- August 2006 (31)
- July 2006 (24)
- June 2006 (50)
- May 2006 (19)
- April 2006 (30)
- March 2006 (38)
- February 2006 (89)
- January 2006 (48)
- December 2005 (48)
- November 2005 (72)
- October 2005 (34)
- September 2005 (39)
- August 2005 (53)
- July 2005 (34)
- June 2005 (68)
- May 2005 (65)
- April 2005 (85)
- March 2005 (89)
- February 2005 (84)
- January 2005 (19)
- December 2004 (56)
- November 2004 (44)
- October 2004 (31)
- September 2004 (21)
- August 2004 (27)
- July 2004 (42)
- June 2004 (78)
- May 2004 (33)
- April 2004 (73)
- March 2004 (43)
- February 2004 (86)
- January 2004 (24)
- December 2003 (60)
- November 2003 (51)
- October 2003 (69)
- September 2003 (71)
- August 2003 (64)
- July 2003 (38)
- June 2003 (95)
- May 2003 (99)
- April 2003 (185)
- March 2003 (185)
- February 2003 (130)
- January 2003 (118)
- December 2002 (89)
- November 2002 (167)
- October 2002 (87)
- September 2002 (92)
- August 2002 (105)
- July 2002 (154)
- June 2002 (99)
- May 2002 (111)
- April 2002 (58)
- March 2002 (149)
- February 2002 (85)
- January 2002 (102)
- December 2001 (48)
- November 2001 (101)
- October 2001 (91)
- September 2001 (18)
- August 2001 (83)
- July 2001 (112)
- June 2001 (93)
- May 2001 (137)
- April 2001 (142)
- March 2001 (223)
- February 2001 (209)
- January 2001 (342)
- December 2000 (271)
- November 2000 (304)
- October 2000 (291)
- September 2000 (125)
- August 2000 (205)
- July 2000 (232)
- June 2000 (152)
- May 2000 (212)
- April 2000 (173)
- March 2000 (89)
- February 2000 (269)
- January 2000 (221)
- December 1999 (329)
- November 1999 (289)
- October 1999 (279)
- September 1999 (330)
- August 1999 (292)
- July 1999 (317)
- June 1999 (390)
- May 1999 (340)
- April 1999 (247)
- March 1999 (315)
- February 1999 (336)
- January 1999 (234)
- December 1998 (143)
- November 1998 (241)
- October 1998 (217)
- September 1998 (142)
- August 1998 (275)
- July 1998 (336)
- June 1998 (191)
- May 1998 (183)
- April 1998 (321)
- March 1998 (172)
- February 1998 (30)
- January 1998 (50)