On Thu, Aug 20, 2009 at 12:41 AM, JwexlerAt
MailDotCom<jwexler@mail.usa.com> wrote:
> The error often happens after I have created a number of columns and then creating the two timestamp with timezone
columnsat which the error seams to appear most. Naming convention is lower case first word, then capital first
characterof subsequent words. Table creation is generally as such (toggling between Excel 2007 and pgAdminIII at every
step(I use the Excel datamodel to manage the design/changes/planning etc of the db due to the inability of PostgreSQL
toallow for easily re-order positions of columns as well as some other reasons).
> * Create table
> * Create a bigserial, non-null column called "serialNumInt" (This is the primary key on all tables with the exception
ofmany-to-many tables)
> * Create a text column called "recordDescriptiveCodeStr". Add a comment to it after creation.
> * On many-to-many tables, create two bigint, non-null columns. Then make them jointly the primary key. Add separate
foreignkeys to each (using the default settings for the foreign keys). Add a comment to some of them after creation.
> * Add a bigint column, null ok. Add a foreign key for this column (using default settings for the foreign key).
> * Create various text, bigint, and double precision columns (depending on the table)
> * Create 3 text columns
> * Create a bigint column
> * Create the two "timestamp with time zone" columns. Each have a comment (6 words for the first one, 7 words for the
secondone).
> The termination is intermittent. Usually, there is no termination. When there is one, it seems most often during the
creationof the second "timestamp with time zone" column (i.e., the last column of the table).
What encoding/locale is your database using?
Hiroshi/Quan - are either of you able to reproduce this issue? I'm
wondering if this is something specific to Japanese Windows/locales
etc.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com