Not true. Currently, you need either OID *or* a primary key. Obviously,
that id column should get a pk.
We'll extend the grid some time, to accept any other unique keys also.
Still, defining a PK on every table is best practice.
Defining a column as serial does *not* guarantee it's unique!
Rememb
On Feb 17, 2004, at 5:51 PM, Markus Wollny wrote:
The architecture just doesn't fit here - it's two LANs connected over a
VLAN, so the firewall is between us and the open internet, even though
the PG-server is in it's own LAN. I can not fix the firewall, it's not
in my jurisdiction and I cannot tak
Hi!
-UrsprÃngliche Nachricht-
Von: Andreas Pflug
Gesendet: Di 17.02.2004 21:10
An: Dave Page
Cc: Markus Wollny; Josh Endries; [EMAIL PROTECTED]
Betreff: Re: [pgadmin-support] connection dropping continued
Actua
The server is waiting for tcp/ip disconnect, which is
never coming
because the firewall eats this, resulting in backends
waiting to death.
Again: you'll have to request your sysadmin to fix the
firewall, at
least on that pgsql port for
> -Original Message-
> From: Andreas Pflug [mailto:[EMAIL PROTECTED]
> Sent: 17 February 2004 17:42
> To: Markus Wollny
> Cc: Josh Endries; [EMAIL PROTECTED]
> Subject: Re: [pgadmin-support] connection dropping continued
>
> >
> >I wouldn't call that malfunctioning,
>
> So call it ill
Dave Page wrote:
-Original Message-
From: Andreas Pflug [mailto:[EMAIL PROTECTED]
Sent: 17 February 2004 17:42
To: Markus Wollny
Cc: Josh Endries; [EMAIL PROTECTED]
Subject: Re: [pgadmin-support] connection dropping continued
I wouldn't call that malfunctioning,
So call
A. You are correct. Turns out I was failing to define my serial 'id'
attribute as a primary key. My bad. Thanks for the help.
MD
>-Original Message-
>From: Andreas Pflug [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, February 17, 2004 9:15 AM
>To: [EMAIL PROTECTED]
>Cc: [pgADMIN]
>Subject:
Markus Wollny wrote:
Hi!
-Ursprüngliche Nachricht-
Von: Andreas Pflug [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 17. Februar 2004 17:40
An: Josh Endries
Cc: [EMAIL PROTECTED]; Markus Wollny
Betreff: Re: [pgadmin-support] connection dropping continued
This is *not* an pgAdmin
Matt Doggett wrote:
Ooops. I sent this yesterday to the wrong maillist address. Sorry. I'll
repost here.
MD
-Original Message-
When I create a new table that does not have OIDs (the Has OIDs checkbox
is off and I'm using a serial column type to id my records), then I
CANNOT insert new data
Hi!
> -Ursprüngliche Nachricht-
> Von: Andreas Pflug [mailto:[EMAIL PROTECTED]
> Gesendet: Dienstag, 17. Februar 2004 17:40
> An: Josh Endries
> Cc: [EMAIL PROTECTED]; Markus Wollny
> Betreff: Re: [pgadmin-support] connection dropping continued
> This is *not* an pgAdmin issue, any other
Ooops. I sent this yesterday to the wrong maillist address. Sorry. I'll
repost here.
MD
-Original Message-
When I create a new table that does not have OIDs (the Has OIDs checkbox
is off and I'm using a serial column type to id my records), then I
CANNOT insert new data records using the
Josh Endries wrote:
On Tuesday, February 17, 2004 13:03, Markus Wollny wrote:
Referring to
http://www.mail-archive.com/[EMAIL PROTECTED]/msg02050.html
, I'd like to ask if there's going to be some remedy to the problem any
time in the near future? We're using PGAdmin III and it's really an
extr
On Tuesday, February 17, 2004 13:03, Markus Wollny wrote:
> Referring to
> http://www.mail-archive.com/[EMAIL PROTECTED]/msg02050.html
> , I'd like to ask if there's going to be some remedy to the problem any
> time in the near future? We're using PGAdmin III and it's really an
> extremely useful a
Hello!
Referring to
http://www.mail-archive.com/[EMAIL PROTECTED]/msg02050.html
, I'd like to ask if there's going to be some remedy to the problem any
time in the near future? We're using PGAdmin III and it's really an
extremely useful admin-tool for PostgeSQL, but this issue is really
quite unne
14 matches
Mail list logo
