The MusicBrainz project replicates in a way that sounds like it could
fit your needs. It depends on a lot of perl, but if that's not a
showstopper, then maybe adapting their replication scheme would work
for you.
On Oct 5, 2007, at 5:25 PM, Laurent ROCHE wrote:
Hello,
I must replicate (o
Hello,
I must replicate (or synchronise) data between disconnected postgreSQL
databases ... hence a replication "very asynchronous"!
Application description
This an application to manage sales forces with a central application (and
postgreSQL server) where everybody in the office can connect (t
On Oct 5, 2007, at 8:32 AM, Oleg Bartunov wrote:
On Fri, 5 Oct 2007, Tom Lane wrote:
Benjamin Arai <[EMAIL PROTECTED]> writes:
# explain analyze select * FROM fulltext_article, to_tsquery
('simple','dog') AS q WHERE idxfti @@ q ORDER BY rank(idxfti, q)
DESC;
QUERY PLAN
-
I'm having a strange issue with postgres...I think.
I have the following query:
GRANT SELECT ON 'tablename' TO 'username';
As far as I can tell, thats a valid query. It works fine when I run it
under the psql command line interface and executed against a remote db.
When I try and run the sa
- "Felipe de Jesús Molina Bravo" <[EMAIL PROTECTED]> wrote:
> May be can help you \timing in psql
>
> El vie, 05-10-2007 a las 21:32 +0400, John Wells escribió:
> > Guys,
> >
> > In the book PostgreSQL (2nd ed) the author mentions a timer script
> he wrote to analyze various performance bits
(Makes me have to think twice about raising
any _real_ issues though, like why my VACUUMs periodically keep
getting
into lock contentions with my JDBC connections and ultimately
causing me
to have to shut down Postgres w/ "pg_ctl stop -m immediate", or how to
properly handle postmaster errors
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Andreas Kretschmer
> Sent: Friday, October 05, 2007 12:55 PM
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Request: Anyone using bogus /
> "humorous" X-Message-Flag headers, could we p
May be can help you \timing in psql
El vie, 05-10-2007 a las 21:32 +0400, John Wells escribió:
> Guys,
>
> In the book PostgreSQL (2nd ed) the author mentions a timer script he wrote
> to analyze various performance bits about PostgreSQL. I've looked everywhere
> and can't find it. Does anyon
Guys,
In the book PostgreSQL (2nd ed) the author mentions a timer script he wrote to
analyze various performance bits about PostgreSQL. I've looked everywhere and
can't find it. Does anyone know where I can find a copy, or find an equivalent
tool?
Thanks!
John
---(end
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Erik Jones wrote:
> On Oct 5, 2007, at 10:53 AM, Scott Marlowe wrote:
>
>> On 10/5/07, Josh Tolley <[EMAIL PROTECTED]> wrote:
>>> On 10/3/07, Goboxe <[EMAIL PROTECTED]> wrote:
Hi,
I have two questions on the above:
1. I found
Bill Bartlett <[EMAIL PROTECTED]> schrieb:
>
>
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] On Behalf Of A. Kretschmer
> > Sent: Friday, October 05, 2007 10:57 AM
> > To: pgsql-general@postgresql.org
> > Subject: Re: [GENERAL] Request: Anyone using bo
> -Original Message-
> From: Scott Marlowe [mailto:[EMAIL PROTECTED]
> Sent: Friday, October 05, 2007 12:30 PM
> To: Bill Bartlett
> Cc: A. Kretschmer; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Request: Anyone using bogus /
> "humorous" X-Message-Flag headers, could we pleas
On 10/5/07, Bill Bartlett <[EMAIL PROTECTED]> wrote:
>
> Hmm ... I still use "Pine" on some of my really old Linux boxes -- does
> this count? (Useful for reading CRON output...)
If you need / want the familiar interface of pine on a modern linux
box, look for cone.
Note that there's also an ope
On Oct 5, 2007, at 10:53 AM, Scott Marlowe wrote:
On 10/5/07, Josh Tolley <[EMAIL PROTECTED]> wrote:
On 10/3/07, Goboxe <[EMAIL PROTECTED]> wrote:
Hi,
I have two questions on the above:
1. I found in some postings recommended to use triggers instead of
rules. Is this documented somewhere?
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of A. Kretschmer
> Sent: Friday, October 05, 2007 10:57 AM
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Request: Anyone using bogus /
> "humorous" X-Message-Flag headers, could we please
On Oct 5, 2007, at 10:56 , Bill Bartlett wrote:
* Given it's an X- header, doesn't that mean the meaning of
the value
is implementation dependent? What's "bogus" wrt Outlook may not be
wrt another mail system or client
* Doesn't this indicate that Outlook is broken (for some values of
broken)?
> -Original Message-
> From: Michael Glaesemann [mailto:[EMAIL PROTECTED]
> Sent: Friday, October 05, 2007 10:45 AM
> To: Bill Bartlett
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Request: Anyone using bogus /
> "humorous" X-Message-Flag headers, could we please turn the
On 10/5/07, Josh Tolley <[EMAIL PROTECTED]> wrote:
> On 10/3/07, Goboxe <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > I have two questions on the above:
> >
> > 1. I found in some postings recommended to use triggers instead of
> > rules. Is this documented somewhere?
>
> A howto is available at
> htt
Scott Ribe wrote:
I think it's out of print, unfortunately, but by far the best quick intro
I've ever seen is: "The Essence of SQL: A Guide to Learning Most of SQL in
the Least Amount of Time" by David Rozenshtein.
Must be a pretty good book. Amazon has one used copy for $119.
abebooks.com sh
On Fri, 5 Oct 2007, Tom Lane wrote:
Benjamin Arai <[EMAIL PROTECTED]> writes:
# explain analyze select * FROM fulltext_article, to_tsquery
('simple','dog') AS q WHERE idxfti @@ q ORDER BY rank(idxfti, q) DESC;
QUERY PLAN
---
"Tom Lane" <[EMAIL PROTECTED]> writes:
> "Joshua D. Drake" <[EMAIL PROTECTED]> writes:
>> Tom Lane wrote:
>>> such a hokey query (how many applications really write "WHERE false"?),
>
>> Granted this isn't WHERE FALSE, but I certainly see WHERE TRUE all the
>> time in similar scenarios and I have
Benjamin Arai <[EMAIL PROTECTED]> writes:
> # explain analyze select * FROM fulltext_article, to_tsquery
> ('simple','dog') AS q WHERE idxfti @@ q ORDER BY rank(idxfti, q) DESC;
>QUERY PLAN
> ---
"Christian Rengstl" <[EMAIL PROTECTED]> writes:
> whenever I execute the following query as admin I get all results, but
> as soon as I execute it as a less-privileged user the result is empty.
> SELECT * FROM information_schema.schemata
The SQL standard specifies that information_schema.schemata
am Fri, dem 05.10.2007, um 10:05:32 -0400 mailte Bill Bartlett folgendes:
> Quick request to the group: we have several members who include bogus or
> "humorous" X-Message-Flag headers in their email messages. Could I
> request that you _please_ turn them off? Because they come through as
Do yo
On 10/5/07, Michael Glaesemann <[EMAIL PROTECTED]> wrote:
>
> On Oct 5, 2007, at 9:05 , Bill Bartlett wrote:
> * Given it's an X- header, doesn't that mean the meaning of the value
> is implementation dependent? What's "bogus" wrt Outlook may not be
> wrt another mail system or client
> * Doesn't
I think it's out of print, unfortunately, but by far the best quick intro
I've ever seen is: "The Essence of SQL: A Guide to Learning Most of SQL in
the Least Amount of Time" by David Rozenshtein.
--
Scott Ribe
[EMAIL PROTECTED]
http://www.killerbytes.com/
(303) 722-0567 voice
On Oct 5, 2007, at 9:05 , Bill Bartlett wrote:
Quick request to the group: we have several members who include
bogus or
"humorous" X-Message-Flag headers in their email messages. Could I
request that you _please_ turn them off?
In all practicality, a request like this is futile:
* Given th
On 10/3/07, Goboxe <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have two questions on the above:
>
> 1. I found in some postings recommended to use triggers instead of
> rules. Is this documented somewhere?
A howto is available at
http://images.omniti.net/omniti.com/talks/partitions-public.pdf
- Josh/e
Quick request to the group: we have several members who include bogus or
"humorous" X-Message-Flag headers in their email messages. Could I
request that you _please_ turn them off? Because they come through as
flagged messages in Outlook, it throws off my email rules processing
and the messages
On 10/4/07, Ted Byers <[EMAIL PROTECTED]> wrote:
> --- Michael Glaesemann <[EMAIL PROTECTED]> wrote:
>
> >
> > On Oct 4, 2007, at 9:30 , Ted Byers wrote:
> >
> > > I do not know if PostgreSQL, or any other RDBMS,
> > > includes the ability to call on software such as
> > "R"
> >
> > See PL/R:
> >
>
Jan Theodore Galkowski wrote:
Does anyone know, or can anyone point to information about how much
triggers penalize inserts in PG tables? I'm getting a report that it is
substantial, and before I investigate more. The triggers in question
look like:
I use triggers everywhere. About a year
On Oct 5, 2007, at 4:11 , Stefan Schwarzer wrote:
Alternately, you could have a gdp table and a fish_catch table which
would be easily joined to give the same result.
Expanding on this:
create table fish_catches (country text not null,
data_year date not null,
On Oct 5, 2007, at 1:20 , Stefan Schwarzer wrote:
Before I was used that the yearly values were all to be found in a
single SQL row; now for each year of each country I have a separate
row. How do I convert that into a single (HTML) row again?
Take a look at the crosstab functions in contr
Hmmm. Don't really get that query working. My SQL looks like
this now:
SELECT
id_country,
year,
value
FROM
internet_users
NATURAL JOIN
gdp
WHERE
id_country = 8
ORDER BY
year
LIMIT
1
Ok, got it working with another proposed SQL SELECT. This is a
solution (comes out
Benjamin Arai wrote:
> Hi,
>
> I have very slow performance for a TSearch2 table. I have pasted the
> EXPLAIN ANALYZE queries below. 12 seconds is slow for almost any
> purpose. Is there any way to speed this up?
>
> # explain analyze select * FROM fulltext_article,
> to_tsquery('simple','dog'
Hi list,
whenever I execute the following query as admin I get all results, but
as soon as I execute it as a less-privileged user the result is empty.
SELECT * FROM information_schema.schemata
Strange enough, when I query information_schema.tables I can see
everything both as a normal user and ad
Thank you for the fix.
--
Miroslav
Tom Lane napsal(a):
> I wrote:
>
>> Bottom line seems to be that we should run through the in_info_list and
>> force Vars mentioned therein to be propagated up at least to the
>> "righthand" join level, ensuring they're available if we decide to
>> unique-ify
Alternately, you could have a gdp table and a fish_catch table which
would be easily joined to give the same result.
Expanding on this:
create table fish_catches (country text not null,
data_year date not null,
primary key (country, data_yea
What's the best method for migrating data from my laptop to the final
server DB?
The data currently in my laptop is using SQL_ASCII encoding and the
deployment target is defaulted to using UTF-8. (should not be a concern
as the encoding should be handled via the dump right?)
However a concern wou
Hi,
I have very slow performance for a TSearch2 table. I have pasted the
EXPLAIN ANALYZE queries below. 12 seconds is slow for almost any
purpose. Is there any way to speed this up?
# explain analyze select * FROM fulltext_article, to_tsquery
('simple','dog') AS q WHERE idxfti @@ q ORD
am Fri, dem 05.10.2007, um 9:13:10 +0200 mailte Stefan Schwarzer folgendes:
> >>
> >>And the next question coming up is: How should my query look like so
> >>that I can sort the (HTML) table by a specific year in ascending or
> >>descending order? So, that it doesn't display it by the country nam
And the next question coming up is: How should my query look like so
that I can sort the (HTML) table by a specific year in ascending or
descending order? So, that it doesn't display it by the country names
alphabetical order, but by, say 1998?
If you have only one row, how would you sort this
42 matches
Mail list logo
