does anyone know what this error message refers to?=20
PostgreSQL query failed: ERROR: SPI_execp() failed in RI_FKey_cascade_del()
The $query was "DELETE FROM request WHERE request_id=3D33 AND label=3D'DEMO=
2';"
I have a couple of tables (about 5) that refers to table "request"
with a foreign key constraint like:
request_id INTEGER
CONSTRAINT n_request_id NOT NULL=20
CONSTRAINT f_request_id=20
REFERENCES request ON DELETE CASCADE=20
DEFERRABLE INITIALLY DEFERRED,
Can i work around this without recreate the schema and not delete
correponding values from respective tables one by one?
Papp Gyozo
- pgerzson@freestart.hu
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
set_time_limit -VS- database queries
am 09.04.2002 13:44:31 von Areski Belaid
Hi everybody,
Ok, explain:
I do a lot of database queries with php...
to import a lot of field in the database...
In the first time, i put the set_time_limit(0)
But the execution of the script such as system calls using system(),
the sleep() function, database queries, etc. is not included when
determining the maximum time that the script has been running.
So, of course, Ii can't put my script on background...
but I want known how many field has been inserted (hai)...
Helpsssssss
Areski
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
>I do a lot of database queries with php...
>to import a lot of field in the database...
>
>In the first time, i put the set_time_limit(0)
>But the execution of the script such as system calls using system(),
>the sleep() function, database queries, etc. is not included when
>determining the maximum time that the script has been running.
>
>So, of course, Ii can't put my script on background...
What do you mean put it in the background ?
>but I want known how many field has been inserted (hai)...
It depends on how you're inserting (or updating) them.
If you're using some sort of loop to do it, you can add another variable in
to automatically increment when you do an update or insert.
-----------------
Chris Smith
http://www.squiz.net/
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Re: set_time_limit -VS- database queries
am 10.04.2002 10:57:31 von Areski Belaid
> Hi,
>
> >I do a lot of database queries with php...
> >to import a lot of field in the database...
> >
> >In the first time, i put the set_time_limit(0)
> >But the execution of the script such as system calls using system(),
> >the sleep() function, database queries, etc. is not included when
> >determining the maximum time that the script has been running.
> >
> >So, of course, Ii can't put my script on background...
>
> What do you mean put it in the background ?
Launch a script with exec() or system()...
>
> >but I want known how many field has been inserted (hai)...
>
> It depends on how you're inserting (or updating) them.
>
> If you're using some sort of loop to do it, you can add another variable
in
> to automatically increment when you do an update or insert.
I have a double key on a table and some insert can be failed and I want
known how many
is really inserted... I can always know that with the last id (oid)...
Thus,I just want know if there are a way to execute a script without timeout
when I do
some database query...
Thanks a lot, Areski (qui rit)
-> http://www.areski.be.tf
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
Re: set_time_limit -VS- database queries
am 10.04.2002 14:38:18 von pgerzson
Hi,
----- Original Message -----=20
From: "Areski Belaid"
To: ; "Chris"
Sent: Wednesday, April 10, 2002 10:57 AM
Subject: Re: [PHP] set_time_limit -VS- database queries
| > Hi,
| >
| > >I do a lot of database queries with php...
| > >to import a lot of field in the database...
If you don't want to output any result from these queries, you may=20
consider putting them in a shutdown function which will be called
after all output is sent to the browser, in other words the request
has been completed, the connection has been closed.
Shutdown functions generally are used to close special, "hand-made"
connections, to empty queues, etc, but it is also possible to make
any database query. You're just unable to send any type of output
to the browser, but note that error_reporting() does work.=20
You may specify several shutdown functions with register_shutdown_function(=
)=20
http://www.php.net/manual/en/function.register-shutdown-func tion.php
| > >
| > >In the first time, i put the set_time_limit(0)
| > >But the execution of the script such as system calls using system(),
| > >the sleep() function, database queries, etc. is not included when
| > >determining the maximum time that the script has been running.
| > >
| > >So, of course, Ii can't put my script on background...
| >
| > What do you mean put it in the background ?
| Launch a script with exec() or system()...
|=20
| >
| > >but I want known how many field has been inserted (hai)...
| >
| > It depends on how you're inserting (or updating) them.
| >
| > If you're using some sort of loop to do it, you can add another variable
| in
| > to automatically increment when you do an update or insert.
|=20
| I have a double key on a table and some insert can be failed and I want
| known how many
| is really inserted... I can always know that with the last id (oid)...
|=20
| Thus,I just want know if there are a way to execute a script without time=
out
| when I do
| some database query...
|=20
|=20
|=20
| Thanks a lot, Areski (qui rit)
| -> http://www.areski.be.tf
|=20
|=20
|=20
|=20
|=20
|=20
|=20
|=20
|=20
| ---------------------------(end of broadcast)---------------------------
| TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
Sorry.But again i describe what i want.I want to receive(In php
code because i want to use this value in sql statement.) value of
the variable l2 Within script tag.
If u have solution then send me as soon as possible.Also tell me
is any method in php for event handle.
dharm.
_________________________________________________________
Click below to visit monsterindia.com and there is always a
better job for you at http://monsterindia.rediff.com/jobs
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
Re:
am 16.06.2002 19:55:24 von Keary Suska
on 6/15/02 4:37 AM, dharm_shankar@rediffmail.com purportedly said:
> Hi
>
> Sorry.But again i describe what i want.I want to receive(In php
> code because i want to use this value in sql statement.) value of
> the variable l2 Within script tag.
>
>
>
>
>
>
> If u have solution then send me as soon as possible.Also tell me
> is any method in php for event handle.
> dharm.
PHP is a server-side only scripting language, so JavaScript and PHP cannot
interact except by making calls to the server. So you would either need to
enclose the
Re:
am 17.06.2002 00:52:21 von Chris
> > Hi
> >
> > Sorry.But again i describe what i want.I want to receive(In php
> > code because i want to use this value in sql statement.) value of
> > the variable l2 Within script tag.
> >
> >
> >
> >
> >
> >
> > If u have solution then send me as soon as possible.Also tell me
> > is any method in php for event handle.
> > dharm.
>
>PHP is a server-side only scripting language, so JavaScript and PHP cannot
>interact except by making calls to the server. So you would either need to
>enclose the