Re: [GENERAL] leaking FD's ?

1999-10-05 Thread Michael Simms
> > Hi > > > > I am running a process that does a fair number of selects and updates but > > nothing too complex. > > > > I have the postmaster starting like such: > > > > /usr/bin/postmaster -o "-F -S 10240" -d 1 -N 128 -B 256 -D/var/lib/pgsql/data -o >-F > /tmp/postmasterout 2> /tmp/postmast

[GENERAL] User Gallery in a mess

1999-09-23 Thread Michael Simms
Hi Has anyone looked at the user gallery recently? Its a bit of a mess. You need to clean up some of the entries, such as the one where all fields were filled in with testing_shit Also, you need to make sure that if the URL entry doesnt start off with a protocol, you add http:// to the start, c

Re: [GENERAL] data type "serial"

1999-09-22 Thread Michael Simms
> > > > > > > So how do you store something in data type serial? > > > I've created the column but everytime I attempt to do an update I get > > > back the error message that I can't store a duplicate key. > > > > > > table_col_seq.last_value = 1 > > > increment = 1 > > > maxvalue = 2billion s

Re: [GENERAL] data type "serial"

1999-09-22 Thread Michael Simms
> > So how do you store something in data type serial? > I've created the column but everytime I attempt to do an update I get > back the error message that I can't store a duplicate key. > > table_col_seq.last_value = 1 > increment = 1 > maxvalue = 2billion something > > I've tried storing 1,

Re: [GENERAL] max() question

1999-09-14 Thread Michael Simms
> > On Tue, 14 Sep 1999, you wrote: > > I have a table with and email address and a datetime timestamp. What > > would be the easiest way to select the 3 earliest timestamps (earliest > > being furthest in the past from the current date) > > lots of ways =) though the first that comes to mind i

[GENERAL] Bug-tracking

1999-08-31 Thread Michael Simms
Hi I was wondering what the situation is with the bugtracking system, cos there are a number of serious bugs that havent even been looked at according to that, as well as a bug that is killing my whole system that I reported on here and isnt even *listed* on the bugtrack. Thanx

Re: [GENERAL] Memory leak

1999-08-25 Thread Michael Simms
> > > What version of PostgreSQL? The "backends dying problem", I thought, was > fixed already... => select version(); version -- PostgreSQL 6.5.1 on i586-pc-linux-gnu, compiled b

[GENERAL] PQsendQuery

1999-08-04 Thread Michael Simms
Hi I have a query regarding PQsendQuery that doesnt seem to be well explained in the docs. My basic situation is that I want to run a series of queries quickly, and I dont care what the result of them is (it is an insert). 1 ) When I run PQsendQuery(), can I then immediately run PQexec() or do I

Re: [GENERAL] ElephantWear Now Available...

1999-08-04 Thread Michael Simms
> Oh, I like this one too...Daniel? Jeff? T-Shirt #3? If you want to send > in suggestions, feel free to send them to [EMAIL PROTECTED] Not saying > we'll do everything and anything, but diversity is cool... Hows about: Postgres - We didnt need to consult an oracle to know it would be great!

[GENERAL] big copy tasks

1999-08-01 Thread Michael Simms
Hi. one question and two bug reports. I am using 5.1 on Linux 2.0.37 glibc 2.0 Firstly, I am performing a big copy, around 1.5 million rows. The speed, whilst slower than I would like, is acceptable, and more my problem for having an underpowered machine. My problem is that whilst I perform thi

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