[HACKERS] pg_dump patch: Allow -X'exclude table from dump by pattern'

2001-09-12 Thread Giuseppe Tanzilli - CSF
Ciao, I had the need to exclude tables from the dump so I made this patch, I do something like pg_dump -X \"Test_*\" -X \"Devel*\" test I'm not a C guru, but it work, the only thing I was unable to get rid of is the dump of sequences for that table, so I have to add -X tablename_id_seq If you

[HACKERS] Fields Case problem

2000-11-24 Thread Giuseppe Tanzilli - CSF
Hi, I had a problem porting applications from mySQL. I can't find info on this in the docs... so mailed the list, sorry for my english. I create the fileds name with first letter uppercase, I need this way, because the result set must have the fileds name with the correct case in PHP. I woul

[HACKERS] WAL Crash during index vacuuming 7.1beta4

2001-02-01 Thread Giuseppe Tanzilli - CSF
Hi, during the nightly vacuum pgsql closed and do not start any more. Attached the log. Seems the problem was rebuilding an Index, There is a way to force wal to ignore indexes ? Can I delete it ? thanks in advance --- Giuseppe Tanzilli

[HACKERS] pgsql 7.4b2 bug on column defaults?

2003-08-29 Thread Giuseppe Tanzilli - CSF
Hi, just testing beta2 I got strange things on default values with functions: create table test2 (i integer, t timestamp default 'now()'); test1=# \d test2 Table "public.test2" Column |Type | Modifiers -

Re: [HACKERS] pgsql 7.4b2 bug on column defaults?

2003-08-29 Thread Giuseppe Tanzilli - CSF Sistemi
Hi, I see it work without quotes around function, but I got it from a 7.2 dump with quotes around it. Maybe it require a note for people dumping from 7.2, I don't have 7.3 around to try, sorry bye Giuseppe Tanzilli - CSF wrote: Hi, just testing beta2 I got strange things on default values