Search

Clear search

Close search

Main menu

Google apps

web2py-users

1–30 of 34904

0 selected

Maurice Waka, Clemens4

2/14/20

I removed postgresql and reinstalled it. Working well now. Regards On Thu, Feb 13, 2020, 22:59

unread,

I removed postgresql and reinstalled it. Working well now. Regards On Thu, Feb 13, 2020, 22:59

2/14/20

12/17/19

Accessing Postgres server from a secondary docker container without db.py

How do I do connect to a prostgres server using PyDAL but without a db.py in the secondary container

unread,

Accessing Postgres server from a secondary docker container without db.py

How do I do connect to a prostgres server using PyDAL but without a db.py in the secondary container

12/17/19

João Matos, … Anthony19

3/25/19

Does web2py/DAL allow for creating atomic operations (begin transaction/end transaction)?

@John and @Anthony Thanks for your time. @John I disagree with you about the corner thing. With

unread,

Does web2py/DAL allow for creating atomic operations (begin transaction/end transaction)?

@John and @Anthony Thanks for your time. @John I disagree with you about the corner thing. With

3/25/19

David Orme, Leonel Câmara4

3/19/19

ST_Transform in GIS support

So, in addition to st_transform, I would add st_aswkb. This isn't an official Postgis command -

unread,

ST_Transform in GIS support

So, in addition to st_transform, I would add st_aswkb. This isn't an official Postgis command -

3/19/19

2/16/19

Is there such a thing as a reliable, managed web2py/PostgreSQL host with good support?

Need managed, reliable hosting for a mission critical app that hits the eBay API at specified times.

unread,

Is there such a thing as a reliable, managed web2py/PostgreSQL host with good support?

Need managed, reliable hosting for a mission critical app that hits the eBay API at specified times.

2/16/19

Lisandro, … Massimiliano10

1/25/19

Error: prepared statement «pg8000_statement_0» already exists

Hi there! Finally I was able to solve the problem uninstalling psycopg2* and reinstalling psycopg2-

unread,

Error: prepared statement «pg8000_statement_0» already exists

Hi there! Finally I was able to solve the problem uninstalling psycopg2* and reinstalling psycopg2-

1/25/19

James McGlynn, Anthony2

4/2/18

Copy table with an upload field from one database to another without disturbing the files.

Why can't you just copy the existing values in the log_file field? Anthony On Monday, April 2,

unread,

Copy table with an upload field from one database to another without disturbing the files.

Why can't you just copy the existing values in the log_file field? Anthony On Monday, April 2,

4/2/18

Rob Paire, … Anthony11

3/2/18

PostgreSQL 10.2

On Thursday, March 1, 2018 at 6:36:40 PM UTC-5, Rob Paire wrote: I am running the windows binary that

unread,

PostgreSQL 10.2

On Thursday, March 1, 2018 at 6:36:40 PM UTC-5, Rob Paire wrote: I am running the windows binary that

3/2/18

Ben Lawrence, Leonel Câmara3

8/23/17

Cannot insert into postgres database, starting with a 1.1M blob.

Ok, i have a very rough fix. (Thanks Leonel for your time) I neglected to say that this is all done

unread,

Cannot insert into postgres database, starting with a 1.1M blob.

Ok, i have a very rough fix. (Thanks Leonel for your time) I neglected to say that this is all done

8/23/17

Oasis Agano, … Pierre3

5/13/17

Web2py Postgresql Groupby issue

here: http://web2py.com/books/default/search/29?search=groupby s = db.table.field_a | db.table.

unread,

Web2py Postgresql Groupby issue

here: http://web2py.com/books/default/search/29?search=groupby s = db.table.field_a | db.table.

5/13/17

Jurgis Pralgauskis, Leonel Câmara5

3/11/17

how to override "select" method?

> Common filters only add to query, but I need to change/replace fields/expressions . Why don'

unread,

how to override "select" method?

> Common filters only add to query, but I need to change/replace fields/expressions . Why don'

3/11/17

3/6/16

PostgreSQL: json_agg()

Hi! This is useful aggregate function for PG-users (tested with PostgreSQL 9.3 ): def json_agg_sql(

unread,

PostgreSQL: json_agg()

Hi! This is useful aggregate function for PG-users (tested with PostgreSQL 9.3 ): def json_agg_sql(

3/6/16

Yebach, Richard Vézina7

1/20/16

Encoding while reading postgres data

Solved the problem I posted on stackoverflow.com http://stackoverflow.com/questions/34596573/

unread,

Encoding while reading postgres data

Solved the problem I posted on stackoverflow.com http://stackoverflow.com/questions/34596573/

1/20/16

Jose C, … António Ramos13

3/23/17

ProgrammingError: column "worker_stats__tmp" is of type json but expression is of type text

Solved. I asked for help from Webfaction and those guys just know a "litle" about web2y...

unread,

ProgrammingError: column "worker_stats__tmp" is of type json but expression is of type text

Solved. I asked for help from Webfaction and those guys just know a "litle" about web2y...

3/23/17

Chris, Niphlod3

5/4/15

A text field in PostgreSQL is mixing unicode and str types

Just spent some time reviewing this - looks OK now, I think I must have screwed up somewhere. All db

unread,

A text field in PostgreSQL is mixing unicode and str types

Just spent some time reviewing this - looks OK now, I think I must have screwed up somewhere. All db

5/4/15

Val K, … Johann Spies7

3/16/15

DAL: INSERT-query's devilry

OK, here is my fix: pydal.py/base.py: TABLE_ARGS=set((... , 'insert_with_returning')) pydal.

unread,

DAL: INSERT-query's devilry

OK, here is my fix: pydal.py/base.py: TABLE_ARGS=set((... , 'insert_with_returning')) pydal.

3/16/15

stingpan, … Niphlod6

2/19/15

web2py Scheduler with Postgres creates "idle in transaction" connections

in my environment, I can't see any idle in transaction........ that's why I patched the

unread,

web2py Scheduler with Postgres creates "idle in transaction" connections

in my environment, I can't see any idle in transaction........ that's why I patched the

2/19/15

2/16/15

Web2py deployment with installer script.

Hi All, When installing on a ubuntu server with the install script does it configure the postgresql

unread,

Web2py deployment with installer script.

Hi All, When installing on a ubuntu server with the install script does it configure the postgresql

2/16/15

Louis Amon, … Carlos Zenteno8

4/5/15

Drill-down menu with PostgreSQL

Thanks for explaining the "materialization" process. It will come handy on my app...

unread,

Drill-down menu with PostgreSQL

Thanks for explaining the "materialization" process. It will come handy on my app...

4/5/15

Kiran Subbaraman, … Niphlod10

1/29/15

pydal / postgres / jsonb

In agreement with you on not enforcing this - jsonb - as default, but something that a knowledge-able

unread,

pydal / postgres / jsonb

In agreement with you on not enforcing this - jsonb - as default, but something that a knowledge-able

1/29/15

Ian W. Scott, … Paolo Valleri7

1/12/15

Problem migrating field type from 'string' to 'text' (postgresql)

Thanks Paolo. That was it. I forgot that I had set migrate to False. I really feel foolish, but

unread,

Problem migrating field type from 'string' to 'text' (postgresql)

Thanks Paolo. That was it. I forgot that I had set migrate to False. I really feel foolish, but

1/12/15

da...@nextoken.com

12/11/14

Various Heroku related questions

I'm new to web2py but I've basically read through the book and checked the forum. I

unread,

Various Heroku related questions

I'm new to web2py but I've basically read through the book and checked the forum. I

12/11/14

Lisandro, … Michele Comitini20

12/6/14

Web2py's included connection pooling VS external pooling software

Thank you very much Michele for your answer. I understand that assigning different priorities to each

unread,

Web2py's included connection pooling VS external pooling software

Thank you very much Michele for your answer. I understand that assigning different priorities to each

12/6/14

10/22/14

pg8000 unexpected EOF on client connection with an open transaction

Hello web2py community, I have a scheduled task that gets executed every 5 minutes by the web2py

unread,

pg8000 unexpected EOF on client connection with an open transaction

Hello web2py community, I have a scheduled task that gets executed every 5 minutes by the web2py

10/22/14

10/21/14

Seeking advice on Heroku db parity

According to this Heroku article, subtle differences between Postgres and Sqlite may cause hard to

unread,

Seeking advice on Heroku db parity

According to this Heroku article, subtle differences between Postgres and Sqlite may cause hard to

10/21/14

8/22/14

MySQL will never migrate this way (not alter table problem)

Summary: We can't make some database migrates on MySQL because we can't DROP column with

unread,

MySQL will never migrate this way (not alter table problem)

Summary: We can't make some database migrates on MySQL because we can't DROP column with

8/22/14

Cliff Kachinske, Anthony3

6/27/14

list:strings not working as described or am I missing something?

Anthony, Thanks for the shove in the right direction. An ajax callback processes that field and I had

unread,

list:strings not working as described or am I missing something?

Anthony, Thanks for the shove in the right direction. An ajax callback processes that field and I had

6/27/14

Mandar Vaze, … Anthony6

5/9/14

Does Web2py Postgres Adapter support JSON as native type ?

On Thu, May 8, 2014 at 6:25 PM, Anthony <abas...@gmail.com> wrote: And here's where it

unread,

Does Web2py Postgres Adapter support JSON as native type ?

On Thu, May 8, 2014 at 6:25 PM, Anthony <abas...@gmail.com> wrote: And here's where it

5/9/14

Sebastian Ortiz Vasquez2

4/23/14

Bug in deflate of json fields

On Monday, April 21, 2014 3:38:08 PM UTC-5, Sebastian Ortiz Vasquez wrote: Hi, i discovered a bug,

unread,

Bug in deflate of json fields

On Monday, April 21, 2014 3:38:08 PM UTC-5, Sebastian Ortiz Vasquez wrote: Hi, i discovered a bug,

4/23/14

Hanna Meressa, Dave S2

3/28/14

On Thursday, March 27, 2014 12:25:15 PM UTC-7, Hanna Meressa wrote: how to collect data? how to

unread,

On Thursday, March 27, 2014 12:25:15 PM UTC-7, Hanna Meressa wrote: how to collect data? how to

3/28/14