A couple of days ago I tried to create a database and
got an error to the effect that I couldn't do that (no
more specific). I then tried to mkdir in my DATA
directory for a new database (as root), and I got
"Can't make directory--not enough space in DIR"). I
deleted everything and then did initd
On Wed, 12 Apr 2000, Haroldo Stenger wrote:
> Now I need help in finding:
Hello to you too. :)
> - I need to track the queries that the backend receives, so that I can
> see what GeneXus is sending to PostgreSQL.
http://www.postgresql.org/docs/admin/pg-options.htm
>
> - A list
Now I need help in finding:
- A list of the errors of the backend, _WITH_ the numbers, not only the
texts.
- I need to track the queries that the backend receives, so that I can
see what GeneXus is sending to PostgreSQL.
I coudn't find this info in the doc, either. Any Ideas? Th
Here's my perl implementation:
###
#
# lastday( month, year (4 digit) )
#
# Returns: last day of the month
#
###
sub lastday {
my $month=shift;
my $year= shift;
$month--;
my @days = (31,0,31,30,31,30,31,31,30
I think the cleanest way to handle this is:
while ($Rhash = $sth->fetchrow_hashref) {
do something with %$Rhash or just refer to $Rhash->{fieldname}
}
The array-based version below, if I remember correctly, can fail in
certain cases, including if both params are undefined. The code above
succ
All I can say is I get no errors of this kind in my code, which runs
$sth=$dbh->prepare("select param1,param2 from sometable");
$sth->execute;
while (@resultset = $sth->fetchrow_array) {
.. do something with them .
}
$sth->finish;
I don't think calling $sth-finish should make th
perhaps you'd better first find an evaluation copy of informix, seems that
they have more systematic and well-thought feature set.
there are some historical relations between informix (esp. Object
relational features) -- share the same original source code!
my understanding is that more recent
To obtain the number of days in a month, I wrote this function:
CREATE FUNCTION dayCountOfMonth(datetime) RETURNS float AS
' DECLARE
theDate ALIAS FOR $1;
monthStart date;
monthEnddate;
BEGIN
monthS
On 11 Apr 2000 23:52:32 -0400, [EMAIL PROTECTED] (Ed Loehr) wrote:
>Would you mind posting the actual error text along with PGDATA settings?
>
Well, I was in the process of sending the information you asked for,
when I decided to do some extra investigating. The outcome was that
I'd screwed up -
Your script works fine, but I still get the same error.
I can duplicate this same error with a non-hash ref like this.
$sth=$dbh->prepare("select param1,param2 from sometable");
$sth->execute;
while (($param1,$param2) = $sth->fetchrow_array) {
.. do something with them .
}
My concern
> Hi all,
> I'm trying to create simple rule:
> nieruchomosci=> create rule log_select as
> on select to oferty do insert into log_oferty (nr) values(oferty.nr);
> ERROR: only instead-select rules currently supported on select
> nieruchomosci=>
>
> pg 6.5.3 on linux, am I forced to create a trigg
> On 11 Apr 2000 17:55:43 -0400, [EMAIL PROTECTED] (Andrew
> Schmeder) wrote:
>
> AFAIK Postgres doesn't (yet) directly support foreign keys. You have
> to supply that ability yourself, possibly through triggers and
> procedures.
AFAIK (and I led the project),
v7.0 (released soon and the
> > AFAIK Postgres doesn't (yet) directly support foreign keys. You have
> > to supply that ability yourself, possibly through triggers and
> > procedures.
>
> I am using version 7.0 beta 5... and btw, I found a little snippit of
> code syntax on this page: http://www.postgresql.org/projects/devel
- Original Message -
From: "Jeffrey" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 12, 2000 10:05 AM
Subject: [GENERAL] Perl error: fetchrow_hashref failed
> Hi, I wonder if I might tap the vast knowledge here againg.
>
> I have a perl script that is looping through
I don't have a CS background and don't really feel competent to answer this;
so I am forwarding it to the PostgreSQL list.
--- Forwarded Message
Date:Wed, 12 Apr 2000 05:24:41 -0400
From:"Adien.Reynald.Suresh.Lopez" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: PostgreSQL
Suddenly, i started getting some weird errors with a table named xx:
db=> drop sequence xx_cod_seq;
ERROR: DeleteTypeTuple: xx_cod_seq type nonexistent
db=> drop table xx;
ERROR: mdopen: couldn't open xx_pkey: No such file or directory
Then, i noticed the file xx_pkey wasnt at the base directo
Hi, I wonder if I might tap the vast knowledge here againg.
I have a perl script that is looping through a statement handle like this.
$statement = "select * from sometable";
$sth=$dbh->prepare($statement);
$sth->execute();
# here is the part I have a question about.
while (%hash_ref = %{$sth->
Better try to install PostgreSQL version 7 and experiment on referential
integrity...
--
Manny C. Cabido
e-mail:[EMAIL PROTECTED]
FYI
> -Original Message-
> From: Andrzej Mazurkiewicz
> Sent: 3 marca 2000 17:05
> To: 'Ron Peterson'
> Cc: [EMAIL PROTECTED]
> Subject: RE: [GENERAL] FOREIGN KEY syntax
>
>
>
> -Original Message-
> From: Ron Peterson [SMTP:[EMAIL PROTECTED]]
> Sent: 3 marca 2000 15:5
19 matches
Mail list logo
