Eylem Koksal wrote:
I'm trying to download v8.0 for fedora core 3.
But the last page i see is :
Choose a download mirror
Downloading:
/binary/v8.0/linux/rpms/fedora/fedora-core-3/postgresql-server-8.0.0-1PGDG.i686.rpm
None of the mirrors work. The message at the status
bar says "Connecting to rem
> For a full list of bugs fixed in this version, please see the
> HISTORY file, which can be found at:
>
> http://www.postgresql.org/ftp/source/v8.0.2/HISTORY
This link should be:
http://wwwmaster.postgresql.org/download/mirrors-ftp?file=source%2Fv8.0.
2%2FHISTORY
or simply
http://www.po
Hmm; the only occurrence of that string in the sources is in
nodes/read.c, which AFAIK would never be invoked for a query entered
straight from the client. What could trigger it would be trying to
read a rule that is misformatted for some reason. Maybe you have
a damaged pg_user view definition
Hello,
I have a table with columns defines as varchar that have values in format
'-MM-DD HH:MM:SS'.
Now, if I do a
select timestamp '2005-10-10 10:10:10';
I get the value just fine. I can use abstime()::integer on the result to
find the unix timestamp. (This is the simplest way I could find
Hi everyone,
i just got a new job in a small entreprise and they are using postgres as a
database for their application. I was stupefied cause the database design is
so bad : we can even say it has been done by amateurs. I observed the
following problems till now:
1- redondancy ( TOO MUCH)
2- M
I suggest you make a report identifying these critical points, the current consequences (use, maintenance, performance, resources (hardware, time, etc.)), and a study of the future. Also, expose the benefits of a good design for the future (including the costs of the migration).
Regards,
Ra
> But the people i am working with are not considering the restructuring of
> the database. They are even thinking of expanding it by adding new
> modules.
> Please can someone advise me, or tell me what to do, what may be the
> consequences
I have been working with databases for web scripts (P
Hello,
I am trying to find a solution for the following case:
replicate the database from a web application on our Internetserver
(master) to a local database (slave) in our LAN with a local IP
address. We want to replicate only a few tables creates specially for
reports.
- the master cannot co
Costin,
You could probably use one of the functions listed here:
file:///usr/share/doc/postgresql-7.4.2/html/functions-formatting.html
If you want the varchar -> date conversion to happen automatically, you
should study this chapter:
file:///usr/share/doc/postgresql-7.4.2/html/typeconv.html
HTH,
On Apr 6, 2005, at 2:53 PM, Otto Blomqvist wrote:
secom=# select f1, f2, f3 from testpassbyval(1, (Select number1 from
test));
ERROR: more than one row returned by a subquery used as an expression
This is where I fail. Am I even on the right path here ? Writing the
actual
parsing function will
On Mon, Apr 11, 2005 at 09:39:13AM +, Jinane Haddad wrote:
> My question is with such database, what are the lomg term consequences or
> can we determinate them. I know that the querys will become slower, and the
> database will grow more quickly ... And a lot of information will not be
> tr
Andrus Moor wrote:
The command
UPDATE dok SET krdokumnr=NULL WHERE krdokumnr NOT in (select dokumnr from
dok);
That's a rather dangerous query; I'm pretty sure it updates a lot more
than you think.
There is a long standing "bug" in the SQL standard where NOT IN (...,
..., NULL) always evaluates
Le lundi 11 avril 2005 à 09:39 +, Jinane Haddad a écrit :
> i just got a new job in a small entreprise and they are using postgres as a
> database for their application. I was stupefied cause the database design is
> so bad : we can even say it has been done by amateurs.
> But the people i
I think bytea is a little bit slower then large object.
Regards
Laser
If speed (add/get) is the only concern, image files could be big (~10M),
and database only serves as storage. In the postgresql 8, which type
(bytea vs large object) is the preferred one? Is it true, in general,
that bytea insert
Hiya
Is it possible to insert a record data type into a table, or am I going
to have to refer to each attribute individually in an insert?
what I would like to be able to do is simply
INSERT INTO newtable VALUES (NEW);
and have the whole NEW record in a trigger inserted into the new tabl
PFC <[EMAIL PROTECTED]> writes:
>> Hmm; the only occurrence of that string in the sources is in
>> nodes/read.c, which AFAIK would never be invoked for a query entered
>> straight from the client. What could trigger it would be trying to
>> read a rule that is misformatted for some reason. Maybe
"Costin Manda" <[EMAIL PROTECTED]> writes:
> select setuptime::timestamp from billing; - error (cannot cast type
> character varying to timestamp without timezone!?)
It works for me in 8.0. In some releases you need to cast to text
first, for example in 7.4:
regression=# select '2005-10-10 10:10
Graeme Hinchliffe <[EMAIL PROTECTED]> writes:
> what I would like to be able to do is simply
> INSERT INTO newtable VALUES (NEW);
In 8.0 it works to spell it "new.*".
regression=# create table z1 (f1 int, f2 text);
CREATE TABLE
regression=# create table z2 (f1 int, f2 text);
CREATE TABLE
regressi
On Mon, Apr 11, 2005 at 01:00:43PM +0300, Costin Manda wrote:
> > But the people i am working with are not considering the
> > restructuring of the database. They are even thinking of expanding
> > it by adding new modules.
>
> > Please can someone advise me, or tell me what to do, what may be
> >
On Mon, 2005-04-11 at 04:39, Jinane Haddad wrote:
> Hi everyone,
>
> i just got a new job in a small entreprise and they are using postgres as a
> database for their application. I was stupefied cause the database design is
> so bad : we can even say it has been done by amateurs. I observed the
You might try comparing the results of
select ev_action from pg_rewrite where ev_class = 'pg_user'::regclass;
from the two builds.
regards, tom lane
Well...
I'll spare your eyes and tell you right away that the results are
identical... they're at the bottom of the
On Mon, 2005-04-11 at 04:40, Costin Manda wrote:
> Hello,
>
> I have a table with columns defines as varchar that have values in format
> '-MM-DD HH:MM:SS'.
>
> Now, if I do a
> select timestamp '2005-10-10 10:10:10';
> I get the value just fine. I can use abstime()::integer on the result t
PFC <[EMAIL PROTECTED]> writes:
>> You might try comparing the results of
>> select ev_action from pg_rewrite where ev_class = 'pg_user'::regclass;
>> from the two builds.
> I'll spare your eyes and tell you right away that the results are
> identical... they're at the bottom of the email.
Title: Convert Cursor to array
hi,
i'm
trying to port an oracle script to postgresql, but i don't find any alternative
for some problems
this
is an extract of the oracle script :
DEFINE MDNSImportBlobDirectory =
C:\Temp\_lm_\ExternalTablesSpace\mdns;@createFraweWorkTables_script.ddl;@creat
If you want, you can try building with --enable-debug and getting a gdb
traceback from the call to errfinish(). That would at least give us
some clue where in the rule text it's getting confused.
Is this :
./configure --enable-debug
?
I have no idea what to type in gbd to get
> Hello,
>
> My objective is design and build a Data Mart what enable OLAP queries
> using Open Source tools.
>
> I will want know if the solution below is possible and correct or exist a
> better solution:
>
> 1 - The data will be generate to PostgreSQL from a commercial Database by
> a ETL pro
PFC <[EMAIL PROTECTED]> writes:
> I have no idea what to type in gbd to get the trace, though
What I usually do is
- start a psql session
- in another window, find out the PID of the backend attached
to the psql session, and do
$ gdb /path/to/postgres backend_PID
...
Does large object table space is associated with the table (with oid)'s
table space created? If not, what's about table with bytea column?
Thanks.
johnl
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
Renato Cramer wrote:
My objective is design and build a Data Mart what enable OLAP queries
using Open Source tools.
I will want know if the solution below is possible and correct or exist a
better solution:
1 - The data will be generate to PostgreSQL from a commercial Database by
a ETL process.
2 -
--
James Strickland - MCP
IT Manager
American Roamer
901-377-8585
http://www.americanroamer.com
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that yo
Fritz Bayer wrote:
Hello,
I`m using postgresql 7.2.1. According to the following lines data in
my database gets encoded as unicode. Server and client communication
seems to use unicode as well:
woody=# select version();
version
---
Postgre
Hello,
Client is getting the following error when attempting
to do an insert on a table:
ERROR: duplicate key violates unique constraint
event_tbl_evt_id_key
Client is using PostgreSQL 7.4.2 on Sparcv9 running
Solaris.
We have the following tables:
EVENT_TBL
evt_id bigserial, unique
d1
Hello,
I am working on live server where we have
installed postgres database as our back end. But now the problem is due to
continues work on postgres, size of log files has become problem for us.
And the partition where our postgres exists is full. Postmaster is not working
now. I tried
Bill Chandler <[EMAIL PROTECTED]> writes:
> Client is getting the following error when attempting
> to do an insert on a table:
> ERROR: duplicate key violates unique constraint
> event_tbl_evt_id_key
What's the exact query (or queries) causing this? Do you have any
triggers or rules that might
Hi,
I are trying to upgrade from Postgresql
v7.3 Cygwin environment to 8.0.1 on a plain Windows environment.
So, far, I can get most of the data transferred, but I cannot get
the large objects. Perusing the net, I got a hint that I must use
the -d dbname with the pg_restore utility. Unfortunat
Tom,
This is not the EXACT command (don't have that since
this a client site and they did not have logging
turned on) but the insert command would have looked
something like:
INSERT INTO EVENT_TBL VALUES(1039850293991, 'X.Y.Z',
1039110343000, '10.25', 1, 739950991)
For what its worth, the comman
You'll need to post the actual error to the list to have any hope of
receiving good help.
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
O
FERREIRA William (COFRAMI) wrote:
> hi,
>
> i'm trying to port an oracle script to postgresql, but i don't find
> any alternative for some problems this is an extract of the oracle
> script :
>
> DEFINE MDNSImportBlobDirectory =
> C:\Temp\_lm_\ExternalTablesSpace\mdns;
> @createFraweWorkTables_s
On Mon, 2005-04-11 at 11:03 -0700, Bill Chandler wrote:
> ERROR: duplicate key violates unique constraint
> event_tbl_evt_id_key
> EVENT_TBL
> evt_id bigserial, unique
> d1 numeric(13)
> obj_id numeric(6)
> d2 numeric(13)
> val varchar(22)
> correction n
Rafael Hernampérez Martín
Arquitecto de Bases de Datos
Tecnología, Soluciones e Integración
BULL España, S.A.
Po. de las Doce Estrellas, 2 - 28042 Madrid
Tel. 91 393 93 48 - Fax 91 393 93 22
e-mail: [EMAIL PROTECTED]
40 matches
Mail list logo
