From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Nadine Mauch <nadine(dot)mauch(at)laposte(dot)net> |
Cc: | pgsql-php(at)postgresql(dot)org |
Subject: | Re: Capitalized Databases and columns names |
Date: | 2010-01-12 19:39:21 |
Message-ID: | 4B4CCFE9.2010704@lelarge.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Gustavo Amarilla Santacruz | 2010-01-28 00:25:44 | Undefined function pg_connect() |
Previous Message | Nadine Mauch | 2010-01-12 18:56:01 | Capitalized Databases and columns names |