Usually, you would only require GROUP BY if you were trying to calculate an
aggregate function such as the SUM, COUNT, AVG etc on a column.
In this case, you are not specifying any such function, so it is unclear
what you are trying to do.
Perhaps you are simply trying to express an ORDER BY?
Pg is not a toy like mysql
It always required an explicit notation for groupby
воскресенье, 15 ноября 2020 г. в 11:18:55 UTC+3, ermolaev...@gmail.com:
> for grp in db((db.pay_ins_stack.ref_==db.pay_ins.id)
> & (db.pay_ins.ref_ == db.deal_acc_addrs.id )
> & (db
for grp in db((db.pay_ins_stack.ref_==db.pay_ins.id)
& (db.pay_ins.ref_ == db.deal_acc_addrs.id )
& (db.deal_acc_addrs.xcurr_id == xcurr.id)
).select(groupby=(db.deal_acc_addrs.id,
db.pay_ins_stack.id)):
same error:
column "pay_ins.id" m
I update all this code by INSERT
суббота, 14 ноября 2020 г. в 12:33:24 UTC+3, kell...@gmail.com:
> Probably also something for @Leonel Câmara .
>
> Can you compare the raw sql of Mysql and PostgreSQL of what you are
> trying to do please?
>
> And post it here, then we can probably see what nee
I make 2 cycles FOR - first for GROUPBY second for SELECT
суббота, 14 ноября 2020 г. в 12:33:24 UTC+3, kell...@gmail.com:
> Probably also something for @Leonel Câmara .
>
> Can you compare the raw sql of Mysql and PostgreSQL of what you are
> trying to do please?
>
> And post it here, then we
Probably also something for @Leonel Câmara .
Can you compare the raw sql of Mysql and PostgreSQL of what you are
trying to do please?
And post it here, then we can probably see what needs to be done.
Thanks!
Am Sa., 14. Nov. 2020 um 10:04 Uhr schrieb Dmitrii Ermolaev <
ermolaev.icrea...@gmail.
I think @Leonel Câmara would know best what is
going on here.
My uneducated guess is that you are using Postgresql12 and that there were
some major changes from postgres11 to postgres12.
Either Pydal has not caught up yet, or since pydal is not strictly an ORM,
you just have to actually adapt you
if not currs_stats:
db.currs_stats[0] = {
'curr_id': curr_id,
'deal_id': deal_id,
'average_': volume_out,
'count_': 1,
}
on MySQl all work
error: No such record: 0
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Sou
for grp in db((db.pay_ins_stack.ref_==db.pay_ins.id)
& (db.pay_ins.ref_ == db.deal_acc_addrs.id )
& (db.deal_acc_addrs.xcurr_id == xcurr.id)
).select(groupby=(db.deal_acc_addrs.id)):
ERROR:
column "pay_ins_stack.id" must appear in the GROUP
Need managed, reliable hosting for a mission critical app that hits the
eBay API at specified times. It's a generic CRUD app except that scheduled
tasks (written in Go) must be run with 1 second accuracy, no more than
200/second at peak times.
I am a pretty terrible sysadmin so my strong prefer
Web2py version: Version 2.14.6-stable+timestamp.2016.05.10.00.21.47
AFAIK, the scheduler is responsible, e.x.:
SETUP (e.x.):
scheduler.queue_task(
'test__task_insert', application_name='app', repeats=0, period=60,
timeout=3600, retry_failed=-1)
def task_insert():
db.table.insert(ti
I'm trying to deploy on heroku, but am having troubles connecting to their
database.
Imported gluon.contrib.heroku.py but get_db() doesn't seem to be working
well with the adapters
Any ideas where to look would be appreciated.
Failure to connect, tried 5 times: Traceback (most
recent call las
Please ignore that last message of mine.
The hanging problem was produced by an issue with the redis_cache.py
adapter failing to write a cache key.
El miércoles, 2 de mayo de 2018, 17:08:38 (UTC-3), Lisandro escribió:
>
> Well, I've commented out the line of the postgresql adapter of web2py, th
Well, I've commented out the line of the postgresql adapter of web2py, the
line where it runs the SET standard_conforming_strings=on; but now it hangs
in the previous line "SET CLIENT_ENCODING TO 'UTF8'".
This is the function of the web2py's adapter where the application hangs:
https://github.co
Hi there, sorry to bother in this old post.
I'm having a problem regarding standard_conforming_strings.
Today my app experienced a problem with Redis going out of memory.
After the problem was fixed, all my websites started to work normally,
except four of them (of a total of 260 websites).
For
Base on this :
https://github.com/web2py/pydal/blob/466a39f13e443bbcc54db2d1ba6ed10196abf440/pydal/drivers.py#L45
web2py shouldn't enforce a specific version of psycopg2...
Are you using python 2 or python 3 and is your last psycopg2 version you
mention is install for the python version that you
Hello web2py community!
I am in the process of moving a 4 year old web2py application to a new
server and I am having trouble getting the application to connect to
PostgreSQL 10.2. I am guessing because the version of psycopg2 driver in
web2py is: 2.5.4 (dt dec pq3 ext)
I installed the lates
here: http://web2py.com/books/default/search/29?search=groupby
s = db.table.field_a | db.table.field_b
groupby s
*always obey the computer.* :)
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.goog
On 11-05-2017 15:22, Oasis Agano wrote:
> Hello
>
> i have moved my connection to Postgres from sqlite and im facing this issue;
>
>ret = self.get_cursor().execute(command, *a[1:], **b)
> ProgrammingError: column "water_flow_log.id" must appear in the GROUP BY
> clause or be used in an aggre
Hello
i have moved my connection to Postgres from sqlite and im facing this issue;
ret = self.get_cursor().execute(command, *a[1:], **b)
ProgrammingError: column "water_flow_log.id" must appear in the GROUP BY clause
or be used in an aggregate function
LINE 1: SELECT water_flow_log.id, water
Hi All,
I'm working with a colleague who is in the process of learning web2py.
In parallel, I have developed a relatively simplistic database in
PostGreSQL, with approximately a dozen tables.
We've managed to get the database into web2py, and can view each of the
tables (and their data) in the
Hi!
This is useful aggregate function for PG-users (tested with PostgreSQL 9.3
):
def json_agg_sql(flds_lst, as_alias):
json_fld_sql = """ '"%s":' || to_json(%s) """
json_row = [json_fld_sql % (f.name, f.name) for f in flds_lst]
json_row_sql = "'{' || " + "|| ',' ||".joi
https://www.compose.io/articles/what-postgresql-has-over-other-open-source-sql-databases/
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received thi
Hi!
I have a table with a json field and I woul like to perform something like:
db(db.mytable.id>0).select(db.mytable.myjsonfield.getitem('myfield').with_alias("myfield"))
the only way I thought is the patch in attachment that works just fine
but I don't like to use a patched version of the frame
Hi there :)
I'm using web2py 2.9.10 with a database PostgreSQL 9.4 for a new project
and I have a question about sorting. In PostgreSQL, when I execute a
SELECT, I can specify 'ORDER BY x ASC NULLS FIRST', which is not the
default output. Is there a way to do that with the DAL other than writin
Finally!
http://blog.pythonanywhere.com/103/
Not free, but fully managed
mic
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message b
I'm having a very annoying issue where the connection to a PostgreSQL
database hangs and I get a "Attempted to connect to this database 5 times
unsuccessfully" which renders the whole web application un-usable.
I'm using PostgreSQL 9.3. Web2Py Version
2.8.2-stable+timestamp.2013.11.28.13.54.07
Hello all.
I've moved a db from sqlite to postgresql, but I've got a strange problem.
With only one tab, ok.
If I have two tabs with the same application, it seems that data's are
mixed.
For example in tab 1 I have a grid, in tab 2 a page.
When I save from tab 1 grid I see some data's from tab 2.
I have a legacy table, and it has some uppercases letters, so in the select
the field must be wrapped in ". Something like SELECT table."fielD" from
table...
Is there any way filter any select that web2py does and wrap any field or
table with uppercase letter around "?
--
Resources:
- http:/
>
> My migrations suddenly failed with
>
> Error:
> ('ERROR', '42P01',
> 'relation "wiki_page" does not exist')
>
>
If the relation does exist in Postgresql (which is why you want to
migrate), try and move the related file in //databases/ for that table
to another destination (say /var/tmp) and
My migrations suddenly failed with
Error:
('ERROR', '42P01',
'relation "wiki_page" does not exist')
This will happen for any relation trying to commenting them out etc.
Running a fake_migrate_all and the problem still persists, so I can not
find a way around manually modify my PostgreSQL schem
Hi!
Is there a way to restore a dump from an sql file that comes from a
pg_dump command using in someway the database object defined in my model
for example using the executesql method?
I ask because I tried without success... it raises the sequent error in
corrispondence of the line where data sta
Test with trunk. We have done some improvements about case sensitivity.
And now lastval() is used in place of curval() i.e. safer and faster.
2013/12/5 Alan Etkin
> (translated from a message of Martin Miranda to web2py-usuarios)
>
> "... After upgrading to web2py 2.8.2-stable+timestamp.201
(translated from a message of Martin Miranda to web2py-usuarios)
"... After upgrading to web2py 2.8.2-stable+timestamp.2013.11.28.13.54.07
my app throws the following error:
(relation "testSeq_id_seq" does not
exist LINE 1: select currval('"testSeq_id_seq"') ^ )
I've been using Postgres 9.1. W
We can make it optional. Please open a ticket.
On Sunday, 24 November 2013 02:28:23 UTC-6, Jayadevan M wrote:
>
> My doubt is - do we need to explicitly set it ON? Since the default
> setting is ON, any client connecting will have it turned ON anyway?
>
> On Sunday, November 24, 2013 1:48:23 PM U
My doubt is - do we need to explicitly set it ON? Since the default setting
is ON, any client connecting will have it turned ON anyway?
On Sunday, November 24, 2013 1:48:23 PM UTC+5:30, Massimo Di Pierro wrote:
>
> It must be done for every connection. Do you have connection pooling on?
> If a c
It must be done for every connection. Do you have connection pooling on? If
a connection is recycled it should not do it again.
On Saturday, 23 November 2013 22:49:47 UTC-6, Jayadevan M wrote:
>
> Thanks for the reply. OK, let us take this forward on the first one
> (default behaviour). Since th
Thanks for the reply. OK, let us take this forward on the first one
(default behaviour). Since the default behaviour is to SET
standard_conforming_strings=on, is there a need to do it again, for each
connection/call? It will incur an ever-so-small overhead which can be
avoided?
On Saturday, No
BTE, if you see an exclusive lock right on the
SET standard_conforming_strings=on
don't worry, it doesn't lock any tables.
On Saturday, November 23, 2013 3:01:00 PM UTC+1, Massimo Di Pierro wrote:
>
> You raise two issues:
>
> 1) About
> SET standard_conforming_strings=on
> This is required and i
You raise two issues:
1) About
SET standard_conforming_strings=on
This is required and in fact as you say it is the default behavior since
9.1. This has nothing to do which locking.
2) You see exclusive locks. Which locks? Can you say more?
On Saturday, 23 November 2013 05:53:02 UTC-6, Jayade
Is it possible to avoid this? Especially since the default server value is
ON since PostgreSQL 9.1
http://www.postgresql.org/docs/9.3/static/runtime-config-compatible.html
On Saturday, November 23, 2013 5:23:02 PM UTC+5:30, Jayadevan M wrote:
>
> I am testing our web2py application with a few co
I am testing our web2py application with a few concurrent users. While
monitoring the database (PostgreSQL), I can see a number of exclusive
locks. The SQL is
SET standard_conforming_strings=on
Is this expected behaviour?
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentatio
The type of the field should be 'datetime'.
A timestamp can be done with the following syntax according to the book
(search for 'request.now') :
Field('created_on', 'datetime',
default=request.now, update=request.now, writable=False),
I suspect the timesone-thing can be done with repr
Hi
I've looked through the forum and can find nothing.
my code
db.define_table('franchise',
Field('code', 'string', length=1),
Field('name'),
Field('recorddate','timestamp with time zone'),
)
the error
Field: unknown field type: timestamp with
time zone for recorddate
Assistance appreciated
Done.
https://code.google.com/p/web2py/issues/detail?id=1535
https://code.google.com/p/web2py/issues/detail?id=1536
Just so you know...
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving e
Open an issue on google code I guess. You could join a app that will make
it easier to reproduce the problem an the explanation required to reproduce.
Richard
On Thu, Jun 13, 2013 at 1:00 PM, Arnon Marcus wrote:
> We've been dealing with issue for a long time now, with a working
> workaround,
We've been dealing with issue for a long time now, with a working workaround,
but frankly, we sbouldn't bave to. It's actually a very basic and common
use-case, so I am surprised nobody brought it up before...
The issue is with migration when changing constraints on fields. It fails
silently. T
We've been dealing with issue for a long time now, with a working workaround,
but frankly, we sbouldn't bave to. It's actually a very basic and common
use-case, so I am surprised nobody brought it up before...
The issue is with migration when changing constraints on fields. It fails
silently. T
I'm aware this might be rather a postgresql question but maybe someone
knows how to deal with it.
I defined 'city' table
db.define_table('city',
Field('id', length=8),
Field('country', length=2, unique=True),
Field('region', length=3),
Field('url', length=50),
Field('name', length=50),
Field('la
Hi,
I am using Postgresql and encountered the following errors. These errors do
not come up when I use SQLite.
I have the following code:
###MODEL
db.define_table('deals',
Field('deal_name', 'string',length=255,requires=IS_NOT_EMPTY()),
Field('num_A', 'integer',default=0),
Field('
Hi all,
Due to a strange Postgresql setup by my systems admin, I can not specify
the host as "localhost" to connect to my production database. Instead, I
have to specify the unix socket. This is currently unsupported in web2py,
but I came up with a temporary workaround for the time being. In a
Hi,
I am encountering the exact same problem as mentioned by Lucas in one the
earlier threads :
msql db_name -U user_name -h localhost
*works*
*
*
import psycopg2
psycopg2.connect
*works*
*
*
python web2py.py -S app_name
DAL(...) works too
But, still I get error
> RuntimeError: Failure to co
I could not get a pg8000 connection to work (see another email) so what I
am writing involves only the psycopg2 driver. It might be the same for
pg8000.
At the moment it seems necessary to duplicate in the python code what the
database is doing when using constraints.
Example: I have several t
How would one translate the following query into DAL - or should I use
executesql (I would like to use the query in SQLFORM.grid):
select B.title, A.title, similarity(A.title, B.title)
from
us2006_2010 B
left join akb_articles A on (A.title % B.title)
where
B.id in
(select A.id
On 27 November 2011 16:28, Alan Etkin wrote:
> psycopg2.ProgrammingError: relation "debugging_id_seq" does not exist
Maybe a typo somewhere where debugging_id_seq should be debugging.id_seq?
Regards
Johann
--
Because experiencing your loyal love is better than life itself,
my lips will praise
Hi, I am trying to use PostgreSQL DAL interface with my project, but
i'm having trouble with table references and insert/update/delete
commands.
The system info:
OS: GNU/Linux, web2py 1.99.2, PostgreSQL 8.4
I have tried the workaround posted by pbreit for a very similar
problem:
http://groups.goo
I have changed the model of a populated table (removing two fields with
uuid-type references to other tables).
Now when I restart web2py the process never becomes ready. In the
Postgresql-log I see:
2011-10-11 12:24:13 SAST LOG: could not receive data from client:
Connection reset by peer
2011-
hello one and all,
i have a thread down below and after much to do and getting no where
fast with db = DAL('postgres://postgres:passwd@localhost/prac2')
because permission was denied over and over no matter what i did.
here is the previous post
http://groups.google.com/group/web2py/browse_thread/
Can you test:
#python2.6
>import psycopg2
>psycopg2.connect(database="prac2", user="postgres", password="password",
>host="localhost")
Maybe the server is down, you have a firewall issue or your
pg_hba.conf is not open for localhost connections:
hostall all 127.0.0.1
hello one and all,
i am having difficultly connecting postgres 9.1 under web2py v1.98.2
on a centos 6.0 box which has python 2.6.5. i have psycopg2 2.4
installed and working in python when i run the test
#python2.6 web2py -S welcom -N -a 'password'
then
>import psycopg2
>
works just fine. howe
On 9/13/11 1:43 AM, Web2Py Freak wrote:
Dear All ,
i want to use PostGresql , now after i download it , what to do so
it can work with web2py ??
How about install the postgres driver?
pip install psycopg
Then next time you run web2py you should see the driver is loaded
then change your db
Dear All ,
i want to use PostGresql , now after i download it , what to do so
it can work with web2py ??
Today I upgraded to Postgresql 9.0 and web2py 1.98.2 (on Mac OS X Snow
Leopard). To test the environment I created a Login Role and Database
in pgAdmin III and entered the following connection string in db.py:
db = DAL('postgres://myusername:mypassword@localhost:5432/mydatabase')
Now, when I star
Hi,
I need to be able to define tables that reference other tables not yet
defined (because of the order in which define_table is called).
Something like the following (simplified for this discussion):
db.define_table(x'table1', Field('xtest'), Field('xref2', 'reference
table2'))
db.de
On 30 May 2011 12:14, Massimiliano wrote:
> Existing tables are divided on different database schemas (not only
> public).
>
> Now I want to rewrite a single application that use existing tables on
> schema "xyz".
>
> Does web2py support that?
>
>
I could not get DAL to work with that(different
Hi all,
I've a legacy enterprise application that use postgresql as database.
Existing tables are divided on different database schemas (not only public).
Now I want to rewrite a single application that use existing tables on
schema "xyz".
Does web2py support that?
Thank you
--
Massimiliano
web2py generate SQL that PostgreSQL doesn't accept.
For instance,
SELECT DISTINCT a.id, a.uid, a.name FROM a, b WHERE a.deleted <>
'T') AND (a.id > 0)) AND (((b.deleted <> 'T') AND (b.id > 0)) AND
(b.id = 1))) AND (b.uid = a.uid)) ORDER BY b.id, a.id LIMIT 1 OFFSET
0;
It fails because select
Personally, I gave up after many tests, I decided to return the installation
of 189.6 andeverything works normally, a problem with the new DAL in
relation to postgresql.
--
Ovidio Marinho Falcao Neto
ovidio...@gmail.com
Tecnologia da Informaçao
Casa Civil do
(PS I have tried auth.define_tables(migrate='False') and it doesn't help)
On 4 February 2011 13:22, Tom Atkins wrote:
> I am getting the same error as reported by Carlos and cannot fix it.
>
> I have just set up a new server (Ubuntu 10.04 - postgres 8.4, Python 2.6.5)
> and have web2py trunk up
I am getting the same error as reported by Carlos and cannot fix it.
I have just set up a new server (Ubuntu 10.04 - postgres 8.4, Python 2.6.5)
and have web2py trunk up and running fine. I have an unmodified 'welcome'
app which runs perfectly with sqlite.
I then delete all the files in database
http://initd.org/psycopg/articles/2010/12/01/postgresql-notifications-psycopg2-eventlet/
Hi,
I'm getting the following error in my local installation with
postgresql when using auth.define_tables(migrate=True):
(relation "auth_user" already
exists)
web2py™ Version 1.89.1 (2010-11-12 15:14:36)
Python Python 2.6.4: C:\Python26\python.exe
Traceback (most recent call last):
File "C:
Any of you have experience with Bucardo or pgpool-II as a replication
add-on?
Some background:
I switched from MySQL to PostgreSQL very cleanly using web2py as the
vehicle. Sort description to document the process: Made a copy of the
app, removed the content of the databases directory, added the
p
On 29 October 2010 08:53, Chris wrote:
> Hey,
>
> I've noticed some serious slowdowns ever since I switched from SQLite
> to Postgres. Pages will take MINUTES to load - it's kind of
> fascinating.
>
I have been using both SQLITE and Postgresql (sometimes with the same
content) and did not notice
Hey,
I've noticed some serious slowdowns ever since I switched from SQLite
to Postgres. Pages will take MINUTES to load - it's kind of
fascinating.
I don't have the full explanation for what's going on yet but I do
have some clues. I've noticed it happens locally, and in a specific
way:
1) I loa
I want to use a legacy database. In Postgresql I access it as A.b.c
where A is the database, b is the schema and c is where the tables
are.sql
Here is an example of the sql that created one of the original tables:
CREATE TABLE kbase.institution
(
id integer NOT NULL,
"name" character varying
http://www.postgresql.org/about/news.1235
I found something in the archive.
This seems to be multiple python versions issue, but still do not have a
solution. Unfortunately, this server is preinstalled with python2.4 and
I am trying to use 2.6, which can't be probably found under mod_wsgi
Julius
V Štvrtok, 27. máj 2010 o 12:54 +0200, Jul
I was too fast.
It works when accessed on port.
It doesn't when accessed through mod_wsgi:
File "gluon/sql.py", line 3835, in DAL
migrate=migrate, fake_migrate=fake_migrate)
File "gluon/sql.py", line 959, in __init__
self._pool_connection(lambda : psycopg2.connect(msg))
File "gluon/sq
I found the reason by removing exception catching when connecting to
Postgres in gluon/sql.py.
It told me that this line
self._execute("SET standard_conforming_strings=on;")
is a problem.
I commented it out and everything is fine until now.
Can this removal have a side effect?
Julius
V Št
I did that as first thing. No luck.
I changed it to IP as I it works from command line.
Julius
V Streda, 26. máj 2010 o 19:41 -0500, Thadeus Burgess napísal(a):
> Try
>
> postgres://w2p:passw...@localhost:5432/w2p
>
> --
> Thadeus
>
>
>
>
>
> On Wed, May 26, 2010 at 5:17 PM, Julius Minka
Try
postgres://w2p:passw...@localhost:5432/w2p
--
Thadeus
On Wed, May 26, 2010 at 5:17 PM, Julius Minka wrote:
> This is virtual server with centos 5.5 in internet.
> I have successfully instaled web2py with Apache and mod_wsgi based
> mainly on instructions from
> http://web2py.com/AlterEg
This is virtual server with centos 5.5 in internet.
I have successfully instaled web2py with Apache and mod_wsgi based
mainly on instructions from
http://web2py.com/AlterEgo/default/show/239 and
http://web2py.com/AlterEgo/default/show/240
Probably last step is missing.
I am getting this error wh
*IF* you determine that web2py is too hard to integrate with your system...
You might look at repoze.BFG. It's a python-based framework that inherits some
of the best features of Django and Pylons, and can integrate with "any" (R)DBMS
or ORM, quite easily.
Good luck with your project,
-r.
On
Hi,
I googled a lot on this topic before send this email.
I am kind of postgresql newbie and of course also with web2py.
I have already designed a database with PGAdminIII that respond to my
need that has already around 50 tables with many foreign key
relationship. I use schemas to group my tabl
The next Jython challenge !
The line:
db = DAL('postgres://stubo:st...@10.220.17.77/stubo_remote',
pool_size=10)
works fine when running in python, but fails from Jython (see
below).
>From Jython I can run: 'from com.ziclix.python.sql import zxJDBC', so
I think that is installed OK
Tracebac
On 28 January 2010 00:15, Thadeus Burgess wrote:
> This is most likely a bug, would you be willing to provide more
> information on the matter?
Example. I have changed the type of a field from string (1024) to 'text'.
>
> For simplicities sake, drop your tables with the DAL by doing
>
> db.table
This is most likely a bug, would you be willing to provide more
information on the matter?
For simplicities sake, drop your tables with the DAL by doing
db.table.drop()
Then you will have a fresh start when you remove this command.
-Thadeus
On Wed, Jan 27, 2010 at 3:37 PM, Johann Spies wr
It has happened several times now that I make changes in models/db.py
to the structure of a table (e.g. changing the type of a field) and
then web2py does not write the changes to the database (Postgresql)
and in the end one ends up with a situation that you have to do
changed using another interfa
;>
>>>>>> web2py closes connections automatically when a thread ends unless you
>>>>>> have pools.
>>>>>>
>>>>>> Massimo
>>>>>>
>>>>>> On Feb 15, 2:19 am, Fran wr
onalError: FATAL: connection limit exceeded for
> > > > > > > non-superusers
> > > > > > > Do I need to close the connection explicitly somewhere?
>
> > > > > > Interesting, someone previously had the same kind of problem with
> > > &g
AL: connection limit exceeded for
> > > > > > non-superusers
> > > > > > Do I need to close the connection explicitly somewhere?
>
> > > > > Interesting, someone previously had the same kind of problem with
> > > > > MySQL which they
someone previously had the same kind of problem with
> > > > MySQL which they fixed by moving to
> > > > PostgreSQL:http://groups.google.com/group/web2py/browse_thread/thread/7019f65977...
>
> > > > For the issue to get fixed, I imagine that people would ne
need to close the connection explicitly somewhere?
>
> > > Interesting, someone previously had the same kind of problem with
> > > MySQL which they fixed by moving to
> > > PostgreSQL:http://groups.google.com/group/web2py/browse_thread
se the connection explicitly somewhere?
>
> > Interesting, someone previously had the same kind of problem with
> > MySQL which they fixed by moving to
> > PostgreSQL:http://groups.google.com/group/web2py/browse_thread/thread/7019f65977...
>
> > For the issue to get
by moving to
> PostgreSQL:http://groups.google.com/group/web2py/browse_thread/thread/7019f65977...
>
> For the issue to get fixed, I imagine that people would need to know:
> (1) The exact versions of Web2Py/PostgreSQL/Python
> (2) Your code
>
> F
--~--~-~--~~---
:
http://groups.google.com/group/web2py/browse_thread/thread/7019f659773ac62a
For the issue to get fixed, I imagine that people would need to know:
(1) The exact versions of Web2Py/PostgreSQL/Python
(2) Your code
F
--~--~-~--~~~---~--~~
You received this message because y
Hello everyone,
I have this error:
Traceback (most recent call last):
File "gluon/restricted.py", line 62, in restricted
exec ccode in environment
File "/home/web2py/site/web2py/applications/docs/models/db.py", line
1, in
db=SQLDB('postgres://user:p...@localhost:5432/db1')
File "g
98 matches
Mail list logo
