Hi,
the query is running fine but i cannot EXPLAIN or (ANALYZE)
it.
I am seeing this message for the first time:
tradein_clients=# SELECT count(*) from shippers1 where city='DELHI';
+---+
| count |
+---+
| 2 |
+---+
(1 row)
tradein_clients=#
tradein_clients=# explain SELECT
Rajesh Kumar Mallah. wrote:
Hi,
the query is running fine but i cannot EXPLAIN or (ANALYZE)
it.
I am seeing this message for the first time:
tradein_clients=# SELECT count(*) from shippers1 where city='DELHI';
+---+
| count |
+---+
| 2 |
+---+
(1 row)
tradein_clients=#
tradei
"Rajesh Kumar Mallah." <[EMAIL PROTECTED]> writes:
> tradein_clients=# explain SELECT count(*) from shippers1 where city='DELHI';
> ERROR: get_names_for_var: bogus varno 5
What version is this? ISTR having fixed some bugs that might cause that.
> i can paste the nasty view definations if nothi
It is PostgreSQL 7.3.0 on Linux.
Sorry Postgresql has really made my VIEWS ugly.
It wasnt' so when i fed them.
I wish pgsql stores the create view defination some day ,
just like it does for indexes (pg_get_indexdef)
Here is the EXPLAIN ANALYZE output of a query that is working
on the view.
"Rajesh Kumar Mallah." <[EMAIL PROTECTED]> writes:
> It is PostgreSQL 7.3.0 on Linux.
Try 7.3.1 then. I think this is this problem:
2002-12-06 14:28 tgl
* src/backend/commands/explain.c (REL7_3_STABLE): Explain's code
for showing quals of SubqueryScan nodes has been broken all
Thank you . But i have a problem ,
I think if i do that i will hve to immediately upgrade
all the 7.3.0 clients in other machines to 7.3.1 rite?
regds
Mallah.
On Monday 03 February 2003 09:10 pm, Tom Lane wrote:
> "Rajesh Kumar Mallah." <[EMAIL PROTECTED]> writes:
> > It is PostgreSQL 7.3.0
"Rajesh Kumar Mallah." <[EMAIL PROTECTED]> writes:
> I think if i do that i will hve to immediately upgrade
> all the 7.3.0 clients in other machines to 7.3.1 rite?
No.
regards, tom lane
---(end of broadcast)---
TIP 3: if p
No, you can mix them.
---
Rajesh Kumar Mallah. wrote:
>
>
> Thank you . But i have a problem ,
>
> I think if i do that i will hve to immediately upgrade
> all the 7.3.0 clients in other machines to 7.3.1 rite?
>
>
> r
>
> Sorry Postgresql has really made my VIEWS ugly.
> It wasnt' so when i fed them.
>
> I wish pgsql stores the create view defination some day ,
> just like it does for indexes (pg_get_indexdef)
>
Did you ever try
SELECT * FROM pg_views ;
It definitely has all view definitions.
Regards, Christ
Thanks , if that is so i am upgrading it right away and posting
you the results. Its my live DB server :-)
Regds
mallah.
On Monday 03 February 2003 09:15 pm, Tom Lane wrote:
> "Rajesh Kumar Mallah." <[EMAIL PROTECTED]> writes:
> > I think if i do that i will hve to immediately upgrade
> > all
On Monday 03 February 2003 09:20 pm, Christoph Haller wrote:
> > Sorry Postgresql has really made my VIEWS ugly.
> > It wasnt' so when i fed them.
> >
> > I wish pgsql stores the create view defination some day ,
> > just like it does for indexes (pg_get_indexdef)
>
> Did you ever try
>
> SELECT *
Hmmm... upgrade to 7.3.1 was not that smooth..
after upgrade i could not run a single query..
tradein_clients=> SELECT * from hogs;
ERROR: current transaction is aborted, queries ignored until end of transaction block
tradein_clients=>
any other query seems to be giving the same ERROR.
check t
Hi ,
This is to confirm that the EXPLAIN problem
does not occur anymore after successfully upgrading
to 7.3.1 from 7.3.0
Thanks everyone.
Regards
Mallah.
explain select * from shippers1 where city='DELHI';
13 matches
Mail list logo