pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Guillaume Lelarge <guillaume@lelarge.info>
To: Nadine Mauch <nadine.mauch@laposte.net>
Cc: pgsql-php@postgresql.org
Subject: Re: Capitalized Databases and columns names
Date: Tue, 12 Jan 2010 20:39:21 +0100
Message-ID: <4B4CCFE9.2010704@lelarge.info> (raw)
In-Reply-To: <201001121956.01058.nadine.mauch@laposte.net>
References: <201001121956.01058.nadine.mauch@laposte.net>

Hi,

Le 12/01/2010 19:56, Nadine Mauch a écrit :
> [...]
> For reasons of lisibility I've created DataBases and
> Table Columns with capitalized names.
> 
> To access databases in php code I just use double
> cotes as delimiters for names in sql requests.
> 
> I compose on-demand requests with concatened
> php strings. The result is for example :
> select "TCRtimestp" from "TrcDFCR" where "TCRtimestp"=20060228113419 ;
> 
> Such requests are manageable thru concatenation
> but I get problems with functions like
> select nextval ('TCRnrordre') ;
> where the request becomes select nextval ('trcnrordre') ;
> where everything is in lowercase and the result is :
> relation tcrnrordre does not exist.
> select nextval ('"TCRnrordre"') ; is not possible due
> to syntax error.
> 

It works for me.

b1=# create sequence "Titi";
CREATE SEQUENCE
b1=# select nextval('"Titi"');
 nextval
---------
       1
(1 ligne)

b1=# select nextval('"Titi"');
 nextval
---------
       2
(1 ligne)

Are you sure you gave us the right error message? can you copy and paste
it here?

> I just don't achieve nor in php nor in psql to get the
> next value because of this capitalize problem.
> Does someone know if there is a solution or if
> I have to use only lowercase caracters ?
> 

You should better use lowercase for PostgreSQL objects, but your issue
is not related to this.

Regards.


-- 
Guillaume.
 http://www.postgresql.fr
 http://dalibo.com



view thread (2+ messages)

Message-ID: <4B4CCFE9.2010704@lelarge.info>
Permalink:  ../4B4CCFE9.2010704@lelarge.info/
Also on:    postgresql.org/message-id/4B4CCFE9.2010704@lelarge.info

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: guillaume@lelarge.info, nadine.mauch@laposte.net
  Subject: Re: Capitalized Databases and columns names
  In-Reply-To: <4B4CCFE9.2010704@lelarge.info>
  References: <201001121956.01058.nadine.mauch@laposte.net> <4B4CCFE9.2010704@lelarge.info>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox