On Mon, Oct 31, 2005 at 08:37:22PM -0500, Bruce Momjian wrote:
> Jim C. Nasby wrote:
> > There was recently discussion about changing how allocation happens in
> > the future. I'm pretty sure it was started by Bruce Momjian on -hackers,
> > but I can't find it in the archives now...
>
> I don't th
Hi,
I´m a brazilian programmer!
I have a question about Postgres UNIQUE KEY. Look:
(Step 1)
CREATE TABLE test (
id integer not null primary key,
id_uni integer not null,
cod integer,
name varchar(40),
constraint test_uk unique(id_uni, cod)
)
(Step 2)
insert into test (id, id_uni, cod, name)
val
I don't have any numbers; and it may be an misconception as you pointed
out that's out there among Oracle DBAs that need to be re-visited again.
Tom, could you also explain what you meant in a previous post I found
during my research on this issue, which I may have misunderstood it: "I
actually
On Tue, 2005-11-01 at 11:17, Tomeh, Husam wrote:
> I don't have any numbers; and it may be an misconception as you pointed
> out that's out there among Oracle DBAs that need to be re-visited again.
>
> Tom, could you also explain what you meant in a previous post I found
> during my research on t
On Tue, 1 Nov 2005, Diego wrote:
> Hi,
> I´m a brazilian programmer!
>
> I have a question about Postgres UNIQUE KEY. Look:
>
> (Step 1)
> CREATE TABLE test (
> id integer not null primary key,
> id_uni integer not null,
> cod integer,
> name varchar(40),
> constraint test_uk unique(id_uni, cod)
>
Diego wrote:
Hi,
I´m a brazilian programmer!
I have a question about Postgres UNIQUE KEY. Look:
(Step 1)
CREATE TABLE test (
id integer not null primary key,
id_uni integer not null,
cod integer,
name varchar(40),
constraint test_uk unique(id_uni, cod)
)
(Step 2)
insert into test (id, id_uni,
On Tue, Nov 01, 2005 at 09:17:46AM -0800, Tomeh, Husam wrote:
>
> I don't have any numbers; and it may be an misconception as you pointed
> out that's out there among Oracle DBAs that need to be re-visited again.
>
> Tom, could you also explain what you meant in a previous post I found
> during
http://www.postgresql.org/docs/8.0/interactive/sql-createtable.html
For the purpose of a unique constraint, null values are not considered
equal.
On Tue, Nov 01, 2005 at 03:09:24PM -0300, Diego wrote:
> Hi,
> I?m a brazilian programmer!
>
> I have a question about Postgres UNIQUE KEY. Look:
>
Sorry about that.
--
Husam
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 01, 2005 9:25 AM
To: Tomeh, Husam
Cc: Tom Lane; pgsql-admin@postgresql.org
Subject: RE: [ADMIN] Pre-allocate space in advance
On Tue, 2005-11-01 at 11:17, Tomeh, Husa
Folks,
I'm having some trouble restoring data that was dumped from my database.
When I dump out a table (pg_dump -d neo -t question > question.tbl) and try
to restore it (psql -d temp -f question.tbl) I get errors on certain rows:
"psql:question.tbl:15861: ERROR: invalid byte sequence for
"Peter Darley" <[EMAIL PROTECTED]> writes:
> I'm having some trouble restoring data that was dumped from my database.
> When I dump out a table (pg_dump -d neo -t question > question.tbl) and try
> to restore it (psql -d temp -f question.tbl) I get errors on certain rows:
> "psql:question.tbl
Tom,
As far as I can tell the source and destination dbs are SQL_ASCII, but I
have to admit I'm not sure how to find out. When I dump just the schema for
the cluster, I get the following create database statements in the dump:
CREATE DATABASE neo WITH TEMPLATE = template0 OWNER = postgres
"Peter Darley" <[EMAIL PROTECTED]> writes:
> So, long and short, I think that everything should be SQL_ASCII, but
> even
> when it is, I get the error.
There is no way you're going to get that error if the encoding setting
is SQL_ASCII, so better look again. "SHOW server_encoding" and "SHO
Tom,
You're correct, the new database was being created as UNICODE instead of
SQL_ASCII. I'd never messed with encoding before, but I guess that the
default was changed some time after I originally made the database on 6.x.
Stupid mistake. :)
Thanks a bundle for your help!
Peter Darley
Are there tools available to automate backing up databases? I would like
to setup my PostgreSQL install to automatically backup databases and
save the file to specific location at specific times of the day with
little to no user intervention... I'd like to know how to do this in
both Windows an
15 matches
Mail list logo
