On Fri, 2003-09-12 at 07:21, Nigel J. Andrews wrote:
> On Thu, 11 Sep 2003, Richard Welty wrote:
...
> > [Thu Sep 11 16:17:25 2003] [notice] caught SIGTERM, shutting down
> > PHP Warning: Unable to load dynamic library '/usr/lib/php4/pgsql.so'
> > - libpq.so.2: cannot open shared object file: No
Gagan Anand wrote:
Hello,
i have data in form of images which are in GB's,
i need to store the extracted data from the images.
This will required large fields size.
I was thinking of Blob data type as we have in
Oracle. Do we have blob data type in postgreSQL, if
yes in which version.
Th
> I haven't had a chance to sit down and do any exhaustive testing yet and
> don't think I will for a while. That said, once 7.4 goes gold, I'm
> going to provide databases/postgresql-devel with a tunable that will
> allow people to choose what block size they would like (4k, 8K, 16K,
> 32K, or 6
> > I haven't had a chance to sit down and do any exhaustive testing
> > yet and don't think I will for a while. That said, once 7.4 goes
> > gold, I'm going to provide databases/postgresql-devel with a
> > tunable that will allow people to choose what block size they
> > would like (4k, 8K, 16K,
Ok you can user the info exists function that is part of TCL
i.e. if { [info exists NEW($1)] } {
or if 1 is the problem do
if { [info exists 1] } {
This will allow you to determine if it exists.
If you want to see what variables exist at this level elog [info vars] and
it will show you all var
I thought "bytea" was PG's version of BLOBs. I don't see a "blob" type in the
current docs.
Also, I saw your example code as well. I use Perl as well but I use the native
Pg.pm module. There doesn't seem to be a way to switch the input to binary data
but there is support for what is called "lar
Some of these image generating apps are even using a background similar
to the color blindness tests. I think even an image recognition program
would have a hard time with those.
Keith G. Murphy wrote:
Bruno Wolff III wrote:
On Wed, Sep 10, 2003 at 14:12:43 +0200,
Francois Suter <[EMAIL PROT
Hello,
is it possible to use the erserver for high-availability solutions like a
two server-system with failover?
Or for systems with distributed servers on different locations?
Thank you
Daniel
---(end of broadcast)---
TIP 8: explain analyze is
Hello
|| isn't OR!!
testdb011=> select ''||'bbb';
?column?
-
bbb
This is SQL, not java or C. OR is OR in SQL :->
Pavel
On Thu, 11 Sep 2003, [ISO-8859-1] Alexander Blüm wrote:
> hello,
>
> I'm facing an odd problem.
> I have a query:
>
> SELECT "Kürzel", "Auto
On Thursday 11 September 2003 09:38, Marek Lewczuk wrote:
> Hey,
> I've searched for MD5 crypting function in PG, but I did not find it.
> Anyone knows how to implement this function in PG ?
Is it not in the contrib/pgcrypto directory in the source distro? Or, check
the contrib package of your bi
BLOBs are PostgreSQL wierdness from before PostgreSQL had TOAST (which
removed the 8kb row limit). See
http://www.postgresql.org/docs/7.3/static/largeobjects.html
For info on the old BLOB interface.
Jon
On Thu, 11 Sep 2003, Network Administrator wrote:
> I thought "bytea" was PG's version of
Hey,
I've searched for MD5 crypting function in PG, but I did not find it.
Anyone knows how to implement this function in PG ?
Best wishes,
Marek L.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
> "BM" == Bruce Momjian <[EMAIL PROTECTED]> writes:
>> Check your logs to see if you are checkpointing too frequently.
BM> That warning message is only in 7.4.
Yes, but the checkpoint activity is still logged. On my 7.2 system,
I'm checkpointing about every 1.5 minutes at peak with 3 checkp
Op 11 Sep 2003 (0:45), schreef ljb <[EMAIL PROTECTED]>:
> I think you're missing something. When you use a Tcl function as a
> trigger, any arguments (like $1) are explicitly supplied in the CREATE
> TRIGGER command. You either define the trigger to call the function with
> a constant argument or
Postgresql 7.4b2 (approximately, compiled out of CVS)
When I have a subquery that has a complex subquery as one of the result
columns, and then that result column is used multiple times in the parent
query, the subquery is inlined for each one. This means multiple redundant
executions of the subq
Kaarel wrote:
This is one of the reasons why the PHP people removed bundled MySQL
support in version 5 back in June.
Would a perl application using DBI have a similar problem? Or how would
one then legally use PHP with MySQL without GPL-ing your product and
without buying MySQL commercial lice
Vivek Khera wrote:
> > "TL" == Tom Lane <[EMAIL PROTECTED]> writes:
>
> TL> My best guess is that the dropoffs occur because of background checkpoint
> TL> operations, but there's not enough info here to prove it. Four inserts
> TL> per second seems horrendously slow in any case.
>
> I'll co
> "MGF" == Marc G Fournier <[EMAIL PROTECTED]> writes:
MGF> Without a fair amount of testing, especially on other platforms, it most
MGF> likely won't happen in the distribution itself ... one of the things that
MGF> was bantered around for after v7.4 is released is seeing how increasing it
MG
"Clay Luther" <[EMAIL PROTECTED]> writes:
> ccm=# explain delete from numplan where pkid in (select numplan.pkid from numplan
> left outer join pilothuntgroup on numplan.pkid=pilothuntgroup.fknumplan left outer
> join devicenumplanmap on numplan.pkid = devicenumplanmap.fknumplan where
> numplan.
You are absoletely correct, quoting the zero did the trick...
And my database has been intialized with Norwegian local, so I am
guessing that that's reason
Thanks to all fo you... :)
BTJ
On Thu, 2003-09-11 at 16:26, Tom Lane wrote:
> =?ISO-8859-1?Q?Bj=F8rn?= T Johansen <[EMAIL PROTECTED]>
This is too weird... and you are sure you haven't modified anything in pg_operator,
used CREATE OPERATOR or something like that??
I think it's time for you to send in a bug report..
/Mattias
- Original Message -
From: "Bjørn T Johansen" <[EMAIL PROTECTED]>
> Well, here is my output
When i run it, it works as intended (on pg 7.3.3). Which version do you use?
Are you absolutely sure you copied it exactly? You typed in '>=' and not '=', right?
/Mattias
- Original Message -
From: "Bjørn T Johansen" <[EMAIL PROTECTED]>
To: "Mattias Kregert" <[EMAIL PROTECTED]>
Cc: <[EM
It's now clearer for me. Thanks a lot for you long explanation.
--
Stéphane
Richard Huxton wrote:
On Wednesday 10 September 2003 12:54, Stéphane Cazeaux wrote:
Richard Huxton wrote:
Client2's first SELECT started before you commited the INSERT, the second
SELECT
Well, here is my output..:
DT=# create table mytable (starttime time, stoptime time);
CREATE TABLE
DT=# insert into mytable values ('10:45', '22:30');
INSERT 20746 1
DT=# insert into mytable values ('19:45', '04:30');
INSERT 20747 1
DT=# insert into mytable values ('00:00', '00:00');
INSERT 20748
I need to write a SQL that calculates the interval between a start time and a stop time. This is the easy part. The problem is that I only have the time part, i.e. no date, so how can I be sure to also calculate the interval if the start time is before midnight and the stop time is after midnig
On 11 Sep 2003, Bjørn T Johansen wrote:
> Yes, I am sure, I just use copy-and-paste and I have double checked
> I am running on 7.3.4 but that shouldn't make any difference?
>
> BTJ
>
> On Thu, 2003-09-11 at 14:56, Mattias Kregert wrote:
> > When i run it, it works as intended (on pg 7.3.3
Am Donnerstag, 11. September 2003 08:59 schrieben Sie:
> Op 11 Sep 2003 (0:45), schreef ljb <[EMAIL PROTECTED]>:
...
> -- This is the function
>
> create or replace function tlow() returns trigger as '
> set NEW($1) [string tolower $NEW($1)]
> return [array get NEW]'
> language 'pltcl';
>
...
hello,
I'm facing an odd problem.
I have a query:
SELECT "Kürzel", "Autor(en)", "Titel"
FROM "tblTitelangaben"
WHERE "Titel"||"Kürzel"||"Monographie-Kürzel"||"Autor(en)" ILIKE '%er%';
this works like a charm.
but if I add another ||"something" - which might be emtpy, I get no
results.. why?
WHE
Yes, I am sure, I just use copy-and-paste and I have double checked
I am running on 7.3.4 but that shouldn't make any difference?
BTJ
On Thu, 2003-09-11 at 14:56, Mattias Kregert wrote:
> When i run it, it works as intended (on pg 7.3.3). Which version do you use?
>
> Are you absolutely sure
Well, it's close... :)
But it looks like the case doesn't work..
If I run your sql, the timediff is negative.
But if I run this:
SELECT (stoptime-starttime+'24 hours') as timediff FROM mytable
the timediff has correct value..
Do you see any error in the case, cause I don't?
BTJ
On Thu, 2003-0
i am having problem of running pg_dump. i am using
winXP home here. postgreSQL requested me to re-install
the application again as can't found cygz.dll file.
do u have any idea?
--- Oliver Elphick <[EMAIL PROTECTED]> wrote:
> On Thu, 2003-09-11 at 09:15, Caroline Yong wrote:
> > Is there a way to
dsfdfd
- Original Message -
From:
Bjørn T Johansen
To: Andrew L. Gould
Cc: PostgreSQL general list
Sent: Thursday, September 11, 2003 2:12
PM
Subject: Re: [GENERAL] I need a
SQL...
On Thu,
2003-09-11 at 14:07, Andrew L. Gould wrote:
Yes, the peri
I was trying to make this work with pgsql.
http://link-n-log.sourceforge.net
Currently it's for MySql dbs. I'm close but I can't get the Qt part ironed
out and the docs seem outdated. I'm asking here in the hope that someone here
may have been down this path before. I'll try with Qt also.
--
>> If You are using Delphi, there is great project called "Zeos
>> objects", and if I remember correctly it has support for large
>> objects.
>>
>Zeos are useing a lot of memory...
Another issue I had with Zeos was that when I looked into possibly using
those components (this was probably over
On Thu, 2003-09-11 at 14:07, Andrew L. Gould wrote:
On Thursday 11 September 2003 06:25 am, Bjørn T Johansen wrote:
> I need to write a SQL that calculates the interval between a start time
> and a stop time. This is the easy part. The problem is that I only have
> the time part, i.e. no date,
On Thursday 11 September 2003 06:25 am, Bjørn T Johansen wrote:
> I need to write a SQL that calculates the interval between a start time
> and a stop time. This is the easy part. The problem is that I only have
> the time part, i.e. no date, so how can I be sure to also calculate the
> interval if
36 matches
Mail list logo
