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
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.
>
>
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
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
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 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
> 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
> 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
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
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
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
27 matches
Mail list logo
