pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: PostgreSQL-6.5.2-0.3 Comment
4+ messages / 3 participants
[nested] [flat]
* Re: PostgreSQL-6.5.2-0.3 Comment
@ 1999-10-20 10:38 Oliver Elphick <olly@lfix.co.uk>
0 siblings, 1 reply; 4+ messages in thread
From: Oliver Elphick @ 1999-10-20 10:38 UTC (permalink / raw)
To: Chuan-kai Lin <cklin@poky.csie.ntu.edu.tw>; +Cc: pgsql-interfaces
Chuan-kai Lin wrote:
>I have recently installed your PostgreSQL 6.5.2-0.3 packages on my
>newly upgraded potato system. ODBC (which is the main purpose of
>the upgrade to your packages) seems to be fine, though I am still
>a little bit pissed about the dirty solution used to handle large
>objects. So far I have only encountered one problem: when I list
>all tables with \l under psql, psql disconnects itself from the
>backend automatically. Other operations, such as SQL queries, seem
>to work fine. Any ideas?
There are no Debian-specific issues involved, so I am forwarding this
to the PostgreSQL interfaces list. Perhaps someone will have some idea?
--
Vote against SPAM: http://www.politik-digital.de/spam/
========================================
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP key from public servers; key ID 32B8FAA1
========================================
"For the LORD God is a sun and shield; the LORD will
give grace and glory; no good thing will he withhold
from them that walk uprightly." Psalms 84:11
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [INTERFACES] Re: PostgreSQL-6.5.2-0.3 Comment
@ 1999-10-20 13:14 Thomas Lockhart <lockhart@alumni.caltech.edu>
parent: Oliver Elphick <olly@lfix.co.uk>
0 siblings, 1 reply; 4+ messages in thread
From: Thomas Lockhart @ 1999-10-20 13:14 UTC (permalink / raw)
To: Oliver Elphick <olly@lfix.co.uk>; Chuan-kai Lin <cklin@poky.csie.ntu.edu.tw>; +Cc: pgsql-interfaces
> >I have recently installed your PostgreSQL 6.5.2-0.3 packages on my
> >newly upgraded potato system. ODBC (which is the main purpose of
> >the upgrade to your packages) seems to be fine, though I am still
> >a little bit pissed about the dirty solution used to handle large
> >objects. So far I have only encountered one problem: when I list
> >all tables with \l under psql, psql disconnects itself from the
> >backend automatically. Other operations, such as SQL queries, seem
> >to work fine. Any ideas?
> There are no Debian-specific issues involved, so I am forwarding this
> to the PostgreSQL interfaces list. Perhaps someone will have some idea?
Sure. Perhaps Mr. Lin would like to contribute a solution to whatever
is upsetting him regarding large objects.
Oh, that's not what you meant? ;)
\l (which lists databases, not tables) behaves itself on my RH5.2
system with the current development tree.
- Thomas
postgres=> \l
datname |datdba|encoding|datpath
---------+------+--------+---------
template1| 100| 0|template1
postgres | 100| 0|postgres
(2 rows)
--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [INTERFACES] Re: PostgreSQL-6.5.2-0.3 Comment
@ 1999-10-20 16:22 Lamar Owen <lamar.owen@wgcr.org>
parent: Thomas Lockhart <lockhart@alumni.caltech.edu>
0 siblings, 1 reply; 4+ messages in thread
From: Lamar Owen @ 1999-10-20 16:22 UTC (permalink / raw)
To: Thomas Lockhart <lockhart@alumni.caltech.edu>; +Cc: Oliver Elphick <olly@lfix.co.uk>; Chuan-kai Lin <cklin@poky.csie.ntu.edu.tw>; pgsql-interfaces
Thomas Lockhart wrote:
> \l (which lists databases, not tables) behaves itself on my RH5.2
> system with the current development tree.
In the interests of thoroughness, I did the following:
I took my production system (running the 6.5.1-0.7lo RPM's), and tried
\l, which worked fine. I then upgraded to the 6.5.2-1 RPM's, and tried
\l -- and it works fine.
System is Mandrake 5.3 (linux kernel 2.0.36, glibc 2.0.7). I'll try it
against my RedHat 6.1 partition after I reboot into it here in a moment
(it's on this very notebook).
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [INTERFACES] Re: PostgreSQL-6.5.2-0.3 Comment
@ 1999-10-20 17:24 Oliver Elphick <olly@lfix.co.uk>
parent: Lamar Owen <lamar.owen@wgcr.org>
0 siblings, 0 replies; 4+ messages in thread
From: Oliver Elphick @ 1999-10-20 17:24 UTC (permalink / raw)
To: Chuan-kai Lin <cklin@poky.csie.ntu.edu.tw>; +Cc: Lamar Owen <lamar.owen@wgcr.org>; Thomas Lockhart <lockhart@alumni.caltech.edu>; pgsql-interfaces
Lamar Owen wrote:
>Thomas Lockhart wrote:
>> \l (which lists databases, not tables) behaves itself on my RH5.2
>> system with the current development tree.
>
>In the interests of thoroughness, I did the following:
>I took my production system (running the 6.5.1-0.7lo RPM's), and tried
>\l, which worked fine. I then upgraded to the 6.5.2-1 RPM's, and tried
>\l -- and it works fine.
>
>System is Mandrake 5.3 (linux kernel 2.0.36, glibc 2.0.7). I'll try it
>against my RedHat 6.1 partition after I reboot into it here in a moment
>(it's on this very notebook).
And that's the result I get with Debian 6.5.2-2 - no problem found. So I conclude
that it's something wrong in your database.
Try doing `select * from pg_database;' (which does the same as \l) and see
what results you get. Turn on backend debugging and logging and see what the
error is.
(I was confused by the mention of odbc; this problem doesn't have anything to
do with odbc, does it?)
--
Vote against SPAM: http://www.politik-digital.de/spam/
========================================
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP key from public servers; key ID 32B8FAA1
========================================
"For the LORD God is a sun and shield; the LORD will
give grace and glory; no good thing will he withhold
from them that walk uprightly." Psalms 84:11
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~1999-10-20 17:24 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-10-20 10:38 Re: PostgreSQL-6.5.2-0.3 Comment Oliver Elphick <olly@lfix.co.uk>
1999-10-20 13:14 ` Thomas Lockhart <lockhart@alumni.caltech.edu>
1999-10-20 16:22 ` Lamar Owen <lamar.owen@wgcr.org>
1999-10-20 17:24 ` Oliver Elphick <olly@lfix.co.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox