[BUGS] problem with pl/python in 7.2.2

2002-09-06 Thread junk
Hello! I am having a problem with PostgreSQL 7.2.2 which does not happen with 7.2. Basically, I have Python 2.2.1 and PG 7.2.2installed on a RedHat 7.3 box where importing the re module into a python procedure doesn't work. When I try the same thing on a RedHat 7.1 with PG 7.2 iwht Python 2.2.1

[BUGS] Bug #760: to_date

2002-09-06 Thread pgsql-bugs
Swaminathan.K ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description to_date Long Description I have created a table with a datetime datatype. Using to_date function I am unable to format the date and I am unable to get the time sepe

Re: [BUGS] Bug #759: 7.3beta1 DROP COLUMN DEPENDENCY PROBLEM

2002-09-06 Thread Tom Lane
Rod Taylor <[EMAIL PROTECTED]> writes: > The big difference is that the INNER JOIN code needs to drop one of the > colb's coming up with a virtual relation cola, colb, colc; where the > other doesn't have such a renaming scheme. On reflection I think it might be possible to make this work the way

Re: [BUGS] Unable to compile 7.3beta1 on cygwin

2002-09-06 Thread Peter Eisentraut
Ronald Kuczek writes: > I don't know the solution. It seems to be something wrong - 7.2.2 without > problems, > 7.3 - even from CVS - doesn't work. This was fixed about 24 hours ago, so either updating your CVS or using a later snapshot should work. -- Peter Eisentraut [EMAIL PROTECTED]

Re: [BUGS] Bug #759: 7.3beta1 DROP COLUMN DEPENDENCY PROBLEM

2002-09-06 Thread Rod Taylor
On Fri, 2002-09-06 at 10:07, Tim Knowles wrote: > Hi Guys, > > I haven't got access to my test machine which is at home so I can't try it > but will the previous practice of creating a temp table (minus the column > you want to delete), dropping the orignal and renaming the temp table work > in 7

[BUGS] Unable to compile 7.3beta1 on cygwin

2002-09-06 Thread Ronald Kuczek
Your name : Ronald Kuczek Your email address : [EMAIL PROTECTED] System Configuration - Architecture (example: Intel Pentium) : i386 Operating System (example: Linux 2.0.26 ELF) : Windows NT 4.0 (cygwin) PostgreSQL version (example: PostgreSQL-7.3): Postg

Re: [BUGS] Bug #759: 7.3beta1 DROP COLUMN DEPENDENCY PROBLEM

2002-09-06 Thread Rod Taylor
On Fri, 2002-09-06 at 09:17, Tom Lane wrote: > Rod Taylor <[EMAIL PROTECTED]> writes: > > Indeed. At the INNER JOIN it would appear that an alias is applied to > > the columns of a given table. > > ... > > The real trick is to make INNER JOINS less greedy in their requirements > > based on the co

Re: [BUGS] Bug #759: 7.3beta1 DROP COLUMN DEPENDENCY PROBLEM

2002-09-06 Thread Tom Lane
Rod Taylor <[EMAIL PROTECTED]> writes: > Indeed. At the INNER JOIN it would appear that an alias is applied to > the columns of a given table. > ... > The real trick is to make INNER JOINS less greedy in their requirements > based on the columns that are actually used. What surprised me about th

Re: [BUGS] Bug #759: 7.3beta1 DROP COLUMN DEPENDENCY PROBLEM

2002-09-06 Thread Rod Taylor
Indeed. At the INNER JOIN it would appear that an alias is applied to the columns of a given table. { RTE :alias { ALIAS :aliasname b :colnames <>} :eref { ALIAS :aliasname b :colnames ( "col_b" "col_c" )} :rtekind 0 :relid 17194 :inh true :inFromCl true :checkForRead true :checkForWrite fals

[BUGS] Bug #759: 7.3beta1 DROP COLUMN DEPENDENCY PROBLEM

2002-09-06 Thread pgsql-bugs
Tim Knowles ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description 7.3beta1 DROP COLUMN DEPENDENCY PROBLEM Long Description Hi, Been playing with the 7.3beta1 version and I've noticed a small problem with dependency checking when dr