U++ framework: U++ SQL » PostgreSQL Attribute Foreign Key --> Bug?

Home » U++ Library support » U++ SQL » PostgreSQL Attribute Foreign Key --> Bug?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

PostgreSQL Attribute Foreign Key --> Bug? [message #17448]

Fri, 15 August 2008 17:22

captainc
Messages: 278
Registered: December 2006
Location: New Jersey, USA

Experienced Member

I noticed that my foreign keys were not being created in my PostgreSQL database. So I copied a query from the Attributes script created by U++ and tried to run it manually. The query was:

alter table MYTABLE1 add constraint FK_MYTABLE1$MYT_ID foreign key (MYT_ID) references MYTABLE2.MYT_ID;

The error I received was something like:
"ERROR: schema mytable2 does not exist."
I changed the script line to:

alter table MYTABLE1 add constraint FK_MYTABLE1$MYT_ID foreign key (MYT_ID) references MYTABLE2(MYT_ID);

Note the paren () instead of dot/period.
And it worked...

I am using PostgreSQL 8.2.9

Report message to a moderator

[Message index]

		PostgreSQL Attribute Foreign Key --> Bug? By: captainc on Fri, 15 August 2008 17:22
		Re: PostgreSQL Attribute Foreign Key --> Bug? By: zsolt on Fri, 15 August 2008 19:05
		Re: PostgreSQL Attribute Foreign Key --> Bug? By: captainc on Tue, 19 August 2008 13:55
		Re: PostgreSQL Attribute Foreign Key --> Bug? By: captainc on Tue, 19 August 2008 20:43
		Re: PostgreSQL Attribute Foreign Key --> Bug? By: mirek on Thu, 21 August 2008 16:53

Previous Topic:	Connecting to multiple databases.
Next Topic:	Count error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Nov 08 22:27:41 GMT+1 2026

Total time taken to generate the page: 0.04018 seconds