Re: [SQL] Simple Problem ?

2008-09-15 Thread Guillaume Lelarge
Hengky Lie a écrit : > [...] > I really amazed with this problem and need your help. > > I run simple query from Query window of PgAdmin3: SELECT * FROM mytable > limit 10; > > and the result are NON UPDATABLE QUERY, while i need the result are > updatable. > > I run the same query from Passthro

[SQL] Simple Problem ?

2008-09-15 Thread Hengky Lie
Dear friends, I really amazed with this problem and need your help. I run simple query from Query window of PgAdmin3: SELECT * FROM mytable limit 10; and the result are NON UPDATABLE QUERY, while i need the result are updatable. I run the same query from Passthrough SQL in Microsoft Access

Re: [SQL] surrogate vs natural primary keys

2008-09-15 Thread Seb
On Mon, 15 Sep 2008 16:45:08 -0600, "Scott Marlowe" <[EMAIL PROTECTED]> wrote: [...] > I think this question is a lot like "how large should I set > shared_buffers?" There's lots of different answers based on how you > are using your data. Yes, this is precisely what I'm after: *criteria* to he

Re: [SQL] surrogate vs natural primary keys

2008-09-15 Thread Scott Marlowe
On Mon, Sep 15, 2008 at 4:02 PM, Seb <[EMAIL PROTECTED]> wrote: > Hi, > > I've been reading several articles on this hotly debated issue and still > can't find proper criteria to select one or the other approach for the > database I'm currently designing. I'd appreciate any pointers. Thanks. You

[SQL] surrogate vs natural primary keys

2008-09-15 Thread Seb
Hi, I've been reading several articles on this hotly debated issue and still can't find proper criteria to select one or the other approach for the database I'm currently designing. I'd appreciate any pointers. Thanks. Cheers, -- Seb -- Sent via pgsql-sql mailing list (pgsql-sql@postgresq

Re: [SQL] Pls Hlp: SQL Problem

2008-09-15 Thread Fernando Hevia
> -Mensaje original- > De: Scott Marlowe [mailto:[EMAIL PROTECTED] > > > > Consider that if you are NOT going to use the decimals you should > > really use integer or bigint datatypes. The numeric type > compute much > > slower than integer datatypes. > > Note that if you're just c

Re: [SQL] Pls Hlp: SQL Problem

2008-09-15 Thread Scott Marlowe
On Mon, Sep 15, 2008 at 2:14 PM, Fernando Hevia <[EMAIL PROTECTED]> wrote: > > >> -Mensaje original- >> De: Scott Marlowe [mailto:[EMAIL PROTECTED] > >> > >> > Consider that if you are NOT going to use the decimals you should >> > really use integer or bigint datatypes. The numeric type >>