TODO items..
I saw the following in the TODO list. I am currently trying to work on them.
I could not understand clearly what needs to be done. Can anybody give me
the details for the following so that I can work on?
clients-psql
=========
1. Have psql show current values for a sequence
2. Fix psql's display of schema information (Neil)
Please explain me the current feature that is supported and expected
out of it.
Thanks
Dhanaraj
Dhanaraj M wrote:
I saw the following in the TODO list. I am currently trying to work on them.
I could not understand clearly what needs to be done. Can anybody give me
the details for the following so that I can work on?clients-psql
=========
1. Have psql show current values for a sequence
This one means when you do a \dt of a sequence, add a column to display
the current value.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
This one means when you do a \dt of a sequence, add a column to display
the current value.
Perhaps this one will be tricky because you will never be sure to get
the last sequence number when you query for it. The number could change
the moment the query is finished.
On Sat, Apr 22, 2006 at 05:37:28PM +0200, Gevik Babakhani wrote:
This one means when you do a \dt of a sequence, add a column to display
the current value.Perhaps this one will be tricky because you will never be sure to get
the last sequence number when you query for it. The number could change
the moment the query is finished.
So could the structure of a table or the definition of a function.
That's just a fact of life. Doesn't change the fact that it'd be
useful. You need nextval() to actually get a useful value for
queries...
Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
Show quoted text
From each according to his ability. To each according to his ability to litigate.
Dhanaraj M wrote:
I saw the following in the TODO list. I am currently trying to work on them.
I could not understand clearly what needs to be done. Can anybody give me
the details for the following so that I can work on?clients-psql
=========
1. Have psql show current values for a sequence
Already answered.
2. Fix psql's display of schema information (Neil)
Please explain me the current feature that is supported and expected
out of it.
Yes, this item was unclear. I used text suggested by the author:
http://archives.postgresql.org/pgsql-hackers/2004-12/msg00094.php
but that was not clear. TODO is now:
o Fix psql's \dn for various schema combinations (Neil)
http://archives.postgresql.org/pgsql-hackers/2004-11/msg00014.php
with a URL that has the details. Thanks for pointing out the problem.
--
Bruce Momjian http://candle.pha.pa.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
Bruce Momjian <pgman@candle.pha.pa.us> writes:
but that was not clear. TODO is now:
o Fix psql's \dn for various schema combinations (Neil)
http://archives.postgresql.org/pgsql-hackers/2004-11/msg00014.php
with a URL that has the details. Thanks for pointing out the problem.
You might want to also include a link to the thread start,
http://archives.postgresql.org/pgsql-hackers/2004-10/msg00989.php
because the above message doesn't link there (I think our mail archiver
has trouble with following threads across month boundaries).
Also, the TODO item could be worded
* Make psql's \d commands more consistent
because that's really what Neil is on about ...
regards, tom lane
OK, done.
---------------------------------------------------------------------------
Tom Lane wrote:
Bruce Momjian <pgman@candle.pha.pa.us> writes:
but that was not clear. TODO is now:
o Fix psql's \dn for various schema combinations (Neil)
http://archives.postgresql.org/pgsql-hackers/2004-11/msg00014.php
with a URL that has the details. Thanks for pointing out the problem.You might want to also include a link to the thread start,
http://archives.postgresql.org/pgsql-hackers/2004-10/msg00989.phpbecause the above message doesn't link there (I think our mail archiver
has trouble with following threads across month boundaries).Also, the TODO item could be worded
* Make psql's \d commands more consistent
because that's really what Neil is on about ...
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
--
Bruce Momjian http://candle.pha.pa.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
On Saturday 22 April 2006 13:34, Tom Lane wrote:
Also, the TODO item could be worded
* Make psql's \d commands more consistent
because that's really what Neil is on about ...
like making \df only show user functions and \dfS show system functions, like
all the other objects? :-)
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
On Saturday 22 April 2006 11:24, Alvaro Herrera wrote:
Dhanaraj M wrote:
I saw the following in the TODO list. I am currently trying to work on
them. I could not understand clearly what needs to be done. Can anybody
give me the details for the following so that I can work on?clients-psql
=========
1. Have psql show current values for a sequenceThis one means when you do a \dt of a sequence, add a column to display
the current value.
Um, I think you meant \ds right ?
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
Robert Treat wrote:
On Saturday 22 April 2006 11:24, Alvaro Herrera wrote:
Dhanaraj M wrote:
I saw the following in the TODO list. I am currently trying to work on
them. I could not understand clearly what needs to be done. Can anybody
give me the details for the following so that I can work on?clients-psql
=========
1. Have psql show current values for a sequenceThis one means when you do a \dt of a sequence, add a column to display
the current value.Um, I think you meant \ds right ?
Whatever. I don't display sequences a lot myself ...
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
* Robert Treat (xzilla@users.sourceforge.net) wrote:
On Saturday 22 April 2006 13:34, Tom Lane wrote:
Also, the TODO item could be worded
* Make psql's \d commands more consistent
because that's really what Neil is on about ...
like making \df only show user functions and \dfS show system functions, like
all the other objects? :-)
How about also having it show the owner (instead of having to use \df+
which gets huge...) and the permissions... Or perhaps have a seperate
\dfp or something to get that information. It's annoying to have to
either query the catalog directly or look through \df+ for why I can't
drop a given function.
Thanks,
Stephen
On Sunday 23 April 2006 11:42, Alvaro Herrera wrote:
Robert Treat wrote:
On Saturday 22 April 2006 11:24, Alvaro Herrera wrote:
Dhanaraj M wrote:
I saw the following in the TODO list. I am currently trying to work
on them. I could not understand clearly what needs to be done. Can
anybody give me the details for the following so that I can work on?clients-psql
=========
1. Have psql show current values for a sequenceThis one means when you do a \dt of a sequence, add a column to display
the current value.Um, I think you meant \ds right ?
Whatever. I don't display sequences a lot myself ...
:-) I double checked because I wasn't sure myself, but figured it was best to
clarify rather than risk confusing the noobs. :-)
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL