Re: [SQL] UPDATE with a SELECT and subSELECT(About comparing dates and non dates data)

2002-12-19 Thread javier garcia
Thanks Christoph; Typing what you told me there was an errror; I' ve changed it slightly an it seems that this sintax is correct. I say "it seems" because the computer begins to process the query but doesn't finish it. I've leaved it working for more than half an hour, before cancel it, with no

Re: [SQL] Perform a Select on an Oracle Database from PG

2002-12-19 Thread Roberto Mello
On Thu, Dec 19, 2002 at 03:37:00PM +, [EMAIL PROTECTED] wrote: > How do I do a cross-database connection? > > I have data in a table in Oracle that I need to copy into a > Postgres table. It has been suggested to me that I attempt to > perform a cross-database select instead of exporting th

[SQL] Perform a Select on an Oracle Database from PG

2002-12-19 Thread val
How do I do a cross-database connection? I have data in a table in Oracle that I need to copy into a Postgres table. It has been suggested to me that I attempt to perform a cross-database select instead of exporting the info from Oracle into a CSV file and then importing the CSV data into Pos

Re: [SQL] references table(multiple columns go here)

2002-12-19 Thread Gary Stainburn
On Thursday 19 Dec 2002 3:17 pm, Tom Lane wrote: > Gary Stainburn <[EMAIL PROTECTED]> writes: > > That did the trick. However, I now have another problem with the > > constraint complaining about there not being an index to refer to. > > However, there is. > > No there isn't: > > jrank

Re: [SQL] references table(multiple columns go here)

2002-12-19 Thread Tom Lane
Gary Stainburn <[EMAIL PROTECTED]> writes: > That did the trick. However, I now have another problem with the constraint > complaining about there not being an index to refer to. However, there is. No there isn't: > jrank int4 not null references ranks(rrank), -- needs sorting

Re: [SQL] unsubscribe

2002-12-19 Thread Robert Treat
If you just want to take a break, your better off sending "set ALL nomail-14d" to majordomo. Robert Treat On Thu, 2002-12-19 at 07:39, Christoph Haller wrote: > > David and all others on the list, > who want to turn off mailing over xmas and new year, > please send your unsubscribe to > > [EMA

Re: [SQL] unsubscribe

2002-12-19 Thread Christoph Haller
David and all others on the list, who want to turn off mailing over xmas and new year, please send your unsubscribe to [EMAIL PROTECTED] Otherwise it will not be processed. Regards, Christoph ---(end of broadcast)--- TIP 1: subscribe and unsubs

[SQL] unsubscribe

2002-12-19 Thread david williams
unsubscribe _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] references table(multiple columns go here)

2002-12-19 Thread Gary Stainburn
On Thursday 19 Dec 2002 11:30 am, Tomasz Myrta wrote: > Gary Stainburn wrote: > > On Thursday 19 Dec 2002 9:58 am, Tomasz Myrta wrote: > > >Gary Stainburn wrote: > > >>That did the trick. However, I now have another problem with the > > >>constraint > > >>complaining about there not being an index

Re: [SQL] references table(multiple columns go here)

2002-12-19 Thread Tomasz Myrta
Gary Stainburn wrote: On Thursday 19 Dec 2002 9:58 am, Tomasz Myrta wrote: >Gary Stainburn wrote: > >>That did the trick. However, I now have another problem with the >>constraint >>complaining about there not being an index to refer to. However, >>there is. The error is inside declaration o

Re: [SQL] references table(multiple columns go here)

2002-12-19 Thread Gary Stainburn
On Thursday 19 Dec 2002 9:58 am, Tomasz Myrta wrote: > Gary Stainburn wrote: > > That did the trick. However, I now have another problem with the > > constraint > > complaining about there not being an index to refer to. However, > > there is. > > Output below: > > > > create table ranks ( > > ri

Re: [SQL] references table(multiple columns go here)

2002-12-19 Thread Tomasz Myrta
Gary Stainburn wrote: That did the trick. However, I now have another problem with the constraint complaining about there not being an index to refer to. However, there is. Output below: create table ranks ( rid int4 default nextval('ranks_rid_seq'::text) unique not null, rdid characte

Re: [SQL] references table(multiple columns go here)

2002-12-19 Thread Gary Stainburn
Thanks for that Tom On Wednesday 18 Dec 2002 5:50 pm, Tom Lane wrote: > Gary Stainburn <[EMAIL PROTECTED]> writes: > > I've just tried this on a 7.2.1-5 system and get the same error. > > > >> create table jobtypes ( > >> jidint4 default nextval('jobs_jid_seq'::text) unique not null, > >>