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 order by
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
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
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
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:
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
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
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 que
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 log
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
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
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
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
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 for the
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
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
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
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 Intel
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 are
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,
Richard
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
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
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 history,
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
* 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: you
Title: Hola «Nombre»,
I cant 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
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. Thanks for
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=1]'
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
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 seconds for
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 more than
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 create
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 to
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 should be
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
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 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;
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 \TEST\);
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 man
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
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
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
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=2] ( b c )
What
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)
returns
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
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
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
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
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
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 the
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
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
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:
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?
¡ªªªªªªªªªfleêµ}KWªªª 2005/NÌ£Áå ªª¡
/* y áI³ê½eÒERrjÅãYíÈXõÌoˬ÷ z *PR
[EMAIL PROTECTED] [EMAIL PROTECTED] http://puremovie.net/@ *@ *
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 of the
Hi,
I've the following scenario:
1. I've my web serveron 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 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 Postgresql
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 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
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
up.
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 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-
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
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?
--
Kathy
65 matches
Mail list logo
