Re: Large objects - SOS

From: "Daniel Schuchardt" <daniel_schuchardt(at)web(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Large objects - SOS
Date: 2003-02-06 00:15:02
Message-ID: b1s9bv$1jce$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general pgsql-novice

Hi, in 7.3 this changed.

type :

CREATE DOMAIN lo AS oid;

And everything works well.

Daniel

<mjoseph(at)inautix(dot)com> schrieb im Newsbeitrag
news:OF0B8A93EA(dot)20F6C498-ON65256CC3(dot)0043C73A(at)LocalDomain(dot)(dot)(dot)
> Hi,
> I need to create a large object - a photograph and work with it. I would
be
> using ODBC (application on Windows NT , db server on Linux)
> The doc at
> http://gborg.postgresql.org/project/psqlodbc/faq/faq.php?faq_id=52
> suggests creating a custom type like this.
> create type lo (
> internallength=4,
> externallength=10,
> input=int4in,
> output=int4out,
> default='',
> passedbyvalue
> );
>
> I need to define the input & output functions (int4in and int4out).
> Can someone give me a clue as to how these functions should be defined?
> Some sample code would really help me.
>
> Regards,
> Manoj
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-02-06 03:59:13 Re: Problems upgrading from 7.1.3
Previous Message Ian Burrell 2003-02-05 23:15:50 Re: pg_restore problem with 7.3.1

Browse pgsql-general by date

  From Date Subject
Next Message Chris Travers 2003-02-06 00:54:39 Re: Deleting orphan records
Previous Message Vince Vielhaber 2003-02-06 00:13:54 Re: [ANNOUNCE] PostgreSQL v7.3.2 Released

Browse pgsql-novice by date

  From Date Subject
Next Message Andrew McMillan 2003-02-06 00:55:03 Re: How can I speed up with query?
Previous Message Andres Ledesma 2003-02-05 23:52:32 Re: how to create or run an sql script on pgsql ?