Re: [BUGS] BUG #4721: All sub-tables incorrectly included in search plan for partitioned table

2009-03-20 Thread Tom Lane
"Eric Thompson" writes: > test=# -- remove any irrelevant constraint from the master table, and now > the date partitioning works Hmm. Tracing through this, it seems your child tables have exactly 101 separate constraint clauses; removing one from the parent table gets it down to 100. Which is

[BUGS] BUG #4721: All sub-tables incorrectly included in search plan for partitioned table

2009-03-20 Thread Eric Thompson
The following bug has been logged online: Bug reference: 4721 Logged by: Eric Thompson Email address: eric.thomp...@salliemae.com PostgreSQL version: 8.3.7 Operating system: RedHat ES 5.2 Description:All sub-tables incorrectly included in search plan for partitioned t

Re: [BUGS] BUG #4718: "select +'8:00'::interval;" gives an error

2009-03-20 Thread Euler Taveira de Oliveira
Roman Kononov escreveu: This is not a bug, but a missing feature. > test=# select +'8:00'::interval; > ERROR: operator does not exist: + interval > LINE 1: select +'8:00'::interval; >^ > HINT: No operator matches the given name and argument type(s). You might > need to add expli

Re: [BUGS] BUG #4719: Convertion of Data from MSSQL to Postgres

2009-03-20 Thread Heikki Linnakangas
Nagendra.K wrote: PostgreSQL version: Pls Adv Srv 8.3 Is this the EnterpriseDB's commercial Advanced Server product? If so, please contact EnterpriseDB technical support. This mailing list / web form is for reporting bugs in the community PostgreSQL. I had created data in MSSQL server and

[BUGS] BUG #4718: "select +'8:00'::interval;" gives an error

2009-03-20 Thread Roman Kononov
The following bug has been logged online: Bug reference: 4718 Logged by: Roman Kononov Email address: kono...@ftml.net PostgreSQL version: 8.3.7 Operating system: GNU/Linux x86_64 Description:"select +'8:00'::interval;" gives an error Details: test=# select +'8:00':

[BUGS] BUG #4719: Convertion of Data from MSSQL to Postgres

2009-03-20 Thread Nagendra.K
The following bug has been logged online: Bug reference: 4719 Logged by: Nagendra.K Email address: nagendra.in...@gmail.com PostgreSQL version: Pls Adv Srv 8.3 Operating system: WinXP SP2 Description:Convertion of Data from MSSQL to Postgres Details: I had created d