On Wed, Jul 18, 2007 at 03:39:01PM +0530, Ashish Karalkar wrote:
I want to take backup from one server and save it to another machine hard
drive.
The backup will be taken through a shell script attached to a cron job.
something like:
pg_dump -d postgres -U postgres -f IP address of
Here's another easy (stupid?) question:
SELECT data.* FROM (SELECT * FROM foo ORDER BY bar) AS data
Will the returned rows still be ordered by bar?
--
Make April 15 just another day, visit http://fairtax.org
---(end of broadcast)---
TIP 2:
I read the docs but I'm still not sure. If I create a temp table with ON
COMMIT DROP then is that table private to the transaction? In other
words, if the temp table is created in plpgsql stored procedure foo
and foo is executed from different transactions in parallel then each
transaction
1. What is the advantage of the tsearch2() trigger? Why can't I write my
own trigger which does approximately:
UPDATE manuscript set manuscript_vector =
setweight(to_tsvector(manuscript_genre), 'A') ||
setweight(to_tsvector(manuscript_title), 'B') ||
On Wed, Jul 04, 2007 at 10:59:46AM +0400, Oleg Bartunov wrote:
On Wed, 4 Jul 2007, Joshua N Pritikin wrote:
1. What is the advantage of the tsearch2() trigger? Why can't I write my
own trigger which does approximately:
no advantage, it's just an example.
Please mention
On Wed, Jul 04, 2007 at 10:40:11AM +0200, hubert depesz lubaczewski wrote:
On 7/4/07, Joshua N Pritikin [EMAIL PROTECTED] wrote:
Please mention that in the documentation:
dont you think this is perfeclty clear?
If you want to do something specific with columns, you may write your very
own
On Wed, Jul 04, 2007 at 11:08:21AM +0200, hubert depesz lubaczewski wrote:
On 7/4/07, Joshua N Pritikin [EMAIL PROTECTED] wrote:
From where are you quoting? I was quoting from:
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch2-ref.html
i was quoting file
http
Sometime in the future, I anticipate storing other languages in addition
to English in my database to be indexed with tsearch2. set_curcfg()
seems to be per-session. Will I need to call set_curcfg() every time I
switch languages?
--
Make April 15 just another day, visit http://fairtax.org
I am designing a new schema from scratch. Which type is more natural to
work with, a timestamp with a timezone or without a timezone? I read
the 7.4 documentation on timezones two or three times but I'm still not
really sure. The fact that the default is without time zone suggests
that without
I designed a schema which would benefit from inheritance (in particular,
an index over more than one table).
However, I read that inheritance is not really implemented yet. So I
simulated it with extra indexes and extra joins.
Is there any plan / timetable for implementing inheritance (with
10 matches
Mail list logo