[GENERAL] pg-admin development snapshots

2012-03-20 Thread Andy Chambers
Hi, The link[1] for the development snapshots of pg-admin as advertised here [2] seems to be broken. Are these snapshots hosted somewhere else these days or are they no longer produced. I have a colleague who's bravely switching from SQL Server to Postgresql who'd really like to use the new

Re: [GENERAL] pg-admin development snapshots

2012-03-20 Thread Guillaume Lelarge
Hi, On Tue, 2012-03-20 at 16:01 -0400, Andy Chambers wrote: [...] The link[1] for the development snapshots of pg-admin as advertised here [2] seems to be broken. Are these snapshots hosted somewhere else these days or are they no longer produced. They are no longer produced. I'll fix the

Re: [GENERAL] pg-admin development snapshots

2012-03-20 Thread Andy Chambers
On Tue, Mar 20, 2012 at 4:53 PM, Guillaume Lelarge guilla...@lelarge.info wrote: Hi, On Tue, 2012-03-20 at 16:01 -0400, Andy Chambers wrote: [...] The link[1] for the development snapshots of pg-admin as advertised here [2] seems to be broken.  Are these snapshots hosted somewhere else

Re: [GENERAL] pg-admin development snapshots

2012-03-20 Thread Guillaume Lelarge
On Tue, 2012-03-20 at 17:17 -0400, Andy Chambers wrote: On Tue, Mar 20, 2012 at 4:53 PM, Guillaume Lelarge guilla...@lelarge.info wrote: Hi, On Tue, 2012-03-20 at 16:01 -0400, Andy Chambers wrote: [...] The link[1] for the development snapshots of pg-admin as advertised here [2]

Re: [GENERAL] PG Admin

2007-08-04 Thread Andrei Kovalevski
Bob Pawley wrote: Can anyone tell me why a table developed through the PG Admin interface isn't found by SQL when accessing it through the SQL interface?? Bob Pawley 1) Are you sure you are connecting to the same database? 2) What kind of SQL interface you are using? Andrei.

[GENERAL] PG Admin

2007-07-31 Thread Bob Pawley
Can anyone tell me why a table developed through the PG Admin interface isn't found by SQL when accessing it through the SQL interface?? Bob Pawley

Re: [GENERAL] PG Admin

2007-07-31 Thread Raymond O'Donnell
On 31/07/2007 16:55, Bob Pawley wrote: Can anyone tell me why a table developed through the PG Admin interface isn't found by SQL when accessing it through the SQL interface?? Hi Bob, No reason that I can think ofcan you describe *IN DETAIL* the steps you followed and the result? Ray.

Re: [GENERAL] PG Admin

2007-07-31 Thread Luca Ferrari
On Tuesday 31 July 2007 Bob Pawley's cat, walking on the keyboard, wrote: Can anyone tell me why a table developed through the PG Admin interface isn't found by SQL when accessing it through the SQL interface?? Maybe it is a problem of case-sensitive names? Check in the table definition of

Re: [GENERAL] PG Admin

2007-07-31 Thread Merlin Moncure
On 7/31/07, Bob Pawley [EMAIL PROTECTED] wrote: Can anyone tell me why a table developed through the PG Admin interface isn't found by SQL when accessing it through the SQL interface?? Bob Pawley likely issues: in the wrong schema in the wrong database in the wrong host :-) merlin

Re: [GENERAL] PG Admin

2006-12-13 Thread Brandon Aiken
To: Berend Tober Cc: pgsql general Subject: Re: [GENERAL] PG Admin I am talking about designing the control system. No one makes a perfect design at first go. Devices are deleted and others added. Until the end of the design stage the numbers need to be sequential with no gaps. After the design

Re: [GENERAL] PG Admin

2006-12-13 Thread Merlin Moncure
On 12/4/06, Bob Pawley [EMAIL PROTECTED] wrote: Your missing the point. I am creating a design system for industrial control. The control devices need to be numbered. The numbers need to be sequential. If the user deletes a device the numbers need to regenerate to again become sequential and

Re: [GENERAL] PG Admin

2006-12-13 Thread Gurjeet Singh
On 12/4/06, Bob Pawley [EMAIL PROTECTED] wrote: Your missing the point. I am creating a design system for industrial control. The control devices need to be numbered. The numbers need to be sequential. If the user deletes a device the numbers need to regenerate to again become sequential

Re: [GENERAL] PG Admin

2006-12-06 Thread Bob Pawley
Sent: Monday, December 04, 2006 10:43 AM Subject: Re: [GENERAL] PG Admin Bob Pawley wrote: That's what they are doing. That is also what I am looking for, if it is accessable. If so, I can use that information to add a sequential numerical element to my information that doesn't have

Re: [GENERAL] PG Admin

2006-12-05 Thread Dave Page
Bob Pawley wrote: This is basically what I have done. However it is not particularly stable and is inelegant. The serial number is close to what I need except it becomes tied to the information. The row numbering on the PG Admin version 1.6.1 performs the same operation that I am looking

Re: [GENERAL] PG Admin

2006-12-05 Thread Alban Hertroys
Bob Pawley wrote: I'm sure that PG Admin just generates the numbers in the GUI as it displays them (as they're meaningless as persistent data). Perhaps - but they aren't necessarily meaningless as pure information. Can't you just do the same - generate the numbers within your application -

Re: [GENERAL] PG Admin

2006-12-05 Thread Bob Pawley
PROTECTED] Cc: Steve Atkins [EMAIL PROTECTED]; PgSQL General pgsql-general@postgresql.org Sent: Tuesday, December 05, 2006 1:31 AM Subject: Re: [GENERAL] PG Admin Bob Pawley wrote: I'm sure that PG Admin just generates the numbers in the GUI as it displays them (as they're meaningless as persistent

Re: [GENERAL] PG Admin

2006-12-05 Thread Guy Rouillier
Bob Pawley wrote: Your missing the point. I am creating a design system for industrial control. The control devices need to be numbered. The numbers need to be sequential. If the user deletes a device the numbers need to regenerate to again become sequential and gapless. How many control

Re: [GENERAL] PG Admin

2006-12-05 Thread Martijn van Oosterhout
On Tue, Dec 05, 2006 at 07:55:35AM -0800, Bob Pawley wrote: Perhaps I can - it will be learning curve for me. However, the development would be so much easier to apply if it were available in PostgreSQL in a form similar to generating a serial column. Your assertion that it would be easy is

[GENERAL] PG Admin

2006-12-04 Thread Bob Pawley
I just installed PostgreSQL 8.1 and PG Admin 1.6.1 . These versions have a sequential column, that is not part of the table, identifying the rows. Is there any method of accessing those numbers and identifying them with elements within the table?? Bob Pawley

Re: [GENERAL] PG Admin

2006-12-04 Thread Richard Huxton
Bob Pawley wrote: I just installed PostgreSQL 8.1 and PG Admin 1.6.1 . These versions have a sequential column, that is not part of the table, identifying the rows. Is there any method of accessing those numbers and identifying them with elements within the table?? Are you sure it's not just

Re: [GENERAL] PG Admin

2006-12-04 Thread Bob Pawley
@archonet.com To: Bob Pawley [EMAIL PROTECTED] Cc: Postgresql pgsql-general@postgresql.org Sent: Monday, December 04, 2006 9:39 AM Subject: Re: [GENERAL] PG Admin Bob Pawley wrote: I just installed PostgreSQL 8.1 and PG Admin 1.6.1 . These versions have a sequential column, that is not part

Re: [GENERAL] PG Admin

2006-12-04 Thread Tony Caduto
Bob Pawley wrote: That's what they are doing. That is also what I am looking for, if it is accessable. If so, I can use that information to add a sequential numerical element to my information that doesn't have the restrictions of a serial column. Bob Hi Bob, Well, if you create your

Re: [GENERAL] PG Admin

2006-12-04 Thread Bob Pawley
Subject: Re: [GENERAL] PG Admin Bob Pawley wrote: That's what they are doing. That is also what I am looking for, if it is accessable. If so, I can use that information to add a sequential numerical element to my information that doesn't have the restrictions of a serial column. Bob Hi Bob

Re: [GENERAL] PG Admin

2006-12-04 Thread Raymond O'Donnell
On 4 Dec 2006 at 15:40, Bob Pawley wrote: When a row is deleted the serial number and oid are also deleted. The sequence then has gaps which are inadmissible. This is an issue which has come up at various times on this list in the past - it may be worth having a look through the archives.

Re: [GENERAL] PG Admin

2006-12-04 Thread Scott Marlowe
On Mon, 2006-12-04 at 17:53, Raymond O'Donnell wrote: On 4 Dec 2006 at 15:40, Bob Pawley wrote: When a row is deleted the serial number and oid are also deleted. The sequence then has gaps which are inadmissible. This is an issue which has come up at various times on this list in the

Re: [GENERAL] PG Admin

2006-12-04 Thread Bob Pawley
- perhaps. Bob - Original Message - From: Raymond O'Donnell [EMAIL PROTECTED] To: pgsql-general@postgresql.org Sent: Monday, December 04, 2006 3:53 PM Subject: Re: [GENERAL] PG Admin On 4 Dec 2006 at 15:40, Bob Pawley wrote: When a row is deleted the serial number and oid are also

Re: [GENERAL] PG Admin

2006-12-04 Thread Bob Pawley
- From: Scott Marlowe [EMAIL PROTECTED] To: Raymond O'Donnell [EMAIL PROTECTED] Cc: pgsql general pgsql-general@postgresql.org Sent: Monday, December 04, 2006 4:09 PM Subject: Re: [GENERAL] PG Admin On Mon, 2006-12-04 at 17:53, Raymond O'Donnell wrote: On 4 Dec 2006 at 15:40, Bob Pawley wrote

Re: [GENERAL] PG Admin

2006-12-04 Thread Steve Atkins
On Dec 4, 2006, at 3:53 PM, Raymond O'Donnell wrote: On 4 Dec 2006 at 15:40, Bob Pawley wrote: When a row is deleted the serial number and oid are also deleted. The sequence then has gaps which are inadmissible. This is an issue which has come up at various times on this list in the past -

Re: [GENERAL] PG Admin

2006-12-04 Thread Bob Pawley
Perhaps - but they aren't necessarily meaningless as pure information. Bob - Original Message - From: Steve Atkins [EMAIL PROTECTED] To: PgSQL General pgsql-general@postgresql.org Sent: Monday, December 04, 2006 4:33 PM Subject: Re: [GENERAL] PG Admin On Dec 4, 2006, at 3:53 PM

Re: [GENERAL] PG Admin

2006-12-04 Thread Richard Broersma Jr
Your missing the point. I am creating a design system for industrial control. The control devices need to be numbered. The numbers need to be sequential. If the user deletes a device the numbers need to regenerate to again become sequential and gapless. Is it a bill of material line

Re: [GENERAL] PG Admin

2006-12-04 Thread Berend Tober
Bob Pawley wrote: Your missing the point. I am creating a design system for industrial control. The control devices need to be numbered. The numbers need to be sequential. If the user deletes a device the numbers need to regenerate to again become sequential and gapless. Could you explain

Re: [GENERAL] PG Admin

2006-12-04 Thread Adrian Klaver
On Monday 04 December 2006 04:17 pm, Bob Pawley wrote: Your missing the point. I am creating a design system for industrial control. The control devices need to be numbered. The numbers need to be sequential. If the user deletes a device the numbers need to regenerate to again become

Re: [GENERAL] PG Admin

2006-12-04 Thread Bob Pawley
: [GENERAL] PG Admin Bob Pawley wrote: Your missing the point. I am creating a design system for industrial control. The control devices need to be numbered. The numbers need to be sequential. If the user deletes a device the numbers need to regenerate to again become sequential and gapless. Could

Re: [GENERAL] PG Admin

2006-12-04 Thread Adrian Klaver
- Original Message - From: Berend Tober [EMAIL PROTECTED] To: Bob Pawley [EMAIL PROTECTED] Cc: pgsql general pgsql-general@postgresql.org Sent: Monday, December 04, 2006 7:15 PM Subject: Re: [GENERAL] PG Admin Bob Pawley wrote: Your missing the point. I am creating a design

Re: [GENERAL] PG Admin

2006-12-04 Thread Michael Glaesemann
On Dec 5, 2006, at 13:08 , Bob Pawley wrote: The physical devices don't get numbered until the design is established and stable. This is known as the construction stage. I guess I would set up a couple of tables to track this ordering independently of the devices themselves. Rough schema:

[Fwd: Re: [GENERAL] PG Admin]

2006-12-04 Thread Guy Rouillier
Bob Pawley wrote: Your missing the point. I am creating a design system for industrial control. The control devices need to be numbered. The numbers need to be sequential. If the user deletes a device the numbers need to regenerate to again become sequential and gapless. How many control

[GENERAL] pg-admin

2006-03-06 Thread Mary Adel
I am a new user for Pg-admin and i just inatlled it on Linux and i need to connect it on server but their is error that comes up to me which is: Is server running on host and accepting TCP connection on the port 5432 Thanks, mary ---(end of

Re: [GENERAL] pg-admin

2006-03-06 Thread Tino Wildenhain
Mary Adel schrieb: I am a new user for Pg-admin and i just inatlled it on Linux and i need to connect it on server but their is error that comes up to me which is: Is server running on host and accepting TCP connection on the port 5432 Which part of that message dont you understand? Make

Re: [GENERAL] pg admin III and primary keys (for backup/restore)

2006-01-05 Thread Richard Huxton
Assad Jarrahian wrote: Environment: Deployed on Debian. Test and Development on Windows. Using pg_admin III and Postgresql 8.1 (both test and development). I want to backup Development and restore it in test and vice-versa. So when I do a backup of the db (in PGAdmin III), it backs it up. But

[GENERAL] pg admin III and primary keys (for backup/restore)

2006-01-04 Thread Assad Jarrahian
Environment: Deployed on Debian. Test and Development on Windows. Using pg_admin III and Postgresql 8.1 (both test and development). I want to backup Development and restore it in test and vice-versa. So when I do a backup of the db (in PGAdmin III), it backs it up. But when I restore it, all