On 6/19/05, Karl O. Pinc <[EMAIL PROTECTED]> wrote:
>
> On 06/19/2005 11:16:34 AM, Jose Gonzalez Gomez wrote:
> > On 6/17/05, Bruno Wolff III <[EMAIL PROTECTED]> wrote:
> > > On Fri, Jun 17, 2005 at 14:35:01 +0200,
> > > Jose Gonzalez Gomez <[EMAIL PROTECTED]> wrote:
> > > >
> > > > The problem
I am not sure what locale I was running as I had not set it when doing initdb.
I created a new DB with --locale=en_US.utf8 -E UNICODE
and imported my data from original source (not copied from old DB) and still
have the smae problem that UNICODE strings with double byte characters that are
not e
On Fri, Jun 17, 2005 at 01:45:34PM -0400, Berend Tober wrote:
> Gavin Love wrote:
> >Here is the script I use for my daily backups nothing special but it
> >works well. Just run it as a user with admin privs on the database.
> >It will pull the list of all your databases except templates and dump
# [EMAIL PROTECTED] / 2005-06-20 01:02:38 +0200:
> I wanted to define a function like this:
> create or replace function fun(...)...
> create temp table qaz as subquery1;
> create temp table wsx as subquery1;
> select * from qaz, wsx;
> language sql;
> but I get postgresql error saying that relatio
Hi List,
I have a(n external) system driven by data in a Postgres database. I am
looking for a functionality, which would asynchronously inform the
system of any updates into the database, so the system could reflect the
updates (without having to poll the database at regular basis).
I have been
On Monday 20 of June 2005 00:12, you wrote:
> I have such a statement:
> select * from (subquery1) as foo, (subquery2) as bar;
> Both subqueries are reasonably fast (<0.5s) and generate results that have
> several (<10) rows but the whole query takes forever to execute.
Ok, postgresql wanted to be
Hello!
This query
select 1 where 'vasya' = (select 'vasya')
produces
ERROR: failed to find conversion function from "unknown" to text
in my 8.0.0.
If I explicitly cast second 'vasya' to text, it is Ok.
Everything is fine if data comes from database, IOW
type is known.
Is what I am describ
I don't have personal experience with this, but I thought it was fairly
common to DEFER constraint checking until after a restore completed,
for exactly this reason.
- John Burger
MITRE
---(end of broadcast)---
TIP 9: the planner will ignore
I am trying to restore a large database and use the commond
cat dumpfilename | psql dbname
I got a out of memory error when it is trying to copy a String with size
of 245,000,000
Can anyone shed some light on it? Thanks for your help,
wenyan
---(end of broadcast)-
Hi!
Other (besides text literal from my previous message)
condition when we have
ERROR: failed to find conversion function from "unknown" to ..
is usage of null.
When I invoke
select 1 where 5 in (null)
everything is Ok,
though when I try
select 1 where 5 in (select null)
I get
ERROR: f
On Mon, Jun 20, 2005 at 08:18:00AM -0400, John Burger wrote:
>
> I don't have personal experience with this, but I thought it was fairly
> common to DEFER constraint checking until after a restore completed,
> for exactly this reason.
Regarding DEFERRABLE, according to the CREATE TABLE documenta
Hi, I'm having some troubles using the driver ODBC! The problem is that a did
some reports with Crystal Reports XI and used PostgreSQL 7.4.x with
psqlodbc-07_03_0200, now I have migrate to PostgreSQL 8.0.3 and I'm using
psqlodbc-08_00_0101 but the reports that I did is not working anymore beca
O.B. wrote:
I'm attempting to install PostgreSQL v8.0.3 on a Windows XP SP2 machine.
The error log below is generated and the installation rolls back. I
have verified that the "postgres" user (service account) has
read/write/execute permissions to the entire C: drive as well as having
the "
Wenyan Ji wrote:
I am trying to restore a large database and use the commond
cat dumpfilename | psql dbname
I got a out of memory error when it is trying to copy a String with size
of 245,000,000
Can anyone shed some light on it? Thanks for your help,
Why are you using cat rather than just:
Rodrigo Katsumoto Sakai wrote:
Hi, I'm having some troubles using the driver ODBC! The problem is
that a did some reports with Crystal Reports XI and used PostgreSQL
7.4.x with psqlodbc-07_03_0200, now I have migrate to PostgreSQL
8.0.3 and I'm using psqlodbc-08_00_0101 but the reports that I did
On Sun, Jun 19, 2005 at 17:16:34 +0100,
Jose Gonzalez Gomez <[EMAIL PROTECTED]> wrote:
> >
> There would be no problem in doing so with such an easy case, but
> think about having a table with cities (hundred, thousands?) and then
> have four copies for each of the above posibilities with its re
On Mon, Jun 20, 2005 at 04:33:43AM +0200, Milan Krcmar wrote:
>
> I have a(n external) system driven by data in a Postgres database. I am
> looking for a functionality, which would asynchronously inform the
> system of any updates into the database, so the system could reflect the
> updates (witho
Well, the driver psqlodbc-07 works on PostgreSQL, but not very well!
My problem is that I have some tables, for exemple:
create table service (
cod_service int,
nam_service varchar(255) not null default '',
des_service varchar(255)
);
So I did some reports (Crystal Reports) on that ta
Rodrigo Katsumoto Sakai wrote:
Well, the driver psqlodbc-07 works on PostgreSQL, but not very well!
My problem is that I have some tables, for exemple:
create table service (
cod_service int,
nam_service varchar(255) not null default '',
des_service varchar(255)
);
[snip]
> then occur
O.B. wrote:
O.B. wrote:
I'm attempting to install PostgreSQL v8.0.3 on a Windows XP SP2
machine. The error log below is generated and the installation rolls
back. I have verified that the "postgres" user (service account) has
read/write/execute permissions to the entire C: drive as well as
Hi All,
I have 7.4.7 version, my question is what are OIDS user for? What can
one do with it!
Thanks,
Hrishi
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Hrishikesh Deshmukh writes:
>I have 7.4.7 version, my question is what are OIDS user for? What can
>one do with it!
they're for internal use only, they may go away, so don't do anything
with them, pretend that they aren't even there.
richard
---(end of broadcast)
I'm wondering why the PG installer won't allow an install within a terminal
session (Windows remote desktop). Is there an easy answer to this one?
Thanks!
A. Mous
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an in
Am Montag, den 20.06.2005, 11:57 -0400 schrieb Hrishikesh Deshmukh:
> Hi All,
>
> I have 7.4.7 version, my question is what are OIDS user for? What can
> one do with it!
Google or your favourite search engine helps :-)
http://www.postgresql.org/files/documentation/books/aw_pgsql/node71.html
is
Some of the data required by the check function
is being restored after the data being checked
by the function and so it all fails the constraint.
Are you saying that the check function perform queries against other
data? That might not be a good idea -- consider what happens if
the data change
Hi,
thank you very much. These are very good ideas, I think.
I forgot one thing to mention. We will have very few clients (max. 20) and
all clients will be required to have a fix IP address. Fix IP addresses can
be listed in pg_hba.conf to filter incoming IPs very efficiently. With this
note, do y
On 6/17/05, Együd Csaba <[EMAIL PROTECTED]> wrote:
> Hi,
couple of things:
1. make sure postgresql is in a very tight chroot environment. without
shell or anything else.
2. make sure you have list of all client ips, and use firewall to
allow them, and only them to access postgresql port. all othe
On 06/20/2005 12:32:12 PM, Együd Csaba wrote:
Hi,
thank you very much. These are very good ideas, I think.
I forgot one thing to mention. We will have very few clients (max. 20)
and
all clients will be required to have a fix IP address. Fix IP
addresses can
be listed in pg_hba.conf to filter inc
Hello Mike,
thanks a lot for your posting!
> Have you considered using LISTEN/NOTIFY? The listener should receive
> notifications only if the notifying transaction commits.
Yes. I've seen them in the documentation _but_ missed the information
about the notification being delivered after the not
Hi Depesz,
thank you.
Most of your suggestions are in our plans. We plan to grant only the
necessary rights, filtering explicit IP addresses and so on.
We are going to consider applying a VPN. Also we are going to consider
logging all the querie executed by the server. You mentioned that pg8
provi
Hi Karl,
OK, I see the point. We are going to look around the VPN. So as a
conclusion: can we state, that, in addition to all the security features
postgres provides, applying a VPN - with SSL and firewal - is enough to
provide the necessary security?
The server will be a Linux(??) based system.
"A. Mous" <[EMAIL PROTECTED]> writes:
> I'm wondering why the PG installer won't allow an install within a terminal
> session (Windows remote desktop). Is there an easy answer to this one?
Because it doesn't work ;-)
I don't recall why not, myself, but there was discussion of the point
last year
On 06/20/2005 01:45:48 PM, Együd Csaba wrote:
Hi Karl,
OK, I see the point. We are going to look around the VPN. So as a
conclusion: can we state, that, in addition to all the security
features
postgres provides, applying a VPN - with SSL and firewal - is enough
to
provide the necessary security
Richard Huxton wrote:
O.B. wrote:
Here's additional information from the log file surrounding the
problem with initdb failing:
Action 18:10:09: SetPermissions. Setting filesystem permissions...
MSI (s) (2C:AC) [18:10:09:323]: Executing op:
CustomActionSchedule(Action=SetPermissions,ActionTyp
Summary: depending on the value, the planner will sometimes choose a seq
scan, sometimes an index scan. The former produces terrible performace,
the latter great performance.
The long story: we had a disk failure (NOT the disk the db was on) and
the machine's system disk had to be rebuilt fro
I got this error while doing a pg_dump on one of my tables -- any ideas?
pg_dump: ERROR: invalid memory alloc request size 18446744073709551613
pg_dump: SQL command to dump the contents of table "users" failed:
PQendcopy() failed.
pg_dump: Error message from server: ERROR: invalid memory allo
I got this error while doing a pg_dump on one of my tables -- any ideas?
pg_dump: ERROR: invalid memory alloc request size 18446744073709551613
pg_dump: SQL command to dump the contents of table "users" failed:
PQendcopy() failed.
pg_dump: Error message from server: ERROR: invalid memory alloc
Hi
I have just installed 8.0.3, and my standard pg_hba config no longer works.
I usually enable the postgres accound using
# TYPE DATABASEUSERCIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all postgres iden
Simon Windsor <[EMAIL PROTECTED]> writes:
> However, with 8.0.3, the format appears to have changed to
> # host DBNAME IP_ADDRESS ADDRESS_MASK AUTHTYPE [AUTH_ARGUMENT]
> # local DBNAME AUTHTYPE [AUTH_ARGUMENT]
Better check again ... it hasn't looked like that since PG 7.2.
Thank you very much !
- Original Message -
From: "John DeSoi" <[EMAIL PROTECTED]>
To: "Zlatko Matić" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, June 20, 2005 3:40 AM
Subject: Re: [GENERAL] user/groups query ?
On Jun 19, 2005, at 3:56 PM, Zlatko Matić wrote:
How to make a query that wi
Hi All,
I was wondering if you anybody has good references for information
retrieval in databases based on computational geometry methods?
Thanks in advance.
Hrishi
---(end of broadcast)---
TIP 6: Have you searched our list archives?
Bart Grantham <[EMAIL PROTECTED]> writes:
> ... it may be relevant that one node_id has 15 times as many connections:
> ... but that shouldn't make a difference to the planner, should it?
Of course it should (and does).
> Yes, I've vacuum analyzed.
What you need to do is show EXPLAIN ANALYZE o
Akash Garg <[EMAIL PROTECTED]> writes:
> I got this error while doing a pg_dump on one of my tables -- any ideas?
> pg_dump: ERROR: invalid memory alloc request size 18446744073709551613
Did you really transcribe that accurately? The number's an order of
magnitude too large to fit in even an i
I've got an interesting problem - this MIGHT (probably) isn't the right
forum for this. (pointed here from "interfaces")
however - I'd like to restrict access to specific records and groups of
records (based on another table) - and I'm not even sure where to start
looking. I suspect I actual
Tino Wildenhain wrote:
Google or your favourite search engine helps :-)
http://www.postgresql.org/files/documentation/books/aw_pgsql/node71.html
is among the first results.
Unfortunately those docs are quite out of date. This page is better:
http://developer.postgresql.org/docs/postgres/data
I just upgraded 7.4 to 8.0 and I have noticed that i am getting alot of error
that are saying i have a type problem. For example it is saying big int
expected but it was sent character varying. These same queries use to work in
7.4 I am using java and jboss. My queries are all dynamic sql in
I've been backing up my databases by piping pg_dump into gzip and
burning the resulting files to a DVD-R. Unfortunately, FreeBSD has
problems dealing with very large files (>1GB?) on DVD media. One of my
compressed database backups is greater than 1GB; and the results of a
gzipped pg_dumpall
On Mon, Jun 20, 2005 at 08:35:46PM +0200, Milan Krcmar wrote:
> > > I don't know how the various replication tools solve this - do you?
> >
> > Not sure; maybe some of the people who work on such tools can
> > comment.
>
> Still an unresolved issue. Those replication tools must have existed
> bef
"Andrew L. Gould" <[EMAIL PROTECTED]> writes:
> I've been backing up my databases by piping pg_dump into gzip and
> burning the resulting files to a DVD-R. Unfortunately, FreeBSD has
> problems dealing with very large files (>1GB?) on DVD media. One of my
> compressed database backups is great
On Mon, Jun 20, 2005 at 09:28:51PM -0500, Andrew L. Gould wrote:
> I've been backing up my databases by piping pg_dump into gzip and
> burning the resulting files to a DVD-R. Unfortunately, FreeBSD has
> problems dealing with very large files (>1GB?) on DVD media. One of my
> compressed databa
My take on this. For a while I've tried to setup my own internal
documentation system for my company but it turned out to be half-baked,
unfriendly to use, etc. Mainly because I have to spend most of my time
doing product development and end up with zero time to work on the
documentation.
The
On Monday 20 June 2005 09:53 pm, Tom Lane wrote:
> "Andrew L. Gould" <[EMAIL PROTECTED]> writes:
> > I've been backing up my databases by piping pg_dump into gzip and
> > burning the resulting files to a DVD-R. Unfortunately, FreeBSD has
> > problems dealing with very large files (>1GB?) on DVD me
On Monday 20 June 2005 10:14 pm, Alvaro Herrera wrote:
> On Mon, Jun 20, 2005 at 09:28:51PM -0500, Andrew L. Gould wrote:
> > I've been backing up my databases by piping pg_dump into gzip and
> > burning the resulting files to a DVD-R. Unfortunately, FreeBSD has
> > problems dealing with very larg
On Mon, Jun 20, 2005 at 05:17:57PM -0700, Teunis Peters wrote:
>
> however - I'd like to restrict access to specific records and groups of
> records (based on another table) - and I'm not even sure where to start
> looking. I suspect I actually need to look into triggers and/or
> embedded libr
[ BCC to general. ]
I have received very few replies to my suggestion that we implement E''
for escaped strings, so eventually, after a few major releases, we can
have '' treat backslashes literally like the SQL standard requires.
I assume this is because most people say, "yea, it is going to be
Am Montag, den 20.06.2005, 21:28 -0500 schrieb Andrew L. Gould:
> I've been backing up my databases by piping pg_dump into gzip and
> burning the resulting files to a DVD-R. Unfortunately, FreeBSD has
> problems dealing with very large files (>1GB?) on DVD media. One of my
> compressed databas
Hi,
The computer with database has lost power and after restarting I can't
connect to database:
connection to database "db_client" failed: FATAL: invalid memory alloc
request size 4294901760
version:
postgresql-7.4.6
Help me with this problem. I don't have reserve copy of database :(
Thank
57 matches
Mail list logo
