On Tue, 5 Sep 2000, Poet/Joshua Drake wrote:
> Hello,
>
> I have heard of this infamous 8k limit. I have a couple of questions.
> 1. Does this mean that if I have a large object that I am inserting into a
> table, like an image it has to be 8k or less?
In current version is possible range 8--
Hello,
I have heard of this infamous 8k limit. I have a couple of questions.
1. Does this mean that if I have a large object that I am inserting into a
table, like an image it has to be 8k or less?
2. When will this be fixed?
3. Does anyone know the status of the replication capabilities in PGS
[EMAIL PROTECTED] wrote:
> Currently, I'm using the the 7.0.2 rpms from the postgresql.org
> on a RH6.2 install.
>
> I have a few questions on it and the use of the -E flag.
>
> 1 - can 7.0.2 be optimized for i686 architecture or is
> it only possible to compile for i386 architecture?
Yes. Chang
Hi,
I have a tables having this structure:
ID (int) | _ID (int) | Name (String)
_ID is the parent of ID.
I'm looking for the best method to perform a cascade delete. For example, I
delete _ID, it in turn deletes ID, and should ID also be an entry within _ID, it
would continue through the cha
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> how can I write function which takes text from one field, replaces
> some characters and puts it in other field? I have array with old and
> new values.
Probably best to do this as an embedded perl sql function. Then it is
about 3 lines.
Ian
-
Hello,
Is it possible to protect a table of Postgresql by a group of persons instead of
giving a list
of persons ?
Thanks for your answers
Regards
nicolas michaud
The statement "Outer Join" is not available in Postgres ?
Is there an extension provided by a third company that implement this
functionnality ?
If not do you know when this functionnality will be available in
Postgres ?
Thank
Fred
--
TechBourse : le premier site en FRANCAIS dédié le NASDAQ
On Tue, 5 Sep 2000, Larry Rosenman wrote:
> Greetings,
> I was trying to use arrays today, and can't seem to get it right.
>
> What am I doing wrong?
>
> ler=# create table ia_standby (hsrp_group int2,
> ler(# router_interfaces[] varchar(64),
> ler(# routers[] varchar(64));
What you want
Jie Liang <[EMAIL PROTECTED]> writes:
> Hi, there,
>
> I tried different ways, include vaccum table , ensure index works, it
> still is as slow as ~100rows per minute.
>
PGFSYNC=no in postmaster.init?
Well, this might be Debian Linux specific, pardon me if it is. I have
just begun playing
Hi
I'm a newbiw with pgsql:
1: Haven't been able to find the officiel manual to pgsql. What's the
complete URL?
2: How can I make an auto increment with PostGreSQL? is it "inherit"?
3: The "SHOW TABLE FROM pcfocus" statement, does it work in pgsql?
If yes, what kind of variable will be "produced
I have compiled for i686 by hacking up my RPM compile environment.
On Wed, 30 Aug 2000 [EMAIL PROTECTED] wrote:
> Currently, I'm using the the 7.0.2 rpms from the postgresql.org
> on a RH6.2 install.
>
> I have a few questions on it and the use of the -E flag.
>
> 1 - can 7.0.2 be optimized fo
Hello Umashankar,
*warning* this doesn't answer the question you asked *warning*
you write that you are new to object databases. The problem that you
describe sounds like it might much more completely be solved by not using
the object features and avoiding an array alltogether.
If you simply w
OK, I before any starts on my about backups...I have one a week
old, but I want to fix this the right way! (and I want this past
week's worth of data.
What happened:
o downloaded ip and macaddr type programs written by Paul Vixie
et al., scrapped the ip stuff, and compiled the macaddr stuff.
R
Hi, there
Your syntax is not correct, pls check the Pg documentatation, the
correction as following.
Larry Rosenman wrote:
> Greetings,
> I was trying to use arrays today, and can't seem to get it right.
>
> What am I doing wrong?
>
> ler=# create table ia_standby (hsrp_group int2,
> ler(#
Ok, so I can't read. Thanks!
LER
* Kristofer Munn <[EMAIL PROTECTED]> [000905 15:27]:
> On Tue, 5 Sep 2000, Larry Rosenman wrote:
>
> > Greetings,
> > I was trying to use arrays today, and can't seem to get it right.
> >
> > What am I doing wrong?
> >
> > ler=# create table ia_standby (
Greetings,
I was trying to use arrays today, and can't seem to get it right.
What am I doing wrong?
ler=# create table ia_standby (hsrp_group int2,
ler(# router_interfaces[] varchar(64),
ler(# routers[] varchar(64));
ERROR: parser: parse error at or near "["
ler=# create table ia_standby (
Hi, there
I believe that if you create a function with PL/pgSQL that take a text array as
parameter:
create function cancer(_text) returns bool as '
declare
.
begin
use a while loop here to scan the whole array
if string match 'cancer' immediately return true otherwise
end the loop
return fal
Hi,
My experience is when you involoved that you have to use some CONTROL
LANGUAGE
such as LOOP, IF ... ELSE ... or value transfer (use variables), then using
function, otherwise
using view, temp table...
In Postgres, function is another way to store procedure.
Andreas Tille wrote:
> On Mon, 4
Hi,
I am new to Postgres as well as object database. Wondering if one of you can
tell me on how to write a sql query to select an object that has a
particular element in an array.
Example
If I create an object-table with 2 elements.
a) PatientID -> numeric
b) DiseaseArray -> array of text
-
19 matches
Mail list logo
