default tablespaces

I am having a problem when a browser dumps data into a table.

When the browser is Firefox , it works perfect; when the browser is IE,
it dumps 2 entries into the table just thousandths of a second apart.

What could be causing this? Is this an issue with IE, Apache or Postgres.

Thanks in advance for any help.

--
D. Aaron Germ
Scarborough Library, Shepherd University
(304) 876-5423

"Well then what am I supposed to do with all my creative ideas- take a bath and wash myself with them? 'Cause that is what soap is for" (Peter, Family Guy)

On Tue, Jul 05, 2005 at 02:04:47PM -0400, D A GERM wrote:

I am having a problem when a browser dumps data into a table.

How exactly is the browser dumping data into a table? Via a form
submission handled by a CGI program or the like?

When the browser is Firefox , it works perfect; when the browser is IE,
it dumps 2 entries into the table just thousandths of a second apart.

If you're doing a form submission, do you see multiple entries for
IE in the web server's access logs?

What could be causing this? Is this an issue with IE, Apache or Postgres.

We'd need more information to say for sure. Can you tell us more
about the path from the browser to the database? Have you tried
to simplify the problem, i.e., create the smallest possible test
case that exhibits the undesirable behavior? Sometimes that means
writing a separate program that isn't useful to your application
per se, but that eliminates the irrelevant factors so you can focus
on what matters.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

Hi,

I have seen IE posting request twice to the server when you post using a
button that use javascript. Per example, if you have a submit button
and call a javascript that actually post the form... IE will still do
the post attached to the submit button. So you will have 2 submits....
It's stupid but it's true.

It's happen on some version of IE6 I think .. not all for what I remember.

You can search the web for the solution ... I don't remember what I did
or if I actually did something to solve the problem.

/David

P.S.: This is quite OT for the postgresql mailing list .. you don't think ?

D A GERM wrote:

Hi,

If a web page has JavaScript called on a submit button, like
'onClick="someFunction();", and the function does some stuff, then does a
form.submit(), and DOES NOT REMEMBER TO RETURN FALSE, then the browser is
supposed to go ahead and submit the form. So, something like that could
possibly happen, but only if the JavaScript is incorrectly written, as far
as I know. Although, once a submit is done, it would be a gray area as to
whether the form data would still be available for the second submit.

I use JavaScript in forms all the time to interact with a PostgreSQL
database, and don't have any issues like this with debugged code, using
IE6.

Susan

David Gagnon
<dgagnon@siunik.com> To: D A GERM <dgerm@shepherd.edu>
Sent by: cc: Postgresql-General <pgsql-general@postgresql.org>
Subject: Re: [GENERAL] double entries into database when using IE

pgsql-general-owner@pos |-------------------|
tgresql.org | [ ] Expand Groups |
|-------------------|

07/05/2005 02:24
PM

Hi,

I have seen IE posting request twice to the server when you post using a
button that use javascript. Per example, if you have a submit button
and call a javascript that actually post the form... IE will still do
the post attached to the submit button. So you will have 2 submits....
It's stupid but it's true.

It's happen on some version of IE6 I think .. not all for what I remember.

You can search the web for the solution ... I don't remember what I did
or if I actually did something to solve the problem.

/David

P.S.: This is quite OT for the postgresql mailing list .. you don't think ?

D A GERM wrote:

I am having a problem when a browser dumps data into a table.
When the browser is Firefox , it works perfect; when the browser is
IE, it dumps 2 entries into the table just thousandths of a second apart.

What could be causing this? Is this an issue with IE, Apache or Postgres.

Thanks in advance for any help.

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

----------------------------------------------------------------------------------------------
See our award-winning line of tape and disk-based
backup & recovery solutions at http://www.overlandstorage.com
----------------------------------------------------------------------------------------------

SCassidy@overlandstorage.com wrote:

Hi,

If a web page has JavaScript called on a submit button, like
'onClick="someFunction();", and the function does some stuff, then does a
form.submit(), and DOES NOT REMEMBER TO RETURN FALSE, then the browser is
supposed to go ahead and submit the form. So, something like that could
possibly happen, but only if the JavaScript is incorrectly written, as far
as I know. Although, once a submit is done, it would be a gray area as to
whether the form data would still be available for the second submit.

I think this thread discuss the problem .. like they say I started
having the problem with some version of IE6 but not IE5.
http://forums.devshed.com/showthread.php?t=50160&amp;page=1&amp;pp=15
http://www.tfug.org/pipermail/tfug/2004-October/007785.html

They don't give the answer but when they talk

here is what it might be:

<input class="input" type="submit " name="Submit" value="Submit"
onClick="javascript:submitit();">

if you use javascript to submit the form

do not use a button type of submit.........it will submit twice

correct code

<input class="input" type="button " name="Submit" value="Submit"
onClick="javascript:submitit();">

Like SCassidy said .. maybe returing FALSE will solve the problem .. but
I remember having tried this without success...

It's all what I know :-)

Thank you all.

I changed the type to button and added the onClick="return(myFunction())".

I did some tests this morning and the double posts seem to stop.

The duplicate entries were a thousandth to a ten thousandth off in the
time stamp, but now there's only the one entry as should be.

Thank you again.

David Gagnon wrote:

SCassidy@overlandstorage.com wrote:

Hi,

If a web page has JavaScript called on a submit button, like
'onClick="someFunction();", and the function does some stuff, then does a
form.submit(), and DOES NOT REMEMBER TO RETURN FALSE, then the browser is
supposed to go ahead and submit the form. So, something like that could
possibly happen, but only if the JavaScript is incorrectly written, as far
as I know. Although, once a submit is done, it would be a gray area as to
whether the form data would still be available for the second submit.

I think this thread discuss the problem .. like they say I started
having the problem with some version of IE6 but not IE5.
http://forums.devshed.com/showthread.php?t=50160&amp;page=1&amp;pp=15
http://www.tfug.org/pipermail/tfug/2004-October/007785.html

They don't give the answer but when they talk

here is what it might be:

<input class="input" type="submit " name="Submit" value="Submit"
onClick="javascript:submitit();">

if you use javascript to submit the form

do not use a button type of submit.........it will submit twice

correct code

<input class="input" type="button " name="Submit" value="Submit"
onClick="javascript:submitit();">

Like SCassidy said .. maybe returing FALSE will solve the problem ..
but I remember having tried this without success...

It's all what I know :-)

I use JavaScript in forms all the time to interact with a PostgreSQL
database, and don't have any issues like this with debugged code, using
IE6.

Susan

David Gagnon
<dgagnon@siunik.com> To: D A GERM <dgerm@shepherd.edu>
Sent by: cc: Postgresql-General <pgsql-general@postgresql.org>
Subject: Re: [GENERAL] double entries into database when using IE

pgsql-general-owner@pos |-------------------|
tgresql.org | [ ] Expand Groups |
|-------------------|

07/05/2005 02:24
PM

Hi,

I have seen IE posting request twice to the server when you post using a
button that use javascript. Per example, if you have a submit button
and call a javascript that actually post the form... IE will still do
the post attached to the submit button. So you will have 2 submits....
It's stupid but it's true.

It's happen on some version of IE6 I think .. not all for what I remember.

You can search the web for the solution ... I don't remember what I did
or if I actually did something to solve the problem.

/David

P.S.: This is quite OT for the postgresql mailing list .. you don't think ?

D A GERM wrote:

I am having a problem when a browser dumps data into a table.
When the browser is Firefox , it works perfect; when the browser is
IE, it dumps 2 entries into the table just thousandths of a second apart.

What could be causing this? Is this an issue with IE, Apache or Postgres.

Thanks in advance for any help.

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

----------------------------------------------------------------------------------------------
See our award-winning line of tape and disk-based
backup & recovery solutions at http://www.overlandstorage.com
----------------------------------------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

--
D. Aaron Germ
Scarborough Library, Shepherd University
(304) 876-5423

"Well then what am I supposed to do with all my creative ideas- take a bath and wash myself with them? 'Cause that is what soap is for" (Peter, Family Guy)