the universe."
Sir Albert Einstein
--------
Goutam
Paruchuri
Database Consultant,
O'NEIL
ASSOCIATES, INC. http://www.oneil.com495 Byers Rd.Miamisburg, Ohio
45342-3662Phone: (937) 865-0846 ext. 3051Fax: (937) 865-5858
Confidentiality Notice
All this fucking crap is all your fault!
You're such a fucking asshole!
Go fuck yourself up the anus with a broomstick, BITCH!
FUCK YOU!
MOTHER FUCKER!
Goutam Paruchuri
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading
Try this,
Set conn = New ADODB.Connection
Conn.open DNS=SAP_PG;uid=postgres
Set rsE = Conn.Execute(updateSQL)
Where updateSQL is your update statement.
Check permissions for updates/write for the user you are connecting.
- Goutam
-Original Message-
From: [EMAIL PROTECTED]
Give the IP Address of your connecting client in the pg_hda.conf file
and restart postgres.
Thanks !
- goutam
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of ON.KG
Sent: Monday, November 15, 2004 5:06 PM
To: [EMAIL PROTECTED]
Subject: [GENERAL]
If 2 days are equal for color red, you still would get 2 rows returned.
Maybe the below is accurate.
SELECT g.color, g.date, g.entered_by
FROM giventable g
WHERE g.color = 'red'
AND g.date =
(SELECT MAX(g2.date)
FROM giventable g2
Its all depends on what features you would use in Postgres.
Iam no expert but if you use simple selects/inserts/transactions you
would definitely be ok..
You can probably start looking at differences between 8.0 and 7.4.3 and
then decide.
- Goutam
-Original Message-
From: [EMAIL
Hello,
I get an error in my log when connecting to postgres server on Windows.
Postgres version : 8.0.0-beta4
LOG TEXT
2004-11-10 11:22:47 LOG: invalid entry in file C:/Program
Files/PostgreSQL/8.0.0-beta4/data/pg_hba.conf at line 64, token
192.168.2.1/254
2004-11-10 11:22:47 FATAL: missing
My understanding was it means ip range of 1 to 254.
192.168.2.1 to 192.168.1.254
-Original Message-
From: Wilson, David [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 10, 2004 12:05 PM
To: Goutam Paruchuri
Subject: RE: [GENERAL] Error connecting using pgadmin from
different
Its works if I specify the ipaddress of each client which is being
connecting to the server.
Its hard to do it on a DHCP network . Any roundabouts ?
- Goutam
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Goutam Paruchuri
Sent: Wednesday
Yes you can use the copy command. Check for
copy TABLE NAME from 'c:\\bcpdata\\Files\\FILENAME.txt' with delimiter
as '\t' NULL as '';
When creating a table, use an incremental column (data type is serial).
Hope the above helps.
- Goutam
-Original Message-
From: [EMAIL
Why can you not use simple insert statements (sql insert).
Copy is meant to transfer large amount of data from text files to
databases and vice versa.
- Goutam
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Marek Lewczuk
Sent: Monday, November
t Einstein
--------
Goutam
Paruchuri
Database Consultant,
O'NEIL
ASSOCIATES, INC. http://www.oneil.com495 Byers Rd.Miamisburg, Ohio
45342-3662Phone: (937) 865-0846 ext. 3051Fax: (937) 865-5858
Confidentiality Notice
The information contained in this e-mail is confidential and intended fo
Iam trying to import
data from ms-sql server to postgres. I export the data which has datetime columns in sql server using BCP. I use the following to import back into postgres.
copy tablename from
'c:\\bcpdata\\mcfa\\tablename.txt' with delimiter as '\t'
I get the following
error !!
:
Allen LandsidelCc: Goutam Paruchuri;
[EMAIL PROTECTED]Subject: Re: [GENERAL] Copy command and
import - MS SQL Server to Postgres
On Fri, 2004-11-05 at 16:48, Allen Landsidel wrote: On
Fri, 5 Nov 2004 16:31:21 -0500, Goutam Paruchuri
[EMAIL PROTECTED] wrote: Iam trying to
import data from ms
14 matches
Mail list logo