Re: ERROR: relation . . . does not exist

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Albretch Mueller <lbrtchx(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: relation . . . does not exist
Date: 2008-09-01 13:49:40
Message-ID: 48BBF2F4.9070005@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Albretch Mueller wrote:
>> PostgreSQL has 60+ types and many look like eachother. How do you propose to differentiate?
> ~
> Data Types are basically about value ranges (how many bits do you
> need to hold the value) and formatting.

That is exactly wrong, at least in the PostgreSQL approach to the type
system. Data types are about functions and operators associated with
them. So it is not about what the data looks like, but what kind of
processing you want to do with it. Guessing that information from a
dump of data seems pretty much impossible.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Fetter 2008-09-01 14:08:56 Re: Oracle and Postgresql
Previous Message Peter Eisentraut 2008-09-01 13:43:42 Re: determining existence of database and language