Re: [SQL] Reference integrity question

2003-01-02 Thread Stephan Szabo
On Fri, 27 Dec 2002, Evgen Potemkin wrote: > Good time of day! > > I have two tables > news(newsid int4, newscltid int4 references clt(cltid) match full,newstext text) > and > clt(cltid int4, somedata text). > after clt is renamed , for ex. to clt_old, newscltid start to reference to >clt_ol

[SQL] PostgreSQL X Resin EE

2003-01-02 Thread Pedro Igor
Have someone used Resin EE with PostgreSQL or actually use both for building applications ? About PostgreSQL i know that is one of the best options for back-end, but what about Resin EE ?   Thanks ...   Pedro Igor 

Re: [SQL] Slow self-join on a 100 million record table

2003-01-02 Thread Paul Thornett
I've played with this quite a lot on a fairly similar machine to yours - i.e. Dual pentium III 700s, 5x4.5Gb 10k Scsi disks Hardware Raid0, 1 Gb. Ram, Windows 2000 Professional (SP3), Sql Server 2000 Desktop (SP2). As expected my elapse times are almost exactly twice as long as yours. I created my

Re: [SQL] empty arrays

2003-01-02 Thread Steve Crawford
Caution! In 7.2.x your statement is interpreted by the parser to be a single element with an empty string which is converted to a zero. If you do this instead: create table test_table ( test_column integer[], another_column integer ); CREATE steve=# insert into test_table (another_column) values

[SQL] Adding a Primary Key to an exisiting table

2003-01-02 Thread Maly Kaing
Hi I just exported my MS Access databases into postgres using an ODBC driver, but the thing is during the export postgres doesn't recognize any of my primary keys in Access. Is there any way to alter the tables so that i can make one of my current fields the primary key? I don't want to drop the

Re: [SQL] Adding a Primary Key to an exisiting table

2003-01-02 Thread Bhuvan A
> Hi > > I just exported my MS Access databases into postgres using an ODBC driver, > but the thing is during the export postgres doesn't recognize any of my > primary keys in Access. > Is there any way to alter the tables so that i can make one of my current > fields the primary key? I don't wa