[pgadmin-support]

2002-12-22 Thread jsmateo
unsubscribe Jojo S. Mateo Database Administrator ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[pgadmin-support] unsubscribe

2002-12-22 Thread ELECTRONICS
unsubscribe ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[pgadmin-support] unsubscribe

2002-12-22 Thread ELECTRONICS
---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[pgadmin-support]

2002-12-22 Thread ELECTRONICS
unsubscribe ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[pgadmin-support]

2002-12-22 Thread ELECTRONICS
unsubscribe ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[pgadmin-support]

2002-12-22 Thread ELECTRONICS
unsubscribe ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

Re: [pgadmin-support] Can't connect on Windows

2002-12-22 Thread Reshat Sabiq
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Dave Page Sent: Sunday, December 22, 2002 2:25 PM To: Reshat Sabiq; [EMAIL PROTECTED] Subject: Re: [pgadmin-support] Can't connect on Windows --  The 'postgres' user is whoever ran initdb.  -- Fro

Re: [pgadmin-support] Access-postgreSQL migration (extra invalid foreign key added)

2002-12-22 Thread Reshat Sabiq
-Original Message- From: Dave Page [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 22, 2002 2:31 PM To: Reshat Sabiq; [EMAIL PROTECTED] Subject: RE: [pgadmin-support] Access-postgreSQL migration (extra invalid foreign key added) --- It's certainly possible. The Migration Wizard i

Re: [pgadmin-support] Can't connect on Windows

2002-12-22 Thread Reshat Sabiq
Note, in particular, that those steps have you run initdb a second time to create the empty database owned by the 'postgres' user, a necessary step for running postgresql as a service associated with that postgres user. Yes, I have shortcut to the readme, cause I've been using it so much recently.

[pgadmin-support]

2002-12-22 Thread ELECTRONICS
unsubscribe ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

[pgadmin-support] pgAdminII 1.4.12 crash with PostgreSQL 7.3

2002-12-22 Thread Didier Moens
Hi, My PostgreSQL 7.3 setup seems to crash all versions of pgAdminII (tested versions : 1.2, 1.4.2, 1.4.12), immediately after pgAdmin2 connects to the database. (Connections to pre-7.3 PostgreSQL db's work OK). I tested this on both WinME and Win2K/SP3, with both an older and the most rece

Re: [pgadmin-support] Access-postgreSQL migration (extra invalid foreign key added)

2002-12-22 Thread Dave Page
> -Original Message- > From: Reshat Sabiq [mailto:[EMAIL PROTECTED]] > Sent: 22 December 2002 14:00 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] Access-postgreSQL migration (extra > invalid foreign key added) > > > Hi, > > I have an Access DB, that's been running OK in Access

Re: [pgadmin-support] Can't connect on Windows

2002-12-22 Thread Dave Page
Title: Message   -Original Message-From: Reshat Sabiq [mailto:[EMAIL PROTECTED]] Sent: 22 December 2002 01:51To: [EMAIL PROTECTED]Subject: [pgadmin-support] Can't connect on Windows I installed cygwin-based postgreSQL. I have not been able yet to start it as a serv

Re: [pgadmin-support] schemas (public, custom...)

2002-12-22 Thread Dave Page
> -Original Message- > From: Reshat Sabiq [mailto:[EMAIL PROTECTED]] > Sent: 22 December 2002 14:52 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] schemas (public, custom...) > > > What is the significance of public schema (for migration and > otherwise). Is it optional to selec

Re: [pgadmin-support] PGMigration and foriegn Keys

2002-12-22 Thread Dave Page
> -Original Message- > From: Alaric Dailey [mailto:[EMAIL PROTECTED]] > Sent: 20 December 2002 21:59 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] PGMigration and foriegn Keys > > > I need foreign keys longer than 32 characters and the new > pgMigration tool is truncating the n

Re: [pgadmin-support] Can't connect on Windows

2002-12-22 Thread fcy
On Sat, Dec 21, 2002 at 08:51:08PM -0500, Reshat Sabiq wrote: > I installed cygwin-based postgreSQL. I have not been able yet to start > it as a service (net start postmaster), apparently because of > permissions problems. I'm waiting on some suggestions, hopefully, about > that. Have you followed

[pgadmin-support] schemas (public, custom...)

2002-12-22 Thread Reshat Sabiq
What is the significance of public schema (for migration and otherwise). Is it optional to select a schema? I believe it is for security constraints. I'm just not used to working with SQL statements like: public."TableName" What schema should I have for a DB that will be on the web mostly for queri

Re: [pgadmin-support] Access-postgreSQL migration (extra invalid foreign key added)

2002-12-22 Thread Reshat Sabiq
Actually exactly 1 out of every 10 foreign keys couldn't be re-created. So that means almost everything is automatic. And that is already good enough for production. Nevertheless, I'd appreciate any feedback on the problem below. Thanks, r. -Original Message- From: [EMAIL PROTECTED] [mail

[pgadmin-support] Access-postgreSQL migration (extra invalid foreign key added)

2002-12-22 Thread Reshat Sabiq
Hi, I have an Access DB, that's been running OK in Access, and as part of a web app based on JDBC. When I convert it to postreSQL, all table creation, data insertion, and primary key creation statements complete just fine. However, the first foreign key attempt fails: Creating Foreign Key: Compa