Re: [GENERAL] Database Connect

[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::errstr";

Umm, do you have any idea what we should do now?

Thanks for all the effort that you guys have put into Postgres--if I was
following pgsql-hackers I probably could have put my 2 cents in earlier.

W

Tom Lane wrote:

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

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [GENERAL] Database Connect

[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 undocumented and mostly-broken code in libpq that tried
to be fancy about interpreting database names to mean more than just a
database name.  I don't recall all the arguments for taking it out
versus trying to fix and document it, but the upshot was we took it out.

regards, tom lane

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Re: [GENERAL] Database Connect Permission

[G.Elangovan]

In pg_hba.conf file u can enter database name hostIP and password entry
that way  u can ensure  some amount of security

On Mon, 17 Aug 1998, Anand Surelia wrote:

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