Marcos Barreto de Castro wrote:
Hi,
Is it possible to declare 2 cursors in the same
transaction?
I am issuing a "BEGIN WORK" statement, after that I
am issuing "DECLARE c_cursor FOR SELECT * FROM table".
When, after that, I issue "DECLARE c_cursor1 FOR
SELECT COUNT(*) FROM table" I
Marc Tardif wrote:
I'm writing a search engine using python and postgresql which requires to
store a temporary list of results in an sql table for each request. This
list will contain at least 50 records and could grow to about 300. My
options are either to pickle the list and store a single
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
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.
--- 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:
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
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
Are there any monitor programs for administrator to find out what
operations are in progress and possibly killing deadlocking queries?
Regards,
Kari Lempiäinen
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
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 stdlib.h
#include stdio.h
exec sql include sqlca;
int main( int argc, char *argv[] ) {
exec sql whenever sqlerror
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
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
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
13 matches
Mail list logo