Thread: Constraint sql in sql pane
Hi folks, new to the list. After searching the archives, I found nothing regarding the following. When selecting a constraint I've configured on a table in the object browser, the sql that creates the constraint is displayed in the sql pane. Where is this sql statement pulled from? Also, while it seems I can highlight contents of the sql pane, I cannot copy it. I've tried pasting into a terminal, and gedit, and what I get is the previous copy done before copying from sql pane. I've tried highlighting, then pasting, highlighting, left mouse, select copy, then pasting, both fail to paste whats supposed to have been copied. I'm doing this in Fedora 14, pgadmin3 versions 1.12.2 and 1.14.0, using Gnome 2.32.0. Thanks -- aRDy Music and Rick Dicaire present: http://www.ardynet.com http://www.ardynet.com:9000/ardymusic.ogg.m3u
On Sun, 2011-10-09 at 18:08 -0400, Rick Dicaire wrote: > Hi folks, new to the list. > After searching the archives, I found nothing regarding the following. > > When selecting a constraint I've configured on a table in the object > browser, the sql that creates the constraint is displayed in the sql > pane. > Where is this sql statement pulled from? > We use the contraint metadata in PostgreSQL catalogs to create it. It's not stored as-is in any PostgreSQL catalogs. > Also, while it seems I can highlight contents of the sql pane, I > cannot copy it. I've tried pasting > into a terminal, and gedit, and what I get is the previous copy done > before copying from sql pane. > I've tried highlighting, then pasting, highlighting, left mouse, > select copy, then pasting, both fail to paste whats supposed to have > been copied. > I'm doing this in Fedora 14, pgadmin3 versions 1.12.2 and 1.14.0, > using Gnome 2.32.0. > I have no issue with this. I select the part of the SQL that I want to copy, right click, choose Copy. And then I can paste anywhere. I tried on pgadmin 1.14 (fedora 15, gnome 3.0). -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
On Mon, Oct 10, 2011 at 4:40 AM, Guillaume Lelarge <guillaume@lelarge.info> wrote: >> Also, while it seems I can highlight contents of the sql pane, I >> cannot copy it. I've tried pasting >> into a terminal, and gedit, and what I get is the previous copy done >> before copying from sql pane. > > I have no issue with this. I select the part of the SQL that I want to > copy, right click, choose Copy. And then I can paste anywhere. Any tips on how I can troubleshoot this then? -- aRDy Music and Rick Dicaire present: http://www.ardynet.com http://www.ardynet.com:9000/ardymusic.ogg.m3u
On Mon, 10 Oct 2011 13:44:42 -0400, Rick Dicaire <kritek@gmail.com> wrote: > On Mon, Oct 10, 2011 at 4:40 AM, Guillaume Lelarge > <guillaume@lelarge.info> wrote: >>> Also, while it seems I can highlight contents of the sql pane, I >>> cannot copy it. I've tried pasting >>> into a terminal, and gedit, and what I get is the previous copy done >>> before copying from sql pane. >> >> I have no issue with this. I select the part of the SQL that I want to >> copy, right click, choose Copy. And then I can paste anywhere. > > Any tips on how I can troubleshoot this then? > Try to do the few steps I said in previous post. And if it doesn't work, nope, no ideas. -- Guillaumehttp://www.postgresql.frhttp://dalibo.com