Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tFOgq-00CmdF-LE for pgsql-general@arkaria.postgresql.org; Mon, 25 Nov 2024 02:19:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tFOgp-00B7EY-CY for pgsql-general@arkaria.postgresql.org; Mon, 25 Nov 2024 02:19:03 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tFOdY-00B0et-3k for pgsql-general@lists.postgresql.org; Mon, 25 Nov 2024 02:15:40 +0000 Received: from mail-bn7nam10olkn2016.outbound.protection.outlook.com ([40.92.40.16] helo=NAM10-BN7-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tFOdV-003cWc-Gy for pgsql-general@postgresql.org; Mon, 25 Nov 2024 02:15:38 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=KOmmOmSkTgPdClrf4ix4bSJM30rziOxtuwOAo4tcGGusIDuuCe5qcQB2+rUcUS9wZRwtpZQge/WscyloAcnTH6sAsvW6F+OZABSGejqtAEBjresF3yaxUX6jiMmg4SvYSsTnTM4eJzQCs5FxvmtWxX+wwI7NUcMjn1ZsxXGc6HDhHrL5EN8dg4JTiRC2Exxl8R+cFsxRy+kS3zSXDGyCgVBSSmIav6DJL4v06ThBLzPEBDLmz94NTnHLoS9ThONbnCpQobVnUFLuqH/bGVRLSjIbbc8EqFcRA47EZExw2RmIUohh6PjfJSo8f2AxcOsooY69h4L2Ji+xna6XSgcJsg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=pkcVw/pUKn7qe5eXUSibHzSIHWbWlpDitsnTrnZsfR4=; b=YcP9LFLQNsSj8QAJu/AaT/m86K7pZYj18izO9FSZ04zbLt4v+9rkuiNl4EebOIIFEf9IBd4q5DfiT0TpK649H/OUxXbIbqcu+8odf47kD10agijMuaWEaX/anLTx3TRSyJTpf5oSHKzff70Z6uxFal2Ndr3HowXIY55CYhQMbn6W23vs+xKVKXN37WXrH9KJy9PRpHrZHia5j/nTzhM5uFCEFgiYFhMcAfQ+xdXmu7vp296VQRiPLG7C7wbc0HYSdyZVcPB9M2uxVr3igXH75OeP4jNSV5t4jA+WitFJFYLt3tnOW0l+mHtGiIQOFCHXq7j7iY5T4EU6wY65TvdDDg== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=HOTMAIL.CA; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=pkcVw/pUKn7qe5eXUSibHzSIHWbWlpDitsnTrnZsfR4=; b=PAH1n8GuKQ4C12b+xCPrPw2FyABFGb3jIxXvtY73dXO6zy/xJowXbNIqcS9x2Hz3pKCupqcuSBace/OcF0X+5aSvmu/le+jb2hk+TTugDoLSYWTF8BtjtSPrnIhgW+DtRRZorWW3zoDXBEDs4QGFWcPW9Fw55kWbRZKATV75GROIr4tvajOW8HJc3oSodoUJzkOH+H5EambIXUHJkOMUd9IrdWEqqUSdUq3Y59QKkZAO0fZDlQoaOIlFVifBXxVIUT0aK2g7M8WQ/3LdLUZYuilJ96n/ZzIbPrDHxsWBW+s0W2Rrfg4yOlawfAhEAldD2+A5+9A7NxMF0Cm9MI0abQ== Received: from BYAPR12MB2808.namprd12.prod.outlook.com (2603:10b6:a03:69::24) by SJ2PR12MB8784.namprd12.prod.outlook.com (2603:10b6:a03:4d0::11) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8182.20; Mon, 25 Nov 2024 02:15:33 +0000 Received: from BYAPR12MB2808.namprd12.prod.outlook.com ([fe80::63f0:8d51:63fb:86fb]) by BYAPR12MB2808.namprd12.prod.outlook.com ([fe80::63f0:8d51:63fb:86fb%6]) with mapi id 15.20.8158.024; Mon, 25 Nov 2024 02:15:33 +0000 Content-Type: multipart/alternative; boundary="------------9a4WsXtIr4Ox0rWwWVYT2FC3" Message-ID: Date: Sun, 24 Nov 2024 21:15:27 -0500 User-Agent: Mozilla Thunderbird Content-Language: es-ES, en-CA To: "pgsql-general@lists.postgresql.org" , PostGreSQL MailingList From: Arbol One Subject: JDBC using REFERENCES Organization: ArbolOne X-ClientProxiedBy: YT4PR01CA0435.CANPRD01.PROD.OUTLOOK.COM (2603:10b6:b01:10d::28) To BYAPR12MB2808.namprd12.prod.outlook.com (2603:10b6:a03:69::24) X-Microsoft-Original-Message-ID: <0621f9a3-2aa7-4953-a4b7-c058724ded40@hotmail.ca> MIME-Version: 1.0 X-MS-Exchange-MessageSentRepresentingType: 1 X-MS-PublicTrafficType: Email X-MS-TrafficTypeDiagnostic: BYAPR12MB2808:EE_|SJ2PR12MB8784:EE_ X-MS-Office365-Filtering-Correlation-Id: c7b2f51e-1c32-4858-56d9-08dd0cf70896 X-Microsoft-Antispam: BCL:0;ARA:14566002|19110799003|461199028|15080799006|8060799006|7092599003|5072599009|440099028|3412199025; X-Microsoft-Antispam-Message-Info: =?utf-8?B?eUdBTG1hVEJYRkRLMU5VNzI4VjNLRWJqUjIvMjBtZ1NrMWtjUmppcXhZRWZI?= =?utf-8?B?OWx3T29mL0JDVnhwNi9RQm5CRHBjSE1NVG9tRHJSOURTNHREdmw5MVV1eUxl?= =?utf-8?B?U1piWk1RQ3ZENTF0ZFRNU28xeStYNTRNYlJnbjVOT0tieUpiSUI2cFBFOC9w?= =?utf-8?B?L0N0QTJPMUxIYTRQa0g1VEZFWHJqTDJHL1hsYjk1ajZTRXNHdDVKNzhuNFQr?= =?utf-8?B?Q3RVb0E1YUdsZk9MQVRXNlVMQy9pVitsK1ozdlZlbTFOTWcrbzhMbTl4aVVY?= =?utf-8?B?R1J1dWV3S1JNa0FHcDB2ZTc3dW9sQ2Z0cm5ocjM0c1JHTnlYb0dlUnBwZko0?= =?utf-8?B?M2ZvenRPQzUyaXhCWThjOGVDWTlEY2JQVDk1Y0NUekR4MkMzZWVKeCtNQ1lw?= =?utf-8?B?WkJNMlRmT3BzS1A4Z3NPeUI1N0o3VjlJTzV4TURIeG5pMU1YR2UxRkNOejdH?= =?utf-8?B?WElBS2kxcTdRZWZ2L1dqU1Z3TUpqMmtEb0ZkWE1mQUNxWGpuVHpOVmplSEI0?= =?utf-8?B?VnpXWkFrbGRvWFlOOXFLOGhlZHVLUTRqOXE4b2dSckl3OXF5WnVvKzkzb3Vy?= =?utf-8?B?UGZkWFpjN0JPamxYV1lBTHJJL0F3RU9FdmExVlRzTWhOektDY2tTbnhDZWJr?= =?utf-8?B?elEwbFpLOWtvTE5EdkFCWDNMZFYybGRjRUNkY3VDWG5zcXBQcTZPNklWZmxt?= =?utf-8?B?SUNBOHNiN3k3TEFDek1jMTZUZGYwY0RZcHJscHdUYXBvbWJMV3BlZUx0bk9Q?= =?utf-8?B?MFVVczhjZFh1TlVNblBUNnF3ZGVtNEd6WmpkWWlVWUxyZVlvQ0pjWktHZEg0?= =?utf-8?B?MzRFd3N1OUplTnlUVDk0K1ZOZ0lJTFpRV0kwZ3ZYbUhiQVF4cjlzZDJRMnJx?= =?utf-8?B?ZjFmV2I3SlhVdzNTTVVWRElwSVNyUGptZWREMmNtOTBjRTNPM1hzdmFWQzJX?= =?utf-8?B?cURTVS9SQStwSTYwK1ZRRlNnQisyQ29oUE5QV3JUelJRUE1jU09EcUJlaEdG?= =?utf-8?B?SjF5UnFWYnlKVEltcDBkaS9DejZWNm9ldFBzY0hlZWpraUFYWXpIdGRuNldM?= =?utf-8?B?ZW5XUmpXV29KWVZWV3JmRGNMa0RVZVBsUTRRNnEvSnlXZ2pVR0JScUIwUTM2?= =?utf-8?B?N0VJTG5MTXYyMUJla1RqZmtsejdTZUJrR1dyR0d0ZDh5SHFpWUQ2R1RTS0hF?= =?utf-8?B?WEM0dktuaXhUME4zeG8xRXFCemRWU09PN3Q3UVFKS0JZeFg1UjYwU245bWtJ?= =?utf-8?B?c043UHliQ09YcE5WajBZUkkzQUl5SUVEcmJQa2xpNGJBa3Fqa2w5Szg5SWFW?= =?utf-8?B?WUNwMmx5eXdBWHNNYzRXUjJPTjVidTNRaVAvYkZpaUFZYjViZTlsT3VsNjdk?= =?utf-8?Q?K8yLEfXJNZLRuEo/zJfS0OtqmmdmdnVM=3D?= X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-MessageData-0: =?utf-8?B?a2ZscmswNUp6ZVdtVlFWZmQ2K29STm1DUnMxNDNaUnpSaUlyRzhuRVdIWm9N?= =?utf-8?B?cW5zdlI1RzRyeGdEZ1EzWm1CMDdsSFJkUnFpa1Z2MnJvMVI0TVN4a3cxaXl6?= =?utf-8?B?YWF3ZkVHclVGbzFHOWJBWUp3M1FVOHZiNmNsTTVrQXYxdHlROEZJL3FJU0tn?= =?utf-8?B?eTJhWlRjblk2aVRSNzMvZDZ6dDN5b2ZZd21ETzVoTkRjR0VBZzMwcFllZnJS?= =?utf-8?B?L2VQSWs5L3FOL0ovcnJ3azZ3Qmx6RjVkN3BJYTNKbFozMGtWWnhaM0Z0WFJO?= =?utf-8?B?NXRScVMxelUvYzd2WmhUMnR1Q0hWUlRpSjU5Mjd2R1R1YVc1ejAveUE0STBE?= =?utf-8?B?UHN2eWNKanZEdGtGRG5WSHJLR0REblhEQkJyZGQ4a1JpSlZMOWdvYTJSZG1w?= =?utf-8?B?MUUzTEVCQTNlNTJ1ZDZXbEIwZkZaSnVBdmlpdU5FVDNNN3B4dXFUMVVGMHpq?= =?utf-8?B?ZHRaMW1NemJVenRuaHA3Q2hYQVZBbGxueDJmWVVxRTB6S3hmeU9aQWJMWGV2?= =?utf-8?B?S1pLS0hxc09LdW1Ma1RiU1ZuRHBza3MvdEpaN3Ftb3RNcXN4bTNpdzdSS3cz?= =?utf-8?B?R3dyRC9vWVF3NEFzYzBIYlUyaDV3akJOOW5HWnVOQWxMUXZ3ZFk4eVZtd3ZI?= =?utf-8?B?N3V2L2NVa29JeGNFRENYdVBPaWtrTFBNZ1VPRlIwaDRJTDlwR1B0TEFrNzhl?= =?utf-8?B?TVVISWgxNkdRdkhkV295aHUzWTA4T2RLcXFMTVNib1FSTmNIYXZGSFk5OVBy?= =?utf-8?B?RlIzTWFVNjZiOUlQZjBVMFJ0RFN4MWRoUW0xdlFCdTJzYmNGQnAwSGU3NUd3?= =?utf-8?B?aWVSRGtJNjRPTWI4VlExN0JoS1U0SGQrVGNnd1loTGdSNlVYaHp2bFFQdjBD?= =?utf-8?B?M2w5VTk5d1NRT0tZVWdFSUcvWVY1VU5FNUh4Tis4ei80a3pLVXhNZzBaY0Fm?= =?utf-8?B?Y2Ewejg0TWVlRW04Q2IwVUhMNG9ZTldoV3Z2V1p0bi9laGZzTkxPT0QvVHVx?= =?utf-8?B?UVlTTlFtQ1lRQkxCY21ZaDBFVlFJcXJFdTZyOXQxZmx0R1dNWHNFZkJwQytM?= =?utf-8?B?bXg5TGR5WnJLczdRS0E1UnNOVnlzNk0yR0xtclhncjBBaEtOQmNnK2JnY3dz?= =?utf-8?B?YmpwdGw2UFV5anJTYzdVaFVkaGVNZkN5TUhpUDRBSGRXclMzMXdpei9YTENz?= =?utf-8?B?anFJT1ROTkN6K2pLRU9mSHlDemV4YmdEWk1HRjRLNjdvbWtPS09DanlWVWJP?= =?utf-8?B?OWlFeG1LdUNSTW41MUdtclJiaEJqQWcxRlBaOUN1b2IrdCtkdkFuN2l5alRD?= =?utf-8?B?ZkdEdFVtUWs2elZsNVlZcnhhWXVGQkpLM01CMGszZ0lDdFFOV1Rjei93anU0?= =?utf-8?B?TFcvY0FPN0NBdE92dmowSGd5YkxqL0MrZmx6b2JhaUxLN0xSalhBODJVNjhT?= =?utf-8?B?N3NaTzNHYjhvc2FRdTNOelVtcnpBbzJCWjVWMUx4Z3hiak1TWGQ0SXE4eDdW?= =?utf-8?B?cUQ1V3cxMGVtREpGKzVvVDZYcWEzMFMxT0lxdFlBaFU1OHdHTzBIcEhoSFBa?= =?utf-8?B?ek84R1YzZkEyazN4OFFyUGNZSHRCNWdsRk43NTJGUCswWFFUeUFjYVFNTW1k?= =?utf-8?Q?5c3Y1pcV5TYZoZa2w7vv8DeE3dKNdq36vng6Bj2FtTWo=3D?= X-OriginatorOrg: sct-15-20-7741-18-msonline-outlook-1cf9b.templateTenant X-MS-Exchange-CrossTenant-Network-Message-Id: c7b2f51e-1c32-4858-56d9-08dd0cf70896 X-MS-Exchange-CrossTenant-AuthSource: BYAPR12MB2808.namprd12.prod.outlook.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-OriginalArrivalTime: 25 Nov 2024 02:15:30.0950 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-CrossTenant-Id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: SJ2PR12MB8784 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --------------9a4WsXtIr4Ox0rWwWVYT2FC3 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit In an application that uses JDBC I am trying to use the following statement *               // Table parameters                 var sql = new MyString();                 sql.setData("CREATE TABLE IF NOT EXISTS ");                 sql.append(this.tableName);                 sql.append(" (");                 sql.append("index SERIAL NOT NULL, ");                 sql.append("id TEXT PRIMARY KEY, ");                 sql.append("day TEXT NOT NULL, ");                 sql.append("month TEXT NOT NULL, ");                 sql.append("year TEXT NOT NULL, ");                 sql.append("hour TEXT NOT NULL, ");                 sql.append("minute TEXT NOT NULL, ");                 sql.append("second TEXT NOT NULL, ");                 sql.append("millisecond TEXT NOT NULL, ");                 sql.append("am_pm TEXT NOT NULL, ");                 sql.append("admin boolean NOT NULL DEFAULT false, ");                 sql.append("CONSTRAIN id PRIMARY KEY (id)"); *_<== Error_*                 sql.append(");");* but I get a message saying : Exception in thread "main" java.sql.SQLException: In company.contact.createTable() ERROR: syntax error at or near "("   Position: 315 Does JDBC allow us to do this? What am I doing wrong? How to fix this -- */ArbolOne ™/* Using Fire Fox and Thunderbird. ArbolOne is composed of students and volunteers dedicated to providing free services to charitable organizations. ArbolOne's development on Java, PostgreSQL, HTML and Jakarta EE is in progress [ í ] --------------9a4WsXtIr4Ox0rWwWVYT2FC3 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit

In an application that uses JDBC I am trying to use the following statement

               // Table parameters
                var sql = new MyString();
                sql.setData("CREATE TABLE IF NOT EXISTS ");
                sql.append(this.tableName);
                sql.append(" (");
                sql.append("index SERIAL NOT NULL, ");
                sql.append("id TEXT PRIMARY KEY, ");
                sql.append("day TEXT NOT NULL, ");
                sql.append("month TEXT NOT NULL, ");
                sql.append("year TEXT NOT NULL, ");
                sql.append("hour TEXT NOT NULL, ");
                sql.append("minute TEXT NOT NULL, ");
                sql.append("second TEXT NOT NULL, ");
                sql.append("millisecond TEXT NOT NULL, ");
                sql.append("am_pm TEXT NOT NULL, ");
                sql.append("admin boolean NOT NULL DEFAULT false, ");
                sql.append("CONSTRAIN id PRIMARY KEY (id)"); <== Error
                sql.append(");");

but I get a message saying :

Exception in thread "main" java.sql.SQLException: In company.contact.createTable()
ERROR: syntax error at or near "("
  Position: 315

Does JDBC allow us to do this?
What am I doing wrong?
How to fix this

--
ArbolOne ™
Using Fire Fox and Thunderbird.
ArbolOne is composed of students and volunteers dedicated to providing free services to charitable organizations.
ArbolOne's development on Java, PostgreSQL, HTML and Jakarta EE is in progress [ í ]
--------------9a4WsXtIr4Ox0rWwWVYT2FC3--