[GENERAL] Using data for column names in plpgsql

Hi I'm attempting to do some partitioning in a database and am wondering if I can use the data being inserted to insert into new schema. I have the following in the public schema: create table test (id serial, note varchar not null, schema varchar not null) then create a schema: create schema

[GENERAL] WARNING: pgstat wait timeout

I have had some issues with a database on EC2 and I have restored it to a new instance. When vacuuming the database I am getting the following in the logs; WARNING: pgstat wait timeout Is this normal/acceptable? Thanks

Re: [GENERAL] WARNING: pgstat wait timeout

any thing wrong. > > Once we made any changes in this file then we need to restart the > PostgreSQL Cluster to take it's Effect on autovacuum worker processes. > > > > I hope some one will add more on this. > > > Regards, > > Dinesh Kumar > > manojadi

[GENERAL] Query optimisation and sorting on external merge

Hi, I'm trying to optimise a query at the moment, I've added some new indexes to stop seq scans, but I'm now trying to work out if I can stop a join using external sort to speed up the query. I've included an explain analyze below and would appreciate any pointers to gaps in my understanding. exp

Re: [GENERAL] Query optimisation and sorting on external merge

2009/7/29 A. Kretschmer : > In response to Jake Stride : >> Hi, >> >> I'm trying to optimise a query at the moment, I've added some new >> indexes to stop seq scans, but I'm now trying to work out if I can >> stop a join using external sort t

[GENERAL] Strange Planner Issues

Hi, I have 2 databases running on the same server. One is a dump of the other, however the query plans for the same query on the same tables in each database is wildly different and I cannot work out why. The first result below is for the dump of the database and executes in a reasonable time. Th

Re: [GENERAL] Query optimisation and sorting on external merge

Thanks I'll take a look into it - they query you provide seems to take longer in the query plan but I can see where you are coming from and it's good base to work from. Jake -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.pos

[GENERAL] Trigger/Query Warnings

t.option_value='d73bd962-cb61-4b94-8a55-f819615c623f' AND lower(trim(e.varchar_value)) = lower(trim(n.varchar_value))

Re: [GENERAL] Trigger/Query Warnings

Hi David, Thanks, that's exactly what it was. Jake On 9 October 2011 10:05, David Johnston wrote: > On Oct 8, 2011, at 21:45, Jake Stride wrote: > >> Hi, >> >> I've been staring at this for hours and was hoping somebody could >> point me in the right di

[GENERAL] Access to inserted rows via select in a statement

via UPDATE as the row exists from a previous insert but not the first time it is called. Should a SELECT function within a function and a transaction be able to select other rows that have just been inserted in the transaction, but before it is committed? Thanks Jake -- Jake Stride Find out

[GENERAL] Function Question

I am trying to create a function that gets fired when a new row is inserted. I can get the following function built but my problem is that the sequence that is created is called "NEW.key" rather than the value that is being inserted (it should be a UUID). I have tried putting the key into a variab

[GENERAL] Compatible Dumps

Is there a way to make a postgresql 8 database dump work with 7.4? I.E I want to do a dump from 8.0 on one machine and put it into a database running on 7.4 on another? Thanks Jake ---(end of broadcast)--- TIP 3: if posting/reading through Usenet,

Re: [GENERAL] Compatible Dumps

Richard Huxton wrote: Jake Stride wrote: Is there a way to make a postgresql 8 database dump work with 7.4? I.E I want to do a dump from 8.0 on one machine and put it into a database running on 7.4 on another? Haven't tried this yet, but apart from turning off dollar-quoting for function

[GENERAL] Intervals

Is there a way to convert in interval into hours? I have a table that records the amount of time worked by a person and want to sum up all the hours, however with the column being an interval once you reach more than 24 hours it turns that into a day. This is not what I want so instead of outputtin

Re: [GENERAL] Intervals

gt; $$select cast( (cast($2 as date) - cast($1 as date)) * 24 + > extract(hour from cast($2 as time) - cast($1 as time)) as integer)$$ > language SQL IMMUTABLE; > > Andrei > > Jake Stride wrote: > >> Is there a way to convert in interval into hours? I have a table that >&

[GENERAL] Indexes

Hi, I have a table set up: \d companycontactmethod Table "public.companycontactmethod" Column | Type| Modifiers ---+---+ tag | character varying | not null contact | character varying | not null type

Re: [GENERAL] Indexes

Peter Wilson wrote: > Jake Stride wrote: >> Hi, >> >> I have a table set up: >> >> \d companycontactmethod >> Table "public.companycontactmethod" >> Column | Type| Modifiers >> ---+-

[GENERAL] Cascades Failing

I seem to be having some problems with cascading updates, I seem to remember that this worked in the database in 7.4 but seems to fail in 8, can anyone give me any pointer please as I seem to be able to find anything about this online. I have several tables, but the two I am having issue with are

[GENERAL] Constaints

Is there anyway to declare a constant that you can then use within a postgresql 'session', i am connecting from a PHP based application and trying to integrate another. What I want to be able to do is setup a rule on another table so that whenever a query is run on the table it appends another

Re: [GENERAL] Constaints

Bruno Wolff III wrote: On Sun, Dec 05, 2004 at 16:55:33 +, Jake Stride <[EMAIL PROTECTED]> wrote: Is there anyway to declare a constant that you can then use within a postgresql 'session', i am connecting from a PHP based application and trying to integrate another.

[GENERAL] pg_column_size()

Hi,I'm trying to find the size of individual rows in a database (or a subset of them) so that we can tell users how much of a quota they are using on the system (in practice this will actually be across a number of tables and I will need to write a query to do this). I have come across pg_column_si