SEO

#1 (**permalink**) 04-17-2008, 07:37 PM

To reproduce, run the following code in query window:

create table test ( ä text );
select * from test;

Observed in output pane:

No column name.
Column type "text" is only partially visible.

Observed in object browser:

Column with empty name is shown.

Observed in SQL pane:

CREATE TABLE tt
(
text
)

Observed when tryind to delete column in object browser:

---------------------------
pgAdmin III
---------------------------
An error has occurred:

ERROR: syntax error at end of input at character 28

---------------------------
OK
---------------------------

Expected:

Column name must be shown.
Word text must be fully visible.

Version: 1.6beta3

Platform: XP SP2

Andrus.

#2 (**permalink**) 04-17-2008, 07:37 PM

Andrus wrote:
> To reproduce, run the following code in query window:
>
> create table test ( ä text );
> select * from test;
>
> Observed in output pane:
>
> No column name.
> Column type "text" is only partially visible.

I see both.

>
> Observed in object browser:
>
> Column with empty name is shown.
>
> Observed in SQL pane:
>
> CREATE TABLE tt
> (
> text
> )

I see:

CREATE TABLE test
(
"ä" text
)
WITHOUT OIDS;
ALTER TABLE test OWNER TO postgres;

> Observed when tryind to delete column in object browser:
>
> ---------------------------
> pgAdmin III
> ---------------------------
> An error has occurred:
>
> ERROR: syntax error at end of input at character 28

And the column gets deleted just fine!

What is your database encoding? I tested with latin1 and utf8.

Regards, Dave.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

#3 (**permalink**) 04-17-2008, 07:37 PM

>> To reproduce, run the following code in query window:
>>
>> create table test ( ä text );
>> select * from test;
>>
>> Observed in output pane:
>>
>> No column name.
>> Column type "text" is only partially visible.
>
> I see both.
> And the column gets deleted just fine!
>
> What is your database encoding? I tested with latin1 and utf8.

My database encoding is UTF8
Cluster and Windows locales are Estonian

Andrus.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Accented characters column names not displayed