Re: [GENERAL] HELP with a query with blank fields

On Tue, 27 May 2008, J. Manuel Velasco wrote: > Hello, > > This is the current query I have: > > SELECT dominis.nom, dominis.extensio, dominis.creat, dominis.expira, > titulars.first_name, titulars.last_name, contactes_admin_tec.first_name, > contactes_admin_tec.last_name, dns1.nom, dns2.nom, dom

Re: [GENERAL] Bottom Posting

IMHO and WADR I am on four different types of lists. When I am following a thread I very much appreciate those respondents who get their point across up front without making me wade through previous posts which I have already read. I can understand the concept of bottom posting as a means of

[GENERAL] Help with app design

Hi all, First - if this is the wrong spot for such a question, I apologize ahead of time! I'm hoping someone who knows better can tell me if I'm on the right track or not. I have written a desktop application that is used throughout my company. This application is a wxPython GUI that controls se

[GENERAL] HELP with a query with blank fields

Hello, This is the current query I have: SELECT dominis.nom, dominis.extensio, dominis.creat, dominis.expira, titulars.first_name, titulars.last_name, contactes_admin_tec.first_name, contactes_admin_tec.last_name, dns1.nom, dns2.nom, dominis.redirec, contactes_fac.nom, grups.nom FROM dominis, con

Re: [GENERAL] conditional alter table

Brian Cox wrote: > I'd like to either 1) execute an alter table to re-add a constraint only > if it doesn't exist or 2) have psql ignore the failure when setting it's > exit status. Any ideas on how to do either would be appreciated. I don't think there's a way to do that but you can look at the

Re: [GENERAL] phpeclipse debugging & setup

> phpeclipse seems to be working - HOWEVER, it does not ignore php > comments and commented out instructions and the PHP Browser does not > seem to be working. > Such errors as "pg_exec, pg_errormessage() pg_free_result(), > pg_num_rows() & others: supplied argument is not a valid PostgreSQL link

Re: [GENERAL] Multiple result sets

> I'm not sure i got it. You mean like this?: > > import psycopg2 as db > dsn = 'host=localhost dbname=dbname user=user password=passwd' > connection = db.connect(dsn) > cursor = connection.cursor() > > cursor.execute('BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE;'); > rs1 = cursor.execute(query

Re: [GENERAL] Multiple result sets

> > I am not familiar with the python library, but that looks correct > > to me. You can always test it by adding a sleep between your two > > queries and modifying the database from a console connection > > during the sleep. > > > Note that I'm assuming your 5 queries are all read-only selects.

Re: [GENERAL] Multiple result sets

2008/6/1 Adam Rich <[EMAIL PROTECTED]>: > >> >> I need that 5 queries, fired from the same ajax request to a web >> >> python application, see the same database snapshot. The driver is >> >> psycopg2. >> >> >> >> Since postgresql 8.2 functions can't return multiple result sets >> >> what would be t

Re: [GENERAL] Multiple result sets

On Sun, 1 Jun 2008 15:36:14 -0500 "Adam Rich" <[EMAIL PROTECTED]> wrote: > I am not familiar with the python library, but that looks correct > to me. You can always test it by adding a sleep between your two > queries and modifying the database from a console connection > during the sleep. > Note

Re: [GENERAL] Multiple result sets

> >> I need that 5 queries, fired from the same ajax request to a web > >> python application, see the same database snapshot. The driver is > >> psycopg2. > >> > >> Since postgresql 8.2 functions can't return multiple result sets > >> what would be the best aproach? > >> > > You want to set your

Re: [GENERAL] Multiple result sets

2008/6/1 Adam Rich <[EMAIL PROTECTED]>: > >> I need that 5 queries, fired from the same ajax request to a web >> python application, see the same database snapshot. The driver is >> psycopg2. >> >> Since postgresql 8.2 functions can't return multiple result sets what >> would be the best aproach? >

Re: [GENERAL] Multiple result sets

> I need that 5 queries, fired from the same ajax request to a web > python application, see the same database snapshot. The driver is > psycopg2. > > Since postgresql 8.2 functions can't return multiple result sets what > would be the best aproach? > You want to set your transaction isolation

Re: [GENERAL] Multiple result sets

Clodoaldo <[EMAIL PROTECTED]> writes: > I need that 5 queries, fired from the same ajax request to a web > python application, see the same database snapshot. serializable transaction? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

[GENERAL] Multiple result sets

I need that 5 queries, fired from the same ajax request to a web python application, see the same database snapshot. The driver is psycopg2. Since postgresql 8.2 functions can't return multiple result sets what would be the best aproach? All 5 queries return 2 columns but they are different types

Re: [GENERAL] Defining character sets for indicidual fields

Hi, Steve Atkins wrote: On May 31, 2008, at 6:22 PM, Ram Ravichandran wrote: Hi, By default, my postgresql server is set to use UTF8 character set. I was wondering if there is any way to make sure that certain fields like url etc. only makes use of ascii. My main aim is to save space by u