Re: Connection without database name

On Thu, Dec 23, 2004 at 10:46:26AM +0100, Michael Meskes wrote:

> Very early in its existance ecpg got an oracle compat hack that enabled
> it to do a connect with just the username and use the database as
> specified via PGDATABASE. It appears that this feature is not really
> used as it seems it segfault for quite some amount of releases. 

The following works for me in 8.0.0rc2 and 7.4.6, making the
connection based on PGDATABASE, PGUSER, etc.:
 EXEC SQL BEGIN DECLARE SECTION; char  *target = ""; EXEC SQL END DECLARE SECTION;
 EXEC SQL CONNECT TO :target;

The following, however, dumps core with a segmentation fault:
 EXEC SQL CONNECT TO DEFAULT;

Here's a backtrace from 8.0.0rc2:

#0  0x280d5dcc in strdup () from /usr/lib/libc.so.4
#1  0x2806efac in ECPGconnect (lineno=17, c=0, name=0x0, user=0x0, passwd=0x0,    connection_name=0x8048800 "DEFAULT",
autocommit=0)at connect.c:245
 
#2  0x804864e in main () at conntest.pgc:17

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/