Re: [pgadmin-hackers] Smallint

2003-08-21 Thread Adam H.Pendleton
On Thursday, Aug 21, 2003, at 05:54 US/Eastern, Andreas Pflug wrote:

I'm thinking of a reduced mode, offering only common types. Does the 
average pgsql user use regoperator[] very often ? ;-)
IMHO, the combobox is too full, I'd need only a few basic types and my 
domains.

I completely agree, assuming, of course, that for users that do want to 
use regoperator[], they still can, without having to resort to the SQL 
dialog.  Perhaps an option Use advanced data types or something like 
that could change the combo box's contents.

ahp


PGP.sig
Description: PGP signature


[pgadmin-hackers] Smallint

2003-08-18 Thread Adam H. Pendleton
Am I missing something obvious, or is the SMALLINT datatype missing from 
the appliation (add column on Columns tab of database property sheet)?

ahp

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


Re: [pgadmin-hackers] Smallint

2003-08-18 Thread Adam H. Pendleton
Duh!  Obviously it's not, it's just that pgAdmin3 calls it an int2?  Any 
reason not to call it a smallint, since that's they way it's referred to 
in the documentation?

ahp

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
 subscribe-nomail command to [EMAIL PROTECTED] so that your
 message can get through to the mailing list cleanly


Re: [pgadmin-hackers] Smallint

2003-08-18 Thread Andreas Pflug
Adam H. Pendleton wrote:

Duh!  Obviously it's not, it's just that pgAdmin3 calls it an int2?  
Any reason not to call it a smallint, since that's they way it's 
referred to in the documentation? 
Yeah.
Virtually all types are read from the database. SMALLINT and INTEGER are 
parser translations, and there might be more. IMHO, the combobox already 
shows way to much.

Only types that don't have a pg_type entry (serial, bigserial) are added 
manually.

Regards,
Andreas


---(end of broadcast)---
TIP 6: Have you searched our list archives?
  http://archives.postgresql.org


Re: [pgadmin-hackers] Smallint

2003-08-18 Thread Andreas Pflug
Adam H. Pendleton wrote:

Am I missing something obvious, or is the SMALLINT datatype missing 
from the appliation (add column on Columns tab of database property 
sheet)? 
Just try int2...

Regards,
Andreas


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