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
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
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
"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
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
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(); //
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
- 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
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
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
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.
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
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";
13 matches
Mail list logo