Re: [GENERAL] Primary keys and speed

2001-09-09 Thread Rob Brown-Bayliss
Hi, I have not yet seen an answer to the following, can I assume it's not a problem? On Thu, 2001-09-06 at 19:58, Rob Brown-Bayliss wrote: > > Hello. > > I am looking at useing uuid's as primary keys rather than a normal > sequence of numbers. > > The uuids are long text strings like so: >

Re: [GENERAL] Primary keys and speed

2001-09-09 Thread Joe Conway
> > I am looking at useing uuid's as primary keys rather than a normal > > sequence of numbers. > > > > The uuids are long text strings like so: > > > > 7559e648-a29c-11d5-952f-00c026a18838 > > > > The reason for useing them is that it's almost gaurenteed that > > imported data from another site i

[GENERAL] Repairing table corruption

2001-09-09 Thread Graham White
We are looking at moving from a Mysql database setup and we understand that table corruption in Postgres is a lot less likely but if it does happen are there built in utilities to repair the tables? Recommended 3rd party products? Thanks GW ---(end of broadcast)-

Re: [GENERAL] Repairing table corruption

2001-09-09 Thread Tod McQuillin
On Sun, 9 Sep 2001, Graham White wrote: > We are looking at moving from a Mysql database setup and we understand > that table corruption in Postgres is a lot less likely but if it does > happen are there built in utilities to repair the tables? Recommended > 3rd party products? Thanks If your t

FW: [GENERAL] a plpgsql programming question

2001-09-09 Thread Jefim Matskin
I have the following problem; The client of the DB issues a lot of the SQL commands over a network , the statements are of the simple form - select an integer from some table(s) using some criteria. I want to create a function that will accept the string containing all the statements to be execu