Hello the list
Before all : happy new year for all.
I Don't know how can I write a sql select.
I have 2 tables :
One with an array of codes
and another with a code
I try to retrieve the array of codes from the first table and return
only the codes existing on the second table
If possible I se
Hello,
I don't know how can I pass a md5 password to the password field ?
example :
connInfo = "host=localhost port=5432 dbname=db_stats user=postgres
password=secret";
pConn = PQconnectdb(connInfo);
I try to replace the string 'secret' by the content of /etc/shadow but
without succès.
Tha
hout asking for a PW.. check your
pg_hba.conf first though.
On May 6, 2008, at 5:07 AM, Guy Deleeuw wrote:
Hello,
I don't know how can I pass a md5 password to the password field ?
example :
connInfo = "host=localhost port=5432 dbname=db_stats user=postgres
password=secret"
tself ?
I found strange that you were trying out the password from /etc/shadow
file though.
> ALTER USER postgres WITH ENCRYPTED PASSWORD 'secret';
What error the postgres log gives you ?
On May 6, 2008, at 12:58 PM, Guy Deleeuw wrote:
--
Sent via pgsql-admin mailing
Hello Tom
No, you need to put the plain text of the password into the connInfo.
Knowing the md5 doesn't prove you know the password.
regards, tom lane
I just try to cancel the easy way to "string" the binary and extract the
password from my app.
A solution are to p
Hello
I have a small application with apache and fastcgi
I use valgrind to debug my app.
see the apache log below (the app run fine, but it's very strange)
This is the call of :
pConn = PQconnectdb(connInfo);
==20793== Thread 3:
==20793== Invalid read of size 8
==20793==at 0x4015B24: (with
Hello the list
I have a problem with an sql command and I not understand what is happens.
I execute this query and the result is ok :
db_stats=# SELECT code, label, typecumul FROM table_f801_cat_period
INNER JOIN table_cat_period USING (code) WHERE typecumul = 0 EXCEPT
SELECT code_base, label,
Hello,
I cannot convert properly a cstring to a Datum :
Here my code :
int attColNumber;
Datum new_barcode;
bool isnull= 0;
char barcode[14];
elog(INFO, "gd_trigfunc_before_article_insert() : bar_code = %s",
Hi Tom
Many thanks for your answer, all work fine now :-)
Regards
Guy
Le 20/02/10 16:45, Tom Lane a écrit :
Guy Deleeuw writes:
I cannot convert properly a cstring to a Datum :
Well, CStringGetDatum would be the proper thing to use if you meant to
produce a Datum of type "cs
Hello
I have :
SELECT
t_orders_articles.k_idAS k_id
,t_orders_articles.quantityAS order_qty
,(SELECT sum(quantity) FROM t_deliveries_articles WHERE
article_id = t_orders_articles.k_id) AS delivery_qty
, (t_orders_articles.quantity - delive
Hello Dimitri,
Many thanks for your answers
Regards
Guy
Le 24/03/10 20:09, Dimitri Fontaine a écrit :
Hi,
Guy Deleeuw writes:
SELECT
t_orders_articles.k_idAS k_id
,t_orders_articles.quantityAS order_qty
,(SELECT sum(quantity) FROM
Hello
When using valgrind with one of my program a have these error from
PQconnectdb.
Debian lenny last update.
postgresql 8.3
Regards
Guy
g...@vsstats:src# valgrind /usr/local/lassie/bin/gdExecJob -i
/var/www/users/guy/gdQuery2/testTextEdit -o /tmp/textedit.rpg
==20166== Memcheck, a memory
Hello
I have a strange behaviour :
time psql -d db_cathline -c "SELECT * FROM v_stock_status;"
real0m5.780s
user0m0.090s
sys 0m0.020s
time psql -d db_cathline -c "SELECT * FROM v_stock_status WHERE
remain_qty != 0;"
real0m56.075s
user0m0.070s
sys 0m0.030s
Why with the
Hello Kevin,
>
> You should probably look at reqorking the v_stock view to use joins
> instead of subqueries -- they often optimize much better.
This is the problem effectively.
For creating this view I use a query tools that generate the code, not a
good idea.
I update and work now :-)
Best rega
14 matches
Mail list logo
