Skip site navigation (1) Skip section navigation (2)

Re: Lightspeed for frmQuery and other issues.

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: <edigeronimo(at)xtracards(dot)com>,<pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: Lightspeed for frmQuery and other issues.
Date: 2006-04-30 17:18:40
Message-ID: 008301c66c7a$27ea29ab$6a01a8c0@valehousing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-hackers

-----Original Message-----
From: "Edward Di Geronimo Jr."<edigeronimo(at)xtracards(dot)com>
Sent: 30/04/06 16:20:56
To: "pgadmin-hackers(at)postgresql(dot)org"<pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: [pgadmin-hackers] Lightspeed for frmQuery and other issues.

> Enterprise Manager handles the issue by skipping over any identity  
> (serial) columns when pasting rows. That's how I figured it should be  
> done. OID's would of course be treated the same way.

I'd like serials to be optional - for example, you could pull some rows out, manipulate in excel, then bung them back with the same IDs. OIDs needn't be of course.

>  I was also planning on looking into it when I had a chance to get back  
> to pgAdmin. If you want, I should be able to look into it midweek or  
> so. Let me know if you want to do it or if I should.

If you can, that'd be good. There's plenty more for me to do :-)

/D

-----Unmodified Original Message-----
Quoting Dave Page <dpage(at)vale-housing(dot)co(dot)uk>:

> Pasteing? I dunno. Anyway in MS Query Analyser you can paste entire   
> rows, or sets of new rows into a table. I had been planning on   
> looking at something similar, but with an additional option (offered  
>  at paste time, when necessary) to skip OID/serial columns.

Enterprise Manager handles the issue by skipping over any identity  
(serial) columns when pasting rows. That's how I figured it should be  
done. OID's would of course be treated the same way.

I was also planning on looking into it when I had a chance to get back  
to pgAdmin. If you want, I should be able to look into it midweek or  
so. Let me know if you want to do it or if I should.

Ed

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.



---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
       message can get through to the mailing list cleanly

pgadmin-hackers by date

Next:From: Andreas PflugDate: 2006-04-30 17:43:55
Subject: Re: Lightspeed for frmQuery and other issues.
Previous:From: Dave PageDate: 2006-04-30 17:14:41
Subject: Re: Lightspeed for frmQuery and other issues.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group