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
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 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
> 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
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.
--
Devrim GÜNDÜZ
PostgreSQL DBA @ Akinon/Markafoni, Red Hat Certified Enginee
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
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
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 (>
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
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
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
> 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/
13 matches
Mail list logo
