""Karsten Hilbert"" wrote in message
news:20100719182027.123...@gmx.net...
>> On Thu, Jul 15, 2010 at 4:05 AM, Davor J. wrote:
>> > It seems no secret that a child table will not fire a trigger defined
>> > on
>> > it's parent table. Various posts comment on this. But nowhere could I
>> find a
"Craig Ringer" wrote in message
news:4c3ed37c.1070...@postnewspapers.com.au...
> My understanding is that it's mostly an implementation limitation. In
> other words, rather than any fundamental reason why it should not be
> done, the issue is that nobody has gone and implemented it, tested it,
>
Vincenzo Romano writes:
> Now, why doing this?
> I am using a plain SEQUENCE to create a (kind of) "session ID". That
> is simple but predictable.
> The idea is to use this function in conjunction with encrypt (from
> pgcrypto) and the blowfish algorithm
> to make that sequence numbers somehow unp
"Gauthier, Dave" writes:
> Will DB replication be integral in v9? If so, when (approx) will that
> be out?
Integral meaning all the cluster at a time, yes. You can help have it
out sooner by testing it and reporting your findings. I think the goals
are to have 9.0.0 out by mid august or about, s
2010/7/27 Dimitri Fontaine :
> Vincenzo Romano writes:
>> Now, why doing this?
>> I am using a plain SEQUENCE to create a (kind of) "session ID". That
>> is simple but predictable.
>> The idea is to use this function in conjunction with encrypt (from
>> pgcrypto) and the blowfish algorithm
>> to m
Hi List,
I am using libpq c api to connect postgresql server.
I wanted to retrieve the below metadata information for a column from resultset.
Column name, ( PQfname )
type, (PQftype )
precision, ( ?)
scale, (?)
nullability(?)
Thanks in advance
Regards,
Ravi Katkar
From: Ravi Katkar
Sent: Tuesday, July 27, 2010 5:45 PM
To: 'pgsql-general@postgresql.org'; 'pgsql-o...@postgresql.org'
Subject: resultset metadata libpq
Hi List,
I am using libpq c api to connect postgresql server.
I wanted to retrieve the below metadata inform
On 27 July 2010 13:43, Ravi Katkar wrote:
>
> From: Ravi Katkar
> Sent: Tuesday, July 27, 2010 5:45 PM
> To: 'pgsql-general@postgresql.org'; 'pgsql-o...@postgresql.org'
> Subject: resultset metadata libpq
>
> I wanted to retrieve the below metadata information for a column from
> resultset.
>
> Co
Hi,
I had referred below link
I could not able to locate or identify api to retrieve information like
precision, scale, nullability.
Thanks,
Ravi Katkar
-Original Message-
From: willfurn...@googlemail.com [mailto:willfurn...@googlemail.com] On Behalf
Of William Furnass
Sent: Tuesd
Is there a way to select a list of column values directly into an array?
create table foo (col1 text);
insert into foo (col1) values ('aaa'),('bbb'),('ccc'),('ddd'),('eee');
I'd like to load up an array with {aaa,bbb,ccc,ddd,eee}, prefferably with a
single select statement.
Thanks in advance fo
In response to Gauthier, Dave :
> Is there a way to select a list of column values directly into an array?
>
>
>
> create table foo (col1 text);
>
> insert into foo (col1) values (?aaa?),(?bbb?),(?ccc?),(?ddd?),(?eee?);
>
>
>
> I?d like to load up an array with {aaa,bbb,ccc,ddd,eee}, preff
A. Kretschmer wrote:
In response to Gauthier, Dave :
Is there a way to select a list of column values directly into an array?
create table foo (col1 text);
insert into foo (col1) values (?aaa?),(?bbb?),(?ccc?),(?ddd?),(?eee?);
I?d like to load up an array with {aaa,bbb,ccc,ddd,eee}
A. Kretschmer wrote:
In response to Gauthier, Dave :
Is there a way to select a list of column values directly into an array?
create table foo (col1 text);
insert into foo (col1) values (?aaa?),(?bbb?),(?ccc?),(?ddd?),(?eee?);
I?d like to load up an array with {aaa,bbb,ccc,ddd,eee}
On Tue, Jul 27, 2010 at 9:03 AM, Gauthier, Dave wrote:
> Is there a way to select a list of column values directly into an array?
>
> create table foo (col1 text);
>
> insert into foo (col1) values (‘aaa’),(‘bbb’),(‘ccc’),(‘ddd’),(‘eee’);
>
> I’d like to load up an array with {aaa,bbb,ccc,ddd,eee}
The select array (select col1 from foo ); ...did it.
Thanks!
-Original Message-
From: Merlin Moncure [mailto:mmonc...@gmail.com]
Sent: Tuesday, July 27, 2010 9:25 AM
To: Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] select a list of column values directly in
I'm trying to increase my query speed for this table, it currently takes 2-3
seconds and would like to make if faster if possible.
my table reads as
Table "public.campaign_impressions"
Column |Type | Modifiers
---+-+
show us explain analyze on this
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
EXPLAIN ANALYZE SELECT page, count(page) as impressions FROM
campaign_impressions WHERE campaign = 42 and "timestamp" BETWEEN '2010-05-21
00:00:00' AND '2010-07-27 00:00:00' group by page order by impressions;
QUERY PLAN
--
On 27 Jul 2010, at 21:48, Jamie Kahgee wrote:
> EXPLAIN ANALYZE SELECT page, count(page) as impressions FROM
> campaign_impressions WHERE campaign = 42 and "timestamp" BETWEEN '2010-05-21
> 00:00:00' AND '2010-07-27 00:00:00' group by page order by impressions;
>
I want to move one table from one disk to another.
In order to do this I wanted to create a new tablespace on the new disks and
issue the command alter table tablename set tablespace tablespacename;
The question is, will this in any way affect the database which is in heavily
use?
The table in q
On Tue, 2010-07-27 at 20:38 +, Leif Gunnar Erlandsen wrote:
> I want to move one table from one disk to another.
>
> In order to do this I wanted to create a new tablespace on the new disks and
> issue the command alter table tablename set tablespace tablespacename;
>
> The question is, will
I am using postgresql-odbc and trying to "CREATE OR REPLACE FUNCTION..."
from my C-Application, however, I get "must be owner of function ..." error.
If I execute the command logged in as postgres (i.e. su postgres), then I
can execute the command. I think I tried to grant privileges to public for
Hi,
I have a table containing events with timestamps. I would like to
generate a histogram of the number of each type of event for each half-hour
period from 8:00 am to 6:00 pm. Are there any tools that will help me do this?
Thanks,
Patrick
smime.p7s
Description: S/MIME cryptograp
On 07/27/10 3:39 PM, Jerry Richards wrote:
I am using postgresql-odbc and trying to "CREATE OR REPLACE FUNCTION..."
from my C-Application, however, I get "must be owner of function ..." error.
If I execute the command logged in as postgres (i.e. su postgres), then I
can execute the command. I t
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of Patrick May
> Sent: Tuesday, July 27, 2010 3:59 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Histogram generator
>
> Hi,
>
> I have a table conta
Oleg Bartunov writes:
> I recommend post your problem to -hackers mailing list. I have no idea,
> what could be a problem.
I wonder whether the problem is not windows versus non windows but
original database versus copies. If it is a GIN bug it seems quite
possible that it would depend on the or
Samuel Gilbert writes:
> I have encountered a problem with inserts failing because of permissions
> issues when the table in which I try to insert has foreign key constraints to
> tables for which UPDATE has been revoked.
Yeah, this is because the insertion has to take a row lock on the
refere
On Jul 27, 2010, at 7:12 PM, Dann Corbit wrote:
>> I have a table containing events with timestamps. I would like
>> to generate a histogram of the number of each type of event for each
>> half-hour period from 8:00 am to 6:00 pm. Are there any tools that
>> will help me do this?
>
> GROUP
hi,
i'm having a little openssl problem with pg_dump over a wireless
lan with postgres-8.4SS (on linux) from enterprisedb and
a macosx-10.6 client.
when i run pg_dump from a wired linux client it's always fine
but since i switched from a macosx-10.4 laptop to a
macosx-10.6 laptop, every time i ru
On Jul 27, 2010, at 6:07 PM, Patrick May wrote:
> On Jul 27, 2010, at 7:12 PM, Dann Corbit wrote:
>>> I have a table containing events with timestamps. I would like
>>> to generate a histogram of the number of each type of event for each
>>> half-hour period from 8:00 am to 6:00 pm. Are the
raf writes:
> i'm having a little openssl problem with pg_dump over a wireless
> lan with postgres-8.4SS (on linux) from enterprisedb and
> a macosx-10.6 client.
> when i run pg_dump from a wired linux client it's always fine
> but since i switched from a macosx-10.4 laptop to a
> macosx-10.6 lap
On Jul 27, 2010, at 9:21 PM, Steve Atkins wrote:
> On Jul 27, 2010, at 6:07 PM, Patrick May wrote:
>> On Jul 27, 2010, at 7:12 PM, Dann Corbit wrote:
I have a table containing events with timestamps. I would like
to generate a histogram of the number of each type of event for each
>>>
Gary Fu writes:
> Below is an example that I created. It works okay, but when I add any
> character in the comment or in the table definition, it fails (hangs).
> I checked the server process (with ps command), and I can see that
> connection is 'idle'. By the way, the size 1484 may not mean
Thanks to some very helpful input here in earlier threads, I was
finally able to pull together a working prototype Full Text Search
'engine' on PostgreSQL and compare it directly to the way the
production Oracle Text works. The good news is that PostgreSQL is
bloody fast! The slightly iffy news is
On Tue, Jul 27, 2010 at 7:58 PM, Howard Rogers wrote:
> Thanks to some very helpful input here in earlier threads, I was
> finally able to pull together a working prototype Full Text Search
> 'engine' on PostgreSQL and compare it directly to the way the
> production Oracle Text works. The good new
hi,
The question is very simple - which CMS/Shopping cart/Ecommerce solution
are people using in conjunction with Postgresql ?
Except for Drupal's partial support, I cant find any which has a sizeable
deployment and community size behind it. Spree is a new RoR based system,
that would obviously
Tom Lane wrote:
> raf writes:
> > i'm having a little openssl problem with pg_dump over a wireless
> > lan with postgres-8.4SS (on linux) from enterprisedb and
> > a macosx-10.6 client.
>
> > when i run pg_dump from a wired linux client it's always fine
> > but since i switched from a macosx-10.
Howard Rogers, 28.07.2010 03:58:
Thanks to some very helpful input here in earlier threads, I was
finally able to pull together a working prototype Full Text Search
'engine' on PostgreSQL and compare it directly to the way the
production Oracle Text works. The good news is that PostgreSQL is
bloo
38 matches
Mail list logo
