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 that the xpath
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
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).whole
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 cancel
Linuxps -ef | grep NameOfInstallProgram
Windowsctl/alt/delgo 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
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
Obviously, this
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 =
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:
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.
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 on
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'd like it to
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
get
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
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:
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
22 matches
Mail list logo