Hi Everyone,
Please bear with me.I am a final year student from India-Goa, and
+developing a library management system which can be adopted by any University
+(Hopefully). We are developing this project using PHP and PostgreSql.The good
+thing that we appreciate is that this project is bas
"Josh Berkus" <[EMAIL PROTECTED]> writes:
>> This is not a bug. It's a deliberate change in behavior: sum() and
>> avg() on integer datatypes now return numeric, to avoid problems with
>> overflow.
> That could throw off some of my already-written views & functions. Is
> there a setting that ca
Forest Wilkinson <[EMAIL PROTECTED]> writes:
> Good point. How long is the next cycle likely to take?
Good question. I'd like to say 4 to 6 months, but that was how long 7.1
was supposed to take, and we're pushing a year now.
What might make the most sense is to develop and test a fix in the e
On Thursday 29 March 2001 22:15, Tom Lane wrote:
> > Just looked in heapam.c - I can fix it in two hours.
> > The question is - should we do this now?
>
> This scares the hell out of me.
>
> I do NOT think we should be making quick-hack changes in fundamental
> system semantics at this point of th
Perhaps you can run your file through a filter to replace '' to null.
Any of sed, perl, python and other scripting languages would do nicely.
e.g.
sed -e "s/''/null/g" < myfile > myfile2
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Maurizio Ortola
We recently upgraded sourceforge to 7.1b6 from our nice old stable november
cvs snapshot and we hit this error last nite:
NOTICE: FlushRelationBuffers(groups, 2140): block 2057 is referenced (private
0, global 1)
Error: ERROR: VACUUM (repair_frag): FlushRelationBuffers returned -2
I tend to
Tom,
> This is not a bug. It's a deliberate change in behavior: sum() and
> avg() on integer datatypes now return numeric, to avoid problems with
> overflow.
That could throw off some of my already-written views & functions. Is
there a setting that can change this back to the "regular" behavio
Kyle <[EMAIL PROTECTED]> writes:
> It appears that sum(int4) returns type numeric. Shouldn't it return
> int4?
This is not a bug. It's a deliberate change in behavior: sum() and
avg() on integer datatypes now return numeric, to avoid problems with
overflow.
regards, tom
bernd writes:
> hey i have the following table def (834.000 rows, vaccum analyze'd):
> dl_online=# \d mitglied
> Table "mitglied"
>Attribute| Type | Modifier
> +--+
> mitgliedid | bigint
HI all, I just posted a message about droping a table. I droped it
using pgaccess from the pg_class table. Now I want to recreate the
table and I get the following message:
TypeCreate: type links already defined
I need to fix this problem in hurry please someone could reply to it.
Thanks alo
On Thu, Mar 29, 2001 at 03:47:58PM +0200, bernd wrote:
> hey i have the following table def (834.000 rows, vaccum analyze'd):
> dl_online=# \d mitglied
> Table "mitglied"
>Attribute| Type | Modifier
> +--+--
Hi, I am trying to drop a table and I get the following error:
drop TABLE links;
ERROR: RelationBuildTriggers: 1 record(s) not found
for rel links
mondo=#
Could someone explain this to me. I would really appreciate the
help.
begin:vcard
n:Hashmi;Najm
x-mozilla-html:FALSE
org:Mondo-Live.com
Title: RE: [SQL] Max Size of a text field
You can edit config.h and recompile 7.0.3 to allow for larger tuples (up to 32K - Info used to be in the FAQ but that has changed so try the mailing list archives for info) or you can try 7.1 RC1 or the CVS snapshot as both can deal with almost unlimit
Koen Antonissen writes:
> I just recieved this error:
> 'Warning: PostgreSQL query failed: ERROR: Tuple is too big: size 13872,
> max size 8140 '
>
> Is there anyting I can do about that other than tell my users just not
> typing so much text into the field?
Option 1: increase BLCKSZ in src/in
> "edipoelder" == edipoelder <[EMAIL PROTECTED]> writes:
edipoelder> times. Then I changed the function
and run, at id =
edipoelder> 14. Change again at id = 15.
Where is underlined
edipoelder> (), i tried to put, 'now', timestamp 'now', etc,
edipoelder> and always
Subject: Importing data from Informix to PostgreSQL.
Error in the date field (WITH NULL value)
Hello!
I'll try to explain my little problem. Well, I have this table
create table mytable
( codice char(16) not null,
dt_inizio date,
dt_finedate,
tipo_operaz
Title: RE: [SQL] Help with 'now', now(), timestamp 'now', ...
try timeofday(), now() gives starttime of transaction :-{.
Regards
Ben
PS this has just been discussed in this mailing list or I would have been clueless
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL
Hi there
Warning: PostgreSQL query failed: ERROR: Tuple is too big: size 13872,
max size 8140
Is there anyting we can do about that other than just not typing so much
text into the field?
Kind regards,
Koen Antonissen
---(end of broadcast)---
TI
Alessio Bragadini writes:
> I was wondering if PostgreSQL supports some kind of #include between SQL
> script files, to split a long script in different files.
If you're using the psql client then \i filename can be used.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
Before I go investigating this, is it possible to trigger an arbitrary
program from the SQL, say a shell script?
Also, why am I getting "not subscribed messages", I am subscribed since
I'm replying to a message that was sent to me!!
On Thu, 29 Mar 2001, Peter Mount wrote:
> At 21:37 26/03/01 +
hey i have the following table def (834.000 rows, vaccum analyze'd):
dl_online=# \d mitglied
Table "mitglied"
Attribute| Type | Modifier
+--+
mitgliedid | bigint | not null
dlnummer
"Md. Intekhab Alam" wrote:
> Has anyone tried setting up Postgres as a linked server under Microsofts SQL
> Server 7 to connect with SQL 6.5
>
> I am able to create the link correctly (see below) and see all the tables
> available in Postgres, but if I try querying anything in them I get the
> fo
> > >> I assume this is not possible in 7.1?
> > >
> > >Just looked in heapam.c - I can fix it in two hours.
> > >The question is - should we do this now?
> > >Comments?
> >
> > It's a bug; how confident are you of the fix?
95% -:)
> I doubt if it's a bug of SELECT. Well what
> 'concurrent UPDAT
> How can I "binds" PostgreSQL to consider '' as null ?
You can modify src/backend/utils/{datetime,date,timestamp}.c to accept
an empty string as a null value. But imho it is better to fix this in
your input file, perhaps using sed:
sed "s/''/NULL/g" < informix.dump > pg.dump
> >Reported problem is caused by bug (only one tuple version must be
> >returned by SELECT) and this is way to fix it.
> >
>
> I assume this is not possible in 7.1?
Just looked in heapam.c - I can fix it in two hours.
The question is - should we do this now?
Comments?
Vadim
---
Hi
Regarding my previous post, I just successfully created a unique index on
pg_shadow. DON'T DO THIS!!!
---
CREATE UNIQUE INDEX shadow_index ON pg_shadow (usename)
---
I couldn't create at pg_shadow_index as the pg prefix is reserved for
system tables.
This BROKE the database. At le
I have a vacuum which has been running for about a week, is that too long?
On Wed, 28 Mar 2001, Poul L. Christiansen wrote:
> On Wed, 28 Mar 2001, Graham Vickrage wrote:
>
> > Hi All,
> >
> > What is the correct way of killing postgres 7.0 on redhat linux.
>
> "man pg_ctl".
>
> >
> > Is there a
Subject: Importing data from Informix to PostgreSQL.
Error in the date field (WITH NULL value)
Hello!
I'll try to explain my little problem. Well, I have this table
create table mytable
( codice char(16) not null,
dt_inizio date,
dt_finedate,
tipo_operaz
It's not a machine I look at often, and I realiased that it's database had
never been vacuumed and had grown to about 2 gigs
It is a dual PII 450, with 384 megs and U2W disks... but I started the
vacuum about 10 days ago.. and when I checked it hadn't finished... I
guess I'll kill it and t
Hi all,
I´m developing some procedures in my db and i want know how much time my
procedures take to execute. So, i write my first procedure (to test) as
follows:
CREATE FUNCTION TEST(INTEGER) RETURNS INTEGER AS '
DECLARE
SEQ RECORD;
BEGIN
SELECT N
Hello,
I am a bit at a loss here.
If I create a function which returns something it works fine.
If it returns opaque I get the following: ERROR: typeidTypeRelid: Invalid
type - oid = 0
What am I doing wrong ?
Thanks in advance.
Best regards,
Roelof Sondaar
dhcp=# drop function lalala();
DROP
Thus spake postgresql
> How does currval work if you are not inside a transaction. I have
> been experimenting with inserting into a table that has a sequence.
> If the insert fails (not using a transaction) because of bad client input
> then the next insert gets the proper next number in the s
Hi there
I just recieved this error:
'Warning: PostgreSQL query failed: ERROR: Tuple is too big: size 13872,
max size 8140 '
Is there anyting I can do about that other than tell my users just not
typing so much text into the field?
Kind regards,
Koen Antonissen
---(end
I was wondering if PostgreSQL supports some kind of #include between SQL
script files, to split a long script in different files.
--
Alessio F. Bragadini[EMAIL PROTECTED]
APL Financial Services http://village.albourne.com
Nicosia, Cyprus phone: +357-2-755750
"Mikheev, Vadim" wrote:
>
> > > >> I assume this is not possible in 7.1?
> > > >
> > > >Just looked in heapam.c - I can fix it in two hours.
> > > >The question is - should we do this now?
> > > >Comments?
> > >
> > > It's a bug; how confident are you of the fix?
>
> 95% -:)
>
> > I doubt if it'
35 matches
Mail list logo
