I must add (which i should have included in the original post),
that apart from the FK also 2 triggers on the same table were lost.
And in a 2nd table also two triggers were lost.
(all triggers for use with tsearch2)
Στις Monday 22 November 2010 18:11:12 γράψατε:
> The differences do look suspici
Στις Monday 22 November 2010 18:45:28 γράψατε:
> Achilleas Mantzios wrote:
>
> > (imagine having to upgrade 61 installations for which you dont
> > have ssh/scp ;) sounds fun right? )
>
> I don't have to imagine -- been there, done that. (Not with ships
> but large geographical distances and
On Nov 14, 11:52 am, ojas.du...@gmail.com (ojas dubey) wrote:
> Hi,
>
> I wanted to know if there is a way to get the hostnames of all the systems
> running PostGres DB servers on a local network on Windows (XP/Vista/7) using
> JDBC or any other Java API ?
>
> Regards,
> Ojas
Hi,
JDisc Discovery
Khangelani Gama wrote:
> dbmaster =# select to_char(sum(aud_id),9.99) from
> audmth where aud_id <1669629;
> to_char
> ---
> 2774814647.00
> (1 row)
> dbbackup =# select to_char(sum(aud_id),9.99) from
> audmth where aud_id <1669629;
> to_char
> -
Achilleas Mantzios writes:
> At this time our problematic vessel was running 7.4.2. This vessel upgraded
> to 8.3.3
> some time in January 2009.
7.4!?
I can't shake the suspicion that some of your issues arose from trying
to load a later-version pg_dump output into an older-version server.
The
Στις Tuesday 23 November 2010 17:22:29 ο/η Tom Lane έγραψε:
> Achilleas Mantzios writes:
> > At this time our problematic vessel was running 7.4.2. This vessel upgraded
> > to 8.3.3
> > some time in January 2009.
>
> 7.4!?
>
> I can't shake the suspicion that some of your issues arose from try
Hello,
Does calling a pl/python function from each database connection load the
python interpreter each time? what are the effects of using pl/python
function in a environment where no. of concurrent connections are more and
each user calls a pl/python function?
Please give the details about how p
Tom Lane wrote:
> "Kevin Grittner" writes:
>> A symbolic link seems both safer and easier.
> The notion of mounting a filesystem directly there scares me, on
> the whole. Here is the problem: what if someday that filesystem
> happens not to be mounted? Then you have a bare mountpoint
> dire
Hi,
This is a hypothetical problem but not an impossible situation. Just curious
about what would happen.
Lets say you have an OLTP server that keeps very busy on a large database. In
this large database you have one or more tables on super fast storage like a
fusion IO card which is handling
Elliot Chance writes:
> This is a hypothetical problem but not an impossible situation. Just curious
> about what would happen.
> Lets say you have an OLTP server that keeps very busy on a large database. In
> this large database you have one or more tables on super fast storage like a
> fusio
Hello,
Does calling a pl/python function from each database connection load the
python interpreter each time? what are the effects of using pl/python
function in a environment where no. of concurrent connections are more and
each user calls a pl/python function?
Please give the details about how p
Hi Kevin
Thanks for feedback, I was going to answer your questions and I believe that
your questions were going to lead us to the solution due to the fact that one
of my seniors discovered that there is a bug on getting the data from master to
the backup affecting only this table audmth, which
12 matches
Mail list logo
