[BUGS] slow pasting in psql in UTF-8 locale

2003-07-06 Thread Markus Bertheau
Hi, when I start psql in a UTF-8 locale (my normal case) and paste (with moddle-mouse) characters into it, the paste does not happen instantly but slows down with the character, after maybe 400 characters the rate is at 2-3 chars/second. In non-UTF-8 locales the paste happens instantly. -- Marku

[BUGS] Order by and leading spaces

2003-07-06 Thread Emmanuel GUYOT - InCrEG
Hi,   I've noticed that the 7.3.3 has a strange behaviour were sorting rows with leading spaces. It seems that leadings spaces are ignored.   Anyone has noticed that ? Is there a workaround ? E.G. Emmanuel GuyotCo-créateur & gérant 8 Rue des Monté

Re: [BUGS] Order by and leading spaces

2003-07-06 Thread Stephan Szabo
On Sun, 6 Jul 2003, Emmanuel GUYOT - InCrEG wrote: > I've noticed that the 7.3.3 has a strange behaviour were sorting rows > with leading spaces. It seems that leadings spaces are ignored. Are you in "C" locale or some other locale and on what OS? Some (many?) OS locale definitions have collatio

[BUGS] case sensitivity

2003-07-06 Thread Shachar Shemesh
-- Shachar Shemesh Open Source integration consultant Home page & resume - http://www.shemesh.biz/ POSTGRESQL BUG REPORT TEMPLATE

Re: [BUGS] pg_dump -t option doesn't take schema-qualified table

2003-07-06 Thread Curt Sampson
On Tue, 1 Jul 2003, Tom Lane wrote: > Curt Sampson <[EMAIL PROTECTED]> writes: > > It appears that the command "pgsql -t foo.bar" will not dump the table > > bar in the schema foo. I saw a patch a while back to add schema support > > to pg_dump (with the --namespace option), but I did not see a fi

Re: [BUGS] case sensitivity

2003-07-06 Thread Stephan Szabo
>Postgresql, instead, makes the identifiers in the query lowercase. While Which we know is incorrect. We should instead make it uppercase, but that would break compatibility with older version (SQL 92 draft, 5.2 SR10) >create table "Table" ( id int ); >select * from Table; >You get "relation t

Re: [BUGS] case sensitivity

2003-07-06 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> writes: > I believe that it would require the identifiers in the following to > be the same, whereas PostgreSQL would treat them as different. See also the example and footnote at the end of section 1.1.1 of our documentation: http://www.postgresql.org/docs/view.p

Re: [BUGS] case sensitivity

2003-07-06 Thread Shachar Shemesh
Tom Lane wrote: See also the example and footnote at the end of section 1.1.1 of our documentation: http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=sql-syntax.html#SQL-SYNTAX-IDENTIFIERS (not sure why the link to the footnote doesn't work in that version, but the footnote is at the

Re: [BUGS] case sensitivity

2003-07-06 Thread Stephan Szabo
On Sun, 6 Jul 2003, Shachar Shemesh wrote: > Tom Lane wrote: > > >See also the example and footnote at the end of section 1.1.1 of our > >documentation: > >http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=sql-syntax.html#SQL-SYNTAX-IDENTIFIERS > >(not sure why the link to the footno