I need to have PostgreSQL running with AOLserver before about 8 p.m. this
evening.
Is there anybody in Toronto I can chat with on the phone, or who could come
over to help out? Thai dinner and a bottle of Scotch. Location is Hyde Park
at Dundas West. 416-604-9495.
I am running [PostgreSQL 6.5.0 on i686-pc-linux-gnu, compiled by gcc
2.7.2.3]
I looked into the $PGDATA/base/$DBNAME dirs and there are some pg_temp
files.
This would not normaly raise a question, but they are in the order of
100's of megs and there ctime is from May. I have found these in almo
Hello list,
This is my first post.
I am trying to install a db on pgsql6.5.
It was originally an oracle db. I am reading the docs to try and see if
all the data types from oracle can be ported to pgsql.
The one I am most concerned about is image.
Can I use large objects instead in pgsql?
hi,
i have a null exception. if i make the query in the posgresql it
runs correctly and none field is empty.
in my servlet:
after the query.
String page = rs.getString(1);
in the database:
ref varchar(5),
numpag varchar(2), <-
jserv.log:
[02/08/2000 18:03:
hi,
it occurss me with each field of the database.
i have txt file. i make a database and put it into posgres.
maybe it is a mistake in the in the txt file.
marcos
[EMAIL PROTECTED]
Hi:
Does anybody knows if the JDBC driver maps the
new SQL 3 types (ARRAY and STRUCT) with the proprietary array and user-defined
types of PostgreSQL? To put it another way: when I access an array (for
instance) in PostgreSQL through the JDBC driver, does the driver returns a SQL
3 ARRA
"Poul L. Christiansen" <[EMAIL PROTECTED]> writes:
> I'm developing an Cold Fusion (similar to PHP) application and I have a
> security problem. When I load a page "test.cfm?articleid=5" someone can
> alter the URL to
> "test.cfm?articleid=5;create%20table%20plc%20(plc%20int2)" if the hacker
> wan
Malcolm Beattie <[EMAIL PROTECTED]> writes:
> Tom Lane writes:
>> Thomas Lockhart <[EMAIL PROTECTED]> writes:
The Linux man pages indicate that the behavior and underlying
implementation of random() and rand() are the same (so I just picked
one).
>>
>> Ah, well, there's your proble
The better url i found is http://www.link.it/mailman/listinfo/slash-pgsql :)
We can't look at the admin one (the admin one is also posted on slashcode.com by
the way).
-
Slash is the weblog/discussion board engine that drives Slashdot and
ot
>> none of the man pages I've looked at
so far mention it). But all the
>> machines say that the output of random() is 31 bits, so INT_MAX
should
>> work.
> SuSv2 says explicitly 2^31-1 so you should use that, otherwise
you'll
> be non-portable to platforms with 64-bit ints, for example.
Maybe.
Hi
I have been using this method for over a year now.
NOTE: Beware of "\" (escape) characters.
If you have to use them, they must be changed to "\\".
This is a sample of something similar to what I do:
/bin/cat tab-delimited.txt | /usr/bin/psql -c "copy table1 from stdin;"
database1
Hello,
is it possible to create functional indices with constant params?
I tried to do
create index ix_s_m on stats(date_part('month', sent_date));
And get
ERROR: parser: parse error at or near "'"
If it is not possible is there any workarounds for this?
--
Sincerely Yours,
Denis Perchine
Hello,
I'm a new user of postgresql, I've wrote a program in C to insert data
from files.
I'm searching meanings of PQresultStatus but don't find any answers in
the docs I've read.
Where to find that meanings and different values?
Thanks
Daniel
begin:vcard
n:BETAILLE;Daniel
tel;fax:01 64 46 47
Hello,
Just small question about postgres query optimizer.
If I have a table with 2 fields a and b.
I have indices for both of them.
Table is quite large (> 10).
I do:
select * from q where a = 10 and b = 20;
I know that the best solution is to build the index on both columns, but...
Will po
Christopher Smith wrote:
> The better url i found is http://www.link.it/mailman/listinfo/slash-pgsql :)
Sorry, ofcourse it's true, blame my tired mind.
Thanks
Alessio
--
Alessio F. Bragadini[EMAIL PROTECTED]
APL Financial Services http://www.sevenseas.org/~alessio
Nicosia
15 matches
Mail list logo
