[GENERAL] 6.5.1 possibly lost rows

1999-07-29 Thread Brian Curnow
Hello, I have a table with: A DEFAULT sequence number A rule that causes a NOTIFY on insert A spawned process that does one INSERT on the table per spawning. Two processes LISTENing for INSERTs, one of which does a single UPDATE after processing. Last night I had four consecutive INSERTs on

Re: [GENERAL] 6.5.1 possibly lost rows

1999-07-29 Thread James Thompson
On Thu, 29 Jul 1999, Brian Curnow wrote: 1) An INSERT statement that fails before completion can still use up a sequence # I'm thinking this is what happened. It seems to me postgresql would need to read the sequence value generator before it could perform the insert. Once a sequence

[GENERAL] PG95 module for Apache1.3.x..?

1999-07-29 Thread David HM Spector
Does anyone know of a current Postgres module for Apache..? The only one I've been able to find is for apache 1.2 and doesn't compile with the current sources. Any pointers or ideas would be appreciated. _DHMSpector --

Re: [GENERAL] PG95 module for Apache1.3.x..?

1999-07-29 Thread Gilles Darold
David HM Spector wrote: Does anyone know of a current Postgres module for Apache..? The only one I've been able to find is for apache 1.2 and doesn't compile with the current sources. I'm not sure of what you are searching for but I think Perl is good enought to work with Apache take a look

Re: [GENERAL] PG95 module for Apache1.3.x..?

1999-07-29 Thread The Hermit Hacker
Am running this with Apache 1.3.x and PostgreSQL 6.5 ... One major problem I have with this, and haven't figured a way around, is that, with this, you secure your web page, but you database is insecure...user nobody has to have access to the database... == hub# more README Mod_auth_pgsql

[GENERAL] Slashdot...

1999-07-29 Thread The Hermit Hacker
Does anyone know what you have to do to get anything on slashdot? When v6.5 and v6.5.1 was released, I posted something to Slashdot announcing it, especially considering that the new MVCC code added by Vadim... I just did a look around Slashdot, and the newest thing is a notice about v6.3,

Re: [GENERAL] Slashdot...

1999-07-29 Thread Michael Simms
Does anyone know what you have to do to get anything on slashdot? When v6.5 and v6.5.1 was released, I posted something to Slashdot announcing it, especially considering that the new MVCC code added by Vadim... To get anything on /. you need to have a very big stick and live close to rob

[GENERAL] Large Object questions...

1999-07-29 Thread Howie
im in the process of converting a client from mysql to postgres. this client has been storing images ( jpegs, gifs ) in their mysql database in a BLOB field. the image is then shown to their staff via the web. oddly enough, no, its not porn. so, in the process of doing all these massive

Re: [GENERAL] Large Object questions...

1999-07-29 Thread William Drury
I have never understood why people would store binary data in an SQL database. Am I missing something? On Fri, 30 Jul 1999, Howie wrote: im in the process of converting a client from mysql to postgres. this client has been storing images ( jpegs, gifs ) in their mysql database in a BLOB

[GENERAL] Build without generating shared libraries

1999-07-29 Thread Manuel Lemos
Hello, Is it possible to build PostgreSQL without generating to shared libraries? If so, how? If not, are there any plans to support that as a configure option? Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED] --

Re: [GENERAL] Large Object questions...

1999-07-29 Thread John Huttley
You just haven't met the right application yet. in the manual there is a discussion on other methods that were previosly used. The PG system is good, with minor limitations in the lo* API. I'm busy writing a faxserver application where all the fax page data is stored as a blob. Its just so

[GENERAL] netmask

1999-07-29 Thread Oleg Sharoiko
Hello! I think this is a bug. But it's said not to report any bugs unless you're sure that it's a bug, so I'm asking heer is this a bug? template1= select netmask('10.0.0.1/0'); netmask --- 255.255.255.255 (1 row) This happens because word shift uses only 5 low bits of

[GENERAL] error question

1999-07-29 Thread Christopher Hutton
Hello, I am receiving the following error quite a bit lately. I am connecting vi perl and Pg. What could I do to prevent this error if anything. Error-WARN:WaitOnLock: error on wakeup - Aborting this transaction Thanks. -- Christopher Hutton (847) 265-2028 "PocketCard, the best way to carry