Re: [BUGS] Command-line client sometimes misinterprets tabs for

2002-08-29 Thread Peter Eisentraut
Casey Allen Shobe writes: > Can tab completion be disabled without disabling command line history? I > noticed -n disables both. I would gladly trade tab completion for tab > pastability, but I rely heavily on command line history. man psql, search for "disable" Also, you might find it easier

Re: [BUGS] LATIN2 ORDER BY

2002-08-29 Thread Pavel Stehule
If you seted locales after initdb, then you can have this problem. Try dump data, remove files in db directory (/usr/local/pgsql/data), check locales again :->, and initdb -D /usr/local/pgsql/data. Pavel On Wed, 28 Aug 2002, Kristóf Kontor wrote: > Hi ! > > My problem is that i have LATIN2 e

Re: [BUGS] VU#352803 - postgresql

2002-08-29 Thread Bruce Momjian
CERT Coordination Center wrote: > > > Hello folks, > > We have received report regarding a vulnerability in one of your > products. We would appreciate greatly your help in reviewing this > issue so that we can document it in our public database. > > Please review the following vulnerability

Re: [BUGS] Bug #743: pg_dump -a -c without DELETE FROM

2002-08-29 Thread Bruce Momjian
> Witam Philip Warner! > > 22 sierpnia 2002, 16:49:47, zosta³o napisane: > >> -c, --clean clean (drop) schema prior to create > > PW> Given that it is dropping the table, it does not really need to do a delete. > --- > Ok. But I am talking about "pg_dump -a -c", not about "pg_dump

Re: [BUGS] LATIN2 ORDER BY

2002-08-29 Thread Victor Wagner
On 2002.08.28 at 13:20:29 +0200, Kristóf Kontor wrote: > Hi ! > > My problem is that i have LATIN2 encoding in my postgres and > ISO-8859-2 charset on my linux, but when i'am ordering strings > in psql with acutes it does not work properly... > (psql version = 7.1, linux = debian woody) Are you

Re: [BUGS] PostgreSQL security release 7.2.2 hasn't been announced on

2002-08-29 Thread Bruce Momjian
Tom Lane wrote: > > Tom Lane writes: > >>> However, I see from my mail logs that I never got a copy of that. > > I have to take that back; I was grepping for ANNOUNCE and missed > this log entry: > > Subject: [GENERAL] PostgreSQL 7.2.2: Security Release > > Apparently the announcement was cross

Re: [BUGS] PostgreSQL security release 7.2.2 hasn't been announced on pgsql-announce

2002-08-29 Thread Tom Lane
> Tom Lane writes: >>> However, I see from my mail logs that I never got a copy of that. I have to take that back; I was grepping for ANNOUNCE and missed this log entry: Subject: [GENERAL] PostgreSQL 7.2.2: Security Release Apparently the announcement was cross-posted between -announce and -gen

Re: [BUGS] PostgreSQL security release 7.2.2 hasn't been announced on pgsql-announce

2002-08-29 Thread Lee Kindness
I received the announcement today, seems it was stuck somewhere: From [EMAIL PROTECTED] Thu Aug 29 13:48:26 2002 Return-Path: <[EMAIL PROTECTED]> Received: from internet.csl.co.uk by euphrates.csl.co.uk (8.9.3/ConceptI 2.4) id NAA11884; Thu, 29 Aug 2002 13:48:25 +0100 (BST) Received:

Re: [BUGS] PostgreSQL security release 7.2.2 hasn't been announced on pgsql-announce

2002-08-29 Thread Lee Kindness
I received the announcement today, seems it was stuck somewhere: >From [EMAIL PROTECTED] Thu Aug 29 13:48:26 2002 Return-Path: <[EMAIL PROTECTED]> Received: from internet.csl.co.uk by euphrates.csl.co.uk (8.9.3/ConceptI 2.4) id NAA11884; Thu, 29 Aug 2002 13:48:25 +0100 (BST) Received: fr

Re: [BUGS] PostgreSQL security release 7.2.2 hasn't been announced on pgsql-announce

2002-08-29 Thread Tom Lane
Aleksander Adamowski <[EMAIL PROTECTED]> writes: > What's the use of an announce list if it doesn't announce new releases? It did, according to the archives: http://archives.postgresql.org/pgsql-announce/2002-08/msg4.php However, I see from my mail logs that I never got a copy of that. I am

