Re: [ADMIN] log entries after pitr recovery

2006-07-21 Thread Tom Lane
"Chris Hoover" <[EMAIL PROTECTED]> writes: > ,11962,,2006-07-13 16:11:16.281 EDT,,360LOG: invalid server process ID > -1 See 8.1.4 fix: 2006-03-30 17:11 tgl * src/backend/storage/smgr/smgr.c (REL8_1_STABLE): Suppress attempts to report dropped tables to the stats collector

[ADMIN] log entries after pitr recovery

2006-07-21 Thread Chris Hoover
I have been testing pitr with my development system.  After the system rolled forward, I recieve a ton of errors right after it come on line.  I'm assuming these are fine and just the system cleaning up, but I wanted to make sure. Thanks,Chris,11962,,2006-07-13 16:11:16.281 EDT,,360LOG:  invali

Re: [ADMIN] biginteger to timestamp

2006-07-21 Thread Bruno Wolff III
On Thu, Jul 20, 2006 at 15:11:35 +0530, LiveShell <[EMAIL PROTECTED]> wrote: > hi hubert > actally i have UNIX time and that is in *1153222974* format. and i m using > C api to insert this time in a column whose type is timestamp. > so now can u tell me how can i convert it to timestamp and

Re: [ADMIN] UTF8 characters

2006-07-21 Thread Peter Eisentraut
PostgreSQL Admin wrote: > I had my database set to SQL_ASCII and switched to UTF8, but now I > notice that I must add a slash for periods/dots ( \. vs . ) to insert > into varchar. Is this normal? No. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end

[ADMIN] UTF8 characters

2006-07-21 Thread PostgreSQL Admin
I had my database set to SQL_ASCII and switched to UTF8, but now I notice that I must add a slash for periods/dots ( \. vs . ) to insert into varchar. Is this normal? Thanks, J ---(end of broadcast)--- TIP 5: don't forget to increase your free spa

Re: [ADMIN] Task/Jobs issue

2006-07-21 Thread Shoaib Mir
HI Michael,You can try using an addon like pgjobs (http://gborg.postgresql.org/project/pgjobs/projdisplay.php)Thanks,Shoaib Mir EnterpriseDBOn 7/21/06, Michael Grossman <[EMAIL PROTECTED]> wrote:   Hi!   I am using PostgreSQL 8.1.3 Windows version and pgAdmin 1.4.3   I cannot f

[ADMIN] Task/Jobs issue

2006-07-21 Thread Michael Grossman
  Hi!   I am using PostgreSQL 8.1.3 Windows version and pgAdmin 1.4.3   I cannot find Jobs section for schedule tasks?   Please assist   Best regards, Michael Grossman   New Concept Travel Technologies Ltd Mobile: (972) 54 555 7383 Mobile: (972) 50 4284 555 Tel  :  (972)  8