Обсуждение: bug in query tool when parsing
Hi! I'm experiencing another bug in PgAdmin. I'm trying to give some sql commands to PgAdmin but they are not pasted into Query window. I did a pg_dump of my database and pg_largeobject created a series of SELECT lowrite commands. Unfortunately some of this commands are shown like SELECT lowrite(0, ); instead of SELECT lowrite(0, 'some random content'); Regards, Rikard
Rikard Pavelic wrote: > Hi! > > I'm experiencing another bug in PgAdmin. > > I'm trying to give some sql commands to PgAdmin > but they are not pasted into Query window. > > I did a pg_dump of my database and > pg_largeobject created a series of SELECT lowrite commands. > > Unfortunately some of this commands are shown like > SELECT lowrite(0, ); > instead of > SELECT lowrite(0, 'some random content'); I assume you are copying and pasting the text from another editor? If so, it might be either that or pgAdmin mucking up the encoding. Can you see the text if you open the file instead of pasting the text in? Regards, Dave.
Dave Page wrote: > Rikard Pavelic wrote: > >> Hi! >> >> I'm experiencing another bug in PgAdmin. >> >> I'm trying to give some sql commands to PgAdmin >> but they are not pasted into Query window. >> >> I did a pg_dump of my database and >> pg_largeobject created a series of SELECT lowrite commands. >> >> Unfortunately some of this commands are shown like >> SELECT lowrite(0, ); >> instead of >> SELECT lowrite(0, 'some random content'); >> > > I assume you are copying and pasting the text from another editor? If > so, it might be either that or pgAdmin mucking up the encoding. Can you > see the text if you open the file instead of pasting the text in? > > Regards, Dave. > > The results are the same. It doesn't matter if I paste it or open a file from PgAdmin. Regards, Rikard
Rikard Pavelic wrote: > The results are the same. > It doesn't matter if I paste it or open a file from PgAdmin. Please send a sample file for testing. Regards Dave
Rikard Pavelic wrote: > Dave Page wrote: >> Please send a sample file for testing. >> >> Regards Dave >> > > Here it is. Thanks. It seems that the Styled Text Control simply can't handle lines that long. On Windows the text is there (and will be sent to the server is executed) but is not rendered correctly. On Mac, the application just grinds to a halt. Realistically I think this falls into the "Don't do that" category. If I log this upstream, if I get a response at all (it seems like no-one fully maintains wxSTC these days) I'll bet they'll just say its not designed for that sort of text. I'll log it anyway though... Regards, Dave.