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]
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
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
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
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
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
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
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
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
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
--
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
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 -
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
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
...
> 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
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
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
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.
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
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: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
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
> >
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
"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
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
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
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
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
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
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
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,
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
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
> 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
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
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
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
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
> 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
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
40 matches
Mail list logo
