[GENERAL] Please Help JDBC Error!!

Hi I have been using postgres database since last 7 months working on a involving JBoss server as an application server and postgres database at backend lately.. i noticed as the database started growing larger.. today encountered some error while firing this query select firstname , last name f

[GENERAL] LXP PostgreSQL application server

Hello, I thought I would let everyone know that we are now allow free eval/developer editions of LXP to be acquired. LXP is a PostgreSQL application server that has been under development for 18 months. LXP is currently at version 0.8 and is supports quite a few cool features including: AdHoc/D

[GENERAL] ODBC read/write permission in MS Access

Not sure if this should be here or in the ODBC list (that one looked more developer-ish, wheras this list seems more admin-ish. anyway) Testbedding an MS Access client to a PostgreSQL database, running v 7.1.2 postgreSQL, Access 2000 on a Windows 2000 box. Got the driver, version 7.1.0006.

[GENERAL] openlinksw odbc vs. postgresql on linux ??

no support for "postgres running on linux" ??! are they mad? - Forwarded message from Sonja Nevitt <[EMAIL PROTECTED]> - From: "Sonja Nevitt" <[EMAIL PROTECTED]> Date: Thu, 26 Jul 2001 14:28:06 +0100 To: <[EMAIL PROTECTED]> Subject: RE: hmm. stage one of four -- where's the rest? Hello

Re: [GENERAL] database information

SELECT datname FROM pg_database WHERE datname NOT LIKE 'template_'; -r At 04:22 PM 7/30/01 -0400, Peter Choe wrote: >how do i get the names of the databases that are created in postgres? > >is there a select statement similar to oracle? > >peter choe > >---(end of broad

[GENERAL] database information

how do i get the names of the databases that are created in postgres? is there a select statement similar to oracle? peter choe ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] RULE vs TRIGGER

On Mon, 30 Jul 2001, will trillich wrote: > i have a solution using RULES and PLGPSQL functions (instead of > triggers) for insert-unless-found, using perl lingo: > > # perlish pseudoCode > unless (select(tbl.fld == val)) { insert tbl.fld = val }; > > i'd love to hear the skinny on

Re: [GENERAL] referential integrity violation

It means that the particular key value that is used in the referencing table does not have an associated value in the referenced table, not the columns themselves. On 30 Jul 2001, tony wrote: > Hello, > > While copying from a text file of tab delimited data I am getting > " ERROR: referential

[GENERAL] Unexpected *ABORT STATE*

Seems that during an interactive transaction at the psql prompt any syntax error will cause the following state to be entered NOTICE: current transaction is aborted, queries ignored until end of transaction block *ABORT STATE* This is a bit annoying since it reared up near the end of a l

[GENERAL] referential integrity violation

Hello, While copying from a text file of tab delimited data I am getting " ERROR: referential integrity violation - key referenced from films not found in sales" The salesid field salesid INTEGER PRIMARY KEY DEFAULT NEXTVAL('sales_serial') exists Help =:-D Cheers Tony Grant

Re: [GENERAL] readline and rh7.1

On Mon, 30 Jul 2001, Ben-Nes Michael wrote: > The RPM support locale ? The newest ones do. -- Trond Eivind Glomsrød Red Hat, Inc. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]