Louis-David Mitterrand writes:
> When creating a child (through CREATE TABLE ... INHERIT (parent)) it
> seems the child gets all of the parent's contraints _except_ its PRIMARY
> KEY. Is this normal?
It's kind of a bug.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECT
carl garland writes:
> This didnt really answer the initial question of how long does it take
> to locate a table in a large 100+ table db and where and when do
> these lookups occur.
In the current system there are several places that do sequential scans on
pg_class (which holds information
Kari Lempiainen writes:
> Are there any monitor programs for administrator to find out what
> operations are in progress
`ps' should work on many systems.
> and possibly killing deadlocking queries?
Truly "deadlocked" queries kill themselves, btw.
--
Peter Eisentraut Sernan
Hello,
I'm trying to learn embedded SQL in C. However, it's not working
and reading the documentation is not answering my question(s). Here is my
code:
#include
#include
exec sql include sqlca;
int main( int argc, char *argv[] ) {
exec sql whenever sqlerror sqlprint;
exec sql co
In a previous post Ed Loer wrote:
> Don't even think about 10 separate tables in a database :-(.It's
>not so much that PG's own datastructures wouldn't cope,as thatvery
>few Unix filesystems can cope with 10 filesin a directory.You'd
>be killed on directory search
Are there any monitor programs for administrator to find out what
operations are in progress and possibly killing deadlocking queries?
Regards,
Kari Lempiäinen
On Sat, Jun 03, 2000 at 05:22:56PM +0200, Louis-David Mitterrand wrote:
> When creating a child (through CREATE TABLE ... INHERIT (parent)) it
> seems the child gets all of the parent's contraints _except_ its PRIMARY
> KEY. Is this normal? Should I add a PRIMARY KEY(id) statement each time
> I cr
When creating a child (through CREATE TABLE ... INHERIT (parent)) it
seems the child gets all of the parent's contraints _except_ its PRIMARY
KEY. Is this normal? Should I add a PRIMARY KEY(id) statement each time
I create an inherited table?
Cheers,
--
Louis-David Mitterrand - [EMAIL PROTECTED
--- Blind-Carbon-Copy
To: [EMAIL PROTECTED]
Subject: Re: Industrial-Strength Logging
In-reply-to: <[EMAIL PROTECTED]>
Date: Sat, 03 Jun 2000 22:59:34 +1000
Message-ID: <[EMAIL PROTECTED]>
From: Giles Lean <[EMAIL PROTECTED]>
On Sat, 3 Jun 2000 01:48:33 +0200 (CEST) Peter Eisentraut wrote
Hello,
initdb is a shell-script.
The first line in the script declares the shell it will be using to
execute in.
It looks like this :
#!/bin/sh
Your problem is that /bin/sh doesn't excist !
You'll have to mount the cygwin-executable-path to /bin
Kees.
> My question is :
> 1. Is postgres Large Object saving MPEG video/audio or at least MPEG video ??
I have used it with Quicktime video data with no problme. Should be ok
with MPEG data too.
> 2. Is there a limitation in size to saving something in postgres large object
At least up to 1GB should
11 matches
Mail list logo
