Re: [BUGS] [ADMIN] Date Return must be As per Natural Calander

2003-02-24 Thread Tom Lane
Robert Treat <[EMAIL PROTECTED]> writes: > I guess adding 1 day to 1752-09-02 should give us 1752-09-14, but your > right, it gives us 1752-09-03. As was pointed out at length just recently, the transition from Julian to Gregorian calendars happened at different times in different places. So the a

[BUGS] Bug #903: Performance Hangs during Lookups

2003-02-24 Thread pgsql-bugs
Michael Peddemors ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Performance Hangs during Lookups Long Description We have a postgres backend to our Mail Server product, and encountering performance issues. Simple selects are

Re: [BUGS] [ADMIN] Date Return must be As per Natural Calander

2003-02-24 Thread Robert Treat
[EMAIL PROTECTED] rms_db]$ cal 9 1752 September 1752 Su Mo Tu We Th Fr Sa 1 2 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 I guess adding 1 day to 1752-09-02 should give us 1752-09-14, but your right, it gives us 1752-09-03. Forwarding this to -bugs Robert Treat On Sun, 200

Re: [BUGS] Bugs with rules on views/tables: permission denied

2003-02-24 Thread Donald Fraser
  - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Donald Fraser" <[EMAIL PROTECTED]> Cc: "[BUGS]" <[EMAIL PROTECTED]> Sent: Monday, February 24, 2003 8:29 PM Subject: Re: [BUGS] Bugs with rules on views/tables: permission denied > "Donald Fraser" <[EMAIL PROTECTED]> w

Re: [BUGS] Bugs with rules on views/tables: permission denied

2003-02-24 Thread Tom Lane
"Donald Fraser" <[EMAIL PROTECTED]> writes: > As USER chkrule do: > Bugs=3D> INSERT INTO vu_tbl_test (id, s_text) VALUES('1','sometext'); > ERROR: vu_tbl_test: permission denied What I get is ERROR: test_func: permission denied and the needed fix is to grant execute privilege on the fun

Re: [BUGS] Bugs with rules on views/tables: permission denied

2003-02-24 Thread Donald Fraser
- Original Message - From: "Tom Lane" <[EMAIL PROTECTED]>To: "Donald Fraser" <[EMAIL PROTECTED]>Cc: "[ADMIN]" <[EMAIL PROTECTED]>Sent: Monday, February 24, 2003 2:42 PMSubject: Re: [ADMIN] Bugs with rules on views/tables: permission denied > "Donald Fraser" <[EMAIL PROTECTED]> write

Re: [BUGS] Multibyte char encoding atttypmod weirdness

2003-02-24 Thread Tom Lane
"Huaxin WANG" <[EMAIL PROTECTED]> writes: > When locale is set to multibyte char encoding languages, > such as ja_JP.eucjp, and char encoding set to EUC_JP, for the char(20) > columns (attributes), the libpq ((PGresult *)res)->attDescs[0].atttypmod > returned by PQfmod(res, 0) is not correct. It's

[BUGS] Bugs with rules on views/tables: permission denied

2003-02-24 Thread Donald Fraser
- Original Message - From: "Tim Burgess" <[EMAIL PROTECTED]>To: <[EMAIL PROTECTED]>Sent: Monday, February 10, 2003 6:51 PMSubject: [BUGS] 'update' as action of 'insert' rule: permission denied> Gday All,> > I'm surprised I can't find any descriptions of this in the archive > already,

Re: [BUGS] psql -F problems

2003-02-24 Thread Llew Sion Goodstadt
Most shells allow you to enter in a tab easily. In bash, you need to type control-V followed by a tab. I.e. type -F ", followed by the Control-V/tab key sequence and the closing double quote. Llew ---(end of broadcast)--- TIP 2: you can get off all

[BUGS] Multibyte char encoding atttypmod weirdness

2003-02-24 Thread Huaxin WANG
Version: PostgreSQL 7.2.1 (7.3 not tested) Summary: When locale is set to multibyte char encoding languages, such as ja_JP.eucjp, and char encoding set to EUC_JP, for the char(20) columns (attributes), the libpq ((PGresult *)res)->attDescs[0].atttypmod returned by PQfmod(res, 0) is not correct.

[BUGS] Hello pgsql-bugs !

2003-02-24 Thread pgsql-bugs
Dear pgsql-bugs , Hola! Hello! Como estas? How are you? I got your email address as someone involved with tourism, hotel and condo rentals. We are an award winning web design firm in the USA doing web applications for many companies, including hotels in 3 countries. We have references, and

[BUGS] Hello pgsql-bugs !

2003-02-24 Thread pgsql-bugs
Dear pgsql-bugs , Hola! Hello! Como estas? How are you? I got your email address as someone involved with tourism, hotel and condo rentals. We are an award winning web design firm in the USA doing web applications for many companies, including hotels in 3 countries. We have references, and