Re: NetBeans (3.5 Dev), Postgresql 7.4dev jdbc

It is my understanding that SQL92 calls for all names to be
CASE-INSENSITIVE and that PostgreSQL is broken in this respect.
Perhaps we can get some code introduced to munge cases in the parser
(as a configuration option to avoid the performance penalty for those
who care to be case sensitive).



Charlie


On Thursday, April 3, 2003, at 08:23 PM, snpe wrote:

> Hello,
> I try Database explorer with Netbeans and Postgresql (it is same with
> forte and postgresql 7.3.2 jdbc)
> I can't get tables, views , procedures.
> Problem is schema name - btw. when Database explorer call
> DatabaseMetadata.getTables use only upper case
> (no matter if schema lower case) and don't find anything.
> I think that problem is Netbeans, because lower case schema name is
> allowed.
> - schema (and user,tables, procedures etc)  don't be set in upper case
>
> BTW. I have user (schema) snpe :
> Netbeans Database Explorer call next query for tables (query is ugly,
> but PostgreSQL haven't friendly catalog) :
>
> SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS
> TABLE_NAME,
> CASE n.nspname LIKE 'pg\\_%'
> WHEN true THEN
>     CASE n.nspname
>     WHEN 'pg_catalog' THEN
>     CASE c.relkind
>         WHEN 'r' THEN 'SYSTEM TABLE'
>     WHEN 'v' THEN 'SYSTEM VIEW'
>         WHEN 'i' THEN 'SYSTEM INDEX'
> ELSE NULL         END
> WHEN 'pg_toast' THEN CASE c.relkind
>         WHEN 'r' THEN 'SYSTEM TOAST TABLE'
>         WHEN 'i' THEN 'SYSTEM TOAST INDEX'
>     ELSE NULL
> END
> ELSE CASE c.relkind
>         WHEN 'r' THEN 'TEMPORARY TABLE'
>         WHEN 'i' THEN 'TEMPORARY INDEX'
>         ELSE NULL
>         END
> END
>  WHEN false THEN
> CASE c.relkind     WHEN 'r' THEN 'TABLE'     WHEN 'i' THEN 'INDEX'     WHEN 'S'
> THEN 'SEQUENCE'     WHEN 'v' THEN 'VIEW'     ELSE NULL     END  ELSE NULL  END
>  AS TABLE_TYPE,
>     d.description AS REMARKS
>  FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c
>      LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND
> d.objsubid = 0)
>      LEFT JOIN pg_catalog.pg_class dc ON (d.classoid=dc.oid AND
> dc.relname='pg_class')
>      LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid=dc.relnamespace AND
> dn.nspname='pg_catalog')
>  WHERE c.relnamespace = n.oid
> ** AND n.nspname LIKE 'SNPE'
>  AND c.relname LIKE '%'
>  AND (false  OR ( c.relkind = 'r' AND n.nspname NOT LIKE 'pg\\_%' ) )
>  ORDER BY TABLE_TYPE,TABLE_SCHEM,TABLE_NAME
>
> Row with ** make problem
> I try < AND n.nspname like 'snpe' > and it work.
>
> Who will resolve : Netbeans or Postgresql JDBC people ?
>
> regards
> Haris Peco
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster