am Wed, dem 13.09.2006, um 15:46:58 -0700 mailte Junkone folgendes:
hI
i have a bad situation that i did not have primary key. so i have a
table like this
colname1colname2
1 apple
1 apple
2
a schreef:
this doesnt work
SELECT DISTINCT on link *, rank(ts_vec, to_tsquery('default', $qtxt))
FROM feed_entry WHERE ts_vec @@ to_tsquery('default', $qtxt) ORDER
BY rank(ts_vec, to_tsquery('default', $qtxt)) DESC LIMIT 5 OFFSET 0
can you tell me how to get the DISTINCT elements in LINK
If you have a primary key value (or OID?) then you can delete the
duplicates in situ using something like (untested)
-- should work if never more than 1 duplicate row for colname1, colname2
delete from table where pk_value in (
select min(pk_value)
from table
group by colname1, colname2
having
We're slowly trying to move away from hardware dependence for our
servers and it looks like Xen is the path. Our primary goal is that if
a particular server fails, we can simply migrate the guest OSs to
another Xen node and the users will not experience any downtime. Plus
it should allow us
I'm going to create a (manually) partioned table and wonder whether I
should use inherited tables or an explicitly created view using UNION
ALL. Constraint exclusion is not important for this application
(major updates will directly target the individual tables).
After these considerations, is
Dunno about quickly, but I usually do something like this (before slapping
myself in the face for getting into that state):
CREATE TABLE tn_backup AS SELECT DISTINCT * FROM tn;
TRUNCATE TABLE tn;
INSERT INTO tn VALUES SELECT * from tn_backup;
(Where tn is the table name)
May not be the best
A. Kretschmer wrote:
am Wed, dem 13.09.2006, um 15:46:58 -0700 mailte Junkone folgendes:
hI
i have a bad situation that i did not have primary key. so i have a
table like this
colname1colname2
1 apple
1 apple
2
Florian Weimer [EMAIL PROTECTED] writes:
I'm going to create a (manually) partioned table and wonder whether I
should use inherited tables or an explicitly created view using UNION
ALL. Constraint exclusion is not important for this application
(major updates will directly target the
Hi
All,
I have an issue with
timestamp with time zone I don't understand.
When I insert a time
stamp value '1903-08-07 00:00:00+02' into a table and next select it again using
psql I get '1903-08-06 22:19:32+00:19'.
I'm located in The
Netherlands and before 1940 there was a so called
Jan van der Weijde [EMAIL PROTECTED] writes:
When I insert a time stamp value '1903-08-07 00:00:00+02' into a table
and next select it again using psql I get '1903-08-06 22:19:32+00:19'.
I'm located in The Netherlands and before 1940 there was a so called
Amsterdam Time that is UTC + 20. So
What I'm not sure of:
- Maybe it's better to run PGSQL in Dom0, on 2 different Xen units that
are beefed up, with a few lighter DomU guest OSs running in the
background. Some sort of heartbeat software that allows the 2 Xen units
to grab the PGSQL's IP address as needed.
PostgreSQL
Is there a list anywyere of what config changes take effect after a reload
and which after a restart?
Reading over a number of settings to optimize performance, but would like to
know what settings require restart.. other than trying to use show to see if
the change took effect.
Can all
Tom Lane writes:
Nothing happens when I try to run the query.
So pg_dump seems off the hook. Can you run the query, attach to the
backend with gdb, and see what it's doing?
Tried to set level debug5 to see if any extra output appeared in log.
Nothing.
Going to read up on gdb.. tried
Hi,
We recently upgraded our trac backend from sqlite to postgres, and I
decided to have a little fun and write some reports that delve into
trac's subversion cache, and got stuck with a query optimisation
problem.
Table revision contains 2800+ rows
Table node_change contains 37+.
rev is a
Title: PostgreSQL slammed by PHP creator
Hi all,
Any response to this:
http://www.internetnews.com/dev-news/article.php/3631831
From the FA:
One performance enhancement that Lerdorf suggested based on code analysis was to use MySQL instead of PostgreSQL for the database.
If you can
My database needs are probably less than yours, but I've had zero
issues running postgres inside a domU. I'm not using SAN, but instead
DRBD to replicate data at the block level between dom0s. I haven't
tried migrating the domU from one machine to another without
rebooting it, but the
Francisco Reyes [EMAIL PROTECTED] writes:
Is there a list anywyere of what config changes take effect after a reload
and which after a restart?
These settings require a postmaster restart, nothing else does:
select name from pg_settings where context = 'postmaster';
Francisco Reyes [EMAIL PROTECTED] writes:
Going to try the FreeBSD lists to see why and when a process would not
show up in ktrace. Specially one using 90% cpu.
That's not hard: it's in a loop that doesn't include any kernel calls.
regards, tom lane
I'm pleased to announce the first beta version of pgAdmin III v1.6.0 is
available for download in Source, Windows, Slackware and Mac OSX formats
from:
http://www.pgadmin.org/download/
This is a beta version and may contain bugs - please test at your own
risk and report any bugs found to [EMAIL
Is there a setting to limit the number of database
connections per IP address or client?
Thanks,
Curtis
On Sep 14, 2006, at 11:27 , Arturo Perez wrote:
Hi all,
Any response to this:
http://www.internetnews.com/dev-news/article.php/3631831
From the FA:
One performance enhancement that Lerdorf suggested based on code
analysis was to use MySQL instead of PostgreSQL for the database.
If you
Arturo Perez wrote:
Any response to this:
http://www.internetnews.com/dev-news/article.php/3631831
Oh please! Can we skip this one?
Maybe on the advocacy groups, not on [GENERAL], pleze!
thanks,
bkw
---(end of broadcast)---
TIP 6: explain
On Thu, Sep 14, 2006 at 10:59:09AM -0500, Curtis Scheer wrote:
Is there a setting to limit the number of database connections per IP
address or client?
8.1 has per-database and per-user connection limits; see the
CONNECTION LIMIT option of {CREATE,ALTER} {DATABASE,ROLE}.
AgentM wrote:
On Sep 14, 2006, at 11:27 , Arturo Perez wrote:
One performance enhancement that Lerdorf suggested based on code
analysis was to use MySQL instead of PostgreSQL for the database.
...If you give up A, C, I, and D, of course you get better
performance- just like you can
Arturo Perez wrote:
Hi all,
Any response to this:
http://www.internetnews.com/dev-news/article.php/3631831
From the FA:
One performance enhancement that Lerdorf suggested based on code analysis was to use MySQL instead of PostgreSQL for the database.
If you can fit your problem into what
Joshua D. Drake wrote:
However, he does carry some umpf in certain circles. Perhaps we should
prove him wrong?
I take it you mean oomph?
Main Entry: oomph
Pronunciation: 'um(p)f
Function: noun
Etymology: imitative of a sound made under exertion
1 : personal charm or magnetism : GLAMOUR
2 :
Alvaro Herrera wrote:
Joshua D. Drake wrote:
However, he does carry some umpf in certain circles. Perhaps we should
prove him wrong?
I take it you mean oomph?
Yeah probably :)
Main Entry: oomph
Pronunciation: 'um(p)f
Function: noun
Etymology: imitative of a sound made under exertion
1 :
I wasn't able to find anything the article worth discussing. If you
give up A, C, I, and D, of course you get better performance- just like
you can get better performance from a wheel-less Yugo if you slide it
down a luge track.
I don't think a Yugo would give you better performance no
Hi Alvaro,
This is a second test with some non US-ACII characters...
Since I am in France, I have never seen broken Subject lines.
Greetings
Michelle Konzack
Systemadministrator
Tamay Dogan Network
Debian GNU/Linux Consultant
Am 2006-09-09 12:30:25, schrieb Alvaro Herrera:
I
Hello Marc,
Am 2006-09-09 12:50:36, schrieb Marc G. Fournier:
And I missed this one from Joshua ... but, we aren't running Majordomo
from GreatCircle, we are running Majordomo2 (http://www.mj2.org) which is
very much being actively support ...
I have seen...
Majordomo2 support a nomail
Curtis Scheer wrote:
Is there a setting to limit the number of database connections per IP
address or client?
No but you can limit per database as a whole.
Joshua D. Drake
Thanks,
Curtis
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support:
Michelle Konzack wrote:
Hello Marc,
Am 2006-09-09 12:50:36, schrieb Marc G. Fournier:
And I missed this one from Joshua ... but, we aren't running Majordomo
from GreatCircle, we are running Majordomo2 (http://www.mj2.org) which is
very much being actively support ...
I have seen...
Thanks for the advice, I tried to install the language-packs that
ubuntu supports. I can no initialize a se_SV.utf8 cluster, but it
seems there is no support form latin1.
Best whishes
/Ragnar
---(end of broadcast)---
TIP 6: explain analyze is
* Arturo Perez ([EMAIL PROTECTED]) wrote:
Any response to this:
http://www.internetnews.com/dev-news/article.php/3631831
Turn fsync off and try again. Don't expect your data to stay consistant
tho.
Enjoy,
Stephen
signature.asc
Description: Digital signature
We have a need to rename some columns, but since we can't update both
the database and the programs instantly, we'd like to temporarily
assign both names to the same column while the updates are in
progress. Something like this would be super nifty :-)
ALTER TABLE howdy_doody ADD NAME xyzzy
[EMAIL PROTECTED] writes:
I am pretty certain no such SQL command exists. But is it possible to
do something sneaky to the internal tables so that two names point to
the same columnand everything just works?
No ... at least not for usefully large values of work.
You might be able to do
On Thu, 2006-09-14 at 14:18, [EMAIL PROTECTED] wrote:
We have a need to rename some columns, but since we can't update both
the database and the programs instantly, we'd like to temporarily
assign both names to the same column while the updates are in
progress. Something like this would be
I have some troubles getting Sun Java Studio Creator Sun Java
Application Server to work with
PostgreSQL.
Trying different syntaxes for the SQL statement (schema or no schema) in
the session bean
I get either the error: No columns in table: pmh.tablename or
Cannot change transaction
On Thu, Sep 14, 2006 at 12:18:05PM -0700, [EMAIL PROTECTED] wrote:
We have a need to rename some columns, but since we can't update both
the database and the programs instantly, we'd like to temporarily
assign both names to the same column while the updates are in
progress. Something like
[EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote on 15/09/2006 04:40:04 a.m.:
I wasn't able to find anything the article worth discussing. If you
give up A, C, I, and D, of course you get better performance- just
like
you can get better performance from a wheel-less Yugo if you slide it
And yet this man is smart enough not to run MySQL on Windows. Methinks
this says something
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Joshua D. Drake
Sent: Thursday, September 14, 2006 5:16 PM
To: [EMAIL
On 9/13/06, Martijn van Oosterhout kleptog@svana.org wrote:
On Tue, Sep 12, 2006 at 09:57:33PM -0400, Jack Orenstein wrote:
...
int, bigint: From looking at postgres.h, I realize that Datum is an
unsigned long. I'm guessing that I should just be able to assign Datums
carrying ints or
I would like the ability to absolutely set parameters/settings in psql
so that our psql scripts could generate predictable output absent a
known or controllable initial state. Original discussion at bottom of
message.
One alternate and easier approach I've thought of is to simply add
something
Brandon Aiken wrote:
And yet this man is smart enough not to run MySQL on Windows. Methinks
this says something
Heh..
Joshua D. Drake
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Joshua D. Drake
On Thu, 2006-09-14 at 11:40, Joshua D. Drake wrote:
I wasn't able to find anything the article worth discussing. If you
give up A, C, I, and D, of course you get better performance- just like
you can get better performance from a wheel-less Yugo if you slide it
down a luge track.
I
On 2006-09-14, Jack Orenstein [EMAIL PROTECTED] wrote:
I don't think I explained myself clearly. I have a C string (char*,
terminating zero) and a byte array (char*, possibly containing zeros,
and I know the length). I want to obtain Datums wrapping these values
that will be used to bind
Joshua D. Drake wrote:
[EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote on 15/09/2006 04:40:04 a.m.:
I wasn't able to find anything the article worth discussing. If
you give up A, C, I, and D, of course you get better performance- just
like
you can get better performance from a wheel-less
Joshua D. Drake wrote:
I can top that :). I hit a telephone pole at 135MPH in a 66 Cuda :)
If it hadn't been for the gravel around that corner, I would have beat
the other car too.
' (a tear for your 66 cuda...)
Hell I cried more then a tear. The cop felt so bad for me, he didn't
Alvaro Herrera wrote:
Joshua D. Drake wrote:
I can top that :). I hit a telephone pole at 135MPH in a 66 Cuda :)
If it hadn't been for the gravel around that corner, I would have beat
the other car too.
' (a tear for your 66 cuda...)
Hell I cried more then a tear. The cop felt
Bruce Momjian wrote:
Alvaro Herrera wrote:
Joshua D. Drake wrote:
I can top that :). I hit a telephone pole at 135MPH in a 66 Cuda :)
If it hadn't been for the gravel around that corner, I would have beat
the other car too.
' (a tear for your 66 cuda...)
Hell I cried more then a tear. The
Alvaro Herrera wrote:
Joshua D. Drake wrote:
I can top that :). I hit a telephone pole at 135MPH in a 66 Cuda :)
If it hadn't been for the gravel around that corner, I would have beat
the other car too.
' (a tear for your 66 cuda...)
Hell I cried more then a tear. The cop felt so bad for me,
Joshua D. Drake wrote:
I can top that :). I hit a telephone pole at 135MPH in a 66 Cuda :)
If it hadn't been for the gravel around that corner, I would have
beat the other car too.
' (a tear for your 66 cuda...)
Hell I cried more then a tear. The cop felt so bad for me, he didn't
even
bank :)
Are we talking about this one?
http://www.musclecarclub.com/musclecars/plymouth-cuda/plymouth-cuda.shtml
Note that this was a very long time ago :)
I hope it wasn't on 1966 ...
I am not going to ask how you got to 135MPH.
Oh that is easy, you just press on the gas and watch the
On Sep 14, 2006, at 21:25 , Bruce Momjian wrote:
I am not going to ask how you got to 135MPH.
Obviously he was running MySQL under the hood.
-M
---(end of broadcast)---
TIP 4: Have you searched our list archives?
On Thu, 14 Sep 2006, AgentM wrote:
Obviously he was running MySQL under the hood.
Ta-da! We have a winner!
Rich
--
Richard B. Shepard, Ph.D. |The Environmental Permitting
Applied Ecosystem Services, Inc.(TM)|Accelerator
http://www.appl-ecosys.com
On 09/14/06 21:32, AgentM wrote:
On Sep 14, 2006, at 21:25 , Bruce Momjian wrote:
I am not going to ask how you got to 135MPH.
Obviously he was running MySQL under the hood.
No wonder he spun out and crashed into a telephone poll...
--
Ron Johnson, Jr.
Jefferson LA USA
Is common
56 matches
Mail list logo
