Re: Practical question.

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Practical question.
Date: 2007-03-16 10:26:19
Message-ID: 45FA70CB.9090306@cox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 03/15/07 22:14, louis gonzales wrote:
> Hello List,
> I want to write a statement-level trigger - one that happens once per
> statement - such that, immediately after an insert into a table(which
> gets a unique integer value as an ID from a defined sequence, being the
> primary key on the table), a new table is created with foreign key
^^^^^^^^^^^^^^^^^^^^
> constraint on that unique ID.

So if you insert 10,000 records into T, you then have 10,000 new tables?

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFF+nDLS9HxQb37XmcRAkrOAJ4pKzY/TVlm3K0aqiEY7ukhCfNZjwCfa5C7
mukqcoAmU2/OYr4QFVxjt6k=
=sHA3
-----END PGP SIGNATURE-----

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dany DeBontridder 2007-03-16 10:39:38 Dump a function
Previous Message Robin Ericsson 2007-03-16 08:40:52 Re: simple coordinate system