[GENERAL] Database Connect

2001-04-20 Thread Michaƫl Fiey
Hi, I installed Postgresql 7.1 (RPMs for Redhat 7.0). When I start psql with the command 'psql mydb', everything's ok But whan I start psql with the command 'psql mybase@myhost' I receive : psql: FATAL 1: Database "mybase@myhost" does not exist in system catalog I used this syntax with

Re: [GENERAL] Database Connect

2001-04-20 Thread Tom Lane
=?iso-8859-1?Q?Micha=EBl_Fiey?= [EMAIL PROTECTED] writes: But whan I start psql with the command 'psql mybase@myhost' I receive : psql: FATAL 1: Database "mybase@myhost" does not exist in system catalog This syntax isn't supported. I used this syntax with Postgresql 7.03. There was some

Re: [GENERAL] Database Connect

2001-04-20 Thread webb sprague
Aahh! I have a million Perl scripts that rely on this syntax in the DBI to connect to remote databases. like: $dbh=DBI-connect( "dbi:Pg:dbname=datab@remotehost",'wsprague','pass', {RaiseError = 1, AutoCommit = 1}) or print STDERR "$DBI::errstrp"; Umm, do you have

[GENERAL] Database Connect Permission

1998-08-17 Thread Anand Surelia
Hi, Is there any way to specify connect permissions to a database for specific users? Right now, any user can connect to any database even though he may not be able to see any tables. Thanks, Anand Surelia.