[BUGS] BUG #4402: Column expansion: date comes wthout a cast

2008-09-05 Thread Joachim Unger
The following bug has been logged online: Bug reference: 4402 Logged by: Joachim Unger Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3 Operating system: Windwos XP Professional 32 Bit Description:Column expansion: date comes wthout a cast Details: The colum

Re: [BUGS] BUG #4398: Backslashes get escaped despite of backslash_quote=off

2008-09-05 Thread Rainer Glueck
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello Tom, On 4 Sep 2008 at 12:53, Tom Lane wrote: > > "Rainer Glueck" <[EMAIL PROTECTED]> writes: > > How can backslashes be stopped from escaping themselves in like-statements > > Use ESCAPE ''. There isn't any other way provided. > ... > if you h

Re: [BUGS] BUG #4374: pg_restore does not restore public schema comment

2008-09-05 Thread Bruce Momjian
Tom Lane wrote: > Craig Ringer <[EMAIL PROTECTED]> writes: > > The issue actually appears to be that the comment on default schema like > > `public' isn't dumped in the first place. > > Hmm ... there is a specific exclusion in _printTocEntry to suppress > dumping of either the CREATE SCHEMA comman

Re: [BUGS] BUG #4377: casting result of timeofday() to timestamp fails in some timezones

2008-09-05 Thread Bruce Momjian
Todd A. Cook wrote: > Tom Lane wrote: > > > > In the meantime, why aren't you just using clock_timestamp()? > > timeofday() is deprecated. > > I am using clock_timestamp() now. The use of timeofday() was from the era > when 8.0 was hot stuff. > > BTW, the word "deprecated" does not appear on th

Re: [BUGS] BUG #4402: Column expansion: date comes wthout a cast

2008-09-05 Thread Euler Taveira de Oliveira
Joachim Unger escreveu: > The column expansion lists date types without a date cast. > And all of the text types too. > Here is an example where I'm using NEW inside a trigger: > [...] > ins_sql := 'INSERT INTO ' || quote_ident(new_child_table) || '(' > ||col_names(new_child_table) || ') VALUES