On 24 Nov 2004 01:52:52 -0500, Greg Stark <[EMAIL PROTECTED]> wrote:
> Alexandre Leclerc <[EMAIL PROTECTED]> writes:
>
> > Thanks for those tips. I'll print and keep them. So in my case, the
> > product_code being varchar(24) is:
> > 4 bytes + string size (so possibly up to 24) = possible 28 bytes
Tom Lane <[EMAIL PROTECTED]> writes:
> Greg Stark <[EMAIL PROTECTED]> writes:
> > This could hurt if they ever reuse an old previously retired postal code,
> > which isn't an entirely impossible case. As far as I know it hasn't happened
> > yet though.
>
> One would suppose that the guys who are
Greg Stark <[EMAIL PROTECTED]> writes:
> This could hurt if they ever reuse an old previously retired postal code,
> which isn't an entirely impossible case. As far as I know it hasn't happened
> yet though.
One would suppose that the guys who are in charge of this point at
Canada Post consider th
Alexandre Leclerc <[EMAIL PROTECTED]> writes:
> Thanks for those tips. I'll print and keep them. So in my case, the
> product_code being varchar(24) is:
> 4 bytes + string size (so possibly up to 24) = possible 28 bytes. I
> did the good thing using a serial. For my shorter keys (4 bytes + up
> to
All,
Well, you should still escape any strings you're getting from a web
page so
you can ensure you're not subject to a SQL insert attack, even if you're
expecting integers.
Thanks,
Peter Darley
Well, your framework should do this for you :
"integer" specified in your database object class
On Mon, 22 Nov 2004 16:54:56 -0800, Josh Berkus <[EMAIL PROTECTED]> wrote:
> Alexandre,
>
> > What is the common approach? Should I use directly the product_code as
> > my ID, or use a sequantial number for speed? (I did the same for the
> > company_id, this is a 'serial' and not the shor name of
ehalf Of
Pierre-Frédéric Caillaud
Sent: Monday, November 22, 2004 3:06 PM
To: [EMAIL PROTECTED]
Subject: Re: [PERFORM] Data type to use for primary key
> What is the common approach? Should I use directly the product_code as
> my ID, or use a sequantial number for speed? (I did the same
It would be nice if PostgreSQL had some form of transparent surrogate
keying in the background which would automatically run around and
replace your real data with SERIAL integers. It could use a lookup table
There is still table inheritance, but it's not really the same.
-
Rod,
> It would be nice if PostgreSQL had some form of transparent surrogate
> keying in the background which would automatically run around and
> replace your real data with SERIAL integers. It could use a lookup table
> for conversions between the surrogate and real values so the user never
> kn
On Mon, 2004-11-22 at 16:54 -0800, Josh Berkus wrote:
> Alexandre,
>
> > What is the common approach? Should I use directly the product_code as
> > my ID, or use a sequantial number for speed? (I did the same for the
> > company_id, this is a 'serial' and not the shor name of the customer.
> > I j
Alexandre,
> What is the common approach? Should I use directly the product_code as
> my ID, or use a sequantial number for speed? (I did the same for the
> company_id, this is a 'serial' and not the shor name of the customer.
> I just don't know what is usually done.
Don't use SERIAL just becaus
Mr Caillaud,
Merci! Many points you bring were also my toughts. I was asking myself
really this was the way to go. I'm happy to see that my view of the
problem was good.
Encore merci! (Thanks again!)
On Tue, 23 Nov 2004 00:06:13 +0100, Pierre-Frédéric Caillaud
<[EMAIL PROTECTED]> wrote:
>
> > W
What is the common approach? Should I use directly the product_code as
my ID, or use a sequantial number for speed? (I did the same for the
company_id, this is a 'serial' and not the shor name of the customer.
I just don't know what is usually done.
Use a serial :
- you can change product_code f
Good day,
I'm asking myself if there is a performance issue in using an integer
of varchar(24) PRIMARY KEY in a product table.
I've read that there is no speed issue in the query, but that the only
performance issue is the database size of copying the key in other
tables that require it.
My prod
14 matches
Mail list logo
