On Tue, Feb 21, 2012 at 5:09 AM, sunpeng wrote:
> I try to setup warm-standby using file-based log shipping method:
> Master: 5432 port
> Standby:6432 port at same machine
> Master's :
>
>- wal_level = archive
>- archive_mode = on
>- archive_command = 'cp %p /home/postgres/archive/%f'
Hi guys!
I'want to run unaccent function with a custom unaccent dictionary
I know that we can do:
Select unaccent('áéíóúñ')
Select unaccent('unaccent', 'áéíóúñ')
Select unaccent('custom_unaccent', 'áéíóúñ)
PG Docs say that we can set the rules for default installed unaccent
dictionary:
ALTER
>> Please follow the conventions of previous posters when adding a reply to
an existing posting. If you are the first reply I would personally give
more lee-way but this particular community prefers bottom-posting.
-Original Message-
From: David Johnston [mailto:pol...@yahoo.com]
Sent: T
Situation:
I have two roles, alice & bob. Both are members of the dev_user group role.
I have a schema called 'reports' that both of these users would like
to be able to manage.
I thought I could use the ALTER DEFAULT PRIVILEGES option
(http://www.postgresql.org/docs/9.1/static/sql-alterdefaultpri
David,
Thanks for that. There is always a feeling of relief and frustration when you
learn that a language simply cannot do what you are trying to get it to do.
You mentioned that this could be done by brute force with PL/PGSQL. I do have
this available, but am somewhat unfamiliar with it an
Hi,
I am going to start with quotation: "*PostgreSQL is a powerful, open
source object-relational
database system.*"
So let's use objects (TYPES):
First You have to create proper types:
CREATE TYPE "Facebook" AS
(account_name text,
fb_special_hash text,
fb_security_hash text,
fb_ex
On 02/20/2012 06:49 AM, Andreas wrote:
Hi,
is there a way to split up phone numbers?
Yes.
I know that's a tricky topic and it depends on the national phone
number format.
I'm especially interested in a solution for Germany, Swizerland and
Austria
It really depends on *why* you want to sp
On 02/20/2012 10:12 AM, Rainer Pruy wrote:
...only restriction is the maximum length of internationally reachable
number length - 12 digits including internat. prefix if I remember
correctly, but could also be 14, sorry)...
Per ITU-T E.164 the *recommended* maximum is 15.
6.1 International ITU
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Andy Colson
Sent: Tuesday, February 21, 2012 1:37 PM
To: Jeff Herman
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Combining data from Temp Tables
how about
sele
how about
select date, ln, mbrid, ds, (
select sum(ds) from t2
where t2.date >= t1.date and t2.date <= t1.date + '5 days'::interval
and t1.ln = t2.ln
and t1.mbrid = t2.mbrid)
from t1
That'll give you both the plus and minus (in two different columns), but
it might sum up the same row f
Maxim Boguk writes:
> On Tue, Feb 21, 2012 at 5:32 PM, Tom Lane wrote:
>> If the index key values are not private information, could we see that
>> with "pg_filedump -i -f" not just bare?
> There is it:
> http://maximboguk.com/static/etc/agency_statistics_pkey.pg_full_filedump.gz
Thanks. The i
On 2/21/2012 11:31 AM, Jeff Herman wrote:
Obviously my formatting did not post correctly the first time. Here is
another attempt, with the desired result table listed:
Temp Table 1
DATE LN MBRID DS
1/1 A 1 30
1/1 A 1 30
1/1 B 1 30
1/1 A 2 30
1/1 A 2 30
1/1 C 3 45
1/1 D 4 45
1/1 D 4 45
Obviously my formatting did not post correctly the first time. Here is another
attempt, with the desired result table listed:
Temp Table 1
DATE LN MBRID DS
1/1 A 1 30
1/1 A 1 30
1/1 B 1
Hi all,
I have created two temp tables that I would like to combine to make a third
temp table and am stuck on how to combine them to get the results I want. Any
guidance you could give would be appreciated.
Temp Table 1
Andre Lopes, 21.02.2012 16:11:
Hi all,
I need to create a table to store Twitter accounts information,
Facebook and other social networks details for API login. I need to
know if it is possible to store the account details("account_details"
field) in a field that contains something like an array
Andy Chambers writes:
> In our porting of a big mysql app to postgres, we're finding lots of
> queries like
> select foo
> from (foo f, bar b)
> left join caz c on f.id = f.caz_id
> where f.id = b.foo_id
> I've seen the message where Tom explains why this is invalid in ANSI
> SQL so I converte
Hi all,
I need to create a table to store Twitter accounts information,
Facebook and other social networks details for API login. I need to
know if it is possible to store the account details("account_details"
field) in a field that contains something like an array. I need to
store this data in an
Hi,
In our porting of a big mysql app to postgres, we're finding lots of
queries like
select foo
from (foo f, bar b)
left join caz c on f.id = f.caz_id
where f.id = b.foo_id
I've seen the message where Tom explains why this is invalid in ANSI
SQL so I converted it to
select foo
from foo f C
I try to setup warm-standby using file-based log shipping method:
Master: 5432 port
Standby:6432 port at same machine
Master's :
- wal_level = archive
- archive_mode = on
- archive_command = 'cp %p /home/postgres/archive/%f'
Standby's restore_command = 'cp /home/postgres/archive/%f %p'
Maybe some processing using external libraries? For example
http://code.google.com/p/libphonenumber/ and you may try it there
http://libphonenumber.appspot.com/
Vojta
Dne 20.2.2012 15:49, Andreas napsal(a):
Hi,
is there a way to split up phone numbers?
I know that's a tricky topic and it depe
20 matches
Mail list logo
