Skip site navigation (1) Skip section navigation (2)

Re: General Questions about PG

From: John Koller <johnckoller(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: General Questions about PG
Date: 2006-11-27 03:10:54
Message-ID: vi1q34-3jb.ln1@mirror.cluebuilder.com (view raw or flat)
Thread:
Lists: pgsql-novice
Relaxin wrote:

> Can someone help with this...please?
> 
> "Relaxin" <me(at)yourhouse(dot)com> wrote in message
> news:ejraqt$2m5u$1(at)news(dot)hub(dot)org(dot)(dot)(dot)
>> (NOTE: This is for the Windows version of PG)
>>
>> I'm looking for a replacement for SQLBase, and I have a few questions
>> about PG.
>>
>>
>> 1. Is PostgreSQL OS multi-threaded?
>> 2. Does PG support bi-directional resultsets.  (i.e. If I'm record 4,
>>
>> can I do "Prior" to re-access record 3?)
>>
>> 3. Does PG have the concept of a Record Indentifier (ROWID) by which
>> can be used to update or delete a record?
>>           (i.e.
>>                 1. SELECT first_name,  ROWID from customer.
>>                  2. <Results  are>
>>                    Paul,  0x123456780
>>                    Mike, 0x123456781
>>                    John, 0x123456782
>>                3. DELETE FROM customer WHERE rowid = 0x123456781;
>> //Delete 'MIKE' from the table
>>
>>
>> Thank you...
>>
>>
1. No, it uses processes.

http://www.postgresql.org/files/documentation/books/
aw_pgsql/hw_performance/node12.html

3. You can create a column of type serial.

http://www.postgresql.org/docs/8.1/interactive/datatype.html#DATATYPE-SERIAL

-- 
John Koller

pgsql-novice by date

Next:From: operationsengineer1Date: 2006-11-27 03:35:06
Subject: Re: Benchmarking PostgreSQL against others on Windows?
Previous:From: Andrej Ricnik-BayDate: 2006-11-26 23:20:43
Subject: Re: Benchmarking PostgreSQL against others on Windows?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group