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
>
> 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
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:
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
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:
>
> 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
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
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 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
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
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
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
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 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
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 &
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
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
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.\
> 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
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
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
22 matches
Mail list logo
