Is there any way in which a trigger can return the # of rows affected by the
insert / delete ?
Master
→ slave_1
→ slave_2
Trigger is against master which will, based on the conditions re-direct the
data into the relevant slave_X partitions.
I think this post basically is what I am seeing.
http:
Is there any way in which a trigger can return the # of rows affected by the
insert / delete ?
Master
--> slave_1
--> slave_2
Trigger is against master which will, based on the conditions re-direct the
data into the relevant slave_X partitions.
I think this post basically is what I am
On 01/09/2009 05:14, Yaroslav Tykhiy wrote:
Thanks, I make a restore backup on the slave this morning, and It
works !
Could you detail your solution please, if any? I've seen frozen
pg_controldata output on my standby server for ages and attributed
that to the ancient version of pgsql (8.
On Sun, 6 Sep 2009, APseudoUtopia wrote:
Sorry to post again. I was reading over the documentation and I
discovered that it is possible to concatenate two tsvector's together.
So I can concat the subject tsvector index from the forums_topics
table with the post body in forums_posts.
If you re
-Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> Is there any way in which a trigger can return the # of rows affected by
> the
> insert / delete ?
>
> Master
> ---> slave_1
> ---> slave_2
>
> Trigger is against master which will, based on the cond
On 2009-09-03, S Arvind wrote:
> --001636ed7465170dcf0472ab404d
> Content-Type: text/plain; charset=ISO-8859-1
>
> I have 2 doubts related to Filsesytem and Postgres data folder
>
> 1.Currently in CentOS, our postgres data folder is in single filesystem. Is
> there any possibility to have a singl
On 2009-08-31, bilal ghayyad wrote:
> Just writing a Function in the PostgreSQL it self (so it is sql scripting).
> It is not from any development language.
plpgsql or sql ?
plpgsql has "GET DIAGNOSTICS":
GET DIAGNOSTICS integer_var = ROW_COUNT;
bye.
--
Sent via pgsql-general mailing lis
On 2009-09-02, V S P wrote:
> Hi,
> our application is using Postgres in a rather unusuall way.
> It is used by a GUI application to store several hundred
> thousand 'parameters'. Basically it is used like a big INI
> file.
>
> There are about 50 tables with various parameters.
>
> The applicatio
On Sep 7, 2009, at 2:26 AM, Rakotomandimby Mihamina wrote:
I have a function like this:
CREATE FUNCTION f_active_client(character varying)
RETURNS character varying
AS $_$
DECLARE
v_modem ALIAS FOR $1;
v_firstuse BOOLEAN;
v_admactive BOOLEAN;
v_codeclt varchar;
BEGIN
SELEC
On Sep 6, 2009, at 7:29 PM, Tom Lane wrote:
Jerry LeVan writes:
I have compiled a 32 bit ( CC="gcc -arch i386" ) version of
PG 8.4.0.
Since that's not the default on SL, have you tried 64 bit?
could not lookup DNS configuration info service: (ipc/send) invalid
destination port
LOG: could
hi jerry,
could not lookup DNS configuration info service: (ipc/send) invalid
destination port
LOG: could not resolve "localhost": nodename nor servname provided,
or not known
LOG: disabling statistics collector for lack of working socket
WARNING: autovacuum not started because of misconfigur
Shakil Shaikh wrote:
> --
> From: "Alvaro Herrera"
>
> >Shakil Shaikh wrote:
> >
> >>
> >>ERROR: could not access file "$libdir/plperl": No such file or directory
> >>
> >>Apparently this means that the version of Postgresql I have wasn't
> >>compi
From: Jan Otto [as...@me.com]
Sent: Monday, September 07, 2009 9:37 AM
To: Tom Lane
Cc: Levan, Jerry; pgsql-general@postgresql.org general
Subject: Re: [GENERAL] More Snow Leopard problems...
hi jerry,
>> could not lookup DNS configuration info service: (
Jasen Betts wrote:
> On 2009-09-03, S Arvind wrote:
> > --001636ed7465170dcf0472ab404d
> > Content-Type: text/plain; charset=ISO-8859-1
> >
> > I have 2 doubts related to Filsesytem and Postgres data folder
> >
> > 1.Currently in CentOS, our postgres data folder is in single filesystem. Is
> > th
On Monday 07 September 2009 6:03:28 am Jerry LeVan wrote:
> On Sep 6, 2009, at 7:29 PM, Tom Lane wrote:
> > Jerry LeVan writes:
> >> I have compiled a 32 bit ( CC="gcc -arch i386" ) version of
> >> PG 8.4.0.
> >
> > Since that's not the default on SL, have you tried 64 bit?
> >
> >> could not look
Upgraded to Snow Leopard Saturday, and am having problems building now.
The build logs are here
http://buildfarm.postgresql.org/cgi-bin/show_status.pl?member=polecat
And the failing part is here:
make -C preproc all
make -C ../../../../src/port all
make[5]: Nothing to be done for `all'.
"/usr/b
unsubscribe pgsql-general mlacu...@gmail.com
--
Saludos / Best regards
Mario Lacunza
Software Architect - Webmaster
Website: http://www.lacunza.biz
Email: mlacunza [AT] gmail [DOT] com
Lima - Peru
On Sep 7, 2009, at 11:36 AM, Adrian Klaver wrote:
On Monday 07 September 2009 6:03:28 am Jerry LeVan wrote:
On Sep 6, 2009, at 7:29 PM, Tom Lane wrote:
Jerry LeVan writes:
I have compiled a 32 bit ( CC="gcc -arch i386" ) version of
PG 8.4.0.
Since that's not the default on SL, have you tr
On Sep 7, 2009, at 9:37 AM, Jan Otto wrote:
hi jerry,
could not lookup DNS configuration info service: (ipc/send) invalid
destination port
LOG: could not resolve "localhost": nodename nor servname provided,
or not known
LOG: disabling statistics collector for lack of working socket
WARNING:
Hello.
> Should I do that if the key will be the same for the whole partition?
> Will there be any benefits of having an index on site_id column?
It looks like there is no any need in index on the site_id column for
partitions.
Here is SQL illustraing DB structure and typical usage (which I shou
On 7 Sep 2009, at 21:50, Jerry LeVan wrote:
Snow Leopard needs a bit of work... On my main machine, a macbook
pro3,1 the mds processes
keep dumping core and so spotlight does not work ( and for some
reason I have to reboot
I've seen it take up lots of CPU here until I removed all drives fro
On 7 Sep 2009, at 21:50, Jerry LeVan wrote:
On Sep 7, 2009, at 11:36 AM, Adrian Klaver wrote:
On Monday 07 September 2009 6:03:28 am Jerry LeVan wrote:
On Sep 6, 2009, at 7:29 PM, Tom Lane wrote:
Jerry LeVan writes:
I have compiled a 32 bit ( CC="gcc -arch i386" ) version of
PG 8.4.0.
S
Hi there,
As a beginner of PostgreSQL, I installed PostgreSQL 8.3.7 on Ubuntu 9.04
by using sudo apt-get install.
Now, I want to store PostgreSQL data on an external drive because I work
both on my office machine and on my home machine a lot. This way, I can
always bring my external drive t
your tables are probably not using the new default tablespace
SET default_tablespace = new_tablespace_name
any new tables will be placed into new default tablespace by inserting
TABLESPACE clause
can you put the WHOLE database on the external drive?
Martin Gainty
___
Hi Martin,
Thanks for reply. However, your answer confuses me.
your tables are probably not using the new default tablespace
SET default_tablespace = new_tablespace_name
any new tables will be placed into new default tablespace by inserting
TABLESPACE clause
This is what I did:
I created t
Jerry LeVan writes:
> I have compiled a 32 bit ( CC="gcc -arch i386" ) version of
> PG 8.4.0.
> I am finding the following in the pg logfile when I stop then start
> the postgresql server.
> could not lookup DNS configuration info service: (ipc/send) invalid
> destination port
> LOG: could no
26 matches
Mail list logo