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
>
