On 09.02.2013 22:25, matti.aar...@methics.fi wrote:
CREATE TABLE example (
a TIMESTAMPNOT NULL,
b VARCHAR(256) NOT NULL,
c VARCHAR(256) NOT NULL,
PRIMARY KEY(a,b,c)
);
Inserting a duplicate record on this is returning an SQL Error, but the
status code is 0 instead of ex
On 11.02.2013 17:34, Matti Aarnio wrote:
} catch (SQLException e) {
int code = e.getErrorCode();
if (code == 2 // Derby
|| code == 23505) {// PostgreSQL, Oracle, ...
System.out.println("Expected SQL duplicate insert indication
status code: "+code)
}
The following bug has been logged on the website:
Bug reference: 7867
Logged by: Michele Baravalle
Email address: michele.barava...@me.com
PostgreSQL version: 9.2.3
Operating system: Mac OSX 10.8
Description:
Using this sql:
SELECT similarity('Круиз-контроль отключен
On 02/11/2013 02:11 PM, Heikki Linnakangas wrote:
> Works for me:
>
> postgres=# do $$
> begin
> insert into example values ('2001-01-01', 'foo', 'bar');
> insert into example values ('2001-01-01', 'foo', 'bar');
> exception
> when others then raise notice 'caught %', sqlstate;
> end;
> $$;
>
On 02/11/2013 05:34 PM, Matti Aarnio wrote:
> On 02/11/2013 02:11 PM, Heikki Linnakangas wrote:
>> Works for me:
>>
>> postgres=# do $$
>> begin
>> insert into example values ('2001-01-01', 'foo', 'bar');
>> insert into example values ('2001-01-01', 'foo', 'bar');
>> exception
>> when others
michele.barava...@me.com writes:
> Using this sql:
> SELECT similarity('ÐÑÑиз-конÑÑÐ¾Ð»Ñ Ð¾ÑклÑÑен',
> 'ÐÑÑиз-конÑÑÐ¾Ð»Ñ Ð¾ÑклÑÑен');
> work well on Linux and Windows and the result is 1: on OSX the result is
> NaN.
I couldn't reproduce that on my own Mac. I
On 02/11/2013 07:52 PM, Heikki Linnakangas wrote:
> On 11.02.2013 17:34, Matti Aarnio wrote:
>>} catch (SQLException e) {
>>int code = e.getErrorCode();
>>if (code == 2 // Derby
>> || code == 23505) {// PostgreSQL, Oracle, ...
>> System.out.println("Expec
