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
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
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
-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
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
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
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
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
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
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
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
-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
-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
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
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
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
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
"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
"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
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
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
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
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
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:
> 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
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
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
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
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
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
30 matches
Mail list logo
