> Michael A. Peters wrote:
>> I already maintain my own php RPMs because RHEL php is too old (I need
>> the DOMDocument stuff) so maybe I need to add Postgresql to that.
>>
>
> Note that you don't even have to build them yourself; the set at
> https://public.commandprompt.com/projects/pgcore/wiki/
In article ,
Marcelo de Moraes Serpa writes:
> Some good souls hinted me at the prefix extension, but
> how would I use it?
Like this:
CREATE TABLE users (
id serial NOT NULL,
name text NOT NULL,
reversed_domain prefix_range NULL,
PRIMARY KEY (id)
);
CREATE INDEX users_dom_ix ON users
Hallöchen!
I need statistics about the PG server load. At the moment, I use
for this
SELECT tup_returned + tup_fetched + tup_inserted + tup_updated +
tup_deleted FROM pg_stat_database WHERE datname='mydb';
However, the figures are absurdly high (> 100.000 rows per second).
If a "row" is on
On Sun, Jul 25, 2010 at 12:15:06PM +0200, Torsten Bronger wrote:
> Hallöchen!
>
> I need statistics about the PG server load. At the moment, I use
> for this
>
> SELECT tup_returned + tup_fetched + tup_inserted + tup_updated +
> tup_deleted FROM pg_stat_database WHERE datname='mydb';
>
> H
Torsten Bronger wrote:
> Hallöchen!
>
> I need statistics about the PG server load. At the moment, I use
> for this
>
> SELECT tup_returned + tup_fetched + tup_inserted + tup_updated +
> tup_deleted FROM pg_stat_database WHERE datname='mydb';
>
> However, the figures are absurdly high (>
Hallöchen!
hubert depesz lubaczewski writes:
> On Sun, Jul 25, 2010 at 12:15:06PM +0200, Torsten Bronger wrote:
>
>> I need statistics about the PG server load. At the moment, I use
>> for this
>>
>> SELECT tup_returned + tup_fetched + tup_inserted + tup_updated +
>> tup_deleted FROM pg_st
Hallöchen!
Andreas Kretschmer writes:
> Torsten Bronger wrote:
>
>> I need statistics about the PG server load. At the moment, I use
>> for this
>>
>> SELECT tup_returned + tup_fetched + tup_inserted + tup_updated +
>> tup_deleted FROM pg_stat_database WHERE datname='mydb';
>>
>> However
25.Tem.2010 tarihinde 00:23 saatinde, "Michael A. Peters" > şunları yazdı:
OK. I already maintain my own php RPMs because RHEL php is too old
(I need the DOMDocument stuff)
IIRC, Centosplus repo has already Dom stuff.
--
Devrim GÜNDÜZ
PostgreSQL DBA @ Akinon/Markafoni, Red Hat Certified Enginee
Hi!
The folks who organize OpenSQL Camp (me, among them) are making plans
for a gathering in Sardinia, Italy in early May 2011.
I am trying to gauge interest, and hoping to get a few more PostgreSQL
people involved than we've had in the past. So, if traveling to Italy
in May to hang out with data
> 25.Tem.2010 tarihinde 00:23 saatinde, "Michael A. Peters"
> > Åunları yazdı:
>> OK. I already maintain my own php RPMs because RHEL php is too old
>> (I need the DOMDocument stuff)
>
> IIRC, Centosplus repo has already Dom stuff.
I basically just rebuild the src.rpm from Fedora, which I th
On 25/07/2010 04:03, Lyle wrote:
Hi,
I really like the new:-
ALTER TABLE *table* DROP CONSTRAINT IF EXISTS *contraint*
But I need to achieve the same thing on earlier versions. I've tried
googling with no luck, how do I do it?
I've created functions to achieve this for INDEXes and CONSTRAINT
Hi all,
I'm trying to inject some behavior via rules between an application and a table
schema, preferably without modifying either of them. Using views, I'm able to
have a query that is run with one schema as the search_path to actually run
against a table in a different schema. Is that also p
On 07/25/2010 12:01 PM, Magnus Reftel wrote:
> create view myseq as select * from other_schema.foo_id_seq;
>
> but when I run "select nextval('myseq');" I get an error saying that
> myseq "is not a sequence". What other options are there?
It isn't clear (to me, at least) what you are trying to ac
13 matches
Mail list logo
