Re: Field types

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Pirtea Calin" <pcalin(at)rdsor(dot)ro>
Cc: "PostgreSQL General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Field types
Date: 2002-03-05 19:49:10
Message-ID: 17952.1015357750@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Pirtea Calin" <pcalin(at)rdsor(dot)ro> writes:
>> int8 should certainly work on that. What exactly did you try,
>> and what happened?
>>
> create table catalog1
> (id int8 not null primary key
> ,Info1 VarChar(15) not null
> ,Info2 VarChar(30) not null);

Looks fine to me. You still haven't shown us exactly what goes wrong
for you (like a query and an error message ...)

> Question: Why "Alignment = Double"

That's what it's supposed to be.

> The version string "PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC
> 2.95.3"
> is from pgAdmin II connection info.
> Is it posible that my server is not what this info sais?

Try "select version()" to get the server version for sure.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message James Leigh 2002-03-05 19:56:57 Re: lo_open problems
Previous Message Pirtea Calin 2002-03-05 19:37:00 Re: Field types