Sai Hertz And Control Systems <[EMAIL PROTECTED]> writes:
> I have created my tables without OIDS now my doubts are :
> 1. Will this speed up the data insertion process
Slightly. It means that each inserted row will be 4 bytes smaller (on
disk), which in turn means you can fit more tuples on a p
Hi NG!
Getting *apt-get update* to work with the above mentioned package
turned out to be tricky.
What I supplied in my last posting was incorrect of course. The line in
sources.list needs a distribution after the URI.
Failed:
deb ftp://ftp.postgresql.org/pub/binary/v7.4/debian/ main non-free
On Thu, Dec 11, 2003 at 16:27:25 +0100,
arnaud Betoule <[EMAIL PROTECTED]> wrote:
> Hy,
> I'm a newbie and i'm looking for several informations of PostgreSQL to help me for
> the choice of my next
> database.
> - What's the number max of keys ?
By default the limit is 32 keys on a single mult
[EMAIL PROTECTED] (Oliver Elphick) wrote:
> Peter Eisentraut has copied the binary packages to:
> ftp://ftp.postgresql.org/pub/binary/v7.4/debian/
>
> These are the md5sums of the woody release of 7.4:
(...)
Thank you for making it availiable again, Peter and Oliver!
I assume the correct line for
Hy,
I'm a newbie and i'm looking for several informations of PostgreSQL to help me for the
choice of my next
database.
- What's the number max of keys ?
- Is thre a max lenght for the name of database, table, index, column ?
- Is it possible to make partions of a table ?and how ?
Thank's
E-mail,
Create a new column
alter add column varchar(25);
Then copy the old column into the new column:
update set = ;
Drop the last column:
alter drop column ;
Rename the column:
alter rename column to ;
Take care for INDEXES if there are any.
This should do it.
Best regards.
- Origin
On Fri, 12 Dec 2003, Rhaoni Chiu Pereira wrote:
Hi, is there a switch in your pgsql/odbc connector to enable cursors? If
so, try turning that on.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Fri, 12 Dec 2003, Greg Spiegelberg wrote:
> Any rule of thumb for REINDEX DATABASE? Once per month?
> Per x transactions?
You shouldn't need to reindex databases for the most part. If there's
lots of catalog updates / delete, it might be occasionally useful to down
the database and reindex
Dear all ,
I have created my tables without OIDS now my doubts are :
1. Will this speed up the data insertion process
2. Though I have not written any code in my any of the pgsql functions
which depend on OIDS
1. Will without OIDS the functions behave internally differently
2. Will my applica
Dear all ,
I have created my tables without OIDS now my doubts are :
1. Will this speed up the data insertion process
2. Though I have not written any code in my any of the pgsql functions
which depend on OIDS
1. Will without OIDS the functions behave internally differently
2. Will my appli
Milan Krajnak <[EMAIL PROTECTED]> writes:
> psql# \d
> getTables(): SELECT failed. Explanation from backend: 'pqReadData() --
> backend
> closed the channel unexpectedly.
Standard questions: what shows up in the postmaster's log (stderr or
syslog depending on your setup) when this happens? Is t
Any rule of thumb for REINDEX DATABASE? Once per month?
Per x transactions?
--
Greg Spiegelberg
Sr. Product Development Engineer
Cranel, Incorporated.
Phone: 614.318.4314
Fax: 614.431.8388
Email: [EMAIL PROTECTED]
Cranel. Technology. Integrity. Focus.
---(end of br
Hi List,
First of all, I tried to subcribe the ODBC list but it seems that the
subscription's link is broken ! So here it goes:
I have a delphi software use ttable components that converts dbf information
to PostgreSQL an Oracle Databases. My problem is that PostgreSQL is too slow,
t
hello,
i've got the following problem:
OS - Solaris 8/9 on Sun SPARC
PGSQL 7.1.3
when i try to dump the database with pg_dump command i've got the
following error:
-- last builtin oid is 18539
-- reading user-defined types
-- reading user-defined functions
-- reading user-defined aggregates
I'm wondering how to cleanly disconnect a user from the DB. For the
moment, the only way I found is to kill the pid of the user but I found
it quite ugly.
--
Ci-git une signature avortee.
** RIP **
---(end of broadcast)---
TIP 9: the planner will i
15 matches
Mail list logo