On Thu, 2006-07-13 at 01:41, surabhi.ahuja wrote:
> even i have seen this problem
>
> i am using postgres 8.0.0
>
> i open psql
>
> and there i try to do
> delete from
>
> it seems that psql gets stuck.
>
> even after 5 mins or something, no deletion happens.
>
> generally this happen
On Thu, Jul 13, 2006 at 05:26:31PM +1000, Jamie Deppeler wrote:
> PostgreSQL 8.1.3 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.0.3
> 20060104 (prerelease) (Debian 4.0.2-6)
What about the other outputs I mentioned?
--
Michael Fuhr
---(end of broadcast)-
PostgreSQL 8.1.3 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.0.3
20060104 (prerelease) (Debian 4.0.2-6)
Michael Fuhr wrote:
On Thu, Jul 13, 2006 at 04:58:26PM +1000, Jamie Deppeler wrote:
db=# \d job
Table "job"
Column|
On Thu, Jul 13, 2006 at 04:58:26PM +1000, Jamie Deppeler wrote:
> db=# \d job
>Table "job"
> Column|Type
> | Modifiers
> -+-+-
Title: Re: [GENERAL] Delete Problem
even i have seen this
problem
i am using postgres 8.0.0
i open psql
and there i try to do
delete from
it seems that psql gets stuck.
even after 5 mins or something, no deletion
happens.
generally this happens when the disk is
nearing to
:* pgsql-general@postgresql.org
*Subject:* Re: [GENERAL] Delete Problem
***
Your mail has been scanned by InterScan VirusWall.
***-***
[Please copy the mailing list on replies so others can participate
in and learn from the discussion.]
On Thu, Jul 13, 2006 at
On Thu, Jul 13, 2006 at 04:28:50PM +1000, Jamie Deppeler wrote:
> From psql
>
> db=# select "primary" from job where "primary" = 370;
> primary
> -
> 370
> (1 row)
>
> db=# delete from job where "primary" = 370;
> DELETE 0
You said that you had deleted all triggers -- have you verifi
db=# \d job
Table "job"
Column|Type
| Modifiers
-+-+
primary
Michael Fuhr wrote:
[Please copy the mailing list on replies so others can participate
in and learn from the discussion.]
On Thu, Jul 13, 2006 at 03:32:43PM +1000, Jamie Deppeler wrote:
Michael Fuhr wrote:
On Thu, Jul 13, 2006 at 01:45:36PM +1000, Jamie Deppeler wrote:
Just toda
[Please copy the mailing list on replies so others can participate
in and learn from the discussion.]
On Thu, Jul 13, 2006 at 03:32:43PM +1000, Jamie Deppeler wrote:
> Michael Fuhr wrote:
> >On Thu, Jul 13, 2006 at 01:45:36PM +1000, Jamie Deppeler wrote:
> >>Just today i have noticed i have one ce
On Thu, Jul 13, 2006 at 01:45:36PM +1000, Jamie Deppeler wrote:
> Just today i have noticed i have one certain table that i cannot delete
> any records from
What happens when you try to delete? Do you get an error? Does
the delete succeed but report zero rows deleted? Something else?
What doe
Just today i have noticed i have one certain table that i cannot delete
any records from
1 have delete all Triggers, Vacuumed the tables removed all foreign keys
that linked to this table.
--
*Jamie Deppeler
*Database Administrator
*once:technologies pty ltd
*
*Do It Once!*
46 Roseneath Stre
12 matches
Mail list logo
