Re: [GENERAL] Foreign Key can't refer to one of 2 primary keys

2003-06-21 Thread Gianni Mariani
Reuben D. Budiardja wrote: Hi all, Suppose I have a table with more than one primary key. If I create another table and I want one of the column of that second table REFERENCE to one of the primary key of the first table, how do I do that? eg CREATE TABLE test ( col1 VARCHAR(20), col2 VARCHAR(2

[GENERAL] Foreign Key can't refer to one of 2 primary keys

2003-06-21 Thread Reuben D. Budiardja
Hi all, Suppose I have a table with more than one primary key. If I create another table and I want one of the column of that second table REFERENCE to one of the primary key of the first table, how do I do that? eg CREATE TABLE test ( col1 VARCHAR(20), col2 VARCHAR(20), col3 VARCHAR(20), PRIMAR

Re: [pgsql-advocacy] [GENERAL] Governance WAS: MySQL gets $19.5 MM

2003-06-21 Thread Josh Berkus
Folks, > (And how do we decide what's the best interest of the project as a > whole, anyway? Well, community consensus is the only way that I can > see. Again, the critical factor is that no one voice drown out the > rest.) Well, a lot of it has been about the core committee and trust. The re

Re: [GENERAL] Problem with cursor

2003-06-21 Thread Tom Lane
"Frank Millman" <[EMAIL PROTECTED]> writes: > [ this doesn't work: ] > begin ; > declare fm scroll cursor for select a.CompanyId, b.CompanyName > from SysUsersCompanies a, SysCompanies b > where UserId =3D 'Greer' and a.CompanyId =3D b.CompanyId > order by a.CompanyId ; > move 1 in fm ; > fet

Re: [pgsql-advocacy] [GENERAL] MySQL gets $19.5 MM

2003-06-21 Thread The Hermit Hacker
On Fri, 20 Jun 2003, Tom Lane wrote: > The core committee has spent a fair amount of time worrying about > exactly this issue, as first Great Bridge and later Red Hat threatened > to become the 800-pound gorilla. As a former employee of the former and > a current employee of the latter, I may not

Re: [GENERAL] LAST_INSERT_ID equivalent

2003-06-21 Thread Nigel J. Andrews
It's going back a bit but I don't see any post replying to this in the hundreds I have left unread in that time, so... On Thu, 12 Jun 2003, Arjen van der Meijden wrote: > When you can't use a transaction or don't want to use curval, you can > use this: > > rowsUpdated = st.executeUpdate(); //

[GENERAL] Problem with cursor

2003-06-21 Thread Frank Millman
Hi allI posted this to the newsgroup on June 11th, but I got no replies.Is the mailing list is a better forum for asking questions of this nature? Below is a script that creates and populates three tables, and then creates a scroll cursor to retrieve the data. Mostly it works fine, but in this

Re: [GENERAL] Unable to create or drop plpgsql

2003-06-21 Thread Darko Prenosil
- Original Message - From: "Jason Underdown" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 20, 2003 11:00 PM Subject: [GENERAL] Unable to create or drop plpgsql > Hi everyone, > > This is my first post to this group, so please be kind. > > My database used to have suppor

Re: [GENERAL] JDBC Type 4 Driver Jar File.

2003-06-21 Thread Thomas Kellerer
Arjen van der Meijden schrieb: According to Sun, http://jcp.org/en/jsr/detail?id=221, it is not yet available: "2.11 Please describe the anticipated schedule for the development of this specification. This specification will be available towards the end of the calendar year, 2004. " So I wonder why

Re: [GENERAL] JDBC Type 4 Driver Jar File.

2003-06-21 Thread Arjen van der Meijden
According to Sun, http://jcp.org/en/jsr/detail?id=221, it is not yet available: "2.11 Please describe the anticipated schedule for the development of this specification. This specification will be available towards the end of the calendar year, 2004. " So I wonder why you expect a Postgresql JDBC

[GENERAL] JDBC Type 4 Driver Jar File.

2003-06-21 Thread Kallol Nandi
What is the comaptible version of the JDBC Type 4 Driver Jar File for developing a JDBC application on Redhat Linux version 8.0 and PostgreSql version 7.2.2. Can someone send me the jar file.   Thanks and Regards, Kallol.  

Re: [GENERAL] JDBC in PostgreSql for Linux

2003-06-21 Thread Thomas Kellerer
Kallol Nandi schrieb: I am not able to get the mistake.What might be the problem with the url? Please do reply.It is urgent. Thanks and Regards, Kallol. Did you try to use Sun's JDK? ---(end of broadcast)--- TIP 5: Have you checked our extensive FA

Re: [GENERAL] JDBC in PostgreSql for Linux

2003-06-21 Thread Kallol Nandi
I have changed the url to "jdbc:postgresql://"+server+":"+port+"/"+database import java.sql.*; import java.util.*; import org.postgresql.Driver; public class JDBCConnection { public static void main(String args[]) { try { String server ="10.100.102.31"; String port ="5432";