Sorry for the late reply - but I still haven't found a solution,
for example I have a PHP script with 5 consecutive SELECT
statements (source code + problem described again under:
http://stackoverflow.com/questions/6458246/php-and-pgbouncer-in-transaction-mode-current-transaction-is-aborted
)
I've added
$db-beginTransaction();
$db-commit();
around _all_ statements, but now get:
SQLSTATE[25P02]: In failed sql transaction:
7 ERROR: current transaction is aborted,
commands ignored until end of transaction block
quite often. I don't understand why
would transaction
Hell Marko and others,
On Mon, Jun 20, 2011 at 4:08 PM, Marko Kreen mark...@gmail.com wrote:
Maybe I should try session mode of pgbouncer
again, now that I've got rid of the persistent
PHP connections?
You could, but try to turn off prepared
statements in PDO first.
isn't having prepared
Nope, pool_mode = session kills my site...
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
PDO::ATTR_EMULATE_PREPARES = true
kills my server too...
On Mon, Jun 20, 2011 at 7:34 PM, Alexander Farber
alexander.far...@gmail.com wrote:
Nope, pool_mode = session kills my site...
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
Hello everyone,
after the suggestion from this mailing list,
I have installed pgbouncer at my
CentOS 5.6 / 64 bit server and
activated its transaction mode:
[databases]
pref = host=/tmp user=pref password=XXX dbname=pref
[pgbouncer]
logfile = /var/log/pgbouncer.log
pidfile =
Hello Cedric and others,
On Sun, Jun 19, 2011 at 9:56 PM, Cédric Villemain
cedric.villemain.deb...@gmail.com wrote:
2011/6/19 Alexander Farber alexander.far...@gmail.com:
[pgbouncer]
logfile = /var/log/pgbouncer.log
pidfile = /var/run/pgbouncer/pgbouncer.pid
listen_port = 6432
Hello,
I'm still suffering with my Drupal 7.2 site and
PostgreSQL 8.4.8 every evening, for example
right now. I have tried different combinations
for /etc/pgbouncer.ini - for example now I have:
[databases]
pref = host=/tmp user=pref password=XXX dbname=pref
[pgbouncer]
logfile =
On 6/16/11, Cédric Villemain cedric.villemain.deb...@gmail.com wrote:
2011/6/16 Alexander Farber alexander.far...@gmail.com:
I'm still suffering with my Drupal 7.2 site and
PostgreSQL 8.4.8 every evening, for example
right now. I have tried different combinations
for /etc/pgbouncer.ini
On 6/16/11, Scott Marlowe scott.marl...@gmail.com wrote:
What do vmstat 1 and iostat -xd 1 (or equivalent for your OS) say? So
here's a healthy not working too hard machine:
procs ---memory-- ---swap-- -io -system--
cpu
r b swpd free buff cache si
Hello,
does anybody know of a good source for a apr-util-pgsql
rpm package for CentOS 5.6 / 64 bit and even more I'm curious,
why isn't it included but the apr-util-mysql is included...
Is apr-util-pgsql maybe part of some bigger package already?
I'm using:
# rpm -qa|grep post
Hello,
does anybody know of a good source for a apr-util-pgsql rpm package
for CentOS 5.6 / 64 bit and even more I'm curious why isn't it included
but the apr-util-mysql is included...
Thank you
Alex
___
CentOS mailing list
CentOS@centos.org
Hello fellow CentOS sysadmins,
I run a small multiplayer card game
with around 500 users at peak times.
The client is in Flash and the server is in Perl.
The Perl server binds to port 8080, i.e. only
1 instance of it can be started (important detail).
The Perl server poll()s TCP-sockets and
On Thu, Jun 2, 2011 at 10:10 PM, Les Mikesell lesmikes...@gmail.com wrote:
On 6/2/2011 2:46 PM, Alexander Farber wrote:
The Perl server poll()s TCP-sockets and forks
only once - at the startup by calling this method:
sub daemonize {
die Can not fork: $!\n unless defined (my
I'll omit fork() and run my script from /etc/inittab as
pref:3:respawn:/bin/su -c '/usr/local/pref/pref.pl' nobody 21 /tmp/pref.txt
Do you think I still need setsid(); chdir(/); and umask(0); ?
Regards
Alex
___
CentOS mailing list
CentOS@centos.org
Thank you, now my perl daemon works with /etc/inittab
I've removed fork() and used this line:
pref:3:respawn:/bin/su -c '/usr/local/pref/pref.pl /tmp/pref.txt 21' nobody
Regards
Alex
___
CentOS mailing list
CentOS@centos.org
, Alexander Farber alexander.far...@gmail.com
wrote:
Nevermind, found 1 issue in my server...
_
___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
Thank you, I'll try your suggestions.
I'm just slow in doing so, because it's just a
(sometimes pretty time consuming) hobby-project.
I'm missing knowledge on how to monitor my DB status,
i.e. how to check some of the things you've asked.
Also I wonder, how's shared memory used by PostgreSQL.
I've switched duration and SQL 'all' logging on,
but I have hard time to identify which SQL statement
has had which duration.
For example which SQL statement please has
the duration of 13 seconds (13025.016 ms) below?
LOG: statement: SELECT 1 AS expression
FROM
drupal_sessions
But when I try to look at that wrong index it seems to be ok?
# psql
psql (8.4.8)
Type help for help.
pref= \d pref_match
Table public.pref_match
Column | Type |Modifiers
Actually I have 1 db user accessing 1 db name
(through PHP scripts and 1 game daemon in Perl)
On Thu, May 26, 2011 at 6:23 PM, Scott Marlowe scott.marl...@gmail.com wrote:
You need to log more stuff. Look at the log_line_prefix setting, and
add things like pid, username, database name,
Hello fellow PostgreSQL-users,
I run a Drupal 7 (+Facebook app) website
with a multiplayer flash game and use
postgresql-server-8.4.8-1PGDG.rhel5 +
CentOS 5.6 64 bit on a Quad-Core/4GB machine.
I generally like using PostgreSQL eventhough
I'm not an experienced DB-user, but in the recent
weeks
Thank you for your replies,
I've reverted httpd.conf to
StartServers 8
MinSpareServers5
MaxSpareServers 20
ServerLimit 256
MaxClients 256
and have changed postgresql.conf to:
shared_buffers = 512MB
# for Apache + my game daemon + cron jobs
max_connections
# sysctl kernel.shmmax
kernel.shmmax = 68719476736
# sysctl kernel.shmall
kernel.shmall = 4294967296
On Wed, May 25, 2011 at 9:54 PM, Alexander Farber
alexander.far...@gmail.com wrote:
shared_buffers = 512MB
Do you think I need to reconfigure CentOS 5.6
for the bigger shared memory too
Hello,
I have a small Facebook game sending urlencoded strings over Socket connection:
_socket.writeUTF(_dataVars.toString());
_socket.flush();
It works mostly well since several years. I.e. I don't have the usual
newbie problems
with missing socket policy or sending data before
Nevermind, found 1 issue in my server...
___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
Hello Dave, this really works -
I run Drupal 7 at my CentOS 5.6 machine with
the native php53 and postgresql84 packages.
Just remove the older php packages first.
Regards
Alex
___
CentOS mailing list
CentOS@centos.org
Hello Mark and others,
On Thu, Apr 28, 2011 at 10:21 PM, m.r...@5-cent.us wrote:
At this point, I'd run the long test on each drive, and (after coming back
an hour or two later, see the results.
I have that dreadly warning again -
/etc/cron.weekly/99-raid-check:
WARNING:
Hello,
since weeks I was ignoring this warning at my CentOS 5.6/64 bit machine -
/etc/cron.weekly/99-raid-check:
WARNING: mismatch_cnt is not 0 on /dev/md0
in the hope that the software RAID will slowly repair itself.
I also had executed echo 10 /proc/sys/dev/raid/speed_limit_max
Additional info (how many RAID arrays do I have??):
# mdadm -D /dev/md3
/dev/md3:
Version : 00.90
Creation Time : Sat Mar 19 22:53:25 2011
Raid Level : raid1
Array Size : 185151360 (176.57 GiB 189.59 GB)
Used Dev Size : 185151360 (176.57 GiB 189.59 GB)
Raid Devices : 2
Hello, I didn't touch anything, just booted the hoster's rescue image.
# cat /etc/mdadm.conf
cat: /etc/mdadm.conf: No such file or directory
# cat /proc/mdstat
Personalities : [linear] [raid0] [raid1]
md0 : active raid1 sda1[0] sdb1[1]
1023936 blocks [2/2] [UU]
md1 : active raid1 sda3[0]
Thank you all, it seems to have finished - I'm rebooting.
Just curious why is the State of md3 active, while the others are clean?
# cat /proc/mdstat
Personalities : [linear] [raid0] [raid1]
md0 : active raid1 sda1[0] sdb1[1]
1023936 blocks [2/2] [UU]
md1 : active raid1 sda3[0] sdb3[1]
On the 2nd try it has booted and seems to work.
The /var/log/mcelog is (and was) empty.
# sudo cat /proc/mdstat
Personalities : [raid1]
md0 : active raid1 sdb1[1] sda1[0]
1023936 blocks [2/2] [UU]
md2 : active raid1 sdb5[1] sda5[0]
277728192 blocks [2/2] [UU]
md3 : active raid1
Turned out, smartd kept saying, that it had no entries in smartd.conf.
I've copied smartd.rpmnew over smartd.conf, restarted it,
now I have (in /var/log/messages, date+hostname removed):
smartd version 5.38 [x86_64-redhat-linux-gnu] Copyright (C) 2002-8 Bruce Allen
Home page is
Hello,
I was using CentOS 5.5 as a playground VM at my WinXP notebook
and now I'm migrating to a new CentOS 5.6 install
and everything has worked well - except samba.
I have this very permissive config to export my ~/src dir:
# cat /etc/samba/smb.conf
[global]
guest ok= yes
guest
# chcon -R -t samba_share_t src
hasn't helped either
___
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos
Thank you!
___
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos
Hello,
how do you block incoming AND outgoing traffic to a site?
I have 2 drop lines for a site in my /etc/sysconfig/iptables:
*filter
:INPUT DROP [0:0]
:FORWARD DROP [0:0]
:OUTPUT ACCEPT [294:35064]
-A INPUT -m state --state RELATED,ESTABLISHED -j ACCEPT
-A INPUT -i lo -j ACCEPT
-A INPUT -s
Thank you, it seems to work now
___
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos
Hello,
I'm a user (and big fan) of CentOS 5.6 and in my /etc/sysconfig/iptables
there are few blocking rules for some annoying visitors of my website
(I run a card game there since many years and some people are special):
*filter
:INPUT DROP [0:0]
:FORWARD DROP [0:0]
:OUTPUT ACCEPT [294:35064]
Ouch you're correct. I only tried end-of-line comments, sorry
On Sun, Apr 24, 2011 at 9:30 AM, Nicolas Thierry-Mieg
nicolas.thierry-m...@imag.fr wrote:
Alexander Farber wrote:
Is there a way to add comments to the iptables file?
A hash mark # does not seem to work.
assuming you are talking
Thank you Tom, yum install postgresql84 has worked for CentOS 5.6/64 bit
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hello,
I have installed CentOS from a CentOS-5.6-x86_64-bin-DVD-1of2.iso
and then installed PGDG because I want to have PostgreSQL 8.4.7:
# rpm -Uvh
http://www.pgrpms.org/8.4/redhat/rhel-5-x86_64/pgdg-centos-8.4-2.noarch.rpm
# cat /etc/yum.repos.d/pgdg-84-centos.repo
[pgdg84]
name=PostgreSQL
Hello fellow CentOS users,
until now I was using CentOS 5.5 with php 5.3 through this file:
# grep -v ^# /etc/yum.repos.d/CentOS-Testing.repo
[c5-testing]
name=CentOS-5 Testing
baseurl=http://dev.centos.org/centos/$releasever/testing/$basearch/
enabled=1
gpgcheck=1
Thank you for the replies and the new release
___
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos
Hello flashcoders,
does anybody please know, why is URLStream.connected
is always true in my simple test program at
http://stackoverflow.com/questions/5571175/why-is-urlstream-connected-always-true
?
Thank you
Alex
___
Flashcoders mailing list
Thanks for your replies. I've also seen the following in my log now:
Mar 20 05:08:55 mysite kernel: md: md1: sync done.
Mar 20 05:08:55 mysite kernel: RAID1 conf printout:
Mar 20 05:08:55 mysite kernel: --- wd:2 rd:2
Mar 20 05:08:55 mysite kernel: disk 0, wo:0, o:1, dev:sda3
Mar 20 05:08:55
Thank you for your replies.
I've ended up doing the following for my PHP and Drupal logs:
Uncommented error_log = /var/log/php/php_errors.log in /etc/php.ini
# mkdir /var/log/php
# chown -R apache.apache /var/log/php
Appended following line to /etc/syslog.conf
local6.* /var/log/php/drupal.log
Hello,
yesterday night I had a problem with
my server located at a hoster (strato.de).
I couldn't ssh to it and over the remote serial console
I saw out of memory errors (sorry, don't have the text).
Then I had reinstall CentOS 5.5/64 bit + all my setup (2h work),
because I have a contract with
Thanks Kenni, could you advise any commands
for checking RAID status or health
___
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos
Thank you, I've decreased
/proc/sys/dev/raid/speed_limit_max
from 20 to 10.
I think I don't care about the sync speed,
but I'd like to avoid the OOM errors and
server lockup like I had yesterday
(still not sure if this will help here
or if it is just to get rid of the warning)
Regards
Hello,
the man syslog.conf explains how to filter syslog messages
by facility (auth, authpriv, cron, daemon, kern, ... ) or
by priority (debug, info, notice, warning, ...).
But how could I redirect messages by a program name, like
drupal or php? For example I have in /var/log/messages:
Mar 20
Thank you all for the replies -
On Wed, Mar 16, 2011 at 3:05 PM, Igor Neyman iney...@perceptron.com wrote:
Select id, sum(col1) from tab
Where id 10
Group by id
Having sum)col1) 30;
Spend some time reading basic SQL docs/books - it'll help you
tremendously.
I have already read many
Hello,
I have a table holding number of games per week for each user:
# select id,completed,yw from pref_match limit 3;
id | completed | yw
+---+-
OK2650139676 | 10 | 2011-03
OK513367704098 | 20 | 2011-03
OK513367704098 |
Thank you all for the replies!
On Wed, Mar 9, 2011 at 7:01 PM, David Johnston pol...@yahoo.com wrote:
SELECT username, count(username) FROM phpbb_users
GROUP BY username
HAVING count(username) 1;
If anything shows up then (phpbb_users .username) is not a unique field but
you are trying to
=m.id and u.id like 'DE%' and sum(m.comp...
On Tue, Mar 15, 2011 at 10:43 PM, Vibhor Kumar
vibhor.ku...@enterprisedb.com wrote:
On Mar 16, 2011, at 3:03 AM, Alexander Farber wrote:
# select u.id, u.first_name, sum(m.completed)
from pref_users u, pref_match m
where u.id=m.id and u.id like 'DE
And same for a simple select-query from1 table (w/o join):
# select id from pref_match where sum(completed) 30 group by id;
ERROR: aggregates not allowed in WHERE clause
LINE 1: select id from pref_match where sum(completed) 30 group by...
^
--
Sent
Hello,
I've installed Drupal 7.0 on CentOS 5.5 + PostgreSQL 8.4.7
and have added a SPAM-trap - a field Gender which
can be Robot/Male/Female: http://preferans.de/user/register
Now I'm trying to delete all spammers, who haven't changed
the default value of Gender = Robot since at least 3 days:
#
Hello,
I'm using CentOS 5.5 with PostgreSQL 8.4.7 and
am migrating my site from phpBB 3 to Drupal 7.
I would like to copy these fields from one table:
select user_id, username, user_email, user_regdate, user_lastvisit
from phpbb_users where user_id 50;
into the other (already existing)
Oh it is called INSERT INTO, thank you!
I still have a problem though:
# select uid, name, mail, created, access from drupal_users;
uid | name |mail| created | access
-+--+++
0 | |
Hello Raymond and others,
thank you for looking at my problem!
It is a core Drupal 7 table, with a prefix drupal_
(you can set it while installing Drupal 7 in adv. options).
I have only 2 records in that target table:
# select uid, name, mail, created, access from drupal_users;
uid | name |
I've also tried renaming 'Alex' to a temp. value:
# update drupal_users set name='Alex_1972' where name='Alex';
UPDATE 1
# INSERT INTO drupal_users (uid, name, mail, created, access)
SELECT user_id, username, user_email, user_regdate, user_lastvisit
FROM phpbb_users
WHERE user_id 50 and
Oh ok, found it:
# select one.username, one.user_id, two.user_id from phpbb_users one,
phpbb_users two where two.username=one.username and two.user_id
one.user_id;
username | user_id | user_id
--+-+-
Вячеслав |7564 | 421
Вячеслав | 421 |7564
(2 rows)
Hello,
what is please the command to copy tables from 1 database
from another and is it possible at all without using pg_dump?
I'm trying to migrate 4700 users from phpBB 3 to Drupal 7
and have few custom tables in the phpbb database
which need to be copied over.
Using CentOS 5.5/64 bit +
Maybe install autotools package?
On Fri, Mar 4, 2011 at 9:33 AM, Ken Patching k...@ksptrading.co.uk wrote:
Ken@dozzy ~/WebKit
$ Tools/Scripts/build-webkit --GTK
Calling configure in /tmp/WebKit/WebKitBuild
which: no autoreconf in (/usr/local/bin:/usr/bin:/bin:/cygdrive/d/Program
Files/
Hello,
for drupal 7 installation at CentOS 5.5
(I have 32 bit and 64 bit machines)
I have to upgrade PHP to 5.3.
I've followed the CentOS wiki:
1) Created this file -
grep -v ^# /etc/yum.repos.d/CentOS-Testing.repo
[c5-testing]
name=CentOS-5 Testing
I see though:
# rpm -ql php53-common-5.3.3-1.el5 | grep modules
/usr/lib/php/modules
/usr/lib/php/modules/curl.so
/usr/lib/php/modules/fileinfo.so
/usr/lib/php/modules/json.so
/usr/lib/php/modules/phar.so
/usr/lib/php/modules/zip.so
So json and fileinfo are probably built-in now?
Sorry, I'm not
Hello,
I have a paranoic question.
In PostgreSQL 8.4.7 I had a table to store started, completed and
interrupted games :
# \d pref_match
Table public.pref_match
Column | Type |Modifiers
On Thu, Feb 24, 2011 at 8:02 PM, David Johnston pol...@yahoo.com wrote:
A column constraint can only reference its own column. Since you are
referencing completed in the CHECK it implicitly converts the Column
constraint into a Table constraint - and table constraints do not reference
the
On Thu, Feb 17, 2011 at 1:21 PM, Shruti shrutipati...@gmail.com wrote:
I am trying to run /Tools/Scripts/build-webkit --gtk in ubuntu
checking for GLIB - version = 2.27.90... no
*** Could not run GLIB test program, checking why...
I have done:
sudo apt-get install libglib2.0-dev
Isn't
Hello,
On Thu, Feb 3, 2011 at 12:31 AM, n179911 n179...@gmail.com wrote:
I am trying to run 'configure' for Webkit in ubuntu 10.10.
checking for GLIB - version = 2.27.90... no
*** Could not run GLIB test program, checking why...
*** The test program failed to compile or link. See the file
Hello,
I've followed and re-checked the steps for building with
VC++ 2005 Express at http://webkit.org/building/tools.html
and have run ~/WebKit/Tools/Scripts/update-webkit
numerous times at my both WinXP SP3 PCs,
but the builds always fail with:
afarber@AFARBER-DT:~
Hello Adam and others,
thank you, I've submitted 2 bug reports:
https://bugs.webkit.org/show_bug.cgi?id=53590
https://bugs.webkit.org/show_bug.cgi?id=53591
Then I've looked into
C:\cygwin\home\afarber\WebKit\WebKitBuild\Release\obj\*\BuildLog.htm
and have seen the following errors -
---
Hello,
through some obscure error (probably on my side)
I have several thousand entries for Jan 1 and Jan 2
ending up in the ISO week 2011-52 instead of 2010-52
which breaks the bar chart at the top of my script
http://preferans.de/user.php?id=OK504891003571
# select * from pref_money where
Thank you Pavel, has worked:
# update pref_money as m1 set money=money+coalesce((select money from
pref_money as m2 where m1.id=m2.id and m2.yw='2011-52'),0) where
m1.yw='2010-52';
UPDATE 2081
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
This explains my problem, thanks!
On Mon, Jan 3, 2011 at 7:52 PM, Jasen Betts ja...@xnet.co.nz wrote:
On 2011-01-03, Alexander Farber alexander.far...@gmail.com wrote:
through some obscure error (probably on my side)
Column | Type | Modifiers
Hello,
I'm working on a small app, which receives a list of 20 players in XML format.
The initial version works ok and I use there just 1 SQL statement and thus
it is easy for me to fetch results row by row and print XML at the same time:
select u.id,
I'm trying:
create or replace function pref_money_stats(_id varchar)
returns varchar as $BODY$
begin
declare stats varchar;
for row in select yw, money from pref_money where id=_id order
by yw desc limit 20 loop
stats := stats || ; || row.id || :
Hello Bill and others,
I don't agree about yw being a bad thing
since I have weekly raings in my app,
but your XML suggestion -
On Tue, Dec 28, 2010 at 9:29 PM, Bill Moran wmo...@potentialtech.com wrote:
If there are multiple entries for pref_money, then each one should be
a container inside
On Tue, Dec 28, 2010 at 10:31 PM, Dmitriy Igrishin dmit...@gmail.com wrote:
user id=bla bla bla ...
pref_money date=2010-52 money=760 /
pref_money date=2010-51 money=3848 /
... etc ...
/user
Well, generally storing data in attributes should be avoided:
user id=id
pref_money
Hello Dmitriy,
I think this combination of attributes and children:
user id=bla bla bla ...
pref_money date=2010-52 money=760 /
pref_money date=2010-51 money=3848 /
... etc ...
/user
will be a good balance between size and my original problem
(combining user data and their
Hello,
I have a CentOS 5.5/64bit VM, where I only have sudo rights:
afarber ALL=(ALL) NOPASSWD: ALL
I'm trying to pass LD_LIBRARY_PATH
through sudo to install DBD::Oracle
( https://rt.cpan.org/Ticket/Display.html?id=63678 )
and have tried using sudo -E and also
changing these
This one works, thank you
___
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos
Hello,
has anybody solved the problem of installing GDChart on CentOS 5.5
(I've tried both 32 and 64 bit versions)?
I have:
# rpm -qa | grep -i php
php-pear-1.4.9-6.el5
php-gd-5.1.6-27.el5
php-ldap-5.1.6-27.el5
php-pgsql-5.1.6-27.el5
php-5.1.6-27.el5
php-pdo-5.1.6-27.el5
php-common-5.1.6-27.el5
Hello,
I'd like to have a local PostgreSQL copy of a table
stored (and growing) at the remote Oracle database:
SQL desc qtrack;
Name
Null?Type
On Fri, Dec 10, 2010 at 12:33 PM, Thomas Kellerer spam_ea...@gmx.net wrote:
And I'm not sure how to copy the Oracle's strange DATE
column best into PostgreSQL, without losing precision?
Oracle's DATE includes a time part as well.
So simply use a timestamp in PostgreSQL and everything should
Please help, struggling since hours with this :-(
I've created the following table (columns here and in the proc
sorted alphabetically) to acquire data copied from Oracle:
# \d qtrack
Table public.qtrack
Column|Type | Modifiers
On Fri, Dec 10, 2010 at 6:15 PM, Adrian Klaver adrian.kla...@gmail.com wrote:
On Friday 10 December 2010 8:51:19 am Alexander Farber wrote:
SQLSTATE[22001]: String data, right truncated: 7 ERROR: value too
long for type character varying(16)
CONTEXT: SQL statement update qtrack set
Hello,
I have installed the following packages:
oracle-instantclient11.2-basic-11.2.0.2.0.x86_64.rpm
oracle-instantclient11.2-devel-11.2.0.2.0.x86_64.rpm
oracle-instantclient11.2-sqlplus-11.2.0.2.0.x86_64.rpm
on my CentOS 5.5 Linux / 64 bit with perl 5.8.8
and have set the following env.
Wrong axis index, try: chxr=1,0,30
On Thu, Dec 2, 2010 at 1:24 PM, klevis miho klev...@gmail.com wrote:
Thank you, but I have the chxr in the URL:
Hello,
I have this table where I store player results for each week:
# select * from pref_money limit 5;
id | money | yw
+---+-
OK32378280203 | -27 | 2010-44
OK274037315447 | -56 | 2010-44
OK19644992852 | 8 | 2010-44
OK21807961329 | 114
Ok, it is
# select id from pref_money where money in (select max(money) from
pref_money group by yw);
id
DE8048
VK91770810
DE7115
OK252342810632
OK22853997
(5 rows)
And to see how many times a player has won is:
# select count(id) from pref_money where
Maybe I should just copy gChartPhp's files here:
# ls GChartPhp/PEAR/
gBarChart.phpgMapChart.phpgScatterChart.php
gChart.php gMeterChart.php gStackedBarChart.php
gConcentricPieChart.php gOverlappedBarChart.php gVennDiagram.php
gFormula.php
Hello,
On Fri, Nov 26, 2010 at 1:31 PM, Kai Schaetzl mailli...@conactive.com wrote:
I don't quite understand your whole question. What has this to do with
PEAR? It's not a PEAR package, it's a library that's hosted on
code.google.com.
yes, but it has the subdir called PEAR in it...
If
Hello,
I think this is a bug in Google Charts:
I use 3 underscores to omit values, but they are still displayed as -1 here:
Hello CentOS users,
I'm using gChartPhp by having copied it into /var/www/html dir.
It works ok, but I wonder how to better install/organize/maintain PEAR
packages under CentOS?
I've got the php-pecl rpm installed too, wonder if it's helpful here.
Or maybe just add a dir to php.ini?
Please
Hello,
is there a syntax to add a column not at the last place, but
somewhere inbetween or do I have to dump/restore the table?
For example if I'd like to add last_logout right after last_login:
\d pref_users;
Table public.pref_users
Column |Type |
Easier to read... login, logout
On Wed, Nov 24, 2010 at 8:45 AM, Szymon Guz mabew...@gmail.com wrote:
no
Why do you want to do anything like that?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Hello,
I'm trying to program a PHP-script, where users
can rate the goodness of the other players:
create table pref_rep (
id varchar(32) references pref_users(id) check (id author),
author varchar(32) references pref_users(id),
author_ip
I'm actually hoping to use inet (or cidr?) instead of strings...
On 11/20/10, Dmitriy Igrishin dmit...@gmail.com wrote:
Hey Alexander,
2010/11/20 Alexander Farber alexander.far...@gmail.com
Hello,
I'm trying to program a PHP-script, where users
can rate the goodness of the other players
601 - 700 of 1326 matches
Mail list logo