Re: Calculated bigserial column in a view - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Calculated bigserial column in a view
Date
Msg-id 20050425201046.GA16773@wolff.to
Whole thread Raw
In response to psqlodbc MSAccess and Postgresql  (Typing80wpm@aol.com)
List pgsql-general
Please keep replies copied to the list so that other people can learn from
and comment on the discussion unless to have a good reason to make the
thread private.

On Mon, Apr 25, 2005 at 21:46:20 +0200,
  Zlatko Matic <zlatko.matic1@sb.t-com.hr> wrote:
> The reason for such crazy idea is my front-end MS Access which considers
> views as tables and have problem with tables ( views also) if there is no
> unique numeric field...
> Anyway, how to do it ?
> Thanks.

I don't know MS Access, so I am not going to be able to help much with this.
There may be some way to trick MS Access into thinking that your view has
a unique numeric field. It would help to know how it knows that a column
has those properties and how it uses the information.

>
> ----- Original Message -----
> From: "Bruno Wolff III" <bruno@wolff.to>
> To: "Zlatko Matic" <zlatko.matic1@sb.t-com.hr>
> Cc: <pgsql-general@postgresql.org>
> Sent: Monday, April 25, 2005 6:31 AM
> Subject: Re: [GENERAL] Calculated bigserial column in a view
>
>
> >On Sun, Apr 24, 2005 at 22:16:14 +0200,
> > Zlatko Matic <zlatko.matic1@sb.t-com.hr> wrote:
> >>I know that it sounds crazy,
> >>but I need a bigserial coulumn in a view that is consisted of several
> >>tables.
> >>That column should not be based on bigserial column of any table, but
> >>should be a calculated column...
> >>How can I accomplish it ?
> >
> >This doesn't really make sense. It sounds like you want a key that is
> >unique
> >accross the union of several tables and that doesn't change when other
> >rows
> >in the union are added or removed. There are a couple of ways you might
> >go about doing something like this. Is this what you really want?
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 5: Have you checked our extensive FAQ?
> >
> >              http://www.postgresql.org/docs/faq
> >
>

pgsql-general by date:

Previous
From: John DeSoi
Date:
Subject: Re: column size in libpq
Next
From: John DeSoi
Date:
Subject: Re: plpgsql function not working