>>> "Scott Marlowe" <[EMAIL PROTECTED]> wrote:
> Andreas Philipp <[EMAIL PROTECTED]>
wrote:
>> We are wondering about the advisability to distribute the databases
between
>> the two server machines, both machines acting as active production
systems
>> for one application each, and as warm standb
Just to mention one issue we had here:
In 8.1 we did this to retrieve all data from a specific date:
SELECT * FROM xxx
WHERE LIKE '2008-05-20%'
In 8.3 we had to change to:
SELECT * FROM xxx
WHERE >= CAST('2008-05-20' as timestamp) AND
< CAST('2008-05-21' as timestamp)
Regards
Roberto Ga
Achilleas Mantzios wrote:
pg_dump by default ommits OIDs.
However why do you want to completely remove OID functionality?
space usage?
It doesn't backup the OIDs themselves, but it does set "with oids" if
the table had them. Per docs
(http://www.postgresql.org/docs/8.3/static/runtime-config-
Στις Wednesday 18 June 2008 20:21:45 ο/η Steve Crawford έγραψε:
> I'm getting ready to tackle another upgrade: 7.4.6 -> 8.3.3. The
> preliminaries (development/testing) look good but I'd like
> suggestions/warnings/comments on:
>
> 1. Removing OIDs on user tables.
>
> I don't see any dump or re
On Wed, 2008-06-18 at 10:21 -0700, Steve Crawford wrote:
> I'm getting ready to tackle another upgrade: 7.4.6 -> 8.3.3. The
> preliminaries (development/testing) look good but I'd like
> suggestions/warnings/comments on:
>
> 1. Removing OIDs on user tables.
>
> I don't see any dump or restore
On Wed, Jun 18, 2008 at 10:05:13AM -0700, pradeep kumar wrote:
> GRANT command but how can we GRANT privillages to a user on a row ??? ?
in standard postgresql you can't.
if you want row-level privileges, check this:
http://code.google.com/p/sepgsql/
depesz
--
Sent via pgsql-admin mailing list
I'm getting ready to tackle another upgrade: 7.4.6 -> 8.3.3. The
preliminaries (development/testing) look good but I'd like
suggestions/warnings/comments on:
1. Removing OIDs on user tables.
I don't see any dump or restore options to remove OIDs. Am I better off
modifying the dump to alter th
how to GRANT privillages to user/role on relation's row??
we can grant privvilages to user/role on tables/relations by
GRANT options[SELECT | INSERT | UPDATE | DELETE | REFERENCES | TRIGGER
|ALL]privillages ON relation/tablename TO dbuser/role;
GRANT command but how can we GRANT privillages to a u
[EMAIL PROTECTED] writes:
> is there a way to move the postmaster.pid file
> completely out of the PGDATA directory ?
No, and it's unlikely to be seriously considered, because of the
enormously increased risk of starting two postmasters in the
same directory. All it would take is for them to have
Hello,
is there a way to move the postmaster.pid file
completely out of the PGDATA directory ?
Setting the external_pid_file option in postgres.conf would only
create a second file.
Background: we would like to start a postmaster instance on a readonly
directory
to enable a server for readonl
On Wed, Jun 18, 2008 at 02:49:48PM +0200, Sabbiolina wrote:
> www.google.com is only treated as a unique word? Why not producing multiple
> tokens like www.google.com, www, ., google, ., com? (obviously www and . can
> be nulled or stopworded).
You wouldn't want to get the token ".". It's not a t
Sabbiolina,
you have two options:
1. Write you very own parser
2. Write dictionary, which breaks host to parts
Fortunately, you can use our dict_regex dictionary
(http://vo.astronet.ru/arxiv/dict_regex.html) instead of 2.
Oleg
On Wed, 18 Jun 2008, Sabbiolina wrote:
Hello,
I've seen that
Hello,
I've seen that the default parser for the full-text search can identify
e-mail addresses, hosts, URLs… but I have a serious problem with it:
Suppose I index the following sentence "the search engine I use the most is
www.google.com"
And I search "google" no result is found.
Instead
13 matches
Mail list logo
