Hi again everyone,
i got it to work, but came across another question concerning COPY. If i have a
column in a text file that i do not want/need in the database, is there a way
not to read that column from the file without having to edit the file
beforehand?
Thanks for your advice!
A.
Hello Anika,please see that we are in different timezones, and I usually try to sleep at night. Please also try to keep your mail on the list, so others can try to help you as well.Now, dig deeper in the analyzis:
1st) Logon as Admin, checkout services.mscis there a postgres service running? If
am 11.07.2006, um 9:24:06 +0200 mailte Christian Rengstl folgendes:
Hi again everyone,
i got it to work, but came across another question concerning COPY. If
i have a column in a text file that i do not want/need in the
database, is there a way not to read that column from the file without
On Tuesday 11. July 2006 10:10, A. Kretschmer wrote:
Do you have a UNIX-like operating system? Then you can use tools like
'cut':
[EMAIL PROTECTED]:~$ echo s1,s2,s3 | cut -d ',' -f 1,3
s1,s3
This result can you pipe into psql.
It would be nice, though, if we had something like Oracle's
Karsten Hilbert wrote:
Just for your information:
In our Python implementation of a fuzzy timestamp type we
used accuracy values ranging from 1 to 7 denoting the
precision of a complete timestamp definition:
7 - full subsecond accuracy (7 digits precision)
6 - seconds
5 - minutes
4 - hours
3 -
Hi list,
i execute an operation (a combination of COPY FROM and INSERT) that can take
several minutes via JDBC. Now I would like to show some progress to the user.
Is there a way to obtain information as to the status of the operation or at
least to know when the operation is done
Forget the last email. Today's simply not my day...
--
Christian Rengstl M.A.
Klinik und Poliklinik für Innere Medizin II
Kardiologie - Forschung
Universitätsklinikum Regensburg
B3 1.388
Franz-Josef-Strauss-Allee 11
93053 Regensburg
Tel.: +49-941-944-7230
---BeginMessage---
Hi list,
i execute an
Hi :)
I have funny problem, which i don't understand. I'm adding new users to
PostgreSQL with some password (for example : aa) and i can't log
in any database. But after that i change password to bb and i can
log in. Some passwords are good, and some are bad. And it depends on
user
Leif B. Kristensen wrote:
On Tuesday 11. July 2006 10:10, A. Kretschmer wrote:
Do you have a UNIX-like operating system? Then you can use tools like
'cut':
[EMAIL PROTECTED]:~$ echo s1,s2,s3 | cut -d ',' -f 1,3
s1,s3
This result can you pipe into psql.
It would be nice, though, if we
On Tuesday 11. July 2006 15:22, Alvaro Herrera wrote:
Leif B. Kristensen wrote:
It would be nice, though, if we had something like Oracle's
SQL-Loader for PostgreSQL. It's a very powerful tool for
transforming and loading data.
We do have very powerful tools, even more powerful than
My first ever newsgroup PostgreSQL question... I want to move data
between some very large databases (100+ gb) of different schema at our
customer sites. I cannot expect there to be much working partition
space, so the databases cannot exist simultaneously. I am also
restricted to hours, not days,
hi there.
i'm trying to clear data in a table but somehow it takes way too much
time than i once expected (i'm using the formal 'delete from xxx' type
of query.).
this table's got several foreign keys and i suspect that is why it
takes longer than expected.
my question is that
would having
After further reading, I'm wondering if I should instead try to use
libpq calls like PQgetCopyData, PQputCopyData, and PQputCopyEnd.
Would they be a viable alternative to provide both the speed and
flexibility I'm looking for?
-Lynn
---(end of
Hello,
I'm a pgsql novice and here is what I'm trying to do:
1.I need to create a dynamic table with the column names fetched
from the database using a select statement from some other table. Is
it possible? Could you point me to a simple example on how to do it?
2. I would like to compare
We have PostgreSQL 8.1 running on Windows 2000 for a few weeks now, when
we try to start the service, it could not start claiming no error
returned. So, I go to the command prompt and run the following:
C:\Program Files\PostgreSQL\8.1\bin\pg_ctl.exe runservice -N
pgsql-8.1 -D C:\Program
[EMAIL PROTECTED] [EMAIL PROTECTED] writes:
Is it possible to compile-link together frontend pg_dump code with
backend code from copy.c?
No. Why do you think you need to modify pg_dump at all?
regards, tom lane
---(end of
On Tue, Jul 11, 2006 at 01:27:49AM -0400, Alvaro Herrera wrote:
But I think the main problem may be getting our calling conventions
right. I mean, how would you do a PG_GETARG_BOOL() or stuff like that?
Maybe if we offered PG_GETARG_DATUM and PG_RETURN_DATUM equivalents in
PL/Perl we could
Nuno,
It's the foreign keys that point to this table are the problem, not the
foreign keys of the table itself. In other words, the child tables for
which the table you delete from is the parent... do you have indexes on
the foreign keys of the child tables which point to this table ? Those
We have PostgreSQL 8.1 running on Windows 2000 for a few weeks now. Don't know
what happened, the users reported a connection issue to the database and I
found the service will not start. When
we try to start the service, it could not start claiming no error
returned. So, I go to the command
Jorge
my test, i created one utf8 database but don´t work
ideas?
testutf8=# \set
VERSION = 'PostgreSQL 8.1.0 on i386-pc-linux-gnu,
compiled by GCC cc (GCC) 3.3.5
(Debian 1:3.3.5-13)'
AUTOCOMMIT = 'on'
VERBOSITY = 'default'
PROMPT1 = '%/%R%# '
On 10 Jul 2006 10:33:52 -0700, Karen Hill [EMAIL PROTECTED] wrote:
Hello,
How would one go about creating a US telephone type in the format of
(555)-555- ? I am at a loss on how it could be accomplished in
the most correct way possible while not going into the various
different country
Anika,Sorry, I dont know what time zone you are in - I usually go to bed 4am and am up 8am in my timezone... I do not know programming AT ALL - just html I also dont know how to put the mail back on the list...sorry.
I am in CEST (central europe summer time) ... just giving that info, so you
On 6/30/2006 1:07 PM, Merlin Moncure wrote:
* mysql has a few features here and there which are nice...just to
name a few, flush tables with lock, multiple insert, etc
I have no clue what flushing tables with lock might be good for. Are
applications in MySQuirreL land usually smarter than
On 7/10/2006 10:00 PM, Alex Turner wrote:
http://dev.mysql.com/doc/refman/5.1/en/replication-row-based.html
5.1
Ah, thanks. So I guess 5.1.5 and 5.1.8 must be considered major feature
minor/bugfix releases. I still don't understand how people can use
software in production that has
I have a PostgreSQL schema definition. I'd like to be able to use it as
the basis for code generation in a software build process --
specifically, I want to generate Java enums corresponding to the table
definitions. However, it would be inconvenient to have to connect to a
running database
On Tue, 2006-07-11 at 10:45, Jan Wieck wrote:
On 7/10/2006 10:00 PM, Alex Turner wrote:
http://dev.mysql.com/doc/refman/5.1/en/replication-row-based.html
5.1
Ah, thanks. So I guess 5.1.5 and 5.1.8 must be considered major feature
minor/bugfix releases. I still don't understand how
try truncate. just be aware that truncate is being upgraded in 8.2
for better handling of foreign key isues.
merlin
On 9 Jul 2006 20:35:39 -0700, nuno [EMAIL PROTECTED] wrote:
hi there.
i'm trying to clear data in a table but somehow it takes way too much
time than i once expected (i'm using
On 7/11/06, Jan Wieck [EMAIL PROTECTED] wrote:
On 6/30/2006 1:07 PM, Merlin Moncure wrote:
I have no clue what flushing tables with lock might be good for. Are
applications in MySQuirreL land usually smarter than the DB engine with
respect to when to checkpoint or not?
no, but the ability to
On Tue, 2006-07-11 at 11:04, Jan Wieck wrote:
On 6/30/2006 1:07 PM, Merlin Moncure wrote:
* mysql has a few features here and there which are nice...just to
name a few, flush tables with lock, multiple insert, etc
The multiple insert stuff is not only non-standard, it also encourages
On 7/11/2006 1:08 PM, Scott Marlowe wrote:
On Tue, 2006-07-11 at 11:04, Jan Wieck wrote:
On 6/30/2006 1:07 PM, Merlin Moncure wrote:
* mysql has a few features here and there which are nice...just to
name a few, flush tables with lock, multiple insert, etc
The multiple insert stuff is not
On 7/11/06, Harald Armin Massa [EMAIL PROTECTED] wrote:
Propblem gets clearer. I had similiar symptoms before; so my rough guess is:
your postgres user did loose a privilege.
Technical background:
the postgres-account is a low privileged user, which logs on automatically
when the service starts
On Jul 11, 2006, at 11:49 AM, Vance Maverick wrote:
I have a PostgreSQL schema definition. I'd like to be able to use
it as
the basis for code generation in a software build process --
specifically, I want to generate Java enums corresponding to the table
definitions. However, it would be
On 11.07.2006, at 19:36 Uhr, Merlin Moncure wrote:
As to preparing
statements, I agree in principle although I don't know if that is a
good argument not to make the non-paramaterized interface more
powerful.
It is not, as prepared statements have the problem that they are only
optimized
We have 4 8.1.2 cluster running on an HP-UX 11.23 Itanium, repeatedly
dying with the following log message:
2006-07-11 12:52:27 EDT [21582]LOG: received fast shutdown request
2006-07-11 12:52:27 EDT [21591]LOG: shutting down
2006-07-11 12:52:27 EDT [21591]LOG: database system is
On 7/11/2006 11:57 AM, Scott Marlowe wrote:
On Tue, 2006-07-11 at 10:45, Jan Wieck wrote:
On 7/10/2006 10:00 PM, Alex Turner wrote:
http://dev.mysql.com/doc/refman/5.1/en/replication-row-based.html
5.1
Ah, thanks. So I guess 5.1.5 and 5.1.8 must be considered major feature
minor/bugfix
On 7/11/2006 1:36 PM, Merlin Moncure wrote:
that said, i tried to put fairness in my comparison, many pg/mysql
comparisons ulimately resort to a dismissive mysql diss which does not
play well to the uninformed third party. so, I made an attempt at
something with some substance.
Totally
marcelo Cortez [EMAIL PROTECTED] writes:
testutf8=# \set
...
ENCODING = 'UTF8'
HISTSIZE = '500'
testutf8=# select upper('ñ');
ERROR: invalid UTF-8 byte sequence detected near byte
0xf1
testutf8=#
You're telling the system that your client encoding is utf8, but
it looks from here like
The multiple insert stuff is not only non-standard, it also encourages
the bad practice of using literal values directly in the SQL string
versus prepared statements with place holders. It is bad practice
because it introduces SQL injection risks since the responsibility of
literal value
Version postgres 7.4.7:
Following sql
UPDATE tablename SET value = 0.0 where value!=-9.4;
results in the error message
ERROR: operator does not exist: smallint !=- integer
HINT: No operator matches the given name and argument type(s). You may
need to add explicit type casts.
Seems that
On 7/11/06, Vance Maverick [EMAIL PROTECTED] wrote:
I have a PostgreSQL schema definition. I'd like to be able to use it as
the basis for code generation in a software build process --
specifically, I want to generate Java enums corresponding to the table
definitions. However, it would be
On Tuesday July 11 2006 1:17 pm, Tom Lane wrote:
Ed L. [EMAIL PROTECTED] writes:
We have 4 8.1.2 cluster running on an HP-UX 11.23 Itanium,
repeatedly dying with the following log message:
2006-07-11 12:52:27 EDT [21582]LOG: received fast
shutdown request
*Something* is sending
On 7/5/2006 3:51 PM, Bjørn T Johansen wrote:
Yes, but I need to return n fields from one table and n fiels from another, and
n fields from yet another
table, etc... and return this as some kind of record... How do I to this?
I wonder why your problem can't be solved by a simple join.
Jan
Tom , folks
I've recreated the database with --locale=es_AR
keyword
and all works fine
thanks a lot.
best
MDC
--- Tom Lane [EMAIL PROTECTED] escribió:
marcelo Cortez [EMAIL PROTECTED] writes:
testutf8=# \set
...
ENCODING = 'UTF8'
HISTSIZE = '500'
testutf8=# select
On 7/11/06, Guido Neitzer [EMAIL PROTECTED] wrote:
On 11.07.2006, at 19:36 Uhr, Merlin Moncure wrote:
As to preparing
statements, I agree in principle although I don't know if that is a
good argument not to make the non-paramaterized interface more
powerful.
It is not, as prepared
Ed L. [EMAIL PROTECTED] writes:
We have 4 8.1.2 cluster running on an HP-UX 11.23 Itanium, repeatedly
dying with the following log message:
2006-07-11 12:52:27 EDT [21582]LOG: received fast shutdown request
*Something* is sending SIGINT to the postmaster --- it's simply not
possible to
Guido Neitzer wrote:
On 11.07.2006, at 19:36 Uhr, Merlin Moncure wrote:
As to preparing
statements, I agree in principle although I don't know if that is a
good argument not to make the non-paramaterized interface more
powerful.
It is not, as prepared statements have the problem that
Paul Tilles [EMAIL PROTECTED] writes:
UPDATE tablename SET value = 0.0 where value!=-9.4;
ERROR: operator does not exist: smallint !=- integer
HINT: No operator matches the given name and argument type(s). You may
need to add explicit type casts.
This is not a bug, this is a feature.
Put
Jan Wieck [EMAIL PROTECTED] writes:
On 7/11/2006 1:08 PM, Scott Marlowe wrote:
I thought it was in the SQL 99 standard...
The SQL bible doesn't say SQL99, it says it is a DB2 specific feature.
If you're speaking of INSERT INTO foo VALUES (a, row), (another, row), ...
that's in SQL92. See
Jan Wieck wrote:
On 7/11/2006 1:08 PM, Scott Marlowe wrote:
On Tue, 2006-07-11 at 11:04, Jan Wieck wrote:
On 6/30/2006 1:07 PM, Merlin Moncure wrote:
* mysql has a few features here and there which are nice...just to
name a few, flush tables with lock, multiple insert, etc
The multiple
On Tue, 2006-07-11 at 12:11, Paul Tilles wrote:
Version postgres 7.4.7:
Following sql
UPDATE tablename SET value = 0.0 where value!=-9.4;
results in the error message
ERROR: operator does not exist: smallint !=- integer
HINT: No operator matches the given name and argument type(s).
Is it possible to compile-link together frontend pg_dump code with
backend code from copy.c?
No. Why do you think you need to modify pg_dump at all?
pg_dump and pg_restore provide important advantages for upgrading a
customer's database on site:
They are fast. I want to minimize
Title: Including C/C++ header files containing #defines using EXEC SQL INCLUDE
Here is the problem I am trying to solve:
I have Header files (C and C++) that check to ensure you don't load them twice by doing the following:
#ifndef MY_HDR_FILE
#define MY_HDR_FILE
Blah
Blah
Blah
We are writing a multi-master replication process for our Electronic
Medical Records product. We have written triggers in plPHP and then in
PL/Perl to keep an audit trail of the changes as well as flags so the data
can be replicated. We started with plPHP, but then server started
crashing,
On Jul 11, 2006, at 1:11 PM, Paul Tilles wrote:
ERROR: operator does not exist: smallint !=- integer
HINT: No operator matches the given name and argument type(s). You
may need to add explicit type casts.
I'm pretty sure the SQL-standard spelling of not equals is .
Postgres supporting
Ed L. [EMAIL PROTECTED] writes:
We are wondering if our swap space was too small, and when the
swap reservation failed, the OS was sending SIGINT??
I've never heard of an OS sending that particular signal for a memory
shortage. 'strace' may be your friend here.
-Doug
From a brief and similar session (below), perhaps the best solution is to
simply insert a space between the '=' and the '-'??
Welcome to psql 8.1.4, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql
Yes. That works. I think that the parser should work properly either way.
Paul
Bruce Momjian wrote:
Paul Tilles wrote:
Version postgres 7.4.7:
Following sql
UPDATE tablename SET value = 0.0 where value!=-9.4;
results in the error message
ERROR: operator does not exist: smallint !=-
Ed L. [EMAIL PROTECTED] writes:
We are wondering if our swap space was too small, and when the
swap reservation failed, the OS was sending SIGINT??
You'd have to check your OS documentation ... I thought HPUX would
just return ENOMEM to brk() for such cases. It doesn't do memory
overcommit
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Joshua D. Drake wrote:
The multiple insert stuff is not only non-standard, it also encourages
the bad practice of using literal values directly in the SQL string
versus prepared statements with place holders. It is bad practice
because it
Paul Tilles wrote:
Version postgres 7.4.7:
Following sql
UPDATE tablename SET value = 0.0 where value!=-9.4;
results in the error message
ERROR: operator does not exist: smallint !=- integer
HINT: No operator matches the given name and argument type(s). You
may need to add explicit type
On 11.07.2006, at 21:11 Uhr, Alvaro Herrera wrote:
I had the problem a few months ago, where my app server plugin and
the jdbc driver used prepared statements for selecting stuff from the
database. Most of the time, indexes weren't used at all, so
PostgreSQL performance was the worst I've ever
Paul Tilles wrote:
Version postgres 7.4.7:
Following sql
UPDATE tablename SET value = 0.0 where value!=-9.4;
results in the error message
ERROR: operator does not exist: smallint !=- integer
HINT: No operator matches the given name and argument type(s). You may
need to add
SQL_ASCII may also be an option (assign no special meaning to
characters at all), but I'm less sure of that. Can email address
contain multibyte characters? I didn't think so...
E-Mail addreses themselves can't, but the comment field of an
address can.
The comment field itself, in
Are you certain that it is the trigger that is crashing the process? If
that is true, then there may be a bug in plperl.
To debug, you could use gdb, but try this first:
Use the strict pragma. To do this in plperl (instead of plperlu), use:
BEGIN { strict-import(); }
or set strict
On Jul 11, 2006, at 7:43 AM, zordax wrote:
I have funny problem, which i don't understand. I'm adding new
users to PostgreSQL with some password (for example : aa) and
i can't log in any database. But after that i change password to
bb and i can log in. Some passwords are good,
On Mon, Jul 10, 2006 at 20:05:13 -0400,
Chris Browne [EMAIL PROTECTED] wrote:
worse, over time. Fortunately LD rates have been tending to fall...
Unless you call a country where the local phone company is charging userous
rates andmay be giving kickbacks to people who can get people to call
On Jul 11, 2006, at 6:29 PM, Bruno Wolff III wrote:
SQL_ASCII may also be an option (assign no special meaning to
characters at all), but I'm less sure of that. Can email address
contain multibyte characters? I didn't think so...
E-Mail addreses themselves can't, but the comment field of an
On Tue, Jul 11, 2006 at 06:05:18 -0700,
[EMAIL PROTECTED] wrote:
Hello,
I'm a pgsql novice and here is what I'm trying to do:
1.I need to create a dynamic table with the column names fetched
from the database using a select statement from some other table. Is
it possible? Could you
On Tue, Jul 11, 2006 at 13:11:16 -0400,
Paul Tilles [EMAIL PROTECTED] wrote:
Version postgres 7.4.7:
Following sql
UPDATE tablename SET value = 0.0 where value!=-9.4;
results in the error message
ERROR: operator does not exist: smallint !=- integer
HINT: No operator matches the
On Sun, Jul 09, 2006 at 20:35:39 -0700,
nuno [EMAIL PROTECTED] wrote:
hi there.
i'm trying to clear data in a table but somehow it takes way too much
time than i once expected (i'm using the formal 'delete from xxx' type
of query.).
this table's got several foreign keys and i suspect
Does anyone know roughly when there might be an 8.2 beta? Would a rough
guess of about November be right (1 year after 8.1)?
Regards,
ken
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
2006/7/11, Carl M. Nasal II [EMAIL PROTECTED]:
(...)
Any ideas of what is causing the server to crash will be helpful.
Below are the lines from the PostgreSQL serverlog file when the crash occurs:
LOG: server process
72 matches
Mail list logo
