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 save the fi
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: Don'
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 wi
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
---
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.h
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
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 examp
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') ||
to_tsvector(manuscript_abstra
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
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 prop
10 matches
Mail list logo