Re: Feature requests after crash

2002-02-21 Thread Dave Page
If you wish to add code to prevent dropping of functions that are *currently* in use as a language handler, then that's fine with me. As for the dependencies, you will need to write parsers for at least the following languages to do what you propose: SQL pl/SQL pl/pgSQL pl/tcl pl/perl pl/sh pl

Re: [ODBC] Unicode support

2002-02-21 Thread Jean-Michel POURE
> 1) When I try to view tables from Access XP, the arabic letters are not > correctly displayed: I can see only the multibyte to single byte 1:1 > conversion. This is not that important because I don't need to see it in > Access because the database will be seen through PHP on the web. Dave Page

Feature requests after crash

2002-02-21 Thread Jean-Michel POURE
Dear Dave, When deleting pgadmin_* tables and functions, I dropped by error plpgsql_call_handler which standed right after pgadmin in alphabetical order... A GUI like pgAdmin2 is like a machine gun. Bang Bang. I am shot down. IMHO, dropping plpgsql_call_handler function is a total nonsense as

Re: Timestamp reverse engeneering bug

2002-02-21 Thread Jean-Michel POURE
L I'm using my phone right now so I can't check, but I'm pretty sure that's > not a bug. Isn't timestamptz a timestamp with timezone e.g. 2002-02-21 > 19:00:00+00? You are right.

Re: Timestamp reverse engeneering bug

2002-02-21 Thread Dave Page
I'm using my phone right now so I can't check, but I'm pretty sure that's not a bug. Isn't timestamptz a timestamp with timezone e.g. 2002-02-21 19:00:00+00? Anyway, pgAdmin gets this by looking up the typename from pg_type using pg_attribute.atttypid (iirc) so if it's broken for one type it pr

Timestamp reverse engeneering bug

2002-02-21 Thread Jean-Michel POURE
Hi Dave, Table definition with timestamps under 7.2 return "timestamptz". Cheers, Jean-Michel POURE

Re: [CYGWIN] Question about character encoding

2002-02-21 Thread Dave Page
> -Original Message- > From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]] > Sent: 21 February 2002 13:27 > To: Markus Wollny; [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: [CYGWIN] Question about character encoding > > > > > Dave : I am going to set defaut database encodi

Re: [CYGWIN] Question about character encoding

2002-02-21 Thread Jean-Michel POURE
> I installed the latest cygwin snapshot along with PostgreSQL 7.2; I > access the DB using the latest PGAdmin II 1.2.0. Almost everything seems > to be working fine - with one major glitch: I just cannot insert nor > select strings containing german umlaute or any other special characters > into

Re: Feature request: md5sum footprint of schema objects

2002-02-21 Thread Jean-Michel POURE
Please disregard, this was for pgsql-hackers...

Feature request: md5sum footprint of schema objects

2002-02-21 Thread Jean-Michel POURE
Dear friends, As usual, I am working in pgAdmin2, Dave Page's excellent GUI (http://pgadmin.postgresql.org). Sometimes I create objects in the GUI, sometimes I run SQL queries directly. In this case, pgAdmin2 is not aware when the schema changes. Then, I have to refresh display manually. But