On Thu, Jun 6, 2013 at 5:23 AM, Richard Huxton wrote:
>
> If you have a business e.g. selling books or train tickets or some such
> then you might decide it's better to have a simpler more robust setup from
> the point of view of providing continuous service to end-customers. In the
> (hopefully
Le 2013-06-07 à 12:00, François Beausoleil a écrit :
>
> Le 2013-06-07 à 07:00, François Beausoleil a écrit :
>
>>
>> Le 2013-06-06 à 18:40, Michael Paquier a écrit :
>>
>>> On Fri, Jun 7, 2013 at 1:37 AM, François Beausoleil
>>> wrote:
>>> I can't seem to promote the slave:
>>>
>>> $ sudo
Hello again,
El jueves 6 de junio de 2013 a las 12:23, Jorge Arévalo escribió:
> Hello,
>
>
> El miércoles 5 de junio de 2013 a las 20:31, Paul Ramsey escribió:
>
> > Well, your objects are larger than the page size, so you're getting them
> > out of the toast tables, not directly out of m
> From: Rebecca Clarke
>To: pgsql-general@postgresql.org
>Sent: Friday, 7 June 2013, 11:30
>Subject: [GENERAL] Function tracking
>
>
>
>Hi all
>
>
>I'm looking for suggestions on the best way to track the updates to a function.
>
>
>We have two databases, Dev & Live, so I want to update Live w
> From: Pavel Stehule
> To: Rebecca Clarke
> Cc: pgsql-general@postgresql.org
> Sent: Friday, 7 June 2013, 11:44
> Subject: Re: [GENERAL] Function tracking
>
> Hello
>
> 2013/6/7 Rebecca Clarke :
>> Hi all
>>
>> I'm looking for suggestions on the best way to track the updates to a
>> func
Le 2013-06-07 à 07:00, François Beausoleil a écrit :
>
> Le 2013-06-06 à 18:40, Michael Paquier a écrit :
>
>> On Fri, Jun 7, 2013 at 1:37 AM, François Beausoleil
>> wrote:
>> I can't seem to promote the slave:
>>
>> $ sudo -u postgres touch /var/lib/postgresql/9.1/main/recovery.done
>> # lo
Rebecca Clarke wrote on 07.06.2013 12:30:
I'm looking for suggestions on the best way to track the updates to a
function.
We have two databases, Dev & Live, so I want to update Live with just
the functions that have been modified in the DEV databas3e. Is there
another, easier way to track the up
2013/6/7 Rebecca Clarke :
> Hi all
>
> I'm looking for suggestions on the best way to track the updates to a
> function.
>
> We have two databases, Dev & Live, so I want to update Live with just the
> functions that have been modified in the DEV databas3e.
> Is there another, easier way to track th
On 6/7/2013 6:30 AM, Rebecca Clarke wrote:
I'm looking for suggestions on the best way to track the updates to a
function.
We have two databases, Dev & Live, so I want to update Live with just
the functions that have been modified in the DEV databas3e.
Is there another, easier way to track the
On Fri, Jun 7, 2013 at 3:22 AM, Albe Laurenz wrote:
> Colin Sloss wrote:
>> I have been testing the differences between asynchronous and synchronous hot
>> standby streaming
>> replication on PostgreSQL 9.2.4. There is some push towards synchronous
>> replication, but I am finding
>> some seriou
Marc Dahn writes:
> So -- is there a way to let the planner look through the CASE?
No. It would actually be wrong to simplify the expression in the way
you're imagining, since "1 = case when bool_expr then 1 else 0 end"
does not give the same result as the plain bool_expr if the latter
yields nu
c k writes:
> Yesterday we configured a new server with Fedora 17 64 bit and updated it's
> kernel to 3.8. I have to compile and install postgresql with python. So I
> executed commands
> ./configure --with-python
> make
> but make is running for last 16 hours and still not completed. It is
> sh
Hello
2013/6/7 Aitor Gil Martin :
> Ok. I got the general idea. Thanks Vincent.
> My next question is:
> How do I convert the bytea content stored in Postgresql into the real file so
> I can put it in a local directory? (and the opposite process: store a file on
> a path to a postgresql database
Ok. I got the general idea. Thanks Vincent.
My next question is:
How do I convert the bytea content stored in Postgresql into the real file so I
can put it in a local directory? (and the opposite process: store a file on a
path to a postgresql database)
I know this could be more an access issue b
Le vendredi 07 juin 2013 à 11:35 +0200, Aitor Gil Martin a écrit :
> Hi,
>
> I,ve got a clients table in PostgreSQL. Each client has different
> documents (more than 7.000 files in total in different extensions JPG,
> XLS,DOC,PDF…) stored in a bytea field in another PostgreSQL Table. My
> intentio
Hi,
To maintain an externally defined interface, I'd like to define a
function hasword(haystack, needle) that (essentially) returns 1 when
to_tsvector(haystack) @@ to_tsquery(needle), 0 otherwise.
I've tried
CREATE OR REPLACE FUNCTION ivo_hasword(haystack TEXT, needle TEXT)
RETUR
2013/6/7 Pavel Stehule
> Hello
>
> 2013/6/7 Rebecca Clarke :
> > Hi all
> >
> > I'm looking for suggestions on the best way to track the updates to a
> > function.
> >
> > We have two databases, Dev & Live, so I want to update Live with just the
> > functions that have been modified in the DEV da
Hello,
I just wanted to know if there was a way to automatically execute a cleanup
function before DROP EXTENSION.
In previous versions we have uninstall script which can be modified to call
the function before dropping the schema created by the contrib module. Just
wondering if I can achieve thi
Hi Jeff.
Thanks for the clarification.
I'll adjust wal_keep_segments for the expected biggest table in the backup.
Best regards,
Mads
From: Jeff Janes
To: "mads.tand...@schneider-electric.com"
,
Cc: Albe Laurenz ,
"pgsql-general@postgresql.org"
Date: 06
Le 2013-06-06 à 17:59, Tom Lane a écrit :
> =?iso-8859-1?Q?Fran=E7ois_Beausoleil?= writes:
>> regress=# ALTER DEFAULT PRIVILEGES FOR ROLE dataanalysts IN SCHEMA public
>> REVOKE SELECT ON TABLES FROM dataanalysts;
>> ERROR: permission denied for schema public
>
>> I'm logged in as postgres, t
Le 2013-06-06 à 18:40, Michael Paquier a écrit :
> On Fri, Jun 7, 2013 at 1:37 AM, François Beausoleil
> wrote:
> I can't seem to promote the slave:
>
> $ sudo -u postgres touch /var/lib/postgresql/9.1/main/recovery.done
> # log is silent
> This has no effect. recovery.conf is renamed to recov
Hi everybody
I'm trying to use the dict_xsyn contrib module to implement query
expansion. I'm baffled by what seems like incorrect behaviour, and
would appreciate some help. Here is a simple example using the
packaged example "xsyn_sample.rules":
speel=# CREATE EXTENSION dict_xsyn;
CREATE EXTENS
Hello
2013/6/7 Rebecca Clarke :
> Hi all
>
> I'm looking for suggestions on the best way to track the updates to a
> function.
>
> We have two databases, Dev & Live, so I want to update Live with just the
> functions that have been modified in the DEV databas3e.
> Is there another, easier way to t
Hi all
I'm looking for suggestions on the best way to track the updates to a
function.
We have two databases, Dev & Live, so I want to update Live with just the
functions that have been modified in the DEV databas3e.
Is there another, easier way to track the updates than manually recording
it in
Hi,
I,ve got a clients table in PostgreSQL. Each client has different
documents (more than 7.000 files in total in different extensions JPG,
XLS,DOC,PDF...) stored in a bytea field in another PostgreSQL Table. My
intention is to create a form using Microsoft Access (or some other
software) to be a
Colin Sloss wrote:
> I have been testing the differences between asynchronous and synchronous hot
> standby streaming
> replication on PostgreSQL 9.2.4. There is some push towards synchronous
> replication, but I am finding
> some serious problems, and wonder how other people deal with them.
>
>
i got it here i done it with 'quote_ident ' instead of 'quote_literal'
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/passing-schema-name-and-table-name-as-parameter-functions-in-postgresql-9-2-tp5758130p5758260.html
Sent from the PostgreSQL - general mailing list arc
27 matches
Mail list logo
