Re: [GENERAL] Column does not exists?

2015-03-26 Thread Francisco Olarte
Hi Leonardo: On Thu, Mar 26, 2015 at 6:12 PM, Leonardo M. Ramé l.r...@griensu.com wrote: DELETE From sessions WHERE SESSIONTIMESTAMP '2010-01-01 10:02:02' ERROR: column sessiontimestamp does not exist LINE 1: DELETE From sessions WHERE SESSIONTIMESTAMP '2010-01-01 10... ... DELETE From

Re: [GENERAL] Column does not exists?

2015-03-26 Thread Leonardo M. Ramé
El 26/03/15 a las 14:17, Ashesh Vashi escibió: [Sent through mobile] On Mar 26, 2015 10:43 PM, Leonardo M. Ramé l.r...@griensu.com mailto:l.r...@griensu.com wrote: Ok, I have this table: CREATE TABLE sessions ( SESSIONID integer NOT NULL, SESSIONTIMESTAMP character

Re: [GENERAL] Column does not exists?

2015-03-26 Thread Adrian Klaver
On 03/26/2015 10:21 AM, Leonardo M. Ramé wrote: El 26/03/15 a las 14:18, Adrian Klaver escibió: On 03/26/2015 10:12 AM, Leonardo M. Ramé wrote: Ok, I have this table: CREATE TABLE sessions ( SESSIONID integer NOT NULL, SESSIONTIMESTAMP character varying(45) NOT NULL, SESSIONDATA

Re: [GENERAL] Column does not exists?

2015-03-26 Thread Bill Moran
On Thu, 26 Mar 2015 14:12:36 -0300 Leonardo M. Ramé l.r...@griensu.com wrote: Ok, I have this table: CREATE TABLE sessions ( SESSIONID integer NOT NULL, SESSIONTIMESTAMP character varying(45) NOT NULL, SESSIONDATA character varying(200) DEFAULT NULL::character varying,

Re: [GENERAL] Column does not exists?

2015-03-26 Thread Ashesh Vashi
[Sent through mobile] On Mar 26, 2015 10:43 PM, Leonardo M. Ramé l.r...@griensu.com wrote: Ok, I have this table: CREATE TABLE sessions ( SESSIONID integer NOT NULL, SESSIONTIMESTAMP character varying(45) NOT NULL, SESSIONDATA character varying(200) DEFAULT NULL::character varying,

Re: [GENERAL] Column does not exists?

2015-03-26 Thread Adrian Klaver
On 03/26/2015 10:12 AM, Leonardo M. Ramé wrote: Ok, I have this table: CREATE TABLE sessions ( SESSIONID integer NOT NULL, SESSIONTIMESTAMP character varying(45) NOT NULL, SESSIONDATA character varying(200) DEFAULT NULL::character varying, CONSTRAINT sessions_pkey PRIMARY KEY

Re: [GENERAL] Column does not exists?

2015-03-26 Thread Leonardo M. Ramé
El 26/03/15 a las 14:23, Francisco Olarte escibió: Hi Leonardo: On Thu, Mar 26, 2015 at 6:12 PM, Leonardo M. Ramé l.r...@griensu.com wrote: DELETE From sessions WHERE SESSIONTIMESTAMP '2010-01-01 10:02:02' ERROR: column sessiontimestamp does not exist LINE 1: DELETE From sessions WHERE

[GENERAL] Column does not exists?

2015-03-26 Thread Leonardo M. Ramé
Ok, I have this table: CREATE TABLE sessions ( SESSIONID integer NOT NULL, SESSIONTIMESTAMP character varying(45) NOT NULL, SESSIONDATA character varying(200) DEFAULT NULL::character varying, CONSTRAINT sessions_pkey PRIMARY KEY (SESSIONID) ) Now, when I do: DELETE From sessions WHERE

Re: [GENERAL] Column does not exists?

2015-03-26 Thread Leonardo M. Ramé
El 26/03/15 a las 14:18, Adrian Klaver escibió: On 03/26/2015 10:12 AM, Leonardo M. Ramé wrote: Ok, I have this table: CREATE TABLE sessions ( SESSIONID integer NOT NULL, SESSIONTIMESTAMP character varying(45) NOT NULL, SESSIONDATA character varying(200) DEFAULT NULL::character

Re: [GENERAL] Column does not exists?

2015-03-26 Thread Francisco Olarte
Hi Leonardo: Aha, the problem, then, was caused by the Create statement. This table was copied from a MySql dump where all columns were named column. In part. The problem was caused by non-uniform quote usaga, quotes in create, no quotes elsewhere. Had you used quotes in delete or not used