Re: [GENERAL] noobie question

2013-01-27 Thread Scott Marlowe
On Thu, Jan 24, 2013 at 12:03 PM, Steve Clark wrote: > On 01/24/2013 01:06 PM, Chris Angelico wrote: >> >> On Fri, Jan 25, 2013 at 4:45 AM, Steve Clark wrote: >>> >>> Thanks All, >>> >>> This is for a few very small tables, less 100 records each, that a user >>> can >>> delete and insert records

Re: [GENERAL] noobie question

2013-01-24 Thread Bruno Wolff III
On Thu, Jan 24, 2013 at 14:03:33 -0500, Steve Clark wrote: It is really called rule_num and relates to "in what order firewall rules are applied". And it used to allow the user to place the firewall rules where they want them in relation to other rules. If you just need ordering, you coul

Re: [GENERAL] noobie question

2013-01-24 Thread Steve Clark
On 01/24/2013 01:06 PM, Chris Angelico wrote: On Fri, Jan 25, 2013 at 4:45 AM, Steve Clark wrote: Thanks All, This is for a few very small tables, less 100 records each, that a user can delete and insert records into based on the "id" which is displayed in a php generated html screen. The tabl

Re: [GENERAL] noobie question

2013-01-24 Thread Chris Angelico
On Fri, Jan 25, 2013 at 4:45 AM, Steve Clark wrote: > Thanks All, > > This is for a few very small tables, less 100 records each, that a user can > delete and insert records into based on the "id" > which is displayed in a php generated html screen. The tables are rarely > updated and when they ar

Re: [GENERAL] noobie question

2013-01-24 Thread Gauthier, Dave
-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Steve Clark Sent: Thursday, January 24, 2013 12:46 PM To: Jeff Janes Cc: Chris Angelico; pgsql-general@postgresql.org Subject: Re: [GENERAL] noobie question On 01/24

Re: [GENERAL] noobie question

2013-01-24 Thread Steve Clark
On 01/24/2013 12:36 PM, Jeff Janes wrote: On Thu, Jan 24, 2013 at 8:53 AM, Chris Angelico wrote: On Fri, Jan 25, 2013 at 3:47 AM, Steve Clark wrote: Say I have a table that has 2 columns like create table "foo" ( id integer not null, name text ); CREATE UNIQUE INDEX "foo_pkey" on "foo"

Re: [GENERAL] noobie question

2013-01-24 Thread Jeff Janes
On Thu, Jan 24, 2013 at 8:53 AM, Chris Angelico wrote: > On Fri, Jan 25, 2013 at 3:47 AM, Steve Clark wrote: >> Say I have a table that has 2 columns like >> create table "foo" ( >> id integer not null, >> name text >> ); >> CREATE UNIQUE INDEX "foo_pkey" on "foo" using btree ( "id" "int4_ops

Re: [GENERAL] noobie question

2013-01-24 Thread Adrian Klaver
On 01/24/2013 08:47 AM, Steve Clark wrote: Hi list, This may be really simple - I usually do it using a procedural language such as php or a bash script. Say I have a table that has 2 columns like create table "foo" ( id integer not null, name text ); CREATE UNIQUE INDEX "foo_pkey" on "fo

Re: [GENERAL] noobie question

2013-01-24 Thread Gauthier, Dave
-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Steve Clark Sent: Thursday, January 24, 2013 11:47 AM To: pgsql Subject: [GENERAL] noobie question Hi list, This may be really simple - I usually do it using a

Re: [GENERAL] noobie question

2013-01-24 Thread Chris Angelico
On Fri, Jan 25, 2013 at 3:47 AM, Steve Clark wrote: > Say I have a table that has 2 columns like > create table "foo" ( > id integer not null, > name text > ); > CREATE UNIQUE INDEX "foo_pkey" on "foo" using btree ( "id" "int4_ops" ); > > with 10 rows of data where id is 1 to 10. > > Now I wan

[GENERAL] noobie question

2013-01-24 Thread Steve Clark
Hi list, This may be really simple - I usually do it using a procedural language such as php or a bash script. Say I have a table that has 2 columns like create table "foo" ( id integer not null, name text ); CREATE UNIQUE INDEX "foo_pkey" on "foo" using btree ( "id" "int4_ops" ); with 10