On Tue, 11 Jul 2006, Ken Johanson wrote:
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)?
that woudl be a safe ball park ... we're currently in the process of
working up to feature freeze for August 1st ...
Mar
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
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
subscr
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 su
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 ma
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 yo
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 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 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,
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 mod
> > 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
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
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 s
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 ca
-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 i
"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
overcomm
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 !=- i
>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 co
"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
--
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 support
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, wh
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
#end
> > 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 do
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
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, e
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.
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.
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 probl
"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
possibl
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 sta
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=# se
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
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
>
> *Somethi
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 inc
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 po
> 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
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
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 unders
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/bugf
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 shu
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 once
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 i
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 start
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 no
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 encourage
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
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 usin
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 unders
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 durin
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 literall
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 the
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 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
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%# '
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 prom
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
indexe
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 cou
"[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 broadcast)---
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 Files
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
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 broadcast)-
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 index
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,
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 S
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 ni
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
use
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
--- Begin Message ---
Hi list,
i execute
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 successfully?
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
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
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 wit
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 not
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. Kretsc
73 matches
Mail list logo
