[pgadmin-support] Foreign Keys
I would like a graphical interface that would help me manage my foreign keys. I thought PgAdmin II would do this (it has the Foreign Key object type) but when I create a foreign key in PG and then try and see it in PgAdmin II it I don't see anything. I can't create new ones either using the interface. Am I using the program wrong or is this capability not implemented yet? James Friesen ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[pgadmin-support] problems Visual Basic after migration
Hello, After migration Access to Postgresql my application in Visual Basic shows ERROR: Relation name_table does not exist. But my tables exit in Postgresql,. What´s wrong? Best Regards Andrea Spessotto ---Outgoing mail is certified Virus Free.Checked by AVG anti-virus system (http://www.grisoft.com).Version: 6.0.404 / Virus Database: 228 - Release Date: 15/10/2002
Re: [pgadmin-support] problems Visual Basic after migration
Title: Message Do your tables have mixed case names? If so, either use the option in the Migration Wizard to make them lower case, or quote them in your application. Regards, Dave. -Original Message-From: Andrea (G&F) [mailto:[EMAIL PROTECTED]] Sent: 29 January 2003 19:44To: [EMAIL PROTECTED]Subject: [pgadmin-support] problems Visual Basic after migration Hello, After migration Access to Postgresql my application in Visual Basic shows ERROR: Relation name_table does not exist. But my tables exit in Postgresql,. What´s wrong? Best Regards Andrea Spessotto ---Outgoing mail is certified Virus Free.Checked by AVG anti-virus system (http://www.grisoft.com).Version: 6.0.404 / Virus Database: 228 - Release Date: 15/10/2002
Re: [pgadmin-support] Foreign Keys
> -Original Message- > From: Friesen, James [mailto:[EMAIL PROTECTED]] > Sent: 29 January 2003 19:13 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] Foreign Keys > > > I would like a graphical interface that would help me manage > my foreign keys. I thought PgAdmin II would do this (it has > the Foreign Key object > type) but when I create a foreign key in PG and then try and > see it in PgAdmin II it I don't see anything. I can't create > new ones either using the interface. Am I using the program > wrong or is this capability not implemented yet? Hi James, You can create fkeys when you create a table in pgAdmin, or browse existing keys. You cannot add additional or drop existing keys yet though, unless you enter the SQL manually. If you do so, you will need to right-click and Refresh the relevant bit of the treeview to see the changes. Regards, Dave. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
