Not sure if this belongs here or on the admin or performance list.
Apologies if so. (And this may be a second posting as the first was from
an un-registered account. Further apologies)
My assumption is that any de/compression done by postgres would be
server-side.
We're considering minim
Joshua Tolley writes:
> Primary keys are NOT NULL and UNIQUE. You can't have null values in a primary
> key.
On reflection I think the OP's beef is that we complain about this:
regression=# create table t (f1 int null not null);
ERROR: conflicting NULL/NOT NULL declarations for column "f1" of t
On Tue, Jun 23, 2009 at 05:14:36PM +0200, Harald Fuchs wrote:
> test=# CREATE TABLE t2 (
> test(# id int NOT NULL REFERENCES t1,
> test(# language char(3) NULL,
> test(# txt text NOT NULL,
> test(# PRIMARY KEY (id, language)
> test(# );
> CREATE TABLE
> test=# INSERT INTO
Howdy!
When you say that pg accepts "this" silently instead of complaining what are
you referring to exactly?
First Insert? Why wouldn't it work after all ?
What will happen is that when you try to insert a new record without
specifying the id column you'll get an error informing that
primar
Harald Fuchs writes:
> I tried to throw some invalid SQL to PostgreSQL and found its reaction
> confusing:
> test(# language char(3) NULL,
This is documented as being a no-op specification.
regards, tom lane
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.
I tried to throw some invalid SQL to PostgreSQL and found its reaction
confusing:
$ psql test
psql (8.4beta2)
Type "help" for help.
test=# CREATE TABLE t1 (
test(# id serial NOT NULL,
test(# name text NOT NULL,
test(# PRIMARY KEY (id)
test(# );
CREATE TABLE
te