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,
> >>
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
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
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
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
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
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
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
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
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
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
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
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
13 matches
Mail list logo
