Re: [BUGS] the index on INTEGER field does not work (PG 7.1.2)

2001-06-14 Thread Andrew Snow
Please see FAQ 4.9 http://postgresql.bteg.net/docs/faq-english.html#4.9 On Fri, 15 Jun 2001, Alexandr S. wrote: > > Bug: the index on INTEGER field does not work (PG 7.1.2). > > Test 1: > > 1) create table test_int(id int primary key); > > 2) insert 1 records in table test_int with perl

[BUGS] the index on INTEGER field does not work (PG 7.1.2)

2001-06-14 Thread Alexandr S.
Bug: the index on INTEGER field does not work (PG 7.1.2). Test 1: 1) create table test_int(id int primary key); 2) insert 1 records in table test_int with perl program (values 1,2,3,...,1). 3) 500 times execute query SELECT * FROM test_int WHERE id = random number (random numb

[BUGS] sqlca.sqlcode doesn't work in 7.xx

2001-06-14 Thread pgsql-bugs
scottc ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description sqlca.sqlcode doesn't work in 7.xx Long Description sqlca.sqlcode work in version 6.xx but doesn't work in version 7.xx Sample Code No file was uploaded with this repor

[BUGS] can not create database!!!!

2001-06-14 Thread pgsql-bugs
scott cao ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description can not create database Long Description Can not create database I don't have an explicit transaction block in progress. ERROR: CREATE DATABASE: may not be call