-----Original Message----- From: "Edward Di Geronimo Jr."<[EMAIL PROTECTED]> 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 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@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 [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster