From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | Ana Claudia <ana-b-dias(at)ptinovacao(dot)pt> |
Cc: | "'pgsql-bugs(at)postgresql(dot)org'" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: |
Date: | 2001-09-27 17:55:30 |
Message-ID: | Pine.BSF.4.21.0109271054560.21569-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Mon, 24 Sep 2001, Ana Claudia wrote:
> Hello,
>
> Usually, I use Oracle for develop database application. However, I
> change my computer to Linux system (Mandrake 8) and I decide change database
> to Postgresql.
> In Oracle when I create a table where a colum is a char(n) or varchar(n), if
> I try to insert in this table value bigger than n , I get an error. That
> doesn't happen in Postgresql, if I try to insert a value bigger than n, it's
> accept because trunk the value. I don't want that, if the value is bigger I
> want an error. I created a check constraint with the function [char_length
> (parameter) < (n+1)] but still not working. Can you help me to resolve this
> problem? The version of Postgresql that I have is 7.1.2.
I believe this will be fixed in the upcoming 7.2 release. The reason the
constraint doesn't work is probably that the truncation happens before the
check.
From | Date | Subject | |
---|---|---|---|
Next Message | pgsql-bugs | 2001-09-27 18:32:50 | Bug #472: Cant get source from website for 7.2 |
Previous Message | Bruce Momjian | 2001-09-27 17:17:12 | Re: |