> Is there any way to find out what constraints have been set on a table
> or on columns in a table?
Take a look at the source for psql.
--
johs
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
> More than Interbase :-) More than MS SQL Server. Maybe less than
> Oracle or MySQL; it's open to debate.
Um. In my experience, PostgreSQL is more stable than MySQL. MySQL dies
on me all the time, but I've never had it happen with PostgreSQL. (7.0.3,
currently.)
--
johs
--
>> CREATE TABLE resource_record(
>> rrid SERIAL
>> -- etc.
>> );
> There is no primary key for this table. Just write PRIMARY KEY after
> SERIAL.
There is. I accidentally left it out in the post.
> CREATE INDEX soa_record_pkey ON soa_record ( rrid );
> You could also state the referenced f
Hi,
it seems I can't have a foreign key that references some subclass. Postgres
says it can't figure out what its primary key is. The primary key is defined
in the superclass.
I have something like this:
CREATE TABLE resource_record(
rrid SERIAL
-- etc.
);
CREATE TABLE soa_record(
-- b
