Hurray, that works!
Many thanks David
CREATE OR REPLACE FUNCTION custom.pr_test_parentfunction (
v_action varchar,
out swv_refcur refcursor,
out swv_refcur2 refcursor,
out swv_refcur3 refcursor
)
RETURNS record AS
$body$
DECLARE
SWV_Action VARCHAR(50) DEFAULT Coalesce(v_Act
jonathansfl wrote
> SELECT * INTO v_outvar1, v_outvar2, v_outvar3 FROM
> custom.pr_test_subfunction(SWV_Action);
> OPEN swv_refcur for SELECT v_outvar1;
> OPEN swv_refcur2 for SELECT v_outvar2;
> OPEN swv_refcur3 for SELECT v_outvar3;
> RETURN;
I've never used cursors in this
I'm trying to pass a REFCURSOR variable from a subfunction to its parent
calling function, who will then pass it to the user (for parsing).
thanks to David J I fixed it somewhat, but the user now receives the TEXT of
(etc.) instead of the actual data in that REFCURSOR
variable.
I think the proble
Thank you!
What kind of variable would I declare? Is this any form of right?
No change to subfunction.
In PARENT Function:
DECLARE v_outvar1 REFCURSOR; v_outvar2 REFCURSOR; v_outvar3 REFCURSOR;
?And use:
SELECT * INTO v_outvar1, v_outvar2, v_outvar3 FROM
dev.pr_test_subfunction(SWV_Action);
jonathansfl wrote
> greetings. I'm trying to write a function that acts like a switchboard,
> calling other functions depending on incoming parameters.
> I'm getting error: query has no destination for result data
>
>
> SELECT * FROM dev.pr_test_subfunction(SWV_Action);
In pl/pgsql if you
greetings. I'm trying to write a function that acts like a switchboard,
calling other functions depending on incoming parameters.
I'm getting error: query has no destination for result data
Please advise what we're doing wrong. The subfunctions return a series of
refcursors in a single table and si
ed...';
However it works now. Again thanks to Mr. Wolfe.
Thanks and Regards
Kaleeswaran Velu
From: Wolfe Whalen
To: Kaleeswaran Velu
Cc: Postgres SQL List
Sent: Thursday, April 4, 2013 12:58 PM
Subject: Re: [SQL] Postgres trigger issue with update statem
On 04/03/2013 09:08 PM, Kaleeswaran Velu wrote:
Hello Friends,
I am new to Postgres DB. Recently installed Postgres 9.2.
Facing an issue with very simple trigger, tried to resolve myself by
reading documents or google search but no luck.
I have a table A(parent) and table B (child). There is a
Hi Kaleeswaran,
We're glad to have you on the mailing list. I don't know enough about
your trigger function to know exactly where it's going wrong, but I
threw together a quick example that has an insert trigger on a child
table that updates a row on the parent table. I'm hoping this might
hel
Hello Friends,
I am new to Postgres DB. Recently installed Postgres 9.2.
Facing an issue with very simple trigger, tried to resolve myself by reading
documents or google search but no luck.
I have a table A(parent) and table B (child). There is a BEFORE INSERT OR
UPDATE trigger attached in t
Harald Fuchs wrote:
>> hi, i am fairly new in postgresql, so if anyone can help me would be great
>> if i simply do:
>> select ver_no
>> from version
>> order by ver_no
>> the result will be something like this:
>> .1.3.1
>> .1.3.2.5.
>> .1.4.1.7.12
>> .1.4.11.14.7.
>> .1.4.3.109.1.
>> .1.4.8.
In article ,
James Bond writes:
> hi, i am fairly new in postgresql, so if anyone can help me would be great
> if i simply do:
> select ver_no
> from version
> order by ver_no
> the result will be something like this:
> .1.3.1
> .1.3.2.5.
> .1.4.1.7.12
> .1.4.11.14.7.
> .1.4.3.109.1.
> .1.4.8.
James Bond wrote:
> hi, i am fairly new in postgresql, so if anyone can help me would be great
>
> if i simply do:
>
> select ver_no
> from version
> order by ver_no
>
> the result will be something like this:
>
> .1.3.1
> .1.3.2.5.
> .1.4.1.7.12
> .1.4.11.14.7.
> .1.4.3.109.1.
> .1.4.8.66.
>
hi, i am fairly new in postgresql, so if anyone can help me would be great
if i simply do:
select ver_no
from version
order by ver_no
the result will be something like this:
.1.3.1
.1.3.2.5.
.1.4.1.7.12
.1.4.11.14.7.
.1.4.3.109.1.
.1.4.8.66.
so as you can see first 3 lines ar
On Mon, 24 Jan 2011 10:38:02 +0100
- wrote:
> Hello everyone.
> My question if any known one postgres function, for full text
> search that separates words with "| "?
> As plainto_tsquery separating words with "& ".
>
> For example text "word1 word2 word3 word4"
> and conversion rates for full t
Hello everyone.
My question if any known one postgres function, for full text search that
separates words with "| "?
As plainto_tsquery separating words with "& ".
For example text "word1 word2 word3 word4"
and conversion rates for full text search postgres "word1 | word2 | word3 |
word4"
Or i mu
fine. However, PostGRES can interact with
tables with mixed case letters just fine.
Thanks,
Mike
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Monday, August 30, 2010 11:40 PM
To: Michael Andrew Babb
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] PostGres
On Mon, Aug 30, 2010 at 1:31 PM, Michael Andrew Babb wrote:
> Hi All,
> If I execute a make table query along the lines of “select * into
> SF30001_test from SF30001” I can interact with the table in ArcCatalog just
> fine.
what do
\z SF30001
\z SF30001_test
say about the permissions on the two t
Hi All,
I am using PostGRES 8.3 in conjunction with ESRI's ArcSDE. ArcSDE allows the
storage of spatial data inside of an PostGRES database. One of the programs
bundled with ESRI's GIS suite is ArcCatalog. ArcCatalog is a spatial data
manager. It is possible to browse and analyze the contents o
] Emacs sql-postgres (please, sorry for question not about
PostgreSQL).
Hello all Emacs users!
I am using Emacs recently. I love sql-mode, to use with PostgreSQL,
but I have problems with it.
When my SQL file (or buffer) are small (50-100 lines) I can send
it to SQLi buffer without any problems. But
2010/3/18 Tom Lane :
> Dmitriy Igrishin writes:
>> I am using Emacs recently. I love sql-mode, to use with PostgreSQL,
>> but I have problems with it.
>> When my SQL file (or buffer) are small (50-100 lines) I can send
>> it to SQLi buffer without any problems. But when I working with
>> large SQL
Hello
try to look on
http://www.postgres.cz/index.php/PostgreSQL_SQL_Tricks#Terminal.27s_configuration
Regards
Pavel Stehule
2010/3/18 Dmitriy Igrishin :
> Hello all Emacs users!
>
> I am using Emacs recently. I love sql-mode, to use with PostgreSQL,
> but I have problems with it.
> When my SQL
Dmitriy Igrishin writes:
> I am using Emacs recently. I love sql-mode, to use with PostgreSQL,
> but I have problems with it.
> When my SQL file (or buffer) are small (50-100 lines) I can send
> it to SQLi buffer without any problems. But when I working with
> large SQL file (e.g. complex database
Hello all Emacs users!
I am using Emacs recently. I love sql-mode, to use with PostgreSQL,
but I have problems with it.
When my SQL file (or buffer) are small (50-100 lines) I can send
it to SQLi buffer without any problems. But when I working with
large SQL file (e.g. complex database model, thou
Bryce Nesbitt writes:
> Every so often our production Postgres 8.3 system will get statement
> that runs for a few hours, or a few days, or more, and needs to be
> killed dead. We kill it with pg_cancel_backend(), and cpu usage of the
> process immediately drops, and the process starts serving ot
Every so often our production Postgres 8.3 system will get statement
that runs for a few hours, or a few days, or more, and needs to be
killed dead. We kill it with pg_cancel_backend(), and cpu usage of the
process immediately drops, and the process starts serving other
statements. But the curio
On Tue, Apr 14, 2009 at 2:59 PM, Bryce Nesbitt wrote:
> Scott Marlowe wrote:
>>
>> What does pg_locks say during this time? Specifically about locks
>> that aren't granted?
>
> I don't know, yet. Though these events go for 15-30 minutes before postgres
> restart, and no deadlocks are detected, s
Scott Marlowe wrote:
What does pg_locks say during this time? Specifically about locks
that aren't granted?
I don't know, yet. Though these events go for 15-30 minutes before
postgres restart, and no deadlocks are detected, so I don't think it is
locks.
--
Sent via pgsql-sql mailing list (p
Thanks for the thoughts on what to check. Unfortunately, the priority
of the people responding to the incidents has been to get the system
live again. I will add these items to a list that, hopefully, will be
run through prior to restarting Postgres.
Achilleas Mantzios wrote:
Did you check
On Tue, Apr 14, 2009 at 12:25 AM, Bryce Nesbitt wrote:
> We have a medium scale installation of Postgres 8.3 that is freezing about
> once a week. I'm looking for any hints on how to diagnose the situation, as
> nothing is logged.
>
> The system is matched pair of Sunfire servers, running Debian
Στις Tuesday 14 April 2009 09:25:54 ο/η Bryce Nesbitt έγραψε:
> We have a medium scale installation of Postgres 8.3 that is freezing
> about once a week. I'm looking for any hints on how to diagnose the
> situation, as nothing is logged.
>
> The system is matched pair of Sunfire servers, runnin
We have a medium scale installation of Postgres 8.3 that is freezing
about once a week. I'm looking for any hints on how to diagnose the
situation, as nothing is logged.
The system is matched pair of Sunfire servers, running Debian Etch with
a 2.6.18-6-amd64 kernel, PostgreSQL 8.3.4, and DRBD
am Tue, dem 11.11.2008, um 14:57:20 +0100 mailte Bart van Houdt folgendes:
> Hi all,
Please, don't hijack other threads.
>
> This might be a stupid question, but I wasn't able to find any information on
> it, so here it goes:
> Oracle knows a view which contains information about indexed colu
Cool!
Thx :D
Bart van Houdt
Syfact International B.V.
Database developer
-Original Message-
From: Mario Splivalo [mailto:[EMAIL PROTECTED]
Sent: dinsdag 11 november 2008 15:03
To: pgsql-sql@postgresql.org
Cc: Bart van Houdt
Subject: Re: [SQL] Postgres version of all_ind_cols
Bart van
Bart van Houdt wrote:
Hi all,
This might be a stupid question, but I wasn't able to find any information on
it, so here it goes:
Oracle knows a view which contains information about indexed columns
(all_ind_cols), is there something similar available in Postgres?
I want to be able to create a
Hi all,
This might be a stupid question, but I wasn't able to find any information on
it, so here it goes:
Oracle knows a view which contains information about indexed columns
(all_ind_cols), is there something similar available in Postgres?
I want to be able to create an full overview of each
I guess you can change a little the query to your needs.
The problem is pretty much the same...
I've used c3 column in equality, but if this column
has repeated values, just choose any column or combination of columns which
is unique.
Best,
Oliveiros
SELECT a.c1,a.c2,b.c3,b.c4,a.c5,b.c6
FROM
(
SE
Just add two conditions on the previous query
A particularity of this approach is that the non-null record will always
appear with the first child in alphabetical order.
But, according to what you explain, I guess it is OK, and if it doesn't it
is easily changed. :-)
Also I've changed the first c
hi,
i don't want any sort.. just like this example
*num father child age col5
*1 joe bruce14 8
lei 10
mike 5
2manuel child135 16
child233
child3 30
this is what
s
SELECT a.num,a.father,b.child,b.age
FROM
(
SELECT num,father, MAX(age)as maximo
FROM t1
GROUP BY num,father) a
RIGHT JOIN t1 b
ON b.age = a.maximo
- Original Message -
From: Zied Kharrat
To: pgsql-sql@postgresql.org
Sent: Thursday, October 23, 2008 9:14 AM
Subject: [SQL] Po
Hi Everybody..
Let's present my problem:
I have a table named *t1* and i will insert differents values like this :
insert into t1 (num,father,child,age) values ('1','joe','bruce','14',);
insert into t1 (num,father,child,age) values ('1','joe','lei','10',);
insert into t1 (num,father,child,age) v
Hai all,
my postgres version is PostgreSQL 8.1.8 didn't support clock_timestamp()
regards:
Anoop
2008/7/25 Anoop G <[EMAIL PROTECTED]>:
>
> Hai all,
>
>I have database running on server. I am using python to run my
> application.postgres client is running on the clients .All clients are
> connected to a single database running on server. Each time application
> starts ,the login time is
Anoop G wrote:
Hai all,
I have database running on server. I am using python to run my
application.postgres client is running on the clients .All clients are
connected to a single database running on server. Each time application
starts ,the login time is taken from server using the query
"
Hai all,
I have database running on server. I am using python to run my
application.postgres client is running on the clients .All clients are
connected to a single database running on server. Each time application
starts ,the login time is taken from server using the query
"""select CAST ( t
On Thu, Jul 24, 2008 at 7:56 AM, Anoop G <[EMAIL PROTECTED]> wrote:
> Hai all,
>
> when i was going through the Postgresql documents, i came across a section
> which tells about the TIME ZONE settings
>
>
> what i understood from the document is, based on the value given in this
> conf file postgre
Hai all,
when i was going through the Postgresql documents, i came across a section
which tells about the TIME ZONE settings
what i understood from the document is, based on the value given in this
conf file postgres will add or subtract the displacement hours to the system
time assuming that th
Chadwick Horn wrote:
It looks to me like psql is managing to start a new connection
before the postmaster notices the crash of the prior backend and
tells everybody to get out of town. Which is odd, but maybe not
too implausible if your kernel is set up to favor interactive
processes over ba
"Chadwick Horn" <[EMAIL PROTECTED]> writes:
I keep getting this error:
Attempting reset: WARNING: terminating connection because of crash of
another server process
It looks to me like psql is managing to start a new connection before
the postmaster notices the crash of the prior backend and
"Chadwick Horn" <[EMAIL PROTECTED]> writes:
> I keep getting this error:
> Attempting reset: WARNING: terminating connection because of crash of another
> server process
It looks to me like psql is managing to start a new connection before
the postmaster notices the crash of the prior backend an
TECTED]>
To: "Chadwick Horn" <[EMAIL PROTECTED]>
Cc: "Tom Lane" <[EMAIL PROTECTED]>;
Sent: Tuesday, March 18, 2008 8:37 AM
Subject: Re: [SQL] postgres server crashes unexpectedly
On Tue, 18 Mar 2008, Chadwick Horn wrote:
Sorry about the lack of information
On Tue, 18 Mar 2008, Chadwick Horn wrote:
Sorry about the lack of information on the system. We're running fedora (not
for sure what version though) core (whitebox).
This may not matter in the least bit, but have you tried running the DB on
a real RHEL, or CentOS box? The kernel and libs on
t;[EMAIL PROTECTED]>
To: "Chadwick Horn" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, March 17, 2008 7:32 PM
Subject: Re: [SQL] postgres server crashes unexpectedly
"Chadwick Horn" <[EMAIL PROTECTED]> writes:
PANIC: corrupted item pointer: offset = 0, size = 0
LOG:
"Chadwick Horn" <[EMAIL PROTECTED]> writes:
> PANIC: corrupted item pointer: offset = 0, size = 0
> LOG: autovacuum process (PID 3037) was terminated by signal 6
Hmm ... the only instances of that error text are in PageIndexTupleDelete
and PageIndexMultiDelete, so we can fairly safely say that y
hi all,
we've had a db to stop working for some reason and have searched through google
to it's ends to no avail. we have reindexed the database and system database as
tried to determine other things that would keep it from working... again, to no
avail.
this just started occuring about 2 week
Pascal Tufenkji wrote:
Hi Shane,
You are exactly right.
My issue is that, I now have one role called sti - that has carried the
group members from the old version -
So what do you think my options are, so I can separate them?
I have only one option in my mind:
- Revoke the me
ry 08, 2008 3:54 PM
To: [EMAIL PROTECTED]
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Postgres roles
Pascal Tufenkji wrote:
> My questions are:
>
>
>
> 1. how do I identify the users assigned to this role :
> (in the older version)
> SELECT grolist f
Pascal Tufenkji wrote:
My questions are:
1. how do I identify the users assigned to this role :
(in the older version)
SELECT grolist from pg_group where groname = 'sti';
"The view pg_group exists for backwards compatibility: it emulates a
catalog that existed in PostgreSQL before
Hi,
I'd like to ask you a question about users, groups and roles.
In older versions of Postgres we had users and groups as two separate
entities
Our IT department at work is called "sti", that's why:
- I had a user "sti" (the username of our IT manager)
- I had a group "sti"
"Tena Sakai" <[EMAIL PROTECTED]> writes:
> Namely, I shutdown the database, issued two commands:
> /sbin/sysctl -w kernel.shmmax=134217728
> /sbin/sysctl -w kernel.shmall=2097152
> and rebooted the computer.
>
> After it came up, I checked the shmmax and it is set
> as 33554432. Which surpris
--- On Wed, 11/14/07, Tena Sakai <[EMAIL PROTECTED]> wrote:
> The postgres server I have (on redhat linux with recent
> Dell hardware) is running terribly slow.
Hello Tena,
If you do not get a response to your question regarding performance, you might
try resending this email to : [EMAIL PROTECT
Hi Everybody,
The postgres server I have (on redhat linux with recent
Dell hardware) is running terribly slow.
A job it should have gotten done in less than 1 hour
took 7.5 hours last night. I checked kernel parameter
shmmax and it was set as 33554432. I "fixed" it as
suggested by the manual:
h
On 8/29/07, Radhika Sambamurti <[EMAIL PROTECTED]> wrote:
> Hi,
> I am using a function in postgres 7.4 that returns an integer.
> I modified my store procedure (same function and parameters) to point to
> another table, and return an int.
> But now I am not getting the correct answer only 0.
>
>
Hi,
I am using a function in postgres 7.4 that returns an integer.
I modified my store procedure (same function and parameters) to point to
another table, and return an int.
But now I am not getting the correct answer only 0.
I verified that the column I am returning is int in both the first tabl
Sumeet <[EMAIL PROTECTED]> writes:
> My Vacuum's are running very very slow and expecially when vacuuming indexes
> in large tables of size in 5-10 gigabytes,
> can some one help me determine the parameters for postgres.conf which will
> help me vacuum fast. I'm running postgres on a server with 32
On Tue, 2007-03-13 at 15:48, Sumeet wrote:
> On 3/13/07, Andrej Ricnik-Bay <[EMAIL PROTECTED]> wrote:
> On 3/14/07, Sumeet <[EMAIL PROTECTED]> wrote:
> > Hi All,
> Hi,
>
> > Sorry if this is the wrong list to ask this question.
> General woould have
The only info i have is
Apple xRaid drive array with 14 400GB drives for a total of 5 TB storage
I have around 10-15 indexes for each tables. does the number of indexes slow
down the vacuum process?
indexes are compund indexes on multiple fields.
-Sumeet
On 3/13/07, Andrej Ricnik-Bay <[EMAIL P
On 3/14/07, Sumeet <[EMAIL PROTECTED]> wrote:
Hi All,
Hi,
Sorry if this is the wrong list to ask this question.
General woould have been better :)
My Vacuum's are running very very slow and expecially when vacuuming indexes
in large tables of size in 5-10 gigabytes,
can some one help me det
Hi All,
Sorry if this is the wrong list to ask this question.
My Vacuum's are running very very slow and expecially when vacuuming indexes
in large tables of size in 5-10 gigabytes,
can some one help me determine the parameters for postgres.conf which will
help me vacuum fast. I'm running postgr
On Tue, 2006-09-05 at 11:22 -0400, Tom Lane wrote:
> Mario Splivalo <[EMAIL PROTECTED]> writes:
> > So, I guess it's obvious that postgres doesn't treat regular expressions
> > the same way as java/perl/pyton/php/awk/sed do...
>
> When you get into stuff as arcane as word-boundary constraints, you
On 9/5/06, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
In Perl at least, \b is a word boundary. In PostgreSQL (and probablyTcl as well) it's a backslash AFAICT.More specifically, Perl, Java and Python interpret \b as a backspace in the Character class only (got that from the Regular _expression_ poc
Mario Splivalo <[EMAIL PROTECTED]> writes:
> So, I guess it's obvious that postgres doesn't treat regular expressions
> the same way as java/perl/pyton/php/awk/sed do...
When you get into stuff as arcane as word-boundary constraints, you'll
find that regexes are not NEARLY as well standardized as
Mario Splivalo wrote:
> On Tue, 2006-09-05 at 10:21 -0400, Alvaro Herrera wrote:
> > Mario Splivalo wrote:
> > > On Tue, 2006-09-05 at 08:42 -0500, Aaron Bono wrote:
> > > > On 9/5/06, Mario Splivalo <[EMAIL PROTECTED]> wrote:
> > > >
> > > > pulitzer2=# select 'stop works' ~ '^\s*
On Tue, 2006-09-05 at 10:21 -0400, Alvaro Herrera wrote:
> Mario Splivalo wrote:
> > On Tue, 2006-09-05 at 08:42 -0500, Aaron Bono wrote:
> > > On 9/5/06, Mario Splivalo <[EMAIL PROTECTED]> wrote:
> > >
> > > pulitzer2=# select 'stop works' ~ '^\s*(?:[\
> > > +|-]|(?:[sS][t
Mario Splivalo wrote:
> On Tue, 2006-09-05 at 08:42 -0500, Aaron Bono wrote:
> > On 9/5/06, Mario Splivalo <[EMAIL PROTECTED]> wrote:
> >
> > pulitzer2=# select 'stop works' ~ '^\s*(?:[\
> > +|-]|(?:[sS][tT][oO][pP]\b)).*$';
> > ?column?
> > --
> >
On Tue, 2006-09-05 at 08:42 -0500, Aaron Bono wrote:
> On 9/5/06, Mario Splivalo <[EMAIL PROTECTED]> wrote:
>
> pulitzer2=# select 'stop works' ~ '^\s*(?:[\
> +|-]|(?:[sS][tT][oO][pP]\b)).*$';
> ?column?
> --
> f
> (1 row)
>
On Tue, 2006-09-05 at 10:11 -0400, Tom Lane wrote:
> Mario Splivalo <[EMAIL PROTECTED]> writes:
> > Now, here is what happens if I try this in postgres:
>
> > pulitzer2=# select '+mario' ~ '^\s*(?:[\+|-]|(?:[sS][tT][oO][pP]\b)).*$';
>
> I'm thinking you've forgotten to double your backslashes.
>
Mario Splivalo <[EMAIL PROTECTED]> writes:
> Now, here is what happens if I try this in postgres:
> pulitzer2=# select '+mario' ~ '^\s*(?:[\+|-]|(?:[sS][tT][oO][pP]\b)).*$';
I'm thinking you've forgotten to double your backslashes.
regards, tom lane
-
On 9/5/06, Mario Splivalo <[EMAIL PROTECTED]> wrote:
pulitzer2=# select 'stop works' ~ '^\s*(?:[\+|-]|(?:[sS][tT][oO][pP]\b)).*$'; ?column?-- f(1 row)Here, postgres should return true, but it gives me false.
\b is a back-space - is that what you are wanting there? If I remove it I get tru
I have an regular expression, wich works fine in Java or python, but I
don't seem to be able to make it work in postgres. Regular expression
needs to match everything begining with '+' (plus sign) or letters
'STOP', 'stop', 'StoP', or any other combination pronounced 'stop'.
Here is the python exa
On Mon, Jul 10, 2006 at 01:30:51PM -0500, Scott Marlowe wrote:
> > (which means you have to deal with failures in one database and not
> > another). Is the idea that this is multi-master?
>
> I wonder if it would be possible to write a set of triggers for MSSQL
> that would allow you to run slony
[EMAIL PROTECTED] (Scott Marlowe) writes:
> On Mon, 2006-07-10 at 11:25, Andrew Sullivan wrote:
>> On Mon, Jul 10, 2006 at 11:27:52AM -0400, Kevin Bednar wrote:
>> > Looking to keep 2 databases in sync, at least semi-realtime if possible,
>> > although running a batch update every x mins wouldn't
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Scott Marlowe
> Sent: 10 July 2006 20:03
> To: Kevin Bednar
> Cc: Forums @ Existanze; pgsql-sql@postgresql.org
> Subject: Re: [SQL] MS-SQL<->Postgres sync
>
> I thi
Date: Mon, 10 Jul 2006 13:31:35 -0500
> Subject: Re: [SQL] MS-SQL<->Postgres sync
>
> Look at slony.
>
> On Mon, 2006-07-10 at 11:06, Forums @ Existanze wrote:
> >
Kevin Bednar wrote:
> Took a quick glance but were running windows on both sides and it didnt look
> like that would work. Didnt look real hard though.
I think the to-be-released stuff is supposed to have Windows support.
They were supposed to release Real Soon Now some time ago, so I guess
they
On Mon, 2006-07-10 at 11:25, Andrew Sullivan wrote:
> On Mon, Jul 10, 2006 at 11:27:52AM -0400, Kevin Bednar wrote:
> > Looking to keep 2 databases in sync, at least semi-realtime if possible,
> > although running a batch update every x mins wouldn't be out of the
> > question. One db is postgres
ostgresql.orgDate: Mon,
10 Jul 2006 13:31:35 -0500Subject: Re: [SQL] MS-SQL<->Postgres
sync Look
at slony.On Mon, 2006-07-10 at 11:06, Forums @ Existanze wrote:
> > We are looking for the exact thing
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin
> Bednar
> Sent: 10 July 2006 18:28
> To: pgsql-sql@postgresql.org
> Subject: [SQL] MS-SQL<->Postgres sync
>
>
> Looking to keep 2 databases in sync, at least semi-re
> On 7/10/06, Kevin Bednar <[EMAIL PROTECTED]> wrote:
> >
> > Thanks Aron. What I'm actually trying to do is this:
> >
> > Postgress in physical store, being used by POS system as the back end.
> > MS-SQL being used on web server by ecommerce system.
> >
> > Table structures are different of cours
table would work.
I'll have to look into it. Thanks! Kevin
-Original Message-From: "Aaron Bono"
<[EMAIL PROTECTED]>To: "Kevin Bednar"
<[EMAIL PROTECTED]>, pgsql-sql@postgresql.orgDate:
Mon, 10 Jul 2006 12:15:34 -0500Subject: Re: [SQL]
MS-SQL<-&g
Please reply to all when replying on the list...On 7/10/06, Kevin Bednar <[EMAIL PROTECTED]
> wrote:
Thanks Aron. What I'm actually trying to do is this:
Postgress in physical store, being used by POS system as the back
end. MS-SQL being used on web server by ecommerce system.
Ta
On 7/10/06, Kevin Bednar <[EMAIL PROTECTED]> wrote:
Looking to keep 2 databases in
sync, at least semi-realtime if possible, although running a batch update
every x mins wouldn't be out of the question. One db is postgres and the
other is ms-sql. It's to keep inventory in sync from 2
On Mon, Jul 10, 2006 at 11:27:52AM -0400, Kevin Bednar wrote:
> Looking to keep 2 databases in sync, at least semi-realtime if possible,
> although running a batch update every x mins wouldn't be out of the
> question. One db is postgres and the other is ms-sql. It's to keep inventory
> in sync
We are looking for the exact thing but with two PostgreSQL databases
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin
BednarSent: 10 July 2006 18:28To:
pgsql-sql@postgresql.orgSubject: [SQL] MS-SQL<->Postgres
sync
Looking to keep 2 databa
Looking to keep 2 databases in
sync, at least semi-realtime if possible, although running a batch update
every x mins wouldn't be out of the question. One db is postgres and the
other is ms-sql. It's to keep inventory in sync from 2 seperate locations,
one being a brick and mortar store and
Schnabl, Sebastian wrote:
> I use postgres 8.1 and trie to run jboss over sequoia-ha
> (http://sequoia.continuent.org/HomePage). But i have an problem with
> sequences. Sequoia claims to support for good reasons and
> db-independece only "sql-standard(s)". Therefore they DON'T support
> the postgre
Hello,
I use postgres 8.1 and trie to run jboss over sequoia-ha
(http://sequoia.continuent.org/HomePage). But i have an problem with sequences.
Sequoia claims to support for good reasons and db-independece only
"sql-standard(s)". Therefore they DON'T support the postgres-specific "select
next
Hi!
I have postgres installed in my
machine and have a simple task to do.
Step1) Fetch all the tables in the Database with
name staerting with "AA"
Step2) On each table you get fire a simple SQL
query:
select *
from ;
Step3) Right these into a flat file.
I have to carry out all th
Hi,
ich bin dabei DB-Server zu einem Cluster zusammen zuführen mit
PGCLUSTER. Hat schon jemand von euch damit gearbeitet und kann mir mal
seine Meinung/Erfahrung dazu sagen (positiv oder negativ).
Werde auch meine Erfahrung noch Erfolg hier mal posten.
Server: 7.4.1 (suse9.0)
pgcluster-1.1
Grüs
On Fri, 2005-10-21 at 10:20 -0400, Tom Lane wrote:
> Mario Splivalo <[EMAIL PROTECTED]> writes:
> > I have a query that does COUNT, LEFT JOIN and GROUP BY from two tables.
> > One has 85000 records, and other has 100 records. I've been running
> > the tests on 7.4.3,
>
> Your later message sho
1 - 100 of 267 matches
Mail list logo
