On Tue, 2012-03-20 at 17:17 -0400, Andy Chambers wrote:
> On Tue, Mar 20, 2012 at 4:53 PM, Guillaume Lelarge
> 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
On Tue, Mar 20, 2012 at 4:53 PM, Guillaume Lelarge
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 these days or are
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
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 scri
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.
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
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 pg
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.
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
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
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
f Bob Pawley
Sent: Monday, December 04, 2006 10:40 PM
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 numb
OTECTED]>;
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
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 i
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 de
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Steve Atkins" <[EMAIL PROTECTED]>; "PgSQL General"
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
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
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 f
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 de
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:
tt Marlowe"
<[EMAIL PROTECTED]>; "Raymond O'Donnell" <[EMAIL PROTECTED]>
Sent: Monday, December 04, 2006 7:43 PM
Subject: Re: [GENERAL] PG Admin
On Monday 04 December 2006 04:17 pm, Bob Pawley wrote:
Your missing the point.
I am creating a design system for indu
r"
<[EMAIL PROTECTED]>
Sent: Monday, December 04, 2006 7:58 PM
Subject: Re: [GENERAL] PG Admin
>
- Original Message -
From: "Berend Tober" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "pgsql general"
Sent: M
>
> - Original Message -
> From: "Berend Tober" <[EMAIL PROTECTED]>
> To: "Bob Pawley" <[EMAIL PROTECTED]>
> Cc: "pgsql general"
> Sent: Monday, December 04, 2006 7:15 PM
> Subject: Re: [GENERAL] PG Admin
>
> >
of no consequence - as long as the
totallity of numbers assigned are sequential and gapless.
Bob
- Original Message -
From: "Berend Tober" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "pgsql general"
Sent: Monday, December 0
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
>
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 wha
> 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 nu
Perhaps - but they aren't necessarily meaningless as pure information.
Bob
- Original Message -
From: "Steve Atkins" <[EMAIL PROTECTED]>
To: "PgSQL General"
Sent: Monday, December 04, 2006 4:33 PM
Subject: Re: [GENERAL] PG Admin
On Dec 4, 2006
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 -
-
From: "Scott Marlowe" <[EMAIL PROTECTED]>
To: "Raymond O'Donnell" <[EMAIL PROTECTED]>
Cc: "pgsql general"
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 D
etter - perhaps.
Bob
- Original Message -
From: "Raymond O'Donnell" <[EMAIL PROTECTED]>
To:
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
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
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. He
6 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 the restrictions of a serial co
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 tabl
rd Huxton"
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Postgresql"
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 no
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
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
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
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 broadcast)-
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
w
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 pri
42 matches
Mail list logo
