ied create temp table But it not works..
Is there any way to use arrays.
2> There is one function in Oracle Executesql '...' to execute
and what i got in Postgres is Execute immediate '.'
But it is giving error at Execute.
I will be very thankful i
The following bug has been logged online:
Bug reference: 2134
Logged by: Amit
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4.6
Operating system: RH Linux
Description:Broken Pipe Error
Details:
I am getting a broken pipe error. The actual exception is
The following bug has been logged online:
Bug reference: 5072
Logged by: Amit Khandekar
Email address: amit.khande...@enterprisedb.com
PostgreSQL version: 8.5devel
Operating system: All
Description:User trying to drop an internally dependent object
crashes server
The following bug has been logged online:
Bug reference: 4123
Logged by: Amit Mujawar
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system: Windows XP
Description:Statement.setQueryTimeout does not work with Postgres
Java Driver
Details:
I am
i have to call one c function users() present in one c file which is as
follows:
#include
#include "pgsql/postgres.h"
void users();
int main()
{
users();
}
void users()
{
FILE *fp;
fp = fopen("/home/suresh/trigger/test.txt","w");
fputs("Hello this is c function",fp)
Hi,
I have successfully installed postgresql 7.2.2. on
windows XP.I am using cygipc-1.11-1 package.
On running the database it gives the
following error:
**
amit gupta@AMITG
/cygdrive/c/pgsql$ ipc-daemon &[2] 3656
amit gupta@A
- Original Message -
From: Amit Gupta
To: [EMAIL PROTECTED]
Sent: Monday, September 02, 2002 4:12 PM
Subject: recreate_mmaps_after_fork_failed
Hi,
I have successfully installed postgresql 7.2.2. on
windows XP.I am using cygipc-1.11-1 package.
On running the database it gives
According to what I can see from this defect that it is not confirmed
whether the Postgre server is started or not properly.
You can try on confirming about the following 2 points:
1. How many postgres processes you are able to see in your task manager.
This can give hint whether appropriate postg
In ODBC while binding variable using SQLBindParameter(..) API you might be
using SQL_DOUBLE or SQL_Numeric or some similar datatype to send the
variable, thats why in postgres it is showing as "Double precision"
-Original Message-
From: pgsql-bugs-ow...@postgresql.org
[mailto:pgsql-bugs-o
: Amit Kapila
Cc: pgsql-bugs@postgresql.org
Subject: RE: [BUGS] BUG #6534: Passing numeric Bind variables to ODBC driver
convers to "Double precision"
No matter what numeric type I try to pass,(integer, numeric, currency) the
ODBC driver is turning it into "Double Precision"
g a function with numeric or integer parameters.
Can you provide this with an example like how you have defined your function
and how it is getting called from ODBC.
-Original Message-
From: Barry Bell [mailto:barry_b...@harte-hanks.com]
Sent: Wednesday, April 11, 2012 6:24 PM
To: Amit
No need to reply the below mail.
I am able to generate the scenario.
One of them is basically when there is an expression involving relations on
one side and Var on other side.
Select * from t1,t2 where t1.c1 + t2.c2 = t1.c3;
From: Amit Kapila [mailto:amit.kap...@huawei.com]
Sent
To strat the service on windows, the user (postgres, incase you didn't
change during installation) needs to be have administrative privilege and
service has to run as that user.
You can use Run as in windows to run the particular executable or change the
user in services.
From: pgsql-bugs-ow..
Can you try installing it on different windows machine.
This should not be a bug of postgres, some problem with the way you or doing or
some env. Problem.
From: Milen Lazarov [mailto:milen_laza...@yahoo.com]
Sent: Saturday, May 05, 2012 11:30 PM
To: Amit Kapila
Subject: Re: [BUGS] no
>> I note that "postgres -C data_directory" will refuse to run on the
>> command line because I've got admin privileges in Windows, and that
>> pg_ctl normally starts postgres.exe using CreateRestrictedProcess.
>> But it does not do so for the popen call in adjust_data_dir.
> if that actually is a
out checking if it's running as root.
-Original Message-
From: Edmund Horner [mailto:ejr...@gmail.com]
Sent: Wednesday, June 13, 2012 6:26 AM
To: Amit Kapila
Cc: Tom Lane; pgsql-bugs@postgresql.org; Bruce Momjian
Subject: Re: [BUGS] 9.2 beta2 - pg_ctl crashes on Win32 when neither PG
PM
To: Amit Kapila
Cc: 'Edmund Horner'; Tom Lane; Pg Bugs; Bruce Momjian
Subject: Re: [BUGS] 9.2 beta2 - pg_ctl crashes on Win32 when neither PGDATA nor
-D specified
Excerpts from Amit Kapila's message of mié jun 13 00:53:47 -0400 2012:
> > Unfortunately in src/backend/main/
thing I have noticed is that in function ExecScanSubPlan, the similar
work is not done in
Per-query memory context, I am not sure if it is of any relevance for the
problem you mentioned.
With Regards,
Amit Kapila.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make chan
is specified.
In function ATExecDropConstraint(), for the constarint
"test_constraints_val1_val2_key" con->connoinherit is false,
due to which it tries to drop the constrint from child table as well.
I have checked that from function index_constraint_create() when it calls
function
ith a test case addition?
Yes. I have started working.
With Regards,
Amit Kapila.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
test case addition?
Let me know if above is sufficient or shall I include anything more in
patch.
With Regards,
Amit Kapila.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
> From: Noah Misch [n...@leadboat.com]
> Sent: Monday, July 16, 2012 8:42 PM
> On Mon, Jul 16, 2012 at 04:49:46PM +0530, Amit Kapila wrote:
>> > Care to prepare a patch with a test case addition?
>> Let me know if above is sufficient or shall I include anything more in
&g
>From: pgsql-bugs-ow...@postgresql.org [mailto:pgsql-bugs-ow...@postgresql.org]
>On
> Behalf Of sobhit.pande...@gmail.com
> The following bug has been logged on the website:
> Bug reference: 6740
> Logged by: sobhit
> Email address: sobhit.pande...@gmail.com
> PostgreSQL vers
From: Noah Misch [mailto:n...@leadboat.com]
Sent: Thursday, July 19, 2012 5:23 PM
On Tue, Jul 17, 2012 at 08:59:50AM +, Amit kapila wrote:
>> Patch is attached with this mail.
> Thanks. This patch is ready for committer.
>> +-- Test non-inheritable indices [UNIQUE, EXCL
this?
Have you tried it with less data?
With Regards,
Amit Kapila.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Sure, no problem.
But I also might take some time to do further analysis as I am little busy
with other things as well.
Hope it will not impact you much.
With Regards,
Amit Kapila.
From: Jeferson Braga [mailto:jefersonbl...@gmail.com]
Sent: Thursday, August 09, 2012 7:42 PM
To
set at the time check constraints are
>checked.
Is there any problem if set tableOID before calling ExecConstarints()?
I am not sure may be this is not so important problem for which we don't
want to
change existing code.
With Regards,
Amit Kapila.
--
Sent via pgsql-bugs mailing list (pg
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Friday, August 24, 2012 7:46 PM
Amit Kapila writes:
> From: pgsql-bugs-ow...@postgresql.org
> [mailto:pgsql-bugs-ow...@postgresql.org] On Behalf Of Tom Lane
>>> None of the system columns are set at the time check constraints
However these attributes get
filled in heap_update much later.
So now should the fix be that it returns an error for system column
reference except for OID case?
With Regards,
Amit Kapila.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
On Friday, September 07, 2012 12:20 AM Amit Kapila wrote:
On Tue, Aug 28, 2012 at 6:40 AM, Amit Kapila wrote:
>> AFAICT during Update also, it doesn't contain useful. The only chance
it
>> would have contain something useful is when it goes for EvalPlanQual and
>> then a
The following bug has been logged on the website:
Bug reference: 7533
Logged by: Amit Kapila
Email address: amit.kap...@huawei.com
PostgreSQL version: 9.2.0
Operating system: Suse
Description:
M host is primary, S host is standby and CS host is cascaded standby.
1
The following bug has been logged on the website:
Bug reference: 7534
Logged by: Amit Kapila
Email address: amit.kap...@huawei.com
PostgreSQL version: 9.2.0
Operating system: Suse 10
Description:
1. Both master and standby machine are connected normally,
2. then you
On Wednesday, September 12, 2012 10:12 PM Magnus Hagander wrote:
On Wed, Sep 12, 2012 at 1:54 PM, wrote:
>> The following bug has been logged on the website:
>
>> Bug reference: 7534
>> Logged by: Amit Kapila
>> Email address: amit.kap...@huawe
On Wednesday, September 12, 2012 10:15 PM Fujii Masao
On Wed, Sep 12, 2012 at 8:54 PM, wrote:
>> The following bug has been logged on the website:
>>
>> Bug reference: 7534
>> Logged by: Amit Kapila
>> Email address: amit.kap...@huawei.co
On Thursday, September 13, 2012 12:34 AM Fujii Masao wrote:
On Wed, Sep 12, 2012 at 8:47 PM, wrote:
>> The following bug has been logged on the website:
>
>> Bug reference: 7533
>> Logged by: Amit Kapila
>> Email address: amit.kap...@huawei.com
&
On Thursday, September 13, 2012 5:52 PM Heikki Linnakangas wrote:
On 12.09.2012 22:03, Fujii Masao wrote:
> On Wed, Sep 12, 2012 at 8:47 PM, wrote:
>> The following bug has been logged on the website:
>>
>>> Bug reference: 7533
>>> Logged by:
he website:
>>>
>>> Bug reference: 7533
>>> Logged by: Amit Kapila
>>> Email address: amit.kap...@huawei.com
>>> PostgreSQL version: 9.2.0
>>> Operating system: Suse
>>> Description:
>>>
>>> M host is prima
On Thursday, September 13, 2012 10:57 PM Fujii Masao
On Thu, Sep 13, 2012 at 1:22 PM, Amit Kapila wrote:
> On Wednesday, September 12, 2012 10:15 PM Fujii Masao
> On Wed, Sep 12, 2012 at 8:54 PM, wrote:
>>>> The following bug has been logged on the website:
>>>
&g
On Saturday, September 15, 2012 11:27 AM Fujii Masao wrote:
On Fri, Sep 14, 2012 at 10:01 PM, Amit kapila wrote:
>
> On Thursday, September 13, 2012 10:57 PM Fujii Masao
> On Thu, Sep 13, 2012 at 1:22 PM, Amit Kapila wrote:
>> On Wednesday, September 12, 2012 10:15 PM Fujii Masao
On Sunday, September 16, 2012 12:14 AM Fujii Masao wrote:
On Sat, Sep 15, 2012 at 4:26 PM, Amit kapila wrote:
> On Saturday, September 15, 2012 11:27 AM Fujii Masao wrote:
> On Fri, Sep 14, 2012 at 10:01 PM, Amit kapila wrote:
>>
>> On Thursday, September 13, 2012 10:57 PM Fuj
On Sunday, September 16, 2012 12:14 AM Fujii Masao wrote:
On Sat, Sep 15, 2012 at 4:26 PM, Amit kapila wrote:
> On Saturday, September 15, 2012 11:27 AM Fujii Masao wrote:
> On Fri, Sep 14, 2012 at 10:01 PM, Amit kapila
wrote:
>>
>> On Thursday, September 13, 2012 10:57 PM Fuj
On Tuesday, September 18, 2012 6:03 PM Fujii Masao wrote:
On Mon, Sep 17, 2012 at 4:03 PM, Amit Kapila wrote:
>> To define the behavior correctly, according to me there are 2 options
now:
>
>> Approach-1 :
>> Document that both(sender and receiver) the timeout parameters shou
On Tuesday, September 18, 2012 6:02 PM Fujii Masao wrote:
On Mon, Sep 17, 2012 at 4:03 PM, Amit Kapila wrote:
>> Approach-2 :
>> Provide a variable wal_send_status_interval, such that if this is 0, then
>> the current behavior would prevail and if its non-zero then KeepAlive
&
On Saturday, September 15, 2012 11:41 AM Fujii Masao wrote:
> On Fri, Sep 14, 2012 at 12:21 PM, Amit Kapila
> wrote:
> > On Thursday, September 13, 2012 10:32 PM Fujii Masao wrote:
> > On Thu, Sep 13, 2012 at 9:21 PM, Heikki Linnakangas
> wrote:
> >> On 12.09
On Monday, October 01, 2012 4:08 PM Heikki Linnakangas wrote:
On 21.09.2012 14:18, Amit kapila wrote:
> On Tuesday, September 18, 2012 6:02 PM Fujii Masao wrote:
> On Mon, Sep 17, 2012 at 4:03 PM, Amit Kapila wrote:
>
>>>> Approach-2 :
>>>> Provide a variable wa
gt; I agree, but also note that wal_receiver_status_interval serves
> another user-visible purpose as well.
By above do you mean to say that wal_receiver_status_interval is used for reply
of data sent by server to indicate till what point receiver has flushed data or
something else?
With Reg
On Tuesday, October 02, 2012 1:56 PM Heikki Linnakangas wrote:
On 02.10.2012 10:36, Amit kapila wrote:
> On Monday, October 01, 2012 4:08 PM Heikki Linnakangas wrote:
>>> So let's think how this should ideally work from a user's point of view.
>>> I think th
> -Original Message-
> From: pgsql-bugs-ow...@postgresql.org [mailto:pgsql-bugs-
> ow...@postgresql.org] On Behalf Of Amit kapila
> Sent: Thursday, October 04, 2012 3:43 PM
> To: Heikki Linnakangas
> Cc: Fujii Masao; pgsql-bugs@postgresql.org; pgsql-hack...@postgresql
> On Monday, October 08, 2012 7:38 PM Robert Haas wrote:
> On Thu, Oct 4, 2012 at 6:12 AM, Amit kapila
> wrote:
> > 1. One new configuration parameter wal_receiver_timeout is added to
> detect timeout at receiver task.
> > 2. Existing parameter replicati
On Tuesday, October 09, 2012 6:00 PM Robert Haas wrote:
> On Mon, Oct 8, 2012 at 10:42 AM, Amit Kapila
> wrote:
> > How about following:
> > 1. replication_client_timeout -- shouldn't it be client as new
> configuration
> > is for wal receiver
> > 2. replicat
On Wednesday, October 10, 2012 9:15 PM Heikki Linnakangas wrote:
> On 04.10.2012 13:12, Amit kapila wrote:
> > Following changes are done to support replication timeout in sender as
> well as receiver:
> >
> > 1. One new configuration parameter wal_receiver_timeout is a
On Thursday, October 11, 2012 8:22 PM Heikki Linnakangas wrote:
On 11.10.2012 13:17, Amit Kapila wrote:
>>> How does this look now?
>
>> The Patch is fine and test results are also fine.
>Ok, thanks. Committed.
Thank you very much.
With Regards,
Amit Kapila.
--
Sent v
o.5
> #5 0x0013d792 in PQgetResult () from /usr/local/pgsql/lib/libpq.so.5
I have also observed similar problem in some of tests, but it appears to be
hung due to network break and it came out after 15-20 minutes.
With Regards,
Amit Kapila.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@post
;dim_id" IS NULL
> Line: 1
>
> [Executed: 2/4/13 11:07:08 PM PST ] [Execution: 0/ms]
>
>
> exception.
>
> Is there anything i am missing.
Why the query is different in Exception?
Can you try with
SELECT
tbl.id,
tbl.day,
tbl.week,
t
you have used pg_rotate_logfile() to perform the action,
otherwise if it would have been done
based on time, it should have truncated the file.
Why you think this is wrong behavior, do you expect any time you call
pg_rotate_logfile(), it should truncate the file if
log_truncate_on_rotation is on?
I think if you are expecting such behavior, it might not be right expectation,
because it considers the the time and log_filename format as well.
With Regards,
Amit Kapila.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
On Monday, February 18, 2013 8:28 PM Rafael Martinez wrote:
> On 02/18/2013 03:41 PM, Amit Kapila wrote:
> [...]
> > Why you think this is wrong behavior, do you expect any time you
> > call pg_rotate_logfile(), it should truncate the file if
> > log_truncate_on_ro
quot;blah blah\"
Check on net how to open filename having space.
With Regards,
Amit Kapila.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
ess but it
> come too slow (about 30minutes after standby PC was down).
For such scenario's, new parameter wal_sender_timeout has been introduced in
9.3. Refer below:
http://www.postgresql.org/docs/devel/static/runtime-config-replication.html#RUNTIME-CONFIG-REPLICATION-SENDER
I am not sure h
> Sent: Wednesday, April 10, 2013 1:49 PM Dang Minh Huong wrote:
> To: Amit Kapila
> Subject: Re: [BUGS] replication_timeout not effective
On Wednesday, April 10, 2013 1:49 PM
> Hi,
>
> Thank you for your soon reply.
>
> I'm trying to set the network timeout related
lready rejected?
As per current implementation PostgreSQL behavior is different from Oracle in
the scenario mentioned by you.
However you can try by using Savepoint before failing statement and then after
failure do Rollback To Savepoint_name and then call your select statement.
This will make
appropriately
2. There are triggers defined on tables which could insert the extra rows
you are seeing.
Is the problem you described happen more than once? Could you form testcase
which can show such behavior?
With Regards,
Amit Kapila.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgre
On Friday, May 24, 2013 6:04 AM Chaya Gilburt wrote:
> Dear Amit Kapila,
>
> The apparent problem with duplicate rows appearing in the database was
> solved. I forgot that I had modified a program to insert payments
> directly
> to the database. Not only that, but I also did no
| t
55 | t
56 | t
57 | t
58 | t
59 | t
60 | t
61 | t
62 | t
63 | t
64 | t
65 | t
66 | t
67 | t
68 | t
69 | t
70 | t
71 | t
72 | t
73 | t
74 | t
75 | t
76 | t
77 | t
78 | t
79 | t
80 | t
81 | t
82 | t
83 | t
84 | t
85 | t
86 | t
On Tuesday, May 28, 2013 1:28 PM Brice André wrote:
I shall look into it today in later half of the day.
> Dear Amit,
>
> Thanks for your answer.
>
> I performed the same test as you and I get the same result (on my
> linux server, debian, postgresql 8.4).
>
> Maybe t
On Tuesday, May 28, 2013 1:54 PM Brice André wrote:
> On Tuesday, May 28, 2013 1:28 PM Brice André wrote:
>
> I shall look into it today in later half of the day.
> > Dear Amit,
> >
> > Thanks for your answer.
> >
> > I performed the same test as you and
On Tuesday, May 28, 2013 6:50 PM Brice André wrote:
> Hello Amit,
>
> Thanks for your answer.
>
> The reason why it does not work is still not really clear for me .What
> I find very strange is that, if you perform exactly same request, with
> exactly same C++ code, bu
copyObject(lexpr),
rexpr,
a->location);
Changing the functionality of transformAExprIn() similar to transformAExprOp()
will fix this issue, but not sure if there is any other side effect of same.
With Regards,
Amit Kapila.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
On Wednesday, June 05, 2013 5:34 AM Rafał Rzepecki wrote:
> On Tue, Jun 4, 2013 at 12:35 PM, Amit Kapila
> wrote:
> > On Saturday, June 01, 2013 9:37 PM
> >
> >> Row type literals constructed with ROW() cause an error when used in
> >> an IN clause (stri
On Tuesday, June 11, 2013 12:15 AM Tom Lane wrote:
> [ got around to looking at this thread finally ]
>
> Amit Kapila writes:
> > What happens when you change ON DELETE rule of the view that really
> deletes
> > elements is that command type after applying rule re
generate_series(1,2));
?column?
--
f
(1 row)
postgres=# select 1 = (select generate_series(1,2));
ERROR: more than one row returned by a subquery used as an expression
postgres=#
Why do you want to know the exact row due to which this happens, and what you
want to do with it?
nsert into tbl values(4,2);
ERROR: duplicate key value violates unique constraint "tbl_c1_idx"
DETAIL: Key (c1)=(4) already exists.
With Regards,
Amit Kapila.
2013/6/24 Amit Kapila
On Friday, June 21, 2013 1:24 PM Борис Ромашов wrote:
> I just realized that I wanted to as
On Monday, June 24, 2013 8:59 PM Борис Ромашов wrote:
> Amit, where should I post to force developing this feature ?
You can post this to pgsql-hackers, but I think it would be more better if you
can check if any other database support that feature.
I feel you need a more strong case for
72 matches
Mail list logo
