Fwd: RE: [SQL] dump from access to pg on linux

2000-06-13 Thread Yury Don
This is a forwarded message From: Fred Lecul <[EMAIL PROTECTED]> To: Yury Don <[EMAIL PROTECTED]> Date: Wednesday, June 14, 2000, 10:45:55 AM Subject: [SQL] dump from access to pg on linux ===8<==Original message text=== I did this by using the postgres odbc drivers, I lin

Re: [SQL] dump from access to pg on linux

2000-06-13 Thread Yury Don
Hello rocael, Once, Wednesday, June 14, 2000, 12:11:40 AM, you wrote: run> I have a DB in access, and I wanna pass it to pg7 on my linux box, do somebody run> know which is the best (and easy) way to do that?? like a dump?? We used Pgupt for this: http://dspace.dial.pipex.com/boylesa/pgupt/pgup

[SQL] Q:Postgres 7.0 & Access'97?

2000-06-13 Thread Emils Klotins
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, I am using Postgres 7.0 on SuSE Linux 6.2 and Postdrv.exe 6.50. (as downloaded from /latest/ dir of PG FTP site yesterday). Now, I have experienced 4 issues immediately with Postgres via ODBC from Access and I was wondering whether you

[SQL] dump from access to pg on linux

2000-06-13 Thread rocael
Hi all! I have a DB in access, and I wanna pass it to pg7 on my linux box, do somebody know which is the best (and easy) way to do that?? like a dump?? thanx, Rocael. Get free email and a permanent address at http://www.netad

[SQL] Re: Simple search question

2000-06-13 Thread John McKown
On Tue, 13 Jun 2000 12:15:17 +1000, Alex <[EMAIL PROTECTED]> wrote: [snip] > >> so I can't test this. If it doesn't work, I'd try using pg_GetLastOid() >> to get the OID of the inserted row. The use the pg_Exec and SELECT >> * WHERE OID=oid-value, followed by pg_fetch_row(). > >Thanks John

Re: [SQL] sql foregein key

2000-06-13 Thread Jan Wieck
GANESH KUMAR wrote: > > sir , > > i am working 6.5.2 postgresql > in creation foregein key in table > > syntax i am writing is > 1)create table gk > (sno int primary key); > > 2)create table kk > (sno int references gk, > sname varchar(2)); > i am getting message like this foregein key is not

Re: [SQL] question on diagnostics

2000-06-13 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > I can confirm this is still a bug. Yeah, it's a parser problem. I punted it in Lockhart's direction, but he's been out of town... regards, tom lane >> oh, btw this select refused to use an SQL natural join among the 3 >>>

Re: [SQL] question on diagnostics

2000-06-13 Thread Bruce Momjian
I can confirm this is still a bug. > > > oh, btw this select refused to use an SQL natural join among the 3 > > > relations - the server gives up and disconnects without warning. > > > > That sounds like a garden-variety bug. I'd be willing to look at it > > if I had a complete example to foll

Re: [SQL] postmaster: init.d/start

2000-06-13 Thread Thomas Mack
>Hi Daniel, > >thank you for your reply. > >There are some unanswered questions. >Why does one have to consider multiple run levels? Doesn't run level 3 >(network + X) implicate run level 2 (network)? Not on SuSE Linux. On SOlaris for example, you will find in /etc/inittab an entry like: s2:23:w