> I prefer crepes (au chocolat - is that right? It's about 14 years since I
> did French at school), but that's just me :-)
Don't hesitate to practice and visit me with your wife.
> I think the most effective way to go would be to write new classes
> pgSchema.ODBCServer, pgSchema.ODBCTables, pgSc
> -Original Message-
> From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]]
> Sent: 24 February 2002 21:23
> To: Dave Page
> Cc: [EMAIL PROTECTED]
> Subject: Re: [pgadmin-hackers] Working oin pgAdmin2
>
>
> Le Dimanche 24 Février 2002 21:19, Dave Page a écrit :
> > If a developer workin
> -Original Message-
> From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]]
> Sent: 24 February 2002 21:00
> To: Dave Page
> Cc: [EMAIL PROTECTED]
> Subject: Re: [pgadmin-hackers] Escaping quotes and
> double-quotes problem
>
>
> Le Dimanche 24 Février 2002 21:05, Dave Page a écrit :
>
Dear friends,
PostgreSQL 7.2 offers extensive UTF-8 support. In case of an UTF-8 database,
the big news seems that we now have to write function and view definitions in
UTF-8.
The problem is that pgAdmin2, HighlightBox (the colour code editor) and the
result view do not support Unicode by now
Le Dimanche 24 Février 2002 21:19, Dave Page a écrit :
> If a developer working on pgSchema cannot code the required SQL, then this
> is *not* the project for him to be hacking. That's like a cowboy who can't
> use a lassoo...
Let's say a French man without a baguette. Oh, now I see...
IMHO, thi
Le Dimanche 24 Février 2002 21:05, Dave Page a écrit :
> Having said that, the function update code doesn't do that (Add does) so
> I've comitted a fix for that.
Thanks. I checked-out from CVS to get your fix.
*** Please remove your fix ***, it's not in
> the right place and will probably cause e
> -Original Message-
> From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]]
> Sent: 24 February 2002 08:47
> To: Dave Page
> Cc: [EMAIL PROTECTED]
> Subject: Working oin pgAdmin2
>
>
> Dear Dave,
>
> I got rid of manual SQL constructions in pgSchema->Views,
> just for testing
> and d
> -Original Message-
> From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]]
> Sent: 24 February 2002 15:40
> To: Dave Page; [EMAIL PROTECTED]
> Subject: Re: [pgadmin-hackers] Schema unique stamp (OID, MD5?)
>
>
> Dear Dave,
>
> MD5 is a way to create a unique signature of files. For
>
> -Original Message-
> From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]]
> Sent: 24 February 2002 15:05
> To: Dave Page
> Cc: [EMAIL PROTECTED]
> Subject: Escaping quotes and double-quotes problem
>
>
> Dear Dave,
>
> I discovered quote escape problems in pgAdmin2:
>
> 1) View def
Dear Dave,
MD5 is a way to create a unique signature of files. For example, it is used
to create unique signatures or RPMs or ISO files.
MD5 could well be used to create a unique signature of the database schema:
In bash :
md5sum < pg_dump --schema-only database_name.
result (example):
9b05A8
Dear Dave,
I discovered quote escape problems in pgAdmin2:
1) View definition
In pgAdmin2, try create a view "abc_def" with definition SELECT 'abc' ||
'def'. If you alter the view several times it will grow like:
SELECT ''abc'' || ''def'',
SELECT '''abc''' || '''def''',
SELECT abc ||
Sorry, I don't understand what you are asking.
/D
_Original message
Subject:Re: [pgadmin-hackers] Schema unique stamp (OID, MD5?)
Sender: Jean-Michel POURE <[EMAIL PROTECTED]>
Date: Sun, 24 Feb 2002 08:49:07 +
Le Samedi 23 Février 2002 21:53, Dave
Dear Dave,
I got rid of manual SQL constructions in pgSchema->Views, just for testing
and demonstration. Don't kill me, the job is more or less clean.
This demonstrates we could easily "mask" all SQL in pgSchema->Tables,
Triggers, etc... And it could be possible to do the same in pgAdmin2. Thi
13 matches
Mail list logo
