I am attempting to install the postrgresql-8.3.3-1 download on Windows Vista.
When I get to the "Ready to install" dialog and click OK, I get the message
"Another installation is in progress", and I need to click on cancel and end
the installation -- otherwise I am in a loop. This happens even
Hi Fellows
I still have problem to access my databank.It shows syntax problem,I am using
VC++ 2005 with postgresql 8.3.My table name is Person and it has three
column,Person ID,first name and last name (testing version).whole c++ code is
// Test_postgres.cpp : Defines the entry point for
> Gregory Stark <[EMAIL PROTECTED]> writes:
>> That's just a special case of what would be expected to happen with
>> memory
>> allocation anyways though. Few allocators return memory to the OS
>> anyways.
>
> Well, that does happen on Linux for instance. Since Matt knew in his
> original report t
On Sun, Jul 6, 2008 at 12:04 AM, Sheikh Salman Ahmed
<[EMAIL PROTECTED]> wrote:
> res = PQexec(conn, "INSERT INTO public.Person VALUES
Without quotes around Person, it will be shifted to lower case to
match a table called person. I suspect you need to do:
res = PQexec(conn, "INSERT INTO public.\
On lau, 2008-07-05 at 23:04 +, Sheikh Salman Ahmed wrote:
> Hi Fellows
>
> I still have problem to access my databank.It shows syntax problem,I
> am using VC++ 2005 with postgresql 8.3.My table name is Person and it
> has three column,Person ID,first name and last name (testing
> version).who
On Sat, Jul 5, 2008 at 11:16 PM, Susan Crayne <[EMAIL PROTECTED]> wrote:
> I am attempting to install the postrgresql-8.3.3-1 download on Windows Vista.
> When I get to the "Ready to install" dialog and click OK, I get the message
> "Another installation is in progress", and I need to click on c
Linuxps -ef | grep NameOfInstallProgram
Windowsgo to Task Managerfrom Application Manager or Process
ManagementIf you see the install program delete
itMartin__ Disclaimer and
confidentiality note Everything in this e-mail and any attachments relates t
Hi,
I read a description of MVCC in http://www.cs.ust.hk/~dimitris/CS530/L24.ppt
and
found that this isn't exactly what is implemented in PostgreSQL. For
example,
for a sequence of operations like:
1: T1 sets isolation to serializable & begins a transaction
2: T2 sets isolation to serializable &
Thanks for your prompt response. Actually, I solved the problem after posting.
When I got to the "Ready to Install" dialog, in the Task Manager, there were 4
instances of msiexec.exe running. I experimented with deleting 3 of them. At
first, I killed the whole install, but finally I deleting
Kent Tong <[EMAIL PROTECTED]> writes:
> 1: T1 sets isolation to serializable & begins a transaction
> 2: T2 sets isolation to serializable & begins a transaction
> 3: T1 reads X into v1
> 4: T2 reads Y into v2
> 5: T1 writes v1 into Y
> 6: T2 writes v2 into X
> 7: T1 commits
> 8: T2 commits
> Obvi
Thanks for the tips. I've created separate log files for the two
versions of pg, but postmaster still won't start.
When I try to start 8.3, the log file lists a fatal error in the
postgresql.conf file. But there are no obvious errors in that file.
Line 107 reads: "shared_buffers = 1600
Scott Frankel <[EMAIL PROTECTED]> writes:
> When I try to start 8.3, the log file lists a fatal error in the
> postgresql.conf file. But there are no obvious errors in that file.
> Line 107 reads: "shared_buffers = 1600kB".
You need quotes, like
shared_buffers = '1600kB'
> FATAL: i
Dear list,
I need some tips and/or pointers to relevant documentation implementing (what I
chose to call) "a perfect sequence" i.e. a sequence that has no missing numbers
in the sequence. I'd like it to auto increment on insert, and auto decrement
everything bigger than its value on delete. The
On Sun, Jul 6, 2008 at 6:15 PM, Jack Brown <[EMAIL PROTECTED]> wrote:
> Dear list,
>
> I need some tips and/or pointers to relevant documentation implementing (what
> I chose to call) "a perfect sequence" i.e. a sequence that has no missing
> numbers in the sequence. I'd like it to auto increment
Jack Brown wrote:
Dear list,
I need some tips and/or pointers to relevant documentation implementing (what I chose to
call) "a perfect sequence" i.e. a sequence that has no missing numbers in the
sequence. I'd like it to auto increment on insert, and auto decrement everything bigger
than its
On Sun, Jul 6, 2008 at 7:33 PM, Berend Tober <[EMAIL PROTECTED]> wrote:
> Jack Brown wrote:
>>
>> Dear list,
>>
>> I need some tips and/or pointers to relevant documentation implementing
>> (what I chose to call) "a perfect sequence" i.e. a sequence that has no
>> missing numbers in the sequence. I
Tom Lane-2 wrote:
>
> If you want that to fail, use a SELECT FOR UPDATE at steps 3/4.
>
> My interpretation of MVCC is that the above example isn't even
> meaningful, because it assumes that "writing into Y" is an overwrite,
> which it is not in Postgres --- that is, if T2 reads Y again, it'll
Kent Tong <[EMAIL PROTECTED]> writes:
> Is MVCC not well defined?
It's not defined by the SQL standard, nor any other standard that I know
of. So yes, different implementations might mean subtly different
things by it.
regards, tom lane
--
Sent via pgsql-general mailing
Tom Lane-2 wrote:
>
> It's not defined by the SQL standard, nor any other standard that I know
> of. So yes, different implementations might mean subtly different
> things by it.
>
OK, I see. Where can I find out the precise meaning of MVCC as in
PostgreSQL. I've read
http://www.postgresql.o
Is there any quick hacks to do this quickly? There's around 20-30million
rows of data.
I want to change a column type from varchar(4) to varchar(5) or should I
just use text instead.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http:
>
> is there any quick hacks to do this quickly? There's around 20-30million
> rows of data.
>
> I want to change a column type from varchar(4) to varchar(5) or should I
> just use text instead.
>
ALTER TABLE tablename ALTER COLUMN columnname TYPE VARCHAR(5);
HTH.
-
Eric
Sorry to drag this on further. Though I'm now able to start pg8.3
again (thanks!), I still can't launch pg8.1. Rolling back to 8.1 is
my goal in order to work around a driver issue in Qt.
Is there an example postgresql.conf file for pg 8.1 I can review?
Mine appears to be valid only fo
22 matches
Mail list logo
