Simon Riggs wrote:
> On Wed, 2010-06-02 at 21:06 -0400, Bruce Momjian wrote:
> > Simon Riggs wrote:
> > >
> > > Deferrable unique constraints seem an interesting feature, though I have
> > > either some questions or some issues, not sure which.
> > >
> > > I don't seem to be able to find any way
On Wed, 2010-06-02 at 21:06 -0400, Bruce Momjian wrote:
> Simon Riggs wrote:
> >
> > Deferrable unique constraints seem an interesting feature, though I have
> > either some questions or some issues, not sure which.
> >
> > I don't seem to be able to find any way to do an ALTER TABLE that adds
>
On 3 June 2010 02:06, Bruce Momjian wrote:
>> Also, foreign keys can't be defined that refer to a deferrable primary
>> key. That isn't mentioned at all in the manual with regard to the
>> DEFERRABLE clause, though it is mentioned in the FK section. You get
>> this error message
>> ERROR: cannot
Simon Riggs wrote:
>
> Deferrable unique constraints seem an interesting feature, though I have
> either some questions or some issues, not sure which.
>
> I don't seem to be able to find any way to do an ALTER TABLE that adds
> this new capability to an existing table.
I was able to do it:
Simon Riggs writes:
> Am I missing something?
That we're long past feature freeze? Some of these might be reasonable
TODO items. None of them are happening for 9.0.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes
Deferrable unique constraints seem an interesting feature, though I have
either some questions or some issues, not sure which.
I don't seem to be able to find any way to do an ALTER TABLE that adds
this new capability to an existing table.
There is no way to add a constraint via a CREATE TABLE A
