The following bug has been logged online:

Bug reference: 2867
Logged by: Ted Petrosky
Email address: tedpet5 (AT) yahoo (DOT) com
PostgreSQL version: 8.2
Operating system: OS X
Description: FULL PATH name problem
Details:

I have been working with WebObjects and the EOModeler. When I tell EOModeler
to examine a table, it comes up with this for the primary key.

ALTER TABLE public.article ADD CONSTRAINT public.article_PK PRIMARY KEY
(entityid);

I must change it to be:
ALTER TABLE public.article ADD CONSTRAINT article_PK PRIMARY KEY
(entityid);
because postgresql doesn't like the 'public.' after the CONSTRAINT. I guess
the question is, should it?

Ted

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

"Ted Petrosky" <tedpet5 (AT) yahoo (DOT) com> writes:
No, I think that'd be a bad idea. The SQL spec does call for a
schema-qualified constraint name here, but that's because they have a
different model of the constraint namespace than we do, to wit, unique
per schema vs. our unique per table. Unless you want to buy into the
SQL naming model, you shouldn't be trying to specify a schema name here.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

So my problem is that the program EOModeler is forcing
the schema-qualified constraint. I will filed a bug
report with Apple.... Unfortunitily, I believe that
the product has been deprecated.... I have yet to get
eclipse with "entity modeler" working correctly to see
what it does the the name space....

Thanks for the reply

Ted


--- Tom Lane <tgl (AT) sss (DOT) pgh.pa.us> wrote:


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly