Hi,
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
showing same messages
hi my requirement is to create a table as a result of sub-query and the table
and schema name should be passed as parameters of a function
i also tried like this;
CREATE OR REPLACE FUNCTION secc_master.chkschema(schemaname text, tableis
text)
RETURNS void AS
$BODY$
DECLARE
ione boolean;
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
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
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 r.clark...@gmail.com:
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,
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
Le 2013-06-06 à 18:40, Michael Paquier a écrit :
On Fri, Jun 7, 2013 at 1:37 AM, François Beausoleil franc...@teksol.info
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
Le 2013-06-06 à 17:59, Tom Lane a écrit :
=?iso-8859-1?Q?Fran=E7ois_Beausoleil?= franc...@teksol.info 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
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 jeff.ja...@gmail.com
To: mads.tand...@schneider-electric.com
mads.tand...@schneider-electric.com,
Cc: Albe Laurenz
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
2013/6/7 Pavel Stehule pavel.steh...@gmail.com
Hello
2013/6/7 Rebecca Clarke r.clark...@gmail.com:
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
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)
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
intention is
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
Hello
2013/6/7 Aitor Gil Martin agmar...@getxo.net:
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
c k shreeseva.learn...@gmail.com 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
Marc Dahn d...@tfiu.de 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
On Fri, Jun 7, 2013 at 3:22 AM, Albe Laurenz laurenz.a...@wien.gv.at 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
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 r.clark...@gmail.com:
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
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
From: Pavel Stehule pavel.steh...@gmail.com
To: Rebecca Clarke r.clark...@gmail.com
Cc: pgsql-general@postgresql.org
Sent: Friday, 7 June 2013, 11:44
Subject: Re: [GENERAL] Function tracking
Hello
2013/6/7 Rebecca Clarke r.clark...@gmail.com:
Hi all
I'm looking for suggestions
From: Rebecca Clarke r.clark...@gmail.com
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
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 main
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 franc...@teksol.info
wrote:
I can't seem to promote the slave:
$ sudo -u
On Thu, Jun 6, 2013 at 5:23 AM, Richard Huxton d...@archonet.com 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
28 matches
Mail list logo