Hi Andrew, Ocke already answered, but let me add a few bits.
> I know that there is already an issue for the GUI table editor not > passing default values along for bit fields but it seems not > to do so for time, date or timestamp columns also. Some time ago, there was a discussion here or on [EMAIL PROTECTED] with Jörg Budischewski (the author of the PostgreSQL SDBC driver) about this issue. The conclusion back then was that there probably needs to be a distinction between the database-default and the UI-default - ATM, OOo only has and knows the latter. As Ocke said, knowing possible defaults (plus the syntax to set them) of a given database is quite impossible in a generic, portable way. > If I try to create a timestamp column and set the default to > NOW, using the GUI it failes. If I enter the create table DDL > command in the SQL window using DEFAULT NOW, it works > just fine. Looking at this table later in the table design window, > the default value field is again empty. Which is because the UI-default is not the database-default you just created ... > So, should I add this to the issue for bit fields or enter a new > issue? Or is there already one there. Hard to judge without knowing the number of the issue :) > Actually this is my other problem. Is it me (i.e. a bear of small brain) > or is it really hard to actually find things in issuzilla using the > search function? I'm quite happy with the mini-form at http://qa.openoffice.org/issue_handling/project_issues.html (plus my Firefox extension which wraps this mini-search-form in a toolbar :). The main search form sucks. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
