Re: [SQL] Change of data type

2006-08-08 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2006-08-07 12:38:20 -0500: >Hello everybody, excuse me how can I change de data type of a field, > I currently have: > >material character(30) > >but I now want the field in text type like this: > >material text > >somebody knows if ALTER TABLE h

[SQL] Query response time

2006-08-08 Thread Jonathan Sinclair
Hi all, I am using PostgresSQL 7.4 and having some serious performance issues. Trawling through the archives and previous posts the only visible advice I could see was either by running vacuum or setting the fsynch flag to false. I am using tables that only contain approx 2GB of data. However pe

Re: [SQL] Query response time

2006-08-08 Thread Chris Mair
> I am using PostgresSQL 7.4 and having some serious performance issues. > Trawling through the archives and previous posts the only visible advice > I could see was either by running vacuum or setting the fsynch flag to > false. > > I am using tables that only contain approx 2GB of data. However

Re: [SQL] Query response time

2006-08-08 Thread Richard Broersma Jr
> I am using PostgresSQL 7.4 and having some serious performance issues. > Trawling through the archives and previous posts the only visible advice > I could see was either by running vacuum or setting the fsynch flag to > false. > > I am using tables that only contain approx 2GB of data. However

[SQL] Function Temp Table Woes

2006-08-08 Thread Chad Voelker
Hello, I'm a newbie to plpgsql functions so any help I can get would be appreciated. I have a little bit of a history with MS SQL Server 2000, so this may be where I'm messed up ;) The Goal: Return a set of records from one table based on entries in a temporary table. I'd expect this to be a comm

Re: [SQL] Function Temp Table Woes

2006-08-08 Thread Michael Fuhr
On Tue, Aug 08, 2006 at 10:24:02AM -0700, Chad Voelker wrote: > The Goal: Return a set of records from one table based > on entries in a temporary table. I'd expect this to be > a commonly requested functionality. After reading the > docs, support lists and googling, I haven't come up > with a clea