Re: Why does this not work? (finally)

From: "Johann Zuschlag" <zuschlag(at)online(dot)de>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Why does this not work? (finally)
Date: 2002-04-11 19:24:08
Message-ID: E16vkAy-0006oR-00@mrvdomng2.kundenserver.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 11 Apr 2002 14:45:06 -0400, Tom Lane wrote:

>> Is there a solution for such a problem?
>
>Don't use varchar(n) --- use text. You can still enforce the length
>limit you want inside the trigger, if you really want a length limit
>at all.

Thanks to all, for your help. It seems it is not possible.
Ok, I go for the text solution. The only trouble is, I have
to debug my application to see what nonsense it is
trying to do. But postgresql/psqlodbc is good help doing
that.

IIRC there is no speed difference between varchar and text?

regards

Johann Zuschlag
zuschlag(at)online(dot)de

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gunther Schadow 2002-04-11 20:05:33 Re: Critical performance problems on large databases
Previous Message Jan Wieck 2002-04-11 18:53:01 Re: Why does this not work?