Mike Rylander <[EMAIL PROTECTED]> writes:
> To cut to the chase, here are
> some numbers for everyone to digest:
>total gnu ps resident size
> # ps ax -o rss|perl -e '$x += $_ for (<>);print "$x\n";'
> 5810492
>total gnu ps virual size
> # ps ax -o vsz|perl -e '$x += $_ for
> But this shouldn't be an issue here. If you set the IPC_RMID flag then
> the kernel should remove the segment when all users go away. This is
> standard IPC behaviour and is documentated in the manpage...
>
Would you please tell me where to find the manpage and how to set IPC_RMID flag?
--
Kath
On Dec 8, 2005, at 13:01 , Tim Vadnais wrote:
Thank you.
I've modified the code to read:
DELETE from tracker WHERE tracker.episode_id = 277 AND
tracker.date_of_service BETWEEN '09/12/2005'::date - interval '1
day' AND
'10/20/2005'::date + interval '1 day'
If you're going to be doing a lo
On Dec 7, 2005, at 9:05 PM, Angshu Kar wrote:
3. I'm using php on the windows machine to connect to my db
I'm failing to connect to my db. What is the solution?
Have you looked at the documentation on setting up the pg_hba.conf file?
http://www.postgresql.org/docs/8.1/interactive/client-
a
Thank you.
I've modified the code to read:
DELETE from tracker WHERE tracker.episode_id = 277 AND
tracker.date_of_service BETWEEN '09/12/2005'::date - interval '1 day' AND
'10/20/2005'::date + interval '1 day'
And got:
SELECT * from tracker where tracker.episode_id = 277;
53716 | 277 | 27
On 12/8/05, Kathy Lo <[EMAIL PROTECTED]> wrote:
[snip]
> When the user complains the system becomes very slow, I use top to
> view the memory statistics.
> In top, I cannot find any processes that use so many memory. I just
> found that all the memory was used up and the Swap memory nearly used
>
On Dec 8, 2005, at 12:13 , Tim Vadnais wrote:
I have a set of records spanning several dates, and I want to
delete some
records within a specific date range. For example, I have a record
for each
day from Sept 1 through Nov 1, and I want to delete the records for
Sept 21
through 10/20 an
This question is probably real easy to answer, but I've got myself into a
vicious loop and can't see the forest through the trees.
I have a set of records spanning several dates, and I want to delete some
records within a specific date range. For example, I have a record for each
day from Sept 1
On 12/8/05, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> Please keep replies on list, this may help others in the future, and
> also, don't top post (i.e. put your responses after my responses...
> Thanks)
>
> On Tue, 2005-12-06 at 20:16, Kathy Lo wrote:
> > For a back-end database server running Pos
Hi,
I've the following scenario:
1. I've my web server on a windows xp machine - IIS
2. I've my database server on a linux machine - postgresql
3. I'm using php on the windows machine to connect to my db
I'm failing to connect to my db. What is the solution?
Are there any DSO kind of stuff to
On Wednesday 07 December 2005 05:44, Adam Witney wrote:
> I'm not sure which list to send this to But is the majordomo address
> spelt correctly on the mailing list pages. Here for example:
>
> http://archives.postgresql.org/pgsql-advocacy/
>
> It is spelt [EMAIL PROTECTED]
>
> Also on a couple
¡ªªªªªªªªªfleêµ}KWªªª 2005/NÌ£Áå ªª¡
/* y áI³ê½eÒERrjÅãYíÈXõÌoˬ÷ z *PR
[EMAIL PROTECTED] [EMAIL PROTECTED] http://puremovie.net/@ *@ *
Mû̲ß̺³ñE§q³ñElEUßlªoÄé©àµêܹ
Mike Rylander wrote:
Mike Rylander wrote:
On 12/6/05, Marcus Engene <[EMAIL PROTECTED]> wrote:
[snip]
A & (B | (New OperatorTheNextWordMustFollow York))
Actually, I love that idea. Oleg, would it be possible to create a
tsquery operator that understands proximity?
Developer means postgresql developer (contributes code to postresql
code base), otherwise the person is a 'User'.
I've changed the legend to say 'PG Developer' to make this clearer.
Let me know if you have alternate legend title suggestions.
On Dec 7, 2005, at 1:46 PM, Reid Thompson wrote:
Claire McLister wrote:
Hi All,
The only objection that I've heard to using Google maps is there are
some 'copyright issues'. AFAIK, Google Maps come with a fairly liberal
license. As long as you use it in a web application that is freely
accessible to users, you are within their terms of
Hello,
This is probably a very basic question but I'm having a problem writing queries
that should be accent insensitive. I have pg v8.1 for Windows installed with
Portuguese support and everything works fine except a very basic thing.
An example query like the following:
select name
Please keep replies on list, this may help others in the future, and
also, don't top post (i.e. put your responses after my responses...
Thanks)
On Tue, 2005-12-06 at 20:16, Kathy Lo wrote:
> For a back-end database server running Postgresql 8.0.3, it's OK. But,
> this problem seriously affects th
Hi,
I need to log any statement in my postgresql server.
However, I would like that the password defined in CREATE USER statement
was registered in MD5 format, independent of the form where it was
specified in the statement.
For example, if the user submits the statement:
CREATE USER test ENCRY
As Teodor already pointed there is no non-ambiguous solution, or
at least, we don't know it.
Oleg
On Wed, 7 Dec 2005, Andrew J. Kopciuch wrote:
A & (B | (New OperatorTheNextWordMustFollow York))
I had thought about this before myself. Alas I have never had the time to
properly i
Hi All,
The only objection that I've heard to using Google maps is there
are some 'copyright issues'. AFAIK, Google Maps come with a fairly
liberal license. As long as you use it in a web application that is
freely accessible to users, you are within their terms of use. The
problem with
Michelle Konzack wrote:
Hello PGSQL-Gurus,
I have already ask this on pgsql-php and php-db but unfortunatly
gotten no answer.
I have a search form and I like to add advanced search options like
"this is a search" -XXX Test
which mean,
1) "this is a search" must be in this
Antony Gelberg wrote:
Hi,
This problem is related to an sql-ledger database, but given the nature,
I think it's more appropriate here.
Our sql-ledger server had a filesystem corruption. We do have backups,
but it's only now, after reading the PostgreSQL manual, that I knew that
it would have
>
> The reason that I need this is because of my other question (is there in pg
> a function like oracle's rownum?). The function get_a_foo looks in reality a
> bit more like the next:
>
> create type foo_extended as (a int, b int, rowno int);
>
> create or replace function get_a_foo_func(int)
> r
On 12/7/05, Teodor Sigaev <[EMAIL PROTECTED]> wrote:
> That is a long discussed thing. We can't formulate unconflicting rules... For
> example:
> 1) a &[dist<=2] ( b &[dist<=3] c )
> 2) a &[dist<=2] ( b |[dist<=3] c )
> 3) a &[dist<=2] !c
> 4) a &[dist<=2] ( b |[dist<=3] !c )
> 5) a &[dist<
On Dec 07 06:56, Alexander Scholz wrote:
> I SELECTed them, that's right, but I didn't FETCHed them. I thought that
> would be a difference. It's at least the way it works with MSSQL and
> ODBC/OLEDB (that's where I am coming from...)
IMHO, you can reach to a similar functionaly with using async
Hi Axel,
I have exactly the same problem!!! Seems to be a conceptional problem of
libpq (or my usage of it) in my case. Probably in yours, too...
Refer to the other thread with subject "Problem: libpq, network traffic,
memory usage".
HTH,
Alexander.
---(end of broa
Hi Andreas,
The same question was yesterday on [pgsql-de-allgemein] ;-)
Yes - I just found it. :-) But I don't know whether it is really the
same prob.
You have selected _ALL_ records, you got all records. Thats the point.
I SELECTed them, that's right, but I didn't FETCHed them. I thought t
On Wed, Dec 07, 2005 at 06:34:25PM +0100, Axel Loder wrote:
> Seq Scan on "ADRESSEN" (cost=0.00..14588.75 rows=302975 width=1936)
> (actual time=0.052..422.687 rows=302975 loops=1)
> Total runtime: 544.169 ms
> (2 rows)
>
> Gibt es irgendwelche Schalter (am Server oder an der Datenbank) die ma
On Dec 07 06:36, Alexander Scholz wrote:
> sorry for probably asking such a stupid question, but we are using a
> PQexec(). Where should I specify that cursor declaration?
Just like as you're querying with pgAdmin:
PQexec(conn, "BEGIN");
PQexec(conn, "DECLARE \"test\" CURSOR FOR SELECT * FROM \"
Hi Scott,
try
declare cursor xyz as select ...
fetch 100;
and see how that works.
sorry for probably asking such a stupid question, but we are using a
PQexec(). Where should I specify that cursor declaration?
BTW: When executing
BEGIN WORK;
DECLARE "test" CURSOR FOR SELECT * FROM "TEST"
Vielen Dank für die Antwort!
Diese Abfrage wird beispielsweise benötigt um alle Rechnungen anzuzeigen.
Habe jetzt mal das "explain analyse" mit dem psql tool durchgeführt und
folgendes kam da raus:
QUERY
PLAN
---
Hi,
This problem is related to an sql-ledger database, but given the nature,
I think it's more appropriate here.
Our sql-ledger server had a filesystem corruption. We do have backups,
but it's only now, after reading the PostgreSQL manual, that I knew that
it would have been a good idea to run
That is a long discussed thing. We can't formulate unconflicting rules... For
example:
1) a &[dist<=2] ( b &[dist<=3] c )
2) a &[dist<=2] ( b |[dist<=3] c )
3) a &[dist<=2] !c
4) a &[dist<=2] ( b |[dist<=3] !c )
5) a &[dist<=2] ( b & c )
What does exact they mean? What is tsvectors which
On Dec 07 06:01, Alexander Scholz wrote:
> I have a serious performance flaw, when using postgresql 8.1 (other
> versions haven't been tested) with libpq. When executing a
>
>select * from "xyz" 1)
>
> and "xyz" contains 300'000 records, it takes more than 60 seconds for
> the query just
> > A & (B | (New OperatorTheNextWordMustFollow York))
>
I had thought about this before myself. Alas I have never had the time to
properly investigate implementing such a feature.
:(
A & (B | (New + York))
Something like that?
> Actually, I love that idea. Oleg, would it be possible to c
am 07.12.2005, um 18:01:51 +0100 mailte Alexander Scholz folgendes:
> Dear NG,
>
> I have a serious performance flaw, when using postgresql 8.1 (other
> versions haven't been tested) with libpq. When executing a
>
> select * from "xyz" 1)
>
> and "xyz" contains 300'000 records, it takes
On Wed, 2005-12-07 at 11:01, Alexander Scholz wrote:
> Dear NG,
>
> I have a serious performance flaw, when using postgresql 8.1 (other
> versions haven't been tested) with libpq. When executing a
>
> select * from "xyz" 1)
>
> and "xyz" contains 300'000 records, it takes more than 60 sec
Dear NG,
I have a serious performance flaw, when using postgresql 8.1 (other
versions haven't been tested) with libpq. When executing a
select * from "xyz" 1)
and "xyz" contains 300'000 records, it takes more than 60 seconds for
the query just to complete. First I thought it is a perfor
On 12/6/05, Marcus Engene <[EMAIL PROTECTED]> wrote:
[snip]
> A & (B | (New OperatorTheNextWordMustFollow York))
>
Actually, I love that idea. Oleg, would it be possible to create a
tsquery operator that understands proximity? Or, how allowing a
predicate to the current '&' op, as in '&[dist
On Wed, Dec 07, 2005 at 01:50:37PM +0100, Martijn van Oosterhout wrote:
> > from
> > v_basic_person vbp<--
> > where
> > hxfi.fk_relative = v_basic_person.pk_identity <---
Duh. It got to be something simple which I just couldn't
see. Thank
Title: Hola «Nombre»,
I can’t believe it… spanish
spam in this list :P
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On
Behalf Of Formación On-Line - Formabyte
Sent: Miércoles, 07 de Diciembre
de 2005 03:20 a.m.
To: pgsql-general@postgresql.org
Subject: [GENERAL] CURSOS
FORM
* Tom Lane ([EMAIL PROTECTED]) wrote:
> Richard van den Berg <[EMAIL PROTECTED]> writes:
> > Is there a good reason that the official RPM on postgresql.org is not
> > build with HAVE_INT64_TIMESTAMP ? It would have been so nice if this
> > would have worked. :-/
>
> You've got that 100% backwards:
On Wed, 7 Dec 2005, Hannes Dorbath wrote:
Is there a way to get all unique lexems from a table with a tsvector column?
The stat() function does this (and more), but I cannot use it..
hmm, you could dump tsvector column and use awk+sort+uniq
Thanks
Regards,
Oleg
On Dec 07 12:34, A.j. Langereis wrote:
> I have two questions: fist of all, is there any function in pg like
> oracle's rownum?
[Does Postgresql have a similar pseudo-column "ROWNUM" as Oracle?]
http://archives.postgresql.org/pgsql-sql/2005-05/msg00123.php
--
"We are the middle children of histo
Richard van den Berg <[EMAIL PROTECTED]> writes:
> Is there a good reason that the official RPM on postgresql.org is not
> build with HAVE_INT64_TIMESTAMP ? It would have been so nice if this
> would have worked. :-/
You've got that 100% backwards: you should be complaining to Debian that
it's not
Hi,
On Wed, 7 Dec 2005, Richard van den Berg wrote:
I just tried to move my database files over from a CentOS 4.2 (RHEL AS 4
clone) machine to Debian 3.1. Unfortunately, the server complains:
2005-12-07 11:55:04 CET FATAL: database files are incompatible with server
2005-12-07 11:55:04 CET D
"Daniel Verite" <[EMAIL PROTECTED]>
wrote on 07-12-2005 12:30:17:
> It should depend on the locale. Can you tell the results of
> `show lc_ctype` and `show lc_collate`?
I've fried one of the disks. When the new one arrives,
I'll send you the results (will be sometime next week).
Sincerely,
Rich
"Daniel Verite" <[EMAIL PROTECTED]> writes:
> Richard van den Berg wrote:
>> During the
>> pg_restore, it complained about failing to create several indexes
>> because of duplicates. Inspecting these cases showed that the bogus
>> characters are to blame. It seems that these characters (that
On Wed, Dec 07, 2005 at 02:15:29PM +0100, Richard van den Berg wrote:
> I'll just do a pg_dump / pg_restore cycle, as I was planning to do. Is
> there any guarantee for compatability the pg_dump format? Say, can a
> 8.1.0 pg_dump made using a 64 bit Solaris SPARC binary be read using a
> 32 bit Int
Is there a way to get all unique lexems from a table with a tsvector
column? The stat() function does this (and more), but I cannot use it..
Thanks
--
Regards,
Hannes Dorbath
---(end of broadcast)---
TIP 4: Have you searched our list archives?
Hi,
On Wed, 2005-12-07 at 12:14 +0100, Richard van den Berg wrote:
> I just tried to move my database files over from a CentOS 4.2 (RHEL AS 4
> clone) machine to Debian 3.1. Unfortunately, the server complains:
>
> 2005-12-07 11:55:04 CET FATAL: database files are incompatible with server
> 2005-
Hello PGSQL-Gurus,
I have already ask this on pgsql-php and php-db but unfortunatly
gotten no answer.
I have a search form and I like to add advanced search options like
"this is a search" -XXX Test
which mean,
1) "this is a search" must be in this order
2) -XXX
Martijn van Oosterhout wrote:
> Just be glad the server didn't startup and subsequently crash the first
> time you read a timestamp value.
I was pleasantly surprised that PostgreSQL gave such a detailed error
message. Even down to the compile option that was different, good job.
I'll just do a pg
On Wed, Dec 07, 2005 at 12:14:05PM +0100, Richard van den Berg wrote:
> I just tried to move my database files over from a CentOS 4.2 (RHEL AS 4
> clone) machine to Debian 3.1. Unfortunately, the server complains:
>
> 2005-12-07 11:55:04 CET FATAL: database files are incompatible with server
> 20
On Wed, Dec 07, 2005 at 10:10:40AM +0100, Karsten Hilbert wrote:
> Hello,
>
> I have a slightly involved view that draws from other views.
> Upon insertion into the database (creation) it complains of
>
> ERROR: missing FROM-clause entry in subquery for table "v_basic_person"
>
> and I can't fo
Richard van den Berg wrote:
> During the
> pg_restore, it complained about failing to create several indexes
> because of duplicates. Inspecting these cases showed that the bogus
> characters are to blame. It seems that these characters (that are
> probably not defined in LATIN1) are now t
I just tried to move my database files over from a CentOS 4.2 (RHEL AS 4
clone) machine to Debian 3.1. Unfortunately, the server complains:
2005-12-07 11:55:04 CET FATAL: database files are incompatible with server
2005-12-07 11:55:04 CET DETAIL: The database cluster was initialized
without HAVE
I'm not sure which list to send this to But is the majordomo address
spelt correctly on the mailing list pages. Here for example:
http://archives.postgresql.org/pgsql-advocacy/
It is spelt [EMAIL PROTECTED]
Also on a couple of the others I have looked at... Is this right?
Adam
--
This m
i have a project where inheritance could be used, i think. but after
going through the lists and having read the FM's, i realize that i beter
use another approach. i just describe the project in short :
users have to fill in forms, that mainly exists of different lists
and/or textboxes. Users
select version()
"PostgreSQL 8.0.1 on i686-pc-linux-gnu, compiled by GCC
i686-pc-linux-gnu-gcc (GCC) 3.3.5 (Gentoo Linux 3.3.5-r1, ssp-3.3.2-3,
pie-8.7.7.1)"
I am using PG_Autovacuum with postgresql 8.01 and it doesn't seem to be
doing anything. I've seen it work on other machines where a lo
Title: Hola «Nombre»,
Hola ,
Somos la empresa Formabyte, la cual
nos dedicamos a la impartición de cursos de formación, tanto a empresas como a
particulares en modalidad tanto presencial como online a través de Internet de
nuestro campus.
Contactamos contigo actualmente,
debido a qu
I just upgraded our database from PostgreSQL 7.4.7 to 8.1.0. Our
original character enconding was set to the default of 7.4, being
SQL_ASCII. Along the way I realized our data does have non-ASCII
strings, so I decided to use this upgrade to fix this setting. Our new
8.1.0 database now has the LATIN
Hello,
I have a slightly involved view that draws from other views.
Upon insertion into the database (creation) it complains of
ERROR: missing FROM-clause entry in subquery for table "v_basic_person"
and I can't for the life of it find why (I know I can work
around this with a postgresql.conf o
am 07.12.2005, um 10:53:27 +0300 mailte go KEY802207 folgendes:
> Hi All!
>
> Tell me please - is there any script for conversion MySQL dump
> file into PostgreSQL ?
http://techdocs.postgresql.org/#convertfrom
HTH, Andreas
--
Andreas Kretschmer(Kontakt: siehe Header)
Heynitz: 035242/47
Hi All!
Tell me please - is there any script for conversion MySQL dump
file into PostgreSQL ?
Thanks!
Igor.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joi
contrib/hstore will save you.
See http://www.sai.msu.su/~megera/postgres/gist/hstore/README.hstore
for details.
Oleg
On Wed, 7 Dec 2005, hubert depesz lubaczewski wrote:
hi
jus recently there were some thread on postgresql list with people asying :
i have 700 columns, i have 1000 column
Thank you for all good suggestions. Clay will probably be my choice for this project since
it indeed is an Eclipse plugin that is developed.
Thanks again,
Thomas Hallgren
---(end of broadcast)---
TIP 5: don't forget to increase your free space map
am 07.12.2005, um 8:54:56 +0100 mailte A.j. Langereis folgendes:
> Postgresql supports records in the where clause i.e. you can compare
> multiple columns simultaneously:
>
> > test=# delete from change where id || ':' || datum not in (select id ||
> ':' || max(datum) from change group by id ord
68 matches
Mail list logo