[BUGS] can not create database!!!!

[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 called in a transaction block 
This code work with 6.XX but does't work with 7.xx


Sample Code
#include 
#include 
#include 

int main(void)
{
  exec sql connect to template1 user postgres;
  exec sql create database test1234;
  exec sql commit;
}


No file was uploaded with this report


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

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

[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 report


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

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

[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 number puts with perl program)

4) 500 queries executes for 30 seconds

Test 2:

1) create table test_int1(id int); (i.e. without primary key)

2) insert 1 records in table test_int1 with perl program (values
1,2,3,...,1).

3) 500 times execute query

   SELECT * FROM test_int1 WHERE id = random number

   (random number puts with perl program)

4) 500 queries executes for 30 seconds too  :~-( ...


P.S. For TEXT field the same operations executes for 30 and 1 seconds
correspondingly.




---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

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

[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 program (values
> 1,2,3,...,1).
>
> 3) 500 times execute query
>
>SELECT * FROM test_int WHERE id = random number
>
>(random number puts with perl program)
>
> 4) 500 queries executes for 30 seconds
>
> Test 2:
>
> 1) create table test_int1(id int); (i.e. without primary key)
>
> 2) insert 1 records in table test_int1 with perl program (values
> 1,2,3,...,1).
>
> 3) 500 times execute query
>
>SELECT * FROM test_int1 WHERE id = random number
>
>(random number puts with perl program)
>
> 4) 500 queries executes for 30 seconds too  :~-( ...
>
>
> P.S. For TEXT field the same operations executes for 30 and 1 seconds
> correspondingly.
>
>
>
>
> ---(end of broadcast)---
> TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
>


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html