Thread: Strange column naming problem
Hello, We have encountered a really strange column naming problem. Basically, when creating a table, any columns beginning with the prefix -"rem" will not be created. Columns without that prefix are created normally. For example, if I have 10 columns in my table and 2 of them have names prefixed with "rem", only 8 columns will be created at the end. There is no error message. I tried running the same statement using PGAdmin and the table get created correctly. The problem seems to be with JDBC drivers. I am running 7.3.2 and JDBC3 drivers on JDK1.4.1. Please help. Thanks. _________________________________________________________________ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail
Can you submit a test case for this? --Barry anon permutation wrote: > > > Hello, > > We have encountered a really strange column naming problem. Basically, > when creating a table, any columns beginning with the prefix -"rem" will > not be created. Columns without that prefix are created normally. For > example, if I have 10 columns in my table and 2 of them have names > prefixed with "rem", only 8 columns will be created at the end. There > is no error message. > > I tried running the same statement using PGAdmin and the table get > created correctly. The problem seems to be with JDBC drivers. I am > running 7.3.2 and JDBC3 drivers on JDK1.4.1. > > Please help. Thanks. > > _________________________________________________________________ > Add photos to your messages with MSN 8. Get 2 months FREE*. > http://join.msn.com/?page=features/featuredemail > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >
Hi, I found that we are using an old torque library that is causing the problem. It is now fixed. Thanks anyway. >From: Barry Lind <blind@xythos.com> >To: anon permutation <anonpermutation@hotmail.com> >CC: pgsql-jdbc@postgresql.org >Subject: Re: [JDBC] Strange column naming problem >Date: Mon, 12 May 2003 09:07:16 -0700 > >Can you submit a test case for this? > >--Barry > >anon permutation wrote: >> >> >>Hello, >> >>We have encountered a really strange column naming problem. Basically, >>when creating a table, any columns beginning with the prefix -"rem" will >>not be created. Columns without that prefix are created normally. For >>example, if I have 10 columns in my table and 2 of them have names >>prefixed with "rem", only 8 columns will be created at the end. There is >>no error message. >> >>I tried running the same statement using PGAdmin and the table get created >>correctly. The problem seems to be with JDBC drivers. I am running 7.3.2 >>and JDBC3 drivers on JDK1.4.1. >> >>Please help. Thanks. >> >>_________________________________________________________________ >>Add photos to your messages with MSN 8. Get 2 months FREE*. >>http://join.msn.com/?page=features/featuredemail >> >> >>---------------------------(end of broadcast)--------------------------- >>TIP 2: you can get off all lists at once with the unregister command >> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >> > > >---------------------------(end of broadcast)--------------------------- >TIP 5: Have you checked our extensive FAQ? > >http://www.postgresql.org/docs/faqs/FAQ.html _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus