| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Chris Czeyka <czeyka(at)skwea(dot)co(dot)jp> |
| Cc: | pgsql-sql(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: two tables - foreign keys referring to each other... |
| Date: | 2001-02-21 04:00:54 |
| Message-ID: | 20010221150054.B31213@chiru.svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
On Wed, Feb 21, 2001 at 12:30:51PM +0900, Chris Czeyka wrote:
[big snip]
> of course I get the ERROR, that admin_t doesn't exist. So? help the stupid!
> pls!
I think the general idea is to create the tables first without the
constraints and then do ALTER TABLE ADD CONSTRAINT afterwards.
HTH,
Martijn
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Romanenko M.A. | 2001-02-21 04:39:54 | /usr/lib/perl5/5.6/i386-linux/auto/Opcode/Opcode.so doesn't exist. |
| Previous Message | Martijn van Oosterhout | 2001-02-21 03:58:15 | Re: Weird indices |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Czeyka | 2001-02-21 05:09:49 | Re: two tables - foreign keys referring to each other... |
| Previous Message | Chris Czeyka | 2001-02-21 03:30:51 | two tables - foreign keys referring to each other... |