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
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
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
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
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
t.option_value='d73bd962-cb61-4b94-8a55-f819615c623f' AND
lower(trim(e.varchar_value)) = lower(trim(n.varchar_value))
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
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
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
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
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
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
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
Peter Wilson wrote:
> Jake Stride wrote:
>> Hi,
>>
>> I have a table set up:
>>
>> \d companycontactmethod
>> Table "public.companycontactmethod"
>> Column | Type| Modifiers
>> ---+-
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
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
>&
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
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
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,
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.
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
21 matches
Mail list logo