[BUGS] PostgreSQL security release 7.2.2 hasn't been announced on pgsql-announce

2002-08-29 Thread Aleksander Adamowski
That's a serious issue. Like many other admins, I rely on announce mailing lists for all the daemons I run on my servers, to be informed about fixed security problems in new releases. On the Postgres announce list I get plenty of release information about PgSQL-related projects, but the most i

[BUGS] deadlock detected

2002-08-29 Thread Randy Kunkee
I recently tried to deploy Postgresql in a highly active environment. My use of data was probably a little unusual, in that I was constantly modifying several fields within a table, one of them being a text string. Literally hundreds of thousands of these kinds of changes would be made every day.

Re: [BUGS] Command-line client sometimes misinterprets tabs for

2002-08-29 Thread Rod Taylor
> Can tab completion be disabled without disabling command line history? I > noticed -n disables both. I would gladly trade tab completion for tab > pastability, but I rely heavily on command line history. Perhaps annoying, but a simple work around is to use Formats like tab in the code, b

[BUGS] "Field is too small" error again

2002-08-29 Thread SSY
I'm using MS Access'97 as front-end and I need to link PostgreSQL views to my MS Access database. I have no problems with PG 7.1.3 (on Linux), but with PG 7.2.1 (on cygwin)... I get well-known bugs: "Field is too small" error when inserting record to view with insert rule and "Write Conflict" er

[BUGS] LATIN2 ORDER BY

2002-08-29 Thread Kristóf Kontor
Hi ! My problem is that i have LATIN2 encoding in my postgres and ISO-8859-2 charset on my linux, but when i'am ordering strings in psql with acutes it does not work properly... (psql version = 7.1, linux = debian woody) Example: SELECT name FROM table ORDER BY name; Aa Bb Áá ... I

Re: [BUGS] Command-line client sometimes misinterprets tabs for

2002-08-29 Thread Rod Taylor
The problem is that most items in postgresql are tab completed. Cut and past your text into a bash or zsh prompt. It injects a bunch of filenames into your data, as per tab completion. Annoying, but for the benefits it's livable. Perhaps a toggle could be created to disable tab completion? O

[BUGS] jdbc example datastyle.java

2002-08-29 Thread Grégory Faruch
Your name : Gregory Faruch Your email address : [EMAIL PROTECTED] System Configuration - Architecture (example: Intel Pentium) : Sparc Operating System (example: Linux 2.0.26 ELF) : Solaris 2.9 PostgreSQL version (example: PostgreSQL-7.1.1)

[BUGS] VU#352803 - postgresql

2002-08-29 Thread CERT Coordination Center
Hello folks, We have received report regarding a vulnerability in one of your products. We would appreciate greatly your help in reviewing this issue so that we can document it in our public database. Please review the following vulnerability note for accuracy and answer these questions: 1.

Re: [BUGS] [GENERAL] 'on delete' rule: bug or feature...

2002-08-29 Thread Jan Wieck
The problem is that the deletes in the rules expand to a join according to the view too. As soon as the first rule action has deleted the rows, the second action cannot find anything anymore. We would have to suppress the command counter increment between the rule actions to fix this, but that wou

[BUGS] Error in Connecting java-postgresql

2002-08-29 Thread Prashanth R
hi Prashanth here From Bangalore Inida. I tried to connect the java-postgresql in Linux 7.x platform. I am getting this error check that the host name & port is correct & that the postmaster is running in -i flag which enables TCP/IP networking which neabled networking. thanks , expecting e

Re: [BUGS] Bug #743: pg_dump -a -c without DELETE FROM

2002-08-29 Thread Przemysław Sztoch
Witam Philip Warner! 22 sierpnia 2002, 16:49:47, zostało napisane: >> -c, --clean clean (drop) schema prior to create PW> Given that it is dropping the table, it does not really need to do a delete. --- Ok. But I am talking about "pg_dump -a -c", not about "pg_dump -c". When I am

[BUGS] regarding postgres

2002-08-29 Thread s mahendran
hello     i got the following message when i try to start the database using postmaster PGSTAT:bind(2) : cant assign the requested address pls give me the solution thanks in advanceDo You Yahoo!? Yahoo! Finance - Get real-time stock quotes

[BUGS] Bug #753: test

2002-08-29 Thread pgsql-bugs
test ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description test Long Description Sample Code No file was uploaded with this report ---(end of broadcast)--- TIP 3: if posting/readi