On 06/22/2013 10:32 PM, itishree sukla wrote:
yes, when i tried to start, postgresql service using init.d its gave me
the error removed stale pid, postgresql failed to start.
What is the actual error message?
Regards,
Itishree
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-
Hi,
I recently added a check constraint onto a table in my database, that uses
a stored procedure to check one of the inserted columns against the data of
another table.
I know that this is stretching the limit of what a check constraint is
meant to be, but is there a way, short of editing the pg
=?UTF-8?B?6auY5YGl?= writes:
>>> So I think that the above example can not show that "parameterized path"
>>> has been created.
>> But if you try the PREPAREd sets in versions before 9.2, you will find
>> they use the same plan as each other. Allowing them to differ based on the
>> parameter th
Alan Hodgson writes:
> On Thursday, June 20, 2013 07:52:21 AM Merlin Moncure wrote:
>> OP needs to explore use of connection pooler, in particular pgbouncer.
>> Anyways none of this explains why the server is actually crashing.
> It might be hitting file descriptor limits. I didn't dig into the e
El 23/06/13 13:34, Moshe Jacobson escribió:
Hi,
I recently added a check constraint onto a table in my database, that
uses a stored procedure to check one of the inserted columns against the
data of another table.
Is it possible to see the function?
I know that this is stretching the limit o
On Sun, Jun 23, 2013 at 5:04 PM, Martín Marqués wrote:
> Is it possible to see the function?
Yes -- It checks that the given vendor has the given vendor_type by calling
fn_get_vendor_types_by_vendor(), which gets its data from another table,
tb_vendor_vendor_type (a join table between tb_vendor
Hi,
Is there any settings in postgresql version 9.2 similar to mysql strict mode? I
need to get rid of some type casting errors in the upgrading process from
version 7.4 to 9.2, if this mode is not available I have to modify queries in
the system to make it work...
Thanks in Advance,
Arun
Arun P.L wrote:
> Hi,
>
> Is there any settings in postgresql version 9.2 similar to mysql strict mode?
> I
> need to get rid of some type casting errors in the upgrading process from
> version 7.4 to 9.2, if this mode is not available I have to modify queries in
> the system to make it work...
On Jun 24, 2013, at 3:47, Moshe Jacobson wrote:
> On Sun, Jun 23, 2013 at 5:04 PM, Martín Marqués
> wrote:
> Is it possible to see the function?
>
> Yes -- It checks that the given vendor has the given vendor_type by calling
> fn_get_vendor_types_by_vendor(), which gets its data from another
