From: | Dave Cramer <Dave(at)micro-automation(dot)net> |
---|---|
To: | Charlie Woloszynski <chw(at)clearmetrix(dot)com> |
Cc: | snpe <snpe(at)snpe(dot)co(dot)yu>, "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>, nbdev(at)netbeans(dot)org, nbusers(at)netbeans(dot)org |
Subject: | Re: NetBeans (3.5 Dev), Postgresql 7.4dev jdbc |
Date: | 2003-04-04 14:13:46 |
Message-ID: | 1049465626.1107.358.camel@inspiron.cramers |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
SQL92 is quite old, what does sql99 say about case sensitivity?
also I'm not sure what exactly the issue is here?
as long as the names are not surrounded by ' then postgres is case
insensitive.
Dave
On Fri, 2003-04-04 at 08:53, Charlie Woloszynski wrote:
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
--
Dave Cramer <Dave(at)micro-automation(dot)net>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-04-04 15:09:44 | Re: NetBeans (3.5 Dev), Postgresql 7.4dev jdbc |
Previous Message | Charlie Woloszynski | 2003-04-04 13:53:41 | Re: NetBeans (3.5 Dev), Postgresql 7.4dev jdbc |