Re: [SQL] undefined relations in pg_locks

Oops! You are right. It was not a dead-lock. I let the process to continue and after about one hour I got in the log the following message 'cannot have more than 2^32-1 commands in a transaction'. After some investigations in the code I found an infinite loop. Thanks and sorry for wasting time, S

[SQL] (no subject)

-- Colin Martin -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql

[SQL] dateformat issue

Hi Everyone, I have a question about dates, please. I am using Coldfusion and Postgres I have a function that takes the ate entered in a form and converts it into an odbc date format. So the string ends up being; {d '2008-04-10'} Strangely, the function is used throughout the application an

Re: [SQL] dateformat issue

On Thursday 10 April 2008 03:14, Gavin 'Beau' Baumanis wrote: > Hi Everyone, > > I have a question about dates, please. > > I am using Coldfusion and Postgres > I have a function that takes the ate entered in a form and converts it > into an odbc date format. > > So the string ends up being; > {d '

Re: [SQL] dateformat issue

Hi Aarni, just so you know I am using the CF built-in function, createodbcdate here is the info from livedocs. CreateODBCDate Description Returns a date in ODBC date format. Category Date and time functions Syntax CreateODBCDate(date) so I pass in 2008-01-23 and I get back {d '2008-01-23'}