| From: | Kris Jurka <books(at)ejurka(dot)com> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us> |
| Cc: | Juho Saarikko <juhos(at)mbnet(dot)fi>, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #3965: UNIQUE constraint fails on long column values |
| Date: | 2008-02-19 00:26:14 |
| Message-ID: | Pine.BSO.4.64.0802181914100.11576@leary.csoft.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-docs |
On Mon, 18 Feb 2008, Bruce Momjian wrote:
> Juho Saarikko wrote:
>> While I didn't test, I'd imagine that this would also mean that any attempt
>> to insert such values to an already unique column would fail.
>
> Works here in 8.3:
>
> test=> insert into test values (repeat('a', 50000) || 'b');
>
This only works because it gets toasted before being put in the index.
Since you've selected something real compressible, you can fit 50k chars
into it.
Kris Jurka
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ITAGAKI Takahiro | 2008-02-19 12:16:14 | BUG #3969: pg_ctl cannot detect server startup |
| Previous Message | Juho Saarikko | 2008-02-18 23:21:11 | Re: BUG #3965: UNIQUE constraint fails on long column values |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2008-02-20 08:54:50 | Re: BUG #3965: UNIQUE constraint fails on long column values |
| Previous Message | Juho Saarikko | 2008-02-18 23:21:11 | Re: BUG #3965: UNIQUE constraint fails on long column values |