------=_Part_6850_4264095.1212702402375
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
I think there is a problem with the syntax -- highlighted below
It seems that
datname NOT in (datname=3D'blah')
should just be
datname NOT in ('blah')
SELECT db.oid, datname, db.dattablespace AS spcoid, spcname, datallowconn,
datconfig, datacl, pg_encoding_to_char(encoding) AS serverencoding,
pg_get_userbyid(datdba) AS datowner,has_database_privilege(db.oid,
'CREATE'=
)
as cancreate, current_setting('default_tablespace') AS default_tablespace
FROM pg_database db LEFT OUTER JOIN pg_tablespace ta ON
db.dattablespace=3Dta.OID WHERE datname NOT IN (*datname=3D'blah'*)
On Thu, Jun 5, 2008 at 3:43 PM, Zach Conrad <zach.conrad@[EMAIL PROTECTED]
>
wrote:
> Thank you for your quick response.
>
> There are a few things this brings up:
>
> 1. The pgAdmin help file states the use of datname IN ('blah') in the DB
> Restriction field
> 2. Most people know which databases they want to connect to. Wouldn't it
> make
> more sense to use datename IN (...) rather than NOT IN?
>
> Thank you all for creating a great application!
>
> Sincerely,
>
> Zach Conrad
>
> ----- Original Message -----
> From: "Guillaume Lelarge" <guillaume@[EMAIL PROTECTED]
>
> To: "Zach Conrad" <zach.conrad@[EMAIL PROTECTED]
>
> Cc: pgadmin-sup****t@[EMAIL PROTECTED]
> Sent: Thursday, June 5, 2008 3:31:55 PM GMT -06:00 US/Canada Central
> Subject: Re: [pgadmin-sup****t] 1.8.4 bug DB Restriction field
>
> Zach Conrad a =E9crit :
> > DB Restriction field borks on datname IN ('blah') or datname=3D'blah'
w=
ith
> the error: "ERROR: operator does not exist: name <> boolean LINE 5:
WHE=
RE
> datname NOT IN (datname=3D'blah')
> >
> > Here's the full query from the logs being sent from pgAdmin:
> > SELECT db.oid, datname, db.dattablespace AS spcoid, spcname,
> datallowconn, datconfig, datacl, pg_encoding_to_char(encoding) AS
> serverencoding, pg_get_userbyid(datdba) AS
> datowner,has_database_privilege(db.oid, 'CREATE') as cancreate,
> current_setting('default_tablespace') AS default_tablespace FROM
pg_datab=
ase
> db LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=3Dta.OID WHERE
da=
tname
> NOT IN (datname=3D'blah')
> >
>
> The DB Restriction field should not contain : datname IN ('blah')
>
> It should contain : 'blah'
> or : 'foo','bar'
>
> Regards.
>
>
> --
> Guillaume.
> http://www.postgresqlfr.org
> http://dalibo.com
>
> --
> Sent via pgadmin-sup****t mailing list (pgadmin-sup****t@[EMAIL PROTECTED]
)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-sup****t
>
------=_Part_6850_4264095.1212702402375
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
I think there is a problem with the syntax -- highlighted below<br><br>It
s=
eems that<br><div style=3D"margin-left: 40px;"> datname NOT in
(datnam=
e=3D'blah')<br><br></div>should just be<br><div
style=3D"margin-lef=
t: 40px;">
datname NOT in ('blah')<br><br><br></div><div
style=3D"margin=
-left: 40px;">SELECT db.oid, datname, db.dattablespace AS spcoid, spcname,
datallowconn, datconfig, datacl, pg_encoding_to_char(encoding) AS
serverencoding, pg_get_userbyid(datdba) AS
datowner,has_database_privileg<div id=3D"1exj" class=3D"ArwC7c
ckChnd">e(db=
..oid, 'CREATE') as cancreate,
current_setting('default_tablespa=
ce')
AS default_tablespace FROM pg_database db LEFT OUTER JOIN pg_tablespace
ta ON db.dattablespace=3Dta.OID WHERE datname NOT IN
(<b>datname=3D'bla=
h'</b>)</div></div><br><div class=3D"gmail_quote">On Thu, Jun 5, 2008
a=
t 3:43 PM, Zach Conrad <<a
href=3D"mailto:zach.conrad@[EMAIL PROTECTED]
">za=
ch.conrad@[EMAIL PROTECTED]
>> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204,
=
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Thank you for
you=
r quick response.<br>
<br>
There are a few things this brings up:<br>
<br>
1. The pgAdmin help file states the use of datname IN ('blah') in
t=
he DB Restriction field<br>
2. Most people know which databases they want to connect to. Wouldn't
i=
t make<br>
more sense to use datename IN (...) rather than NOT IN?<br>
<br>
Thank you all for creating a great application!<br>
<br>
Sincerely,<br>
<br>
Zach Conrad<br>
<br>
----- Original Message -----<br>
From: "Guillaume Lelarge" <<a
href=3D"mailto:guillaume@[EMAIL PROTECTED]
">guillaume@[EMAIL PROTECTED]
>><br>
To: "Zach Conrad" <<a
href=3D"mailto:zach.conrad@[EMAIL PROTECTED]
">zach.conrad@[EMAIL PROTECTED]
>><br>
Cc: <a
href=3D"mailto:pgadmin-sup****t@[EMAIL PROTECTED]
">pgadmin-sup****t@[EMAIL PROTECTED]
><br>
Sent: Thursday, June 5, 2008 3:31:55 PM GMT -06:00 US/Canada Central<br>
Subject: Re: [pgadmin-sup****t] 1.8.4 bug DB Restriction field<br>
<br>
Zach Conrad a =E9crit :<br>
> DB Restriction field borks on datname IN ('blah') or datname=
=3D'blah' with the error: "ERROR: operator does not
exis=
t: name <> boolean LINE 5: WHERE datname NOT IN
(datname=3D'=
;blah')<br>
><br>
> Here's the full query from the logs being sent from pgAdmin:<br>
> SELECT db.oid, datname, db.dattablespace AS spcoid, spcname,
datallowc=
onn, datconfig, datacl, pg_encoding_to_char(encoding) AS serverencoding,
pg=
_get_userbyid(datdba) AS datowner,has_database_privilege(db.oid,
'CREAT=
E') as cancreate, current_setting('default_tablespace') AS
defa=
ult_tablespace FROM pg_database db LEFT OUTER JOIN pg_tablespace ta ON
db.d=
attablespace=3Dta.OID WHERE datname NOT IN (datname=3D'blah')<br>
><br>
<br>
The DB Restriction field should not contain : datname IN
('blah')<b=
r>
<br>
It should contain : 'blah'<br>
or : 'foo','bar'<br>
<br>
Regards.<br>
<br>
<br>
--<br>
Guillaume.<br>
<a href=3D"http://www.postgresqlfr.org"
target=3D"_blank">http://www=
..postgresqlfr.org</a><br>
<a href=3D"http://dalibo.com"
target=3D"_blank">http://dalibo.com</a=
><br>
<font color=3D"#888888"><br>
--<br>
Sent via pgadmin-sup****t mailing list (<a
href=3D"mailto:pgadmin-sup****t@[EMAIL PROTECTED]
">pgadmin-sup****t@[EMAIL PROTECTED]
>)<br>
To make changes to your subscription:<br>
<a href=3D"http://www.postgresql.org/mailpref/pgadmin-sup****t"
target=3D"_b=
lank">http://www.postgresql.org/mailpref/pgadmin-sup****t</a><br>
</font></blockquote></div><br>
------=_Part_6850_4264095.1212702402375--
|
