Hi all,
I have looked at some previous posting and thought that I had found
exactly what I need. What I need is to insert an id (from a sequence)
when a new record is inserted. The following example almost does what I
need :
CREATE TABLE topics (id int, topic varchar(50), descriotion text);
Andrew Higgs wrote:
>
> Hi all,
>
> I have looked at some previous posting and thought that I had found
> exactly what I need. What I need is to insert an id (from a sequence)
> when a new record is inserted. The following example almost does what I
> need :
>
> CREATE TABLE topics (id int, to
On Thu, 11 Jan 2001, Justin Clift wrote:
> I haven't seen a mention of a maximum number of constraints of similar
> applying to a table. If so, then could someone please point me to it...
>
> The reason I mention this is because I've found what seems to be causing
> this problem I'm experiencin
As someone else said a serial is probably easier, but
a trigger is probably a better bet than a rule for this purpose.
Using a plpgsql before insert trigger will do it.
On Wed, 10 Jan 2001, Andrew Higgs wrote:
> Hi all,
>
> I have looked at some previous posting and thought that I had found
Hi,
I'm running a postgres db server on my linux machine. Someone else would like
to build his frontends with MS Access and use the postgres server as backend.
He installed the Pg/ODBC-Driver linked to at the pg web site. But when he
tries to link in some table he always gets an error message
On Wed, 10 Jan 2001, Markus Wagner wrote:
> Hi,
>
> I'm running a postgres db server on my linux machine. Someone else would like
> to build his frontends with MS Access and use the postgres server as backend.
> He installed the Pg/ODBC-Driver linked to at the pg web site. But when he
> tries
Hi.
I've always had trouble understanding how to properly deal with the
following case.
I need to run an insert on a table but I don't want any other
transactions to commit the insert before me. Within the logic of the
program, I run a select to see if there is a value there, then the
insert
On Tue, 9 Jan 2001, The Hermit Hacker wrote:
> On Tue, 9 Jan 2001, Kaare Rasmussen wrote:
>
> > I wonder why http://www.postgresql.org is not updated with news. The
> > latest "Latest News" is from Nov 16. I have to go to
> > http://www.pgsql.com to find some interesting news later than that:
> >
