Updatable/Read-only columns
От | Michaël Michaud |
---|---|
Тема | Updatable/Read-only columns |
Дата | |
Msg-id | 56B65FBC.7020102@orange.fr обсуждение исходный текст |
Ответы |
Re: Updatable/Read-only columns
|
Список | pgsql-jdbc |
Hi, First of all, I'm very happy with postgresql and its jdbc driver. Recently, I wanted to access updatable views and know if some columns are read-only (like columns defined by an operation) I looked into DatabaseMataData.getColumns, but the 24.IS_GENERATEDCOLUMN attribute, defines in java7/jdbc4.1 is not availiable in the current driver which has only 23 attributes (anyway, I'm not sure what this attribute is supposed to return) I also looked into ResultSetMetaData.isReadOnly(), but it always return false. Comments say that "we would have to check the GRANT/REVOKE stuff for this to be effective". A first step could be to return if the column cannot be updatable for anybody Maybe information_schema.columns.isupdatable column could be of any help to get this information ? Best regards, Michaël
В списке pgsql-jdbc по дате отправления: