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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: Paste rows rough patch



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

Yes - in particular the quote settings - I have lots of data containing
newlines for example, which this won't work with for obvious reasons.

Ok, that's done. Seems to work ok for me, but I don't have any real data that would stress it to test with, just a few test rows.

OID columns should be ignored, but serial columns should be optional
imho - just a simple 'The data you are pasting include values that will
be inserted into a serial column. Do you want to skip the serial valules
and allow new ones to be assigned? Y/N' prompt at paste time.

I didn't look too hard, but it looked like OIDs are always going to be the first column when present. Based on that, I updated the patch to skip the first column when there are OIDs.

I'm probably not going to have time to deal with the serial columns part in the next few days. The patch should be usable now if people feel like testing it.

Ed

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

Attachment: pasterows-v2.patch
Description: Text Data



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group