[HACKERS] Typo in pg_dump documentation and new suggestion for Release Notes

2006-12-18 Thread Mike G
In the online documentation for 8.2, pg_dump page, --table=table section, in the second Note: paragraph, rather than the old locution of -n sch -t tab probably should be rather than the old location of -n sch -t tab Also maybe this section on pg_dump in the release notes page for 8.2 should be

Re: [HACKERS] Different length lines in COPY CSV

2005-12-12 Thread Mike G.
I too have to deal with this issue daily since I deal with Windows daily. It sounds like the source of the csv files were originally Excel files. I have never been able to figure out how Excel determines to quit putting null values in empty columns after X rows and resume again later on. If

[HACKERS] PgInstaller error on upgrade

2005-12-12 Thread Mike G.
I am running XP Pro with SP2. Postgres 8.1 installed with MSI but later on I did upgrade the ODBC driver. Shortly after selecting upgrade.bat I received an error: This error may indicate a problem with the installation package. Number 2803 After clicking OK the installer continued anyway and

[HACKERS] Did this issue ever get resolved?

2005-04-06 Thread Mike G.
http://archives.postgresql.org/pgsql-hackers/2005-03/msg00260.php I don't see any other discussions about it in the archives. I too get these from time to time on my W2K box. Mostly the permission denied entries. If 1663/17269/1677179: Permission denied refers to a file under the data

Re: [HACKERS] Dump from cygwin directly to windows

2004-12-20 Thread Mike G
domain account. When I first saw all the \N errors I thought it was a unix to windows end of line character conversion error. Thanks for your help. Mike On Sat, 2004-12-18 at 11:00, Tom Lane wrote: Mike G [EMAIL PROTECTED] writes: It looks like it started off as a permissions problem. I

[HACKERS] Dump from cygwin directly to windows

2004-12-17 Thread Mike G.
Hello, In testing RC1 today I attempted to use pg_dump -h cygwin_box mydb | psql -h RC1_box mydb It started off ok but at somepoint while transferring data over in a table it went astray. I started getting rows and rows of syntax errors most of them saying invalid command \N. All of the

[HACKERS] FW: postgres shmat request fails on win98 (cygwin)

2004-08-08 Thread Mike G
Hello, I will bring it up with the postgresql hackers. PS - Sorry for the new posting. I read these via digest. Mike * From: Jason Tishler jason at tishler dot net * To: cygwin at cygwin dot com * Date: Sun, 8 Aug 2004 11:07:56 -0400 * Subject: Re: Initdb FATAL error

Re: [HACKERS] FW: postgres shmat request fails on win98 (cygwin)

2004-08-08 Thread mike g
any mention of XP, whether the Pro or Home version, will be supported in version 8 at the moment either. Mike On Sun, 2004-08-08 at 13:28, Doug McNaught wrote: Mike G [EMAIL PROTECTED] writes: Hello, I will bring it up with the postgresql hackers. PS - Sorry for the new posting. I

[HACKERS] upper() / lower() regression test case needed?

2004-06-03 Thread mike g
Hello, Going through the regress test sql files I noticed that when testing string functions there was no upper / lower case tests. I see upper / lower being used in the select_having and select_implicit files in the GROUP BY and ORDER BY clauses. Good enough or should I submit patch for adding

Re: [HACKERS] I need Help

2004-05-04 Thread mike g
Yes it is possible for both to be on the same pc. Please send mail to the general or novice list if you need more help. On Mon, 2004-05-03 at 11:05, olivia jurado wrote: Hi. I'm from Panama. I don't speak english very well but I'm learning english. I Need help. I installed

[HACKERS] Duplicate variable declared?

2004-04-20 Thread mike g
Hello, In file postgresql-7.4.2/src/backend/utils/fmgrtab.c line 336 and line 337 are both equal to extern Datum array_push (PG_FUNCTION_ARGS); I have created a simple perl script that examines files line by line and if 2 in a row match prints a result. Sometimes it catches bad cvs checkins or

[HACKERS] Returning number of rows - Copy In function

2004-03-25 Thread mike g
Hello, I was looking at putting the code for this in copy.c CopyReadLineFunction. If I do a printf at point A it compiles, installs, runs, doesn't display any data after running initdb and returns a result when a COPY FROM is executed in psql. If I do a printf at point B it compiles, installs,

Re: [HACKERS] COPY formatting

2004-03-17 Thread mike g
I deal with this daily in a cygwin environment. I wrote a simple c++ program where I hardcoded the input file name/location and output file name/location. I strip the quotation marks out where they are used for identifying text fields and change the comma's used as CSV's to pipes. I use a

[HACKERS] Confusion over Copy.c/Count rows from file patch

2004-03-15 Thread mike g
Hi, I am trying to revise my patch for counting the number of rows inserted when using a COPY statement. I set it up a printf to see the results in the log file. When I execute a COPY the first time it reports 0 rows inserted(but actually inserts all rows). If I execute again it reports the