[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 shou

[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 dir

[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, a

[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 o

Re: [HACKERS] Duplicate variable declared?

2004-04-22 Thread mike g
Joe Conway wrote: mike g wrote: In file postgresql-7.4.2/src/backend/utils/fmgrtab.c This is an automatically generated file. The reason for duplicate array_push declarations is that one-and-the-same array_push function is used to implement two SQL functions, array_append and

Re: [HACKERS] I need Help

2004-05-03 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 installe

[HACKERS] Call for 7.5 feature completion

2004-05-17 Thread mike g
Sorry for not replying to a thread but I have a digest subscription... Thank you hackers for all your hard work!!! I use PostgreSQL everyday and love it. My current job would be impossible if I was forced to use MS Access. I don't mind using postgres under cygwin but would much rather use a n

[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

[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 * To: cygwin at cygwin dot com * Date: Sun, 8 Aug 2004 11:07:56 -0400 * Subject: Re: Initdb FATAL error shmat - Win98 Cygwin 1.5.1

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

2004-08-08 Thread mike g
r 14." I don't see 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

[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 num

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 comb

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 th

[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 see

[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

Re: [HACKERS] Dump from cygwin directly to windows

2004-12-17 Thread Mike G
It looks like it started off as a permissions problem. I added the users to the database before trying again and this time it worked fine. I have attached the log from the original attempt if you wish to have a look. Mike On Fri, 2004-12-17 at 22:35, Tom Lane wrote: > "Mike G.&

Re: [HACKERS] Dump from cygwin directly to windows

2004-12-20 Thread Mike G
-superuser 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