Re: Lightspeed for frmQuery and other issues. - Mailing list pgadmin-hackers

From Dave Page
Subject Re: Lightspeed for frmQuery and other issues.
Date
Msg-id 008301c66c7a$27ea29ab$6a01a8c0@valehousing.co.uk
Whole thread Raw
In response to Lightspeed for frmQuery and other issues.  (Andreas Pflug <pgadmin@pse-consulting.de>)
List pgadmin-hackers

-----Original Message-----
From: "Edward Di Geronimo Jr."<edigeronimo@xtracards.com>
Sent: 30/04/06 16:20:56
To: "pgadmin-hackers@postgresql.org"<pgadmin-hackers@postgresql.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
withthe 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@vale-housing.co.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@postgresql.org so that your
       message can get through to the mailing list cleanly

pgadmin-hackers by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Lightspeed for frmQuery and other issues.
Next
From: Andreas Pflug
Date:
Subject: Re: Lightspeed for frmQuery and other issues.