Re: Lightspeed for frmQuery and other issues.

-----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