Re: [GENERAL] libpq.dll causing access violation

2005-05-14 Thread Raymond O'Donnell
On 14 May 2005 at 19:41, Raymond O'Donnell wrote: > I'm using version 8.0.1 of PostgreSQL, running under Windows XP Pro > on my laptop, and libpg.dll is version 8.0.1 also. I should have added that I'm using the Vita Voom (commercial) dbExpress driver for PostgreSQL. --Ray. --

[GENERAL] libpq.dll causing access violation

2005-05-14 Thread Raymond O'Donnell
Hello all, I hope this is the correct forum for this problem - please point me the right way if not. I'm developing a Windows application using Delphi 6, talking to the Windows version of PostgreSQL. I have a master-detail relationship between two tables: Delphi implements this using a nested

Re: [GENERAL] Why is psql \copy process stuck?

2005-05-14 Thread Jack Orenstein
Tom Lane wrote: Jack Orenstein <[EMAIL PROTECTED]> writes: I'm not sure I did this right, (it's been a while since I worked with gdb). But here's what I found. Doesn't look like either of those can be trusted very far :-(. But both of them seem to be waiting for input. What this looks like to me

Re: [GENERAL] Why is psql \copy process stuck?

2005-05-14 Thread Tom Lane
Jack Orenstein <[EMAIL PROTECTED]> writes: > I'm not sure I did this right, (it's been a while since I worked with > gdb). But here's what I found. Doesn't look like either of those can be trusted very far :-(. But both of them seem to be waiting for input. What this looks like to me is some kin

Re: [GENERAL] Why is psql \copy process stuck?

2005-05-14 Thread Jack Orenstein
Tom Lane wrote: Jack Orenstein <[EMAIL PROTECTED]> writes: 21167 ?S 0:00 /usr/local/pgsql/bin/psql -h 10.3.1.154 mydb -U username -c \copy sometable to stdout Why is process 21167 stuck? Are you sure it's made a connection at all? You might try attaching to it with a debugger to get

Re: [GENERAL] Why is psql \copy process stuck?

2005-05-14 Thread Tom Lane
Jack Orenstein <[EMAIL PROTECTED]> writes: > 21167 ?S 0:00 /usr/local/pgsql/bin/psql -h 10.3.1.154 mydb -U > username -c \copy sometable to stdout > Why is process 21167 stuck? Are you sure it's made a connection at all? You might try attaching to it with a debugger to get a stack

[GENERAL] Why is psql \copy process stuck?

2005-05-14 Thread Jack Orenstein
I have two postgres 7.4.6 databases, running on different hosts (Linux 2.6.11 kernel), and I'm copying data from one to the other as follows: psql -h 10.3.1.154 mydb -U username -c "\copy sometable to stdout" | \ psql mydb -U username -c "\copy sometable from stdin" Such copies are pretty f

Re: [GENERAL] Changing column data type on an existing table

2005-05-14 Thread Richard Huxton
Joe Audette wrote: Hi, I have an app that I released with a particular field as varchar 255. Can someone give me a script example I can use to make an upgrade script to change it to text or at least to larger varchar without losing existing data? Others have answered for version 8. If you are runni