Re: [pgadmin-hackers] idea for exluding database not accessible (template0)

2002-09-11 Thread Dave Page 



 -Original Message-
 From: frank_lupo [mailto:[EMAIL PROTECTED]] 
 Sent: 11 September 2002 07:21
 To: pgadmin-hackers
 Subject: [pgadmin-hackers] idea for exluding database not 
 accessible (template0)
 
 
 for excluding database not avviable for excluding database 
 not avviable
 
 insert in selection database this filter :
 
 
 
 where datallowconn='t'

Then it wouldn't be displayed! Currently the code checks datallowconn
before trying to connect to the database, but it still displays them
(you might want to see those you have setup as templates).

Regards, Dave.

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

RE: [pgadmin-hackers] idea for reading encodign format

2002-09-11 Thread frank_lupo 

Is possible that the problem the vesrione of the compiler? 
My version 7.2iscompiledbyGCC2.95.3-5
Your version 7.2iscompiledbyGCCegcs-2.91.66

Is a problem ?


OK, anyideasontheproblemImentioned?
-OriginalMessage-From:frank_lupo [mailto:[EMAIL PROTECTED]]Sent:10September&
 nbsp;200
2
 16:34To:DavePageCc:pgadmin-hackersSubject: Re:[pgadmin-hackers]ideaforreadingencodignformat

IusingPostgreSQL7.2
template1=#select version(); versionPostgreSQL 7.2oni686-pc-cygwin,compiledbyGCC2.95.3-5(1row)
 
Itriedon2
 ;systems
:


template1=#select versin(); version---!-- -PostgreSQL 7.3b1oni686-pc-cygwin,compiledbyGCC2.95.3-5(1row)

template1=#select &
 nbsp;
s
p;pg_encoding_to_char(0)template1-#unionselect pg_encoding_to_char(1)template1-#unionselect pg_encoding_to_char(2)template1-#unionselect pg_encoding_to_char(3)template1-#unionselect pg_encoding_to_char(4)template1-#unionselect pg_encoding_to_char(5)template1-#unionselect pg_encoding_to_char(6)template1-#unionselect pg_encoding_to_char(7)template1-#unionselect pg_encoding_to_char(8)template1-#unionselect pg_encoding_to_char(9)template1-#unionselect pg_enc
 oding_t!
&
nbsp;o_char(10)template1-#unionselect pg_encoding_to_char(11)template1-#unionselect pg_encoding_to_char(12)template1-#unionselect pg_encoding_to_char(13)template1-#unionselect pg_encoding_to_char(14)template1-#unionselect pg_encoding_to_char(15)template1-#unionselect pg_encoding_to_char(16)template1-#unionselect pg_encoding_to_char(17)template1-#unionselect pg_encoding_to_char(18)template1-#unionselect pg_encoding_to_char(19)template1-#unionselect pg_enc
 oding_to
_
char(20)template1-#unionselect pg_encoding_to_char(21);pg_encoding_to_char-EUC_CNEUC_JPEUC_KREUC_TWJOHABKOI8LATIN1LATIN10LATIN2LATIN3LATIN4LA! TIN5n bsp;LATIN6LATIN7LATIN8LATIN9MULE_INTERNALSQL_ASCIITCVNUNICODEWIN1256WIN874(22 rows)

and

template1=select version(); version---PostgreSQL 7.2oni686-pc-linux-gnu,compiledbyGCCegcs-2.91.66(1! row)

template1= selectpg_encoding_to_char(0)template1
 -
s
p;unionselect pg_encoding_to_char(1)template1-unionselect pg_encoding_to_char(2)template1-unionselect pg_encoding_to_char(3)template1-unionselect pg_encoding_to_char(4)template1-unionselect pg_encoding_to_char(5)template1-unionselect pg_encoding_to_char(6)template1-unionselect pg_encoding_to_char(7)template1-unionselect pg_encoding_to_char(8)template1-unionselect pg_encoding_to_char(9)template1-unionselect pg_encoding_to_char(10)templat
 e1-&
n
bsp;unionselect pg_encoding_to_char(11)template1-unionselectnb!sp; pg_encoding_to_char(12)template1-unionselect pg_encoding_to_char(13)template1-unionselect pg_encoding_to_char(14)template1-unionselect pg_encoding_to_char(15)template1-unionselect pg_encoding_to_char(16)template1-unionselect pg_encoding_to_char(17)template1-unionselect pg_encoding_to_char(18)template1-unionselect pg_encoding_to_char(19)template1-unionselect 
 pg_encod
i
ng_to_char(20)template1-unionselect pg_encoding_to_char(21);pg_encoding_to_char-SQL_ASCII(1 row)

The7.2systemwas!;compiled withoutmultibytesupport.In7.3,multibyteisalwayson.Iguess itprobablydoesn'tmattermuchasit'sobviouslygivingonlyusefulencodings, theproblemisthis(onthe7.2
 bsp;syst
e
m):

template1=select pg_encoding_to_char(45);pg_encoding_to_char-SQL_ASCII(1 row)

template1=select pg_encoding_to_char(450);pg_encoding_to_char-SQL_ASCII(1 row)0D 

Howwouldtheloop knowwhentogiveupandexit?

Regards, Dave. 
 -OriginalMessage-From:frank_lupo [mailto:[EMAIL PROTECTED]]Sent:10September2002 14:45To:DavePage!Cc: pgadmin-hackersSubject: RE:[pgadmin-hackers]ideaforreadingencodignformat
 
 
Ireplacethiscodeinfrmdatabasepgadmin2.Idon'thavethisproblem.  
 p;
0D
Whatisyourresultifyouexecutethisselection? 
selectpg_encoding_to_char(0) 
unionselectpg_encoding_to_char(1) 
unionselectpg_encoding_to_char(2) 
unionselectnbsp;pg_encoding_to_char(3) 
union
 selectpg_encoding_to_char(4) 
unionselectpg_encoding_to_char(5) 
unionselectpg_encoding_to_char(6) 
unionselectpg_encoding_to_char(7) 
unionselectpg_encoding_to_char(8) 
union
b
sp;selectpg_encoding_to_char(9) 
unionselectpg_encoding_to_char(10) 
unionselectpg_encoding_to_char(11) 
unionselectpg_encoding_to_char(12) 
unionselectpg_encoding_to_char(13) 
 p;

<
P>unionselectpg_encoding_to_char(14) 
unionselectpg_encoding_to_char(15) 
unionselect pg_encod!ing_to_char(16) 
unionselectpg_encoding_to_char(17) 
unionselectpg_encoding
 _to_char
(
18) 
unionselectpg_encoding_to_char(19) 
unionselectpg_encoding_to_char(20) 
unionselectpg_encoding_to_char(21) 
Myresultis: 
pg_encoding_to_char-ALTEUC_CNEUC_JPEUC_KREUC_TWISO_8859_5ISO_8859_6KOI8LATIN1
L
ATIN10LATIN2n!

Re: [pgadmin-hackers] idea for reading encodign format

2002-09-11 Thread Dave Page 
Title: Message



Possibly, but as that's the standard compiler shipped with at least one 
reasonably popular Linux distro, we have to assume that others will probably be 
using it and would suffer the same problem - and as it's an infinite loop It's 
definately not going in until a real solution is found.

Regards, Dave

  
  -Original Message-From: frank_lupo 
  [mailto:[EMAIL PROTECTED]] Sent: 11 September 2002 
  07:12To: Dave PageCc: pgadmin-hackersSubject: 
  RE: [pgadmin-hackers] idea for reading encodign format
  Is possible that the problem the vesrione of the compiler? 
  
  My version 
  7.2iscompiledbyGCC2.95.3-5
  Your version 
  7.2iscompiledbyGCCegcs-2.91.66
  
  Is a problem ?
  

OK, 
anyideasontheproblemImentioned?
 

  
  -OriginalMessage-From:frank_lupo 
  [mailto:[EMAIL PROTECTED]]Sent:10September! 
  200 2  
  16:34To:DavePageCc:pgadmin-hackersSubject: 
  Re:[pgadmin-hackers]ideaforreadingencodignformat
   
  IusingPostgreSQL7.2 
  template1=#select 
  version(); 
  versionPostgreSQL 
  7.2oni686-pc-cygwin,compiledbyGCC2.95.3-5(1row) 

  
   
Itriedon2nbs! p;systems : 
 
 
template1=#select 
versin(); 
version---!-- 
-PostgreSQL 
7.3b1oni686-pc-cygwin,compiledbyGCC2.95.3-5(1row) 

 
template1=#select ! nb s 
p;pg_encoding_to_char(0)template1-#unionselect 
pg_encoding_to_char(1)template1-#unionselect 
pg_encoding_to_char(2)template1-#unionselect 
pg_encoding_to_char(3)template1-#unionselect 
pg_encoding_to_char(4)template1-#unionselect 
pg_encoding_to_char(5)template1-#unionselect 
pg_encoding_to_char(6)template1-#unionselect 
pg_encoding_to_char(7)template1-#unionselect 
pg_encoding_to_char(8)template1-#unionselect 
pg_encoding_to_char(9)template1-#unionselect 
pg_en! coding_t!  
nbsp;o_char(10)template1-#unionselect 
pg_encoding_to_char(11)template1-#unionselect 
pg_encoding_to_char(12)template1-#unionselect 
pg_encoding_to_char(13)template1-#unionselect 
pg_encoding_to_char(14)template1-#unionselect 
pg_encoding_to_char(15)template1-#unionselect 
pg_encoding_to_char(16)template1-#unionselect 
pg_encoding_to_char(17)template1-#unionselect 
pg_encoding_to_char(18)template1-#unionselect 
pg_encoding_to_char(19)template1-#unionselect 
pg_en! coding_to _ 
char(20)template1-#unionselect 
pg_encoding_to_char(21);pg_encoding_to_char-EUC_CNEUC_JPEUC_KREUC_TWJOHABKOI8LATIN1LATIN10LATIN2LATIN3LATIN4LA! 
TIN5n 
bsp;LATIN6LATIN7LATIN8LATIN9MULE_INTERNALSQL_ASCIITCVNUNICODEWIN1256WIN874(22 
rows) 

 
and 
 
template1=select 
version(); 
version---PostgreSQL 
7.2oni686-pc-linux-gnu,compiledbyGCCegcs-2.91.66(1! 
row) 

 
template1= 
selectpg_encoding_to_char(0)template! 
1-nb s p;unionselect 
pg_encoding_to_char(1)template1-unionselect 
pg_encoding_to_char(2)template1-unionselect 
pg_encoding_to_char(3)template1-unionselect 
pg_encoding_to_char(4)template1-unionselect 
pg_encoding_to_char(5)template1-unionselect 
pg_encoding_to_char(6)template1-unionselect 
pg_encoding_to_char(7)template1-unionselect 
pg_encoding_to_char(8)template1-unionselect 
pg_encoding_to_char(9)template1-unionselect 
pg_encoding_to_char(10)templa! te1- 
n bsp;unionselect 
pg_encoding_to_char(11)template1-unionselectnb!sp; 
pg_encoding_to_char(12)template1-unionselect 
pg_encoding_to_char(13)template1-unionselect 
pg_encoding_to_char(14)template1-unionselect 
pg_encoding_to_char(15)template1-unionselect 
pg_encoding_to_char(16)template1-unionselect 
pg_encoding_to_char(17)template1-unionselect 
pg_encoding_to_char(18)template1-unionselect 
pg_encoding_to_char(19)template1-unionselect 
! ;pg_encod i 
ng_to_char(20)template1-unionselect 
pg_encoding_to_char(21);pg_encoding_to_char-SQL_ASCII(1 
row) 

 
The7.2systemwas!;compiled 
withoutmultibytesupport.In7.3,multibyteisalwayson.Iguess 
itprobablydoesn'tmattermuchasit'sobviouslygivingonlyusefulencodings, 
theproblemisthis(onthe7.2! 
nbsp;syst e m): 
 
template1=select 
pg_encoding_to_char(45);pg_encoding_to_char-SQL_ASCII(1 
row) 

 
template1=select