public inbox for [email protected]
help / color / mirror / Atom feedRE: Re: What's going on here?
8+ messages / 6 participants
[nested] [flat]
* RE: Re: What's going on here?
@ 1970-01-01 00:00 omid omoomi <[email protected]>
0 siblings, 1 reply; 8+ messages in thread
From: omid omoomi @ 1970-01-01 00:00 UTC (permalink / raw)
To: [email protected]; pgsql-general
any rule on this table?
>From: "Dave Cramer" <[email protected]>
>Reply-To: <[email protected]>
>To: <[email protected]>
>Subject: RE: [GENERAL] Re: What's going on here?
>Date: Thu, 26 Jul 2001 15:46:23 -0400
>
>ebox=# select eitemcode,itemavail from inventory where
>eitemcode=6100122;
> eitemcode | itemavail
>-----------+-----------
> 6100122 | 1
>(1 row)
>
>Dave
>
>-----Original Message-----
>From: [email protected]
>[mailto:[email protected]] On Behalf Of J.H.M. Dassen
>(Ray)
>Sent: July 26, 2001 3:24 PM
>To: [email protected]
>Subject: [GENERAL] Re: What's going on here?
>
>
>Dave Cramer <[email protected]> wrote:
> > ebox=# select version();
> > version
> > -------------------------------------------------------------
> > PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 2.96
>
>I wouldn't trust that build for production uses; see
>http://gcc.gnu.org/gcc-2.96.html .
>
> > ebox=# select eitemcode,itemavail from inventory where itemavail = 1
> > limit 1; eitemcode | itemavail
> > -----------+-----------
> > 6100122 | 1
>
> > ebox=# update inventory set itemavail=0 where eitemcode=6100122;
> > UPDATE 0
>
>What do you get with "select eitemcode,itemavail from inventory where
>eitemcode=6100122"? "UPDATE 0" means no row matched the "where" clause.
>
>If this select does return rows, something truely weird is happening. If
>it does not return rows, there may be some kind of typing/casting issue
>at work.
>
>HTH,
>Ray
>--
>Javascript is EVIL!
> keyweed
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
^ permalink raw reply [nested|flat] 8+ messages in thread
* What's going on here?
@ 2001-07-26 18:48 Dave Cramer <[email protected]>
0 siblings, 4 replies; 8+ messages in thread
From: Dave Cramer @ 2001-07-26 18:48 UTC (permalink / raw)
To: pgsql-general
I can't seem to change any rows in this table. Are there locks somewhere
that I can look at or fix
ebox=# select version();
version
-------------------------------------------------------------
PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 2.96
(1 row)
ebox=# select eitemcode,itemavail from inventory where itemavail = 1
limit 1;
eitemcode | itemavail
-----------+-----------
6100122 | 1
(1 row)
ebox=# update inventory set itemavail=0 where eitemcode=6100122;
UPDATE 0
Thanks in advance,
Dave
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: What's going on here?
@ 2001-07-26 19:21 Stephan Szabo <[email protected]>
parent: Dave Cramer <[email protected]>
3 siblings, 0 replies; 8+ messages in thread
From: Stephan Szabo @ 2001-07-26 19:21 UTC (permalink / raw)
To: Dave Cramer <[email protected]>; +Cc: pgsql-general
On Thu, 26 Jul 2001, Dave Cramer wrote:
>
>
> I can't seem to change any rows in this table. Are there locks somewhere
> that I can look at or fix
>
> ebox=# select version();
> version
> -------------------------------------------------------------
> PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 2.96
> (1 row)
>
> ebox=# select eitemcode,itemavail from inventory where itemavail = 1
> limit 1;
> eitemcode | itemavail
> -----------+-----------
> 6100122 | 1
> (1 row)
>
> ebox=# update inventory set itemavail=0 where eitemcode=6100122;
> UPDATE 0
Hmm, could it perhaps be a view (rather than a table)? If it is a table,
are there any views or triggers on the table that might be interfering
with the update?
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: What's going on here?
@ 2001-07-26 19:24 J.H.M. Dassen (Ray) <[email protected]>
parent: Dave Cramer <[email protected]>
3 siblings, 1 reply; 8+ messages in thread
From: J.H.M. Dassen (Ray) @ 2001-07-26 19:24 UTC (permalink / raw)
To: pgsql-general
Dave Cramer <[email protected]> wrote:
> ebox=# select version();
> version
> -------------------------------------------------------------
> PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 2.96
I wouldn't trust that build for production uses; see
http://gcc.gnu.org/gcc-2.96.html .
> ebox=# select eitemcode,itemavail from inventory where itemavail = 1
> limit 1;
> eitemcode | itemavail
> -----------+-----------
> 6100122 | 1
> ebox=# update inventory set itemavail=0 where eitemcode=6100122;
> UPDATE 0
What do you get with "select eitemcode,itemavail from inventory where
eitemcode=6100122"? "UPDATE 0" means no row matched the "where" clause.
If this select does return rows, something truely weird is happening. If it
does not return rows, there may be some kind of typing/casting issue at
work.
HTH,
Ray
--
Javascript is EVIL!
keyweed
^ permalink raw reply [nested|flat] 8+ messages in thread
* RE: Re: What's going on here?
@ 2001-07-26 19:46 Dave Cramer <[email protected]>
parent: J.H.M. Dassen (Ray) <[email protected]>
0 siblings, 0 replies; 8+ messages in thread
From: Dave Cramer @ 2001-07-26 19:46 UTC (permalink / raw)
To: pgsql-general
ebox=# select eitemcode,itemavail from inventory where
eitemcode=6100122;
eitemcode | itemavail
-----------+-----------
6100122 | 1
(1 row)
Dave
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of J.H.M. Dassen
(Ray)
Sent: July 26, 2001 3:24 PM
To: [email protected]
Subject: [GENERAL] Re: What's going on here?
Dave Cramer <[email protected]> wrote:
> ebox=# select version();
> version
> -------------------------------------------------------------
> PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 2.96
I wouldn't trust that build for production uses; see
http://gcc.gnu.org/gcc-2.96.html .
> ebox=# select eitemcode,itemavail from inventory where itemavail = 1
> limit 1; eitemcode | itemavail
> -----------+-----------
> 6100122 | 1
> ebox=# update inventory set itemavail=0 where eitemcode=6100122;
> UPDATE 0
What do you get with "select eitemcode,itemavail from inventory where
eitemcode=6100122"? "UPDATE 0" means no row matched the "where" clause.
If this select does return rows, something truely weird is happening. If
it does not return rows, there may be some kind of typing/casting issue
at work.
HTH,
Ray
--
Javascript is EVIL!
keyweed
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
^ permalink raw reply [nested|flat] 8+ messages in thread
* RE: Re: What's going on here?
@ 2001-07-26 20:37 Dave Cramer <[email protected]>
parent: omid omoomi <[email protected]>
0 siblings, 0 replies; 8+ messages in thread
From: Dave Cramer @ 2001-07-26 20:37 UTC (permalink / raw)
To: pgsql-general
No, I don't think so
ebox=# select * from pg_rules
ebox-# ;
tablename | rulename | definition
-----------+----------+------------
(0 rows)
-----Original Message-----
From: omid omoomi [mailto:[email protected]]
Sent: July 26, 2001 8:35 PM
To: [email protected]; [email protected]
Subject: RE: [GENERAL] Re: What's going on here?
any rule on this table?
>From: "Dave Cramer" <[email protected]>
>Reply-To: <[email protected]>
>To: <[email protected]>
>Subject: RE: [GENERAL] Re: What's going on here?
>Date: Thu, 26 Jul 2001 15:46:23 -0400
>
>ebox=# select eitemcode,itemavail from inventory where
>eitemcode=6100122;
> eitemcode | itemavail
>-----------+-----------
> 6100122 | 1
>(1 row)
>
>Dave
>
>-----Original Message-----
>From: [email protected]
>[mailto:[email protected]] On Behalf Of J.H.M. Dassen
>(Ray)
>Sent: July 26, 2001 3:24 PM
>To: [email protected]
>Subject: [GENERAL] Re: What's going on here?
>
>
>Dave Cramer <[email protected]> wrote:
> > ebox=# select version();
> > version
> > -------------------------------------------------------------
> > PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 2.96
>
>I wouldn't trust that build for production uses; see
>http://gcc.gnu.org/gcc-2.96.html .
>
> > ebox=# select eitemcode,itemavail from inventory where itemavail = 1
> > limit 1; eitemcode | itemavail
> > -----------+-----------
> > 6100122 | 1
>
> > ebox=# update inventory set itemavail=0 where eitemcode=6100122;
> > UPDATE 0
>
>What do you get with "select eitemcode,itemavail from inventory where
>eitemcode=6100122"? "UPDATE 0" means no row matched the "where" clause.
>
>If this select does return rows, something truely weird is happening.
>If it does not return rows, there may be some kind of typing/casting
>issue at work.
>
>HTH,
>Ray
>--
>Javascript is EVIL!
> keyweed
>
>
>---------------------------(end of
>broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>
>
>---------------------------(end of
>broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
_________________________________________________________________
Get your FREE download of MSN Explorer at
http://explorer.msn.com/intl.asp
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: What's going on here?
@ 2001-07-26 21:14 Roderick A. Anderson <[email protected]>
parent: Dave Cramer <[email protected]>
3 siblings, 0 replies; 8+ messages in thread
From: Roderick A. Anderson @ 2001-07-26 21:14 UTC (permalink / raw)
To: Dave Cramer <[email protected]>; +Cc: pgsql-general
On Thu, 26 Jul 2001, Dave Cramer wrote:
> ebox=# select eitemcode,itemavail from inventory where itemavail = 1
> limit 1;
> eitemcode | itemavail
> -----------+-----------
> 6100122 | 1
> (1 row)
>
> ebox=# update inventory set itemavail=0 where eitemcode=6100122;
> UPDATE 0
Did eitemcode get left padded with some whitespace character(s)?
Rod
Rod
--
Remove the word 'try' from your vocabulary ...
Don't try. Do it or don't do it ...
Steers try!
Don Aslett
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: What's going on here?
@ 2001-07-27 05:56 Tom Lane <[email protected]>
parent: Dave Cramer <[email protected]>
3 siblings, 0 replies; 8+ messages in thread
From: Tom Lane @ 2001-07-27 05:56 UTC (permalink / raw)
To: [email protected]; +Cc: pgsql-general
Seems pretty weird. May we see the full schema for the table?
"pg_dump -s -t tablename dbname" is the best way.
regards, tom lane
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2001-07-27 05:56 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1970-01-01 00:00 RE: Re: What's going on here? omid omoomi <[email protected]>
2001-07-26 20:37 ` Dave Cramer <[email protected]>
2001-07-26 18:48 What's going on here? Dave Cramer <[email protected]>
2001-07-26 19:21 ` Stephan Szabo <[email protected]>
2001-07-26 19:24 ` J.H.M. Dassen (Ray) <[email protected]>
2001-07-26 19:46 ` Dave Cramer <[email protected]>
2001-07-26 21:14 ` Roderick A. Anderson <[email protected]>
2001-07-27 05:56 ` Tom Lane <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox