Hello Group,
I might have missed this somewhere, but PostgreSQL doesn't presently
support the cumulative/running aggregate function SUM() OVER
(PARTITION BY) syntax that Oracle does, right?
Here's an example of what I'm talking about:
Say we have a table of sales by month & person. We want to q
I found some posts be developers discussing this issue last Jan. and Nov..
See link below.
http://search.postgresql.org/search?m=1&q=cache+lookup+failed+for+relation
&l=&d=&s=
But have not been able to find any suggestion on how an end user can use
to get around this problem. Basically, we ha
I found some posts be developers discussing this issue last Jan. and Nov.. See
link below.
http://search.postgresql.org/search?m=1&q=cache+lookup+failed+for+relation&l=&d=&s=
But have not been able to find any suggestion on how an end user can use to get
around this problem. Basically, we have
Lewis,
On Sat, Mar 8, 2008 at 3:13 AM, Lewis Cunningham <[EMAIL PROTECTED]> wrote:
>
> My problem is not even so much the feed. I know how to use yahoo
> pipes and feedburner to create a custom feed. The problem is two
> fold. First, this is supposed to be a community aggregator and a
> single
On Fri, Mar 07, 2008 at 01:22:49PM -0800, Colin Fox wrote:
> I've created a pg_foundry project for this.
>
> Assuming the project gets approved, I'll post the link here.
Wouldn't it be better just to send that XSLT to the upstream project?
Cheers,
David.
>
> Regards,
> cf
>
>
> Malinka Rell
On 3/8/08, Alex Turner <[EMAIL PROTECTED]> wrote:
> Well - I know that my stored proc is segfaulting based on a strace of
> postgresql. Don't know how that affects trac which isn't using that
> stored proc... the mystery continues. Either way I didn't get a
> corefile, and ulimit -a show I hav
No I'm not. Where would a core file be if there was going to be one?
I'm not sure how I can tell if the ulimit applies to the running
postmaster
I am the postgres user and ulimit -a show unlimited for core, and I
run pg_ctl start. I have put it in that one place in /etc/ and also
in ~/.bash_prof
On 3/8/08, Alex Turner <[EMAIL PROTECTED]> wrote:
> No I'm not. Where would a core file be if there was going to be one?
They should appear in the data directory (e.g. /var/lib/pgsql/data).
> I'm not sure how I can tell if the ulimit applies to the running
> postmaster
>
> I am the postgres u
On Sat, Mar 8, 2008 at 1:05 PM, Douglas McNaught <[EMAIL PROTECTED]> wrote:
> On 3/8/08, Alex Turner <[EMAIL PROTECTED]> wrote:
>
> > No I'm not. Where would a core file be if there was going to be one?
>
> They should appear in the data directory (e.g. /var/lib/pgsql/data).
>
Yeah - thats where
David Fetter wrote:
> On Fri, Mar 07, 2008 at 01:22:49PM -0800, Colin Fox wrote:
>
>> I've created a pg_foundry project for this.
>>
>> Assuming the project gets approved, I'll post the link here.
>>
>
> Wouldn't it be better just to send that XSLT to the upstream project?
>
> Cheers,
> Dav
Matt Culbreth <[EMAIL PROTECTED]> writes:
> I might have missed this somewhere, but PostgreSQL doesn't presently
> support the cumulative/running aggregate function SUM() OVER
> (PARTITION BY) syntax that Oracle does, right?
Right. There are people interested in this, and it'll likely show up in
"Wei Wu" <[EMAIL PROTECTED]> writes:
> Basically, we have a table X, trying to drop
> it would result an error message below:
> cache lookup failed for relation X
You've got missing catalog rows, apparently.
> I am using PgAdmin and I can still view the schema of this table, but
> any opera
"Alex Turner" <[EMAIL PROTECTED]> writes:
> ... I found what was going on in that bit and fixed it so
> it's not crashing anymore, I'm just worried about how on earth that
> could have affected other back end processes that were querying
> unrelated databases.
You do know that a crash in any backe
Dave Page wrote:
Well there's a major part of your misunderstanding.
planetpostgresql.org IS NOT a community project. It is a project
started and run by a very well liked and respected community member
(with the assistance of a few others), that the community - read web
team, plus others - suppo
Guy Rouillier <[EMAIL PROTECTED]> writes:
> Dave Page wrote:
>> Well there's a major part of your misunderstanding.
>> planetpostgresql.org IS NOT a community project. It is a project
>> started and run by a very well liked and respected community member
>> (with the assistance of a few others), th
On Fri, Mar 07, 2008 at 06:50:17AM -0800, Matt Culbreth wrote:
> I might have missed this somewhere, but PostgreSQL doesn't presently
> support the cumulative/running aggregate function SUM() OVER
> (PARTITION BY) syntax that Oracle does, right?
you might find this useful:
http://www.depesz.com/in
Err, no. That is also not a postgresql.org website. Let me clarify, so
JD doesn't slap my wrists again.
Official PostgreSQL project sites/services are deployed under the
postgresql.org domain, having been agreed upon by -www or the sysadmin
team. We have a policy of not using alternate domain name
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sat, 08 Mar 2008 15:39:32 -0500
Tom Lane <[EMAIL PROTECTED]> wrote:
> Guy Rouillier <[EMAIL PROTECTED]> writes:
> > Dave Page wrote:
> >> Well there's a major part of your misunderstanding.
> >> planetpostgresql.org IS NOT a community project. It i
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sat, 8 Mar 2008 20:57:28 +
"Dave Page" <[EMAIL PROTECTED]> wrote:
> Err, no. That is also not a postgresql.org website. Let me clarify, so
> JD doesn't slap my wrists again.
>
> Official PostgreSQL project sites/services are deployed under the
Ah... no I didn't know that - that would explain all the other
behaviour then!! Good to know.
Alex
On Sat, Mar 8, 2008 at 3:03 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Alex Turner" <[EMAIL PROTECTED]> writes:
> > ... I found what was going on in that bit and fixed it so
>
> > it's not crashin
Hi,
Either please change the subject, or let's move this discussion to -www,
with a different subject.
Thanks.
--
Devrim GÜNDÜZ , RHCE
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.comman
HELLO
i have psql file which is to be used for loading a database
it was downloaded from this link http://conceptnet.media.mit.edu/
the description says
The ConceptNet 3 database, as a PostgreSQL input file. You will need to be
running a PostgreSQL server to install ConceptNet 3.
i was earlier
sug
I installed PostgreSQL on my Windows XP Home PC (at home) but when I
look under the Control Panel, User accounts, the special postgres user
name is not listed.
However, using "net user postgres" shows the following:-
User namepostgres
Full Namepostgres
Comme
On 08/03/2008 19:46, akshay bhat wrote:
now can someone please tell me where to execute above command
should i use dos (i mean command prompt )
Yes, that's it - run it at the command prompt.
Ray.
---
Raymond O'Donnell, Director of M
akshay bhat wrote:
The ConceptNet 3 database, as a PostgreSQL input file. You will need to
be running a PostgreSQL server to install ConceptNet 3.
i was earlier
suggested to use following command
to add it to database
psql -d -f conceptnet-2007-09-25.psql
however i do not know where to execut
Tom Lane wrote:
Guy Rouillier <[EMAIL PROTECTED]> writes:
And with the new exception of the community documentation recently
started at http://www.postgresqldocs.org.
Which in fact has got only the weakest claim to be a "community"
project. If it actually were such, in the sense of having b
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sat, 08 Mar 2008 19:27:43 -0500
Guy Rouillier <[EMAIL PROTECTED]> wrote:
> The only thing I think I have a right to ask is that whatever
> contributions I may make not be a waste of effort because the PG
> decision-makers have decided that a cer
On Sat, 8 Mar 2008, Guy Rouillier wrote:
The only thing I think I have a right to ask is that whatever
contributions I may make not be a waste of effort because the PG
decision-makers have decided that a certain repository is now
"official", and the previous one is defunct.
Contributions to
I have ~350K rows of sample data that has come to me in 64 text files
(CSV) that I'd like to import into a new database. Each file can be
considered its own category and is so named. That is, each file name
will be inserted into a separate categories table. I'd like to relate
each row to its ca
I haven't tested but this is what I would do (uses arrays, which are
handy when you need them), with the names changed to protect the
innocent:
begin;
-- create a table with some duplicates in one of the columns (y is ck);
wsprague=# select x, x%4 as y into temp fbar from generate_series(1,10) as
30 matches
Mail list logo
