Re: [HACKERS] RE: pgsql/src/interfaces/jdbc/org/postgresql/jdbc1 (DatabaseMetaData.java)

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
Cc: Bruce Momjian - CVS <momjian(at)hub(dot)org>, pgsql-hackers <pgsql-hackers(at)postgreSQL(dot)org>, pgsql-committers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] RE: pgsql/src/interfaces/jdbc/org/postgresql/jdbc1 (DatabaseMetaData.java)
Date: 2000-09-12 23:59:12
Message-ID: 200009122359.TAA21692@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

> > As if my JDBC patch hasn't already caused enough grief, there is now a
> > one-line change necessary. Due to the Mark Holloman "New Relkind for
> > Views" patch, my support for views in the driver will need to be updated
> > to match. The change to DatabaseMetaData.getTableTypes[][] is as
> > follows:
> >
> > - {"VIEW", "(relkind='r' and relhasrules='t' and relname !~
> > '^pg_' and relname !~ '^xinv')"},
> > + {"VIEW", "(relkind='v' and relname !~ '^pg_' and relname
> > !~ '^xinv')"},
> >
>
> Current jdbc driver seems to be able to get no VIEW information
> from any RELEASE version of backends.
>
> Hmm,it seems that client app/libs don't mind backward incompatibility.
> Don't I have to bother about backward incomatibility which would be
> caused by my change ?
> If so,I would commit my change about ALTER TABLE DROP COLUMN.

So the issue is how to make the 7.1 jdbc driver handle views from >=7.1
databases, and <7.1 databases. Good question.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Mount 2000-09-13 01:17:05 Re: [HACKERS] RE: pgsql/src/interfaces/jdbc/org/postgresql/jdbc1 (DatabaseMetaData.java)
Previous Message Hiroshi Inoue 2000-09-12 23:46:39 RE: pgsql/src/interfaces/jdbc/org/postgresql/jdbc1 (DatabaseMetaData.java)

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2000-09-13 00:41:45 Re: Status of new relation file naming
Previous Message Hiroshi Inoue 2000-09-12 23:46:39 RE: pgsql/src/interfaces/jdbc/org/postgresql/jdbc1 (DatabaseMetaData.java)