[GENERAL] How to build pgsql without producing the shared lib libpg.so?

1999-10-20 Thread Yan Zhang Chen
Hi all! Due to some reason, I need to build pgsql without producing the shared lib libpg.so. Is there a configure option for disabling producing the shared lib? If not, I guess I would need to modify some config/Makefiles; what would be the appropriate way? Thanks for your help, --Yan *

[GENERAL] How to unlock a table after client dies during a transaction?

1999-10-20 Thread Ting Zhou
Hi, My client application dies during a transaction ( insert into a table ). Next time when connect to psql again and try to operate on the same table, it's trapped in a deadlock scenario. Is there any way to unlock the table? And another problem is that if psql exit unexpectedly during a cl

Re: [GENERAL] Postgres INSERTs much slower than MySQL?

1999-10-20 Thread Lincoln Yeoh
At 04:38 PM 20-10-1999 +0800, Vadim Mikheev wrote: >You hit buffer manager/disk manager problems or eat all disk space. >As for "modifying" - I meant insertion, deletion, update... There was enough disk space (almost another gig more). So it's probably some buffer manager problem. Is that the pos

Re: [GENERAL] Postgres INSERTs much slower than MySQL?

1999-10-20 Thread Gene Selkov, Jr.
> NOTICE: BufferAlloc: cannot write block 990 for joblist/central Whenever I saw this error it was caused by the full filesystem in the data/base/ directory. --Gene

[GENERAL] jdbc small example

1999-10-20 Thread soundar rajan
Hi all, If someone can tell me how to start with, connecting java to postgresql. I suppose I'm right. But, I get some errors. import java.sql.*; public class jd{ public static void main(String[]a rgs){ Class.forName("postgresql.Driver"); String url = "j

[GENERAL] jdbc small example

1999-10-20 Thread soundar rajan
Hi all, If someone can tell me how to start with, connecting java to postgresql. I suppose I'm right. But, I get some errors. import java.sql.*; public class jd{ public static void main(String[]a rgs){ Class.forName("postgresql.Driver"); String url = "j

[GENERAL] jdbc small example

1999-10-20 Thread soundar rajan
Hi all, If someone can tell me how to start with, connecting java to postgresql. I suppose I'm right. But, I get some errors. import java.sql.*; public class jd{ public static void main(String[]a rgs){ Class.forName("postgresql.Driver"); String url = "j

[GENERAL] PHP Database Driven Websites User Group- Atlanta, GA

1999-10-20 Thread Scott Perkins
fm: Scott Perkins, Coordinator, Atlanta PHP Database driven Websites User Group [EMAIL PROTECTED] 770 / 973-3860 The Atlanta Linux General Store has offered to host our website and we are working out the details of a coursework/curriculum that will be offered regarding PHP and open source datab

[GENERAL] Neverending query on 6.5.0 over Solaris 2.5.1

1999-10-20 Thread Fernando Schapachnik
Hello: Maybe somebody could give some clue about what is happening: I have 6.5.0 running over Solaris 2.5.1 SPARC. I have a database with 5 tables, 3 of them < 100 regs. and 2 ("usuarios" and "passwd") with >1. When querying for: SELECT u.nombre_cuenta, per.nombre, pas.clav

Re: [GENERAL] Postgres INSERTs much slower than MySQL?

1999-10-20 Thread Vadim Mikheev
Lincoln Yeoh wrote: > > At 04:12 PM 20-10-1999 +0800, Vadim Mikheev wrote: > >It doesn't seem as MVCC problem. MVCC uses transaction ids, > >not tuple ones, and so should work with any number of rows > >modified by concurrent transaction... In theory... -:)) > > OK. Dunno what I hit then. I wasn

Re: [GENERAL] Postgres INSERTs much slower than MySQL?

1999-10-20 Thread Lincoln Yeoh
At 04:12 PM 20-10-1999 +0800, Vadim Mikheev wrote: >It doesn't seem as MVCC problem. MVCC uses transaction ids, >not tuple ones, and so should work with any number of rows >modified by concurrent transaction... In theory... -:)) OK. Dunno what I hit then. I wasn't modifying rows, I was inserting

Re: [GENERAL] Postgres INSERTs much slower than MySQL?

1999-10-20 Thread Vadim Mikheev
Lincoln Yeoh wrote: > > It's now a lot faster. Now only about 5 or so times slower. Cool. > > But it wasn't unexpected that I got the following after a while ;). > > NOTICE: BufferAlloc: cannot write block 990 for joblist/central > > NOTICE: BufferAlloc: cannot write block 991 for joblist/ce