Good point. anyway, you can always force a column type using the sql-type attribute.
> I think the reason why is that Postgres does not limit the number of > characters in a VARCHAR field (like Oracle, who limits VARCHAR2 to 4000 > characters). Because Postgres doesn't limit VARCHAR, there is no way to > tell what is a good limit to convert to text. Is it 4000 characters like > Oracle limits? Or is it 4500 or 6000 or even 10,000? There would need to > be an agreed heuristic to determine the number, and if such heuristic is > chosen, how are we to ensure that it doesn't conflict with someone's > (pre-existing) Postgres database schema? That is, what if Joe Blow db > administrator has a column in postgres that is declared as VARCHAR(5000), > and we set our "cut-off" conversion point to 4000? His SQL would break, > because the jdbc code would use a java.sql.Types.CLOB parameter (for > postgres "text") instead of a java.sql.Types.VARCHAR parameter (which is > what Joe Blow was expecting). > > Les > >> -----Original Message----- >> From: Gavin King [mailto:[EMAIL PROTECTED] >> Sent: Tuesday, August 26, 2003 3:57 PM >> To: Frank Febbraro >> Cc: [EMAIL PROTECTED] >> Subject: Re: [Hibernate] Postgres Text Type >> >> >> Its just part of the Dialect. If you have suggestions for >> improvements to the Dialect, why not submit a patch to JIRA >> >> >> > I am using Hibernate 1.2.3 with Postgres 7.2.3. >> > >> > In the past when using Hibernate with MySql after a vertain size of >> > String type the generated DDL would oncvert from VARCHAR to TEXT. >> > However that is not the case with Postgres.. is there a >> reason why? An >> > oversight? >> > VARCHAR(45000) seems silly when Postgres supports TEXT. >> > >> > Thanks for any insight, >> > Frank >> > >> > >> > >> > >> > ------------------------------------------------------- >> > This SF.net email is sponsored by: VM Ware >> > With VMware you can run multiple operating systems on a single >> > machine. WITHOUT REBOOTING! Mix Linux / Windows / Novell virtual >> > machines at the same time. Free trial click >> > here:http://www.vmware.com/wl/offer/358/0 >> > _______________________________________________ >> > hibernate-devel mailing list [EMAIL PROTECTED] >> > https://lists.sourceforge.net/lists/listinfo/hibernate-devel >> > >> >> >> >> ------------------------------------------------------- >> This SF.net email is sponsored by: VM Ware >> With VMware you can run multiple operating systems on a >> single machine. WITHOUT REBOOTING! Mix Linux / Windows / >> Novell virtual machines at the same time. Free trial click >> here:http://www.vmware.com/wl/offer/358/0 >> _______________________________________________ >> hibernate-devel mailing list [EMAIL PROTECTED] >> https://lists.sourceforge.net/lists/listinfo/hibernate-devel >> > ------------------------------------------------------- This SF.net email is sponsored by: VM Ware With VMware you can run multiple operating systems on a single machine. WITHOUT REBOOTING! Mix Linux / Windows / Novell virtual machines at the same time. Free trial click here:http://www.vmware.com/wl/offer/358/0 _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
