U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

Search on this site

Search in forums

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

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

Return to the default flat view

Create a new topic

Submit Reply

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

Fri, 15 August 2008 17:22

captainc is currently offline

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

Send a private message to this user

[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) ] [

] [

PDF

]

Current Time: Fri Aug 15 17:12:51 CEST 2025

Total time taken to generate the page: 0.08714 seconds