RE: [SQL] psql problem

Does anyone know why when I am in a particular DB as user postgres and use the following statement, why I get this error?" This is the statement; SELECT * FROM some_file where ID = 1; [Volker Paul] If your ID field is really uppercase, try: SELECT * FROM some_file where "ID" = 1; Cheers, Vol

[SQL] SPEED UP.

I would like to know is there is a specific way to speed up my query to postgres. I have a DB-MACHINE that I use just and only for postgres witch runs linux RedHad 6.2 with 1Gb of RAM on ULTRA SCSI discs. I run vacuum every hour, but there is something else I can do (compile postgres in a spec

Antw: [SQL] Insert with replace?

Wampler, Steve wrote: > ... > I've got a database that (logically) represents a set of > items, where each item has a primary key represented by two > columns (id and name). If that key isn't in the database, > I want to insert the item. If that key is in the database, I want > to update the i

[SQL] pg_recvbuf : unexpected EOF on client

I have an application in Java I use to insert records into postgreSQL base. Java shows no errors, butrecords can't write into base.In pgsqrever.log I found entry :pg_recvbuf : unexpected EOF on client connection.   Thanks for any help. Adam

Re: [SQL] SPEED UP.

Lets see your queries you're running and their plan, I'd bet there are ways to speed them up (that's always been the case with mine!).. fields - Mitch "The only real failure is quitting." - Original Message - From: Alessandro Rossi <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Fri

Re: [SQL] SPEED UP.

> > > I would like to know is there is a specific way to speed up my query to > postgres. Please post the exact command line arguments you are giving when you start the postmaster daemon process. Cordially Patrick Giagnocavo [EMAIL PROTECTED]

[SQL] Deferral of primary key constraint

Is it possible to defer the check on a primary key constraint (or a check constraint, for that matter).  Here is an example that shows why it would be nice to be able to do so.  We have a real-life scenario that is similar (but much more complex). drop table btab; create table btab (     base

[SQL] Benchmark

Is there anywhere I can find some benchmark test for postgres. The reason is that I want to use it for a site that could have several simultanous users querying the database and I want to be sure that it is stable (and fast) enough to handle that kind of (ab)use. Also which is fastest ? 1. A

[SQL] Re: Deferral of primary key constraint

Kyle Bateman wrote: > Is it possible to defer the check on a primary key constraint (or a > check constraint, for that matter). Here is an example that shows why > it would be nice to be able to do so. We have a real-life scenario that > is similar (but much more complex). Not yet. Only

Re: [SQL] Benchmark

Nikolaj Lundsgaard wrote: > Is there anywhere I can find some benchmark test for postgres. The reason is that I >want to use it for a site that could have several simultanous users querying the >database and I want to be sure that it is stable (and fast) enough to handle that >kind of (ab)use.

Re: [SQL] SQL'92 web resources

Bruce Momjian writes: > Shouldn't we have links to these on our web site? SQL92 is yesterday's news. Find your SQL99 documents at: ftp://jerry.ece.umassd.edu/isowg3/x3h2/Standards/ (Though I'm unsure about the legality of these.) -- Peter Eisentraut Sernanders väg 10:115 [E

Re: [SQL] SQL'92 web resources

> Bruce Momjian writes: > > > Shouldn't we have links to these on our web site? > > SQL92 is yesterday's news. Find your SQL99 documents at: > > ftp://jerry.ece.umassd.edu/isowg3/x3h2/Standards/ Yes, all I am saying is that we need to get these onto our web page. -- Bruce Momjian