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, Sabin -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
[SQL] (no subject)
-- Colin Martin -- Sent via pgsql-sql mailing list ([email protected]) 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 and causes
no issues but on one particular template.
And this same templates is replicated for other clients - that
seemingly have no issue .
The SQL is simply
Insert into table (datefield) values ({d '2008-04-10'})
Now, I have read the docs and do not see the {d '2008-04-10'} format
as being a valid date data type...
But it works elsewhere in the application / on other sites - thus my
current state of confusion.
Thanks in advance for any ideas you might have.
Please contact me if you should have any questions.
Gavin 'Beau' Baumanis
Senior Application Developer
PalCare Pty. Ltd.
E: [EMAIL PROTECTED]
T: +61 -3 9318 4567
M: +61 -4 38 545 586
W: http://www.palcare.com.au
--
Sent via pgsql-sql mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
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 '2008-04-10'}
>
> Strangely, the function is used throughout the application and causes
> no issues but on one particular template.
> And this same templates is replicated for other clients - that
> seemingly have no issue .
>
>
> The SQL is simply
>
> Insert into table (datefield) values ({d '2008-04-10'})
>
Hi,
The above is not a valid value for a date field. What function do you use for
the conversion ?
#DateFormat(form.date, "-MM-DD")# ? Or perhaps a custom function /
conversion script ?
Which client (browser?) / platform produces the error ?
And just out of general interest, which cf-version and platform are you
using ? Pg version ?
I use pg 8.x's on CentOS and Fedora with CF 5 Pro Linux and CFMX7 Standard. I
also heard that CFMX7+ would install and run ok on Ubuntu.
Best regards,
--
Aarni Ruuhimäki
---
Burglars usually come in through your windows.
---
--
Sent via pgsql-sql mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
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'}
The weirdness for me is that it works elsewhere in the application, I
am really stumped.
-Gavin.
On 10/04/2008, at 4:17 PM, Aarni Ruuhimäki wrote:
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 '2008-04-10'}
Strangely, the function is used throughout the application and causes
no issues but on one particular template.
And this same templates is replicated for other clients - that
seemingly have no issue .
The SQL is simply
Insert into table (datefield) values ({d '2008-04-10'})
Hi,
The above is not a valid value for a date field. What function do
you use for
the conversion ?
#DateFormat(form.date, "-MM-DD")# ? Or perhaps a custom function /
conversion script ?
Which client (browser?) / platform produces the error ?
And just out of general interest, which cf-version and platform are
you
using ? Pg version ?
I use pg 8.x's on CentOS and Fedora with CF 5 Pro Linux and CFMX7
Standard. I
also heard that CFMX7+ would install and run ok on Ubuntu.
Best regards,
--
Aarni Ruuhimäki
---
Burglars usually come in through your windows.
---
--
Sent via pgsql-sql mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
Please contact me if you should have any questions.
Gavin 'Beau' Baumanis
Senior Application Developer
PalCare Pty. Ltd.
E: [EMAIL PROTECTED]
T: +61 -3 9318 4567
M: +61 -4 38 545 586
W: http://www.palcare.com.au
--
Sent via pgsql-sql mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
