Re: [pgadmin-support] Problem creating backup of schema
I sure mean pgAdmin :) I rename it via pgAdmin's interface what is the sql command to rename a schame that way? /Niklas > Date: Tue, 1 Jun 2010 15:28:28 +0100 > From: r...@iol.ie > To: nikl...@hotmail.com > CC: pgadmin-support@postgresql.org > Subject: Re: [pgadmin-support] Problem creating backup of schema > > On 01/06/2010 15:16, Niklas Olsson wrote: > > I run windows xp, pgdemo 1.10.3. > > I'm sure you mean pgAdmin. :-) > > > I have a schema in one database, export that one. > > Restore in into another database. > > Rename the schema, try to make a backup of it and get the error > > > > pg_dump: No matching schemas were found > > pg_dump: *** aborted because of error > > How are you renaming it? Via pgAdmin's interface (right click -> > properties, etc) or with SQL commands though an edit window or psql? If > the latter, you'll need to refresh pgAdmin's view of the schema after > you rename it. > > Ray. > > > -- > Raymond O'Donnell :: Galway :: Ireland > r...@iol.ie > > -- > Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgadmin-support Chatta från inkorgen. Se möjligheterna med Hotmail! Klicka här! _ Dela kalender. Se möjligheterna med Hotmail! http://www.microsoft.com/sverige/windows/windowslive/thenewbusy.aspx
Re: [pgadmin-support] Problem creating backup of schema
On 03/06/2010 08:22, Niklas Olsson wrote: > > > I sure mean pgAdmin :) :-) > I rename it via pgAdmin's interface > what is the sql command to rename a schame that way? Here you go: http://www.postgresql.org/docs/8.4/static/sql-alterschema.html However, if you're renaming via pgAdmin, then my theory is incorrect - I only ran into problems when I altered things outside of pgAdmin, rendering pgAdmin's view of them invalid. Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Re: [pgadmin-support] sudden program termination: no warning, error, or crash
On pgAdminIII 1.12.0 beta 1, I've been having this happen really frequently. One table I can't even edit--as soon as I type a single character in a column to make a new row, it crash-vanishes every time. Actually, it does an odd thing before vanishing, creating a set of horizontal and vertical scrollbars in the upper-left of the data grid (over top the data), freezes a couple seconds, then all the pgAdmin windows disappear. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Re: [pgadmin-support] sudden program termination: no warning, error, or crash
On Jun 3, 10:20 am, Kev wrote: > On pgAdminIII 1.12.0 beta 1, I've been having this happen really > frequently. One table I can't even edit--as soon as I type a single > character in a column to make a new row, it crash-vanishes every > time. Actually, it does an odd thing before vanishing, creating a set > of horizontal and vertical scrollbars in the upper-left of the data > grid (over top the data), freezes a couple seconds, then all the > pgAdmin windows disappear. Er, no vertical scrollbar. Here's a screenshot (I clicked the name field and typed a letter): http://www.freeimagehosting.net/uploads/9f6a66afb9.png Also, here's the app log entry: Event Type: Error Event Source: Application Error Event Category: (100) Event ID: 1000 Date: 2010-06-03 Time: 10:23:05 AM User: N/A Computer: IN Description: Faulting application pgAdmin3.exe, version 1.12.0.1, faulting module unknown, version 0.0.0.0, fault address 0x. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Data: : 41 70 70 6c 69 63 61 74 Applicat 0008: 69 6f 6e 20 46 61 69 6c ion Fail 0010: 75 72 65 20 20 70 67 41 ure pgA 0018: 64 6d 69 6e 33 2e 65 78 dmin3.ex 0020: 65 20 31 2e 31 32 2e 30 e 1.12.0 0028: 2e 31 20 69 6e 20 75 6e .1 in un 0030: 6b 6e 6f 77 6e 20 30 2e known 0. 0038: 30 2e 30 2e 30 20 61 74 0.0.0 at 0040: 20 6f 66 66 73 65 74 20offset 0048: 30 30 30 30 30 30 30 30 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
