Re: [pgadmin-support] pg admin bug - view data

2003-11-22 Thread Dave Page
> -Original Message- > From: Christopher Kings-Lynne [mailto:[EMAIL PROTECTED] > Sent: 22 November 2003 07:54 > To: Dave Page > Cc: Andreas Pflug; Michael Shapiro; [EMAIL PROTECTED] > Subject: Re: [pgadmin-support] pg admin bug - view data > > > >>Ac

Re: [pgadmin-support] pg admin bug - view data

2003-11-22 Thread Christopher Kings-Lynne
We have Find Object in pga2, though it does little more than search the object heirarchy (everything in pga2 is driven through pgSchema, which is a self-building object hierarchy - basically what you see on the treeview & listview, plus create() and drop() etc. in the relevant places) Ours is a gig

Re: [pgadmin-support] pg admin bug - view data

2003-11-22 Thread Christopher Kings-Lynne
Actually, are you guys BSD licensed or GPL'd? phpPgAdmin is GPL'd. Neither, we use the Artistic Licence, the same as Perl. Does that mean our codebases are compatible or not? If so, to what degree? Chris ---(end of broadcast)--- TIP 3: if posti

Re: [pgadmin-support] pg admin bug - view data

2003-11-21 Thread Dave Page
> -Original Message- > From: Christopher Kings-Lynne [mailto:[EMAIL PROTECTED] > Sent: 22 November 2003 02:15 > To: Andreas Pflug > Cc: Michael Shapiro; [EMAIL PROTECTED] > Subject: Re: [pgadmin-support] pg admin bug - view data > > > You know, phpPgAdmi

Re: [pgadmin-support] pg admin bug - view data

2003-11-21 Thread Christopher Kings-Lynne
Yes, you're right, that's a bug; fixed in cvs. Though I consider a table without PK or OID buggy too... :-) We might expand pgAdmin3 to use a unique key as PK replacement. phpPgAdmin does the following in order to find a unique row identifier: 1. Looks for a PK 2. Looks for a Unique index. If on

Re: [pgadmin-support] pg admin bug - view data

2003-11-21 Thread Andreas Pflug
Michael Shapiro wrote: I think there is a bug in the pgadmin view data option for a table. If the table does not have a primary key, pgadmin issues an invalid select. Here is the table definition: Yes, you're right, that's a bug; fixed in cvs. Though I consider a table without PK or OID buggy t

[pgadmin-support] pg admin bug - view data

2003-11-21 Thread Michael Shapiro
I think there is a bug in the pgadmin view data option for a table. If the table does not have a primary key, pgadmin issues an invalid select. Here is the table definition: CREATE TABLE data_tbl ( packet_rec_id numeric(38) NOT NULL, tag varchar(32) NOT NULL, subtag varchar(32), seq int4