Re: Roadmap for FE/BE protocol redesign

Justin Clift wrote:

[ ... ]

> The problem Dave is suggesting this as a first attempt at a solution for
> is that with ODBC, a frontend (i.e. OpenOffice) asks the ODBC driver
> which columns are NULLable, etc. And the ODBC driver is getting the
> info wrong, then passing back the incorrect info.

And that's probably why OpenOffice doesn't allow you to update a view,
event if there are rules allowing this from psql ...

This, in my book is an EPITA for end users ...

> So, when a person goes to insert a row into a table with a
> SERIAL/SEQUENCE based column, OpenOffice has been told the column isn't
> NULLable and forces the user to enter a value. Voila, it doesn't work
> with sequences. :(
>
> It's likely possible to add to the ODBC driver some way of getting the
> info right, but Dave is also looking for a way of making this easier
> into the future for similar problems. i.e. Let the database explicitly
> have info about what each column can do.

I'd second that, even if it takes time ...

Emmanuel Charpentier

--
Emmanuel Charpentier