Martijn van Oosterhout wrote:
On Thu, Mar 30, 2006 at 11:51:41AM -0700, Don Y wrote:
[snipped questions and answers]
Thanks!
- Wish list item: errdetail(va_list arg) et al. functions (Yeah,
I can write my own... but it would be nice if this was part
of the error reporting routines).
Tom Lane wrote:
Martijn van Oosterhout kleptog@svana.org writes:
On Thu, Mar 30, 2006 at 11:51:41AM -0700, Don Y wrote:
- Can *_in() be ever invoked with a NULL argument? Or, can I
safely assume that the pointer I am passed is valid?
You can't get a NULL there. Yes, the pointer is valid
On 4/4/06, Ottavio Campana [EMAIL PROTECTED] wrote:
hubert depesz lubaczewski wrote: 2) do you think it's possible ina plpgsql procedure select the name of a table into a variable and use that variable in the query? possible, but not really good way. read about 'execute' in plpgsql.
why isn't it
I've dumped a 7.4.5 database using pg_dump and when I used the result
via pgAdmin v1.4.2 on a remote 7.4.11 server, I get an error:-
ERROR: syntax error at or near 45183 at character 5848
and the offending code is:-
COPY jobs (job_id, client_id, title, start_date, final_date,
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: 03 April 2006 01:21
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Cant find temp tables
could be. i will have a look at the pgadmin site and see if i
can
Since I discovered the facilities in Postgres for providing and listing
column descrptions, I have found them very useful, especially for adding a
string showing physical units to my columns. For example:
\d+ cat
Table public.cat
Column | Type |
Michael Fuhr wrote:
On Mon, Apr 03, 2006 at 05:44:18PM +0200, Patrick Refondini wrote:
idns_target=# select test();
INFO: hello !
CONTEXT: SQL statement SELECT hello()
PL/pgSQL function test line 2 at perform
[...]
1. Is there anything wrong using RAISE this way.
Not in the sense
I am looking for service providers that offer postgresql hosting.
One requirement, cheap but reliable (if there is any such thing).
It will be good if they can run different versions simultaneously (on different
ports of course)
If they offer versions of apache, php, mysql etc simultaneously
Hi,
On Wed, 2006-04-05 at 10:16 +, Frank Church wrote:
I am looking for service providers that offer postgresql hosting.
We, at Command Prompt, provide PostgreSQL hosting:
http://www.commandprompt.com/services/sharedhosting/
For other companies, please visit:
Hi.
Is there any way (or working solution) to extend PostgreSQL to accept
Oracles outer join syntax with '(+)'?
Any pointers to docs on how to do this myself are also appreciated.
--
Until the next mail...,
Stefan.
---(end of broadcast)---
TIP
mstsc /console
It should work fine with this switch. I've used it many times.
I ran mstsc /console from my XP Proffessional and tried to install
Postgres 8.1.3 in two different
servers:
Windows 2003
Windows 2000
Both cause the following message:
---
Internal error
Stefan,
Why would you do that ? If you need a solution which works both on
postgres and oracle, use the standard outer join syntax supported by
postgres - it is supported by the latest oracle versions too.
We do this here successfully...
Cheers,
Csaba.
On Wed, 2006-04-05 at 14:46, Stefan
mstsc /console
It should work fine with this switch. I've used it many times.
I ran mstsc /console from my XP Proffessional and tried to
install Postgres 8.1.3 in two different
servers:
Windows 2003
Windows 2000
Both cause the following message:
---
last day to find a solution for me - i am on the edge.
here's a resume of what i am doing. note that i don't have the global
direcotry of $PGDATA.
first of all reinstall a new hard-drive and installed the same version
of postgresql (8.0.4) with the same configuration.
now
My databases are created in SQL ASCII by default.
Is there some disadvantage to this? As a British user, which is the preferred
character set and what advantage do I have to gain by using it?database
---(end of broadcast)---
TIP 2: Don't 'kill
Don Y [EMAIL PROTECTED] writes:
Yeah, I was hoping someone would have built a template for
new types that trimmed everything down to a single page/file
instead of having to snoop the source tree. :-(
The various new types in contrib/ are there in part to serve as models.
You could also look
On Wed, Apr 05, 2006 at 01:35:00PM +, Frank Church wrote:
My databases are created in SQL ASCII by default.
Is there some disadvantage to this? As a British user, which is the preferred
character set and what advantage do I have to gain by using it?database
SQL ASCII just means that
Chris Velevitch [EMAIL PROTECTED] writes:
I've dumped a 7.4.5 database using pg_dump and when I used the result
via pgAdmin v1.4.2 on a remote 7.4.11 server, I get an error:-
ERROR: syntax error at or near 45183 at character 5848
Does pgAdmin promise that it can read pg_dump scripts?
Hello,
I am having a problem of using initcap() for the French charater.
. create table test (id varchar(3));
. insert into test values('É');
. select initcap(id) from test;
*Got ERROR:* invalid multibyte character for locale
HINT: The server's LC_CTYPE locale is probably incompatible with
I cannot find any documentation of this situation.
Here is my system information:
$ uname -a
Linux Lab30.intrusic.com 2.6.15.7-0.1.smp.x86_64 #1 SMP Tue Mar 28
16:28:23 EST 2006 x86_64 x86_64 x86_64 GNU/Linux
I don't have strace installed, unfortunately, and getting approvals to
get it
Hi,
On Wed, 2006-04-05 at 09:53 -0400, Jonathan Beit-Aharon wrote:
I cannot find any documentation of this situatio
Which distro is this?
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services,
Second, make sure that you have the correct version of mstsc. mstsc /?
will tell you if your current client supports the /console parameter.
(If it doesn't, it'll silently eat it and ignore it)
I think I use mstsc from XP SP2
mstsc /? returns
---
Usage
Hi,
I'm working with postgres and I have a question regarding a self-join on
my table (se below for table definition and testdata):
I want to retrieve all depths that have either a measuretype=1040 or a
measuretype=4001 or both. I've tried:
select * from
testtable t1
full outer join testtable
Hello,
I'm running pgsql 8.1.3 and ran into an unexpected situation running
pg_dump remotely. We have 2 LAN's situated some distance apart. I can
run pg_dump against machine A on LAN1 from machine B on LAN1 with no
problem. But if I try to run it from Machine C on LAN2 it stalls with
idle in
Emi Lu [EMAIL PROTECTED] writes:
*Got ERROR:* invalid multibyte character for locale
HINT: The server's LC_CTYPE locale is probably incompatible with the
database encoding.
By the way, both my client and server encoding are UNICODE.
Sounds like you initdb'd using a locale that expects
Csaba Nagy [EMAIL PROTECTED] writes:
Why would you do that ? If you need a solution which works both on
postgres and oracle, use the standard outer join syntax supported by
postgres - it is supported by the latest oracle versions too.
Because there are tons of legacy code I'd have to convert
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: 05 April 2006 15:03
To: Chris Velevitch
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] pg_dump and copy command
Chris Velevitch [EMAIL PROTECTED] writes:
I've dumped a
Csaba Nagy [EMAIL PROTECTED] writes:
Why would you do that ? If you need a solution which works both on
postgres and oracle, use the standard outer join syntax supported by
postgres - it is supported by the latest oracle versions too.
BTW: You have to use the cost based optimizer (new syntax
On Wed, 5 Apr 2006, Frank Church wrote:
I am looking for service providers that offer postgresql hosting.
One requirement, cheap but reliable (if there is any such thing).
It will be good if they can run different versions simultaneously (on
different ports of course)
We
Because there are tons of legacy code I'd have to convert and until
now the Oracle server is still Oracle8. :(
I would think that patching postgres will be no less challenging than
fixing the legacy code... unless you really have a few tons of it or you
simply can't do it (no access for e.g.).
Tom Lane wrote:
Don Y [EMAIL PROTECTED] writes:
Yeah, I was hoping someone would have built a template for
new types that trimmed everything down to a single page/file
instead of having to snoop the source tree. :-(
The various new types in contrib/ are there in part to serve as models.
BTW: You have to use the cost based optimizer (new syntax with rule
based optimizer yields really bad performance). And our DBA really
don't like statistics... :(
This is kind of off topic on this list, but there are ways to force
Oracle to use specific plans by carefully hinting it.
And the
Stefan Nobis [EMAIL PROTECTED] writes:
[ still on Oracle8 ]
BTW: You have to use the cost based optimizer (new syntax with rule
based optimizer yields really bad performance). And our DBA really
don't like statistics... :(
Sounds like both your database and your DBA are dinosaurs ;-).
If you
On 4/5/06, Clive Page [EMAIL PROTECTED] wrote:
Since I discovered the facilities in Postgres for providing and listing
column descrptions, I have found them very useful, especially for adding a
string showing physical units to my columns.
Have you considered using domains for these types? You
On Wed, 2006-04-05 at 14:46 +0200, Stefan Nobis wrote:
Is there any way (or working solution) to extend PostgreSQL to accept
Oracles outer join syntax with '(+)'?
Not AFAIK, and there are no plans to add support that I'm aware of.
EnterpriseDB claim to have pretty good Oracle compatibility, so
On 5 apr 2006, at 16.39, Jonas F. Henriksen wrote:
Hi,
I'm working with postgres and I have a question regarding a self-
join on
my table (se below for table definition and testdata):
I want to retrieve all depths that have either a measuretype=1040 or a
measuretype=4001 or both.
All
I'm unable to create database cluster in Windows 2000 server.
initdb returns error
FATAL: could not create shared memory segment: No such file or directory
any idea how to create cluster in Windows 2000 ?
Task MAnager shows physical memory:
Total: 392664
Available: 81860
System Cache:
Hi,
ehh, sorry, yes, I also want to retrieve other values from the table,
but I left them out for clarity (which made it maby less clear...).
Maybe it makes more sense if you define the table as
CREATE TABLE testtable (
depth integer,
measuretype integer,
operation integer,
On Tue, 2006-04-04 at 16:07, Andrus wrote:
Remote install of Postgres 8.1.3 using Windows installer binary package is
not working (says that console mode is required) even when RDP client is
started with
mstsc /console
switch.
However, using installer package, creating cluster and
On Wed, 5 Apr 2006, Merlin Moncure wrote:
Have you considered using domains for these types? You can comment
the domain appropriately. While the domain description will not show
in \d+. to get the description you can do \dT on the domain.
Based on your background I also think you might
On Fri, Mar 31, 2006 at 22:18:20 -0300,
Reimer [EMAIL PROTECTED] wrote:
The main reason of my question is that we have a ERP software house client
with many customers running PostgreSQL and one of their big customers is
trying go buy another ERP system that uses Sybase instead of
Hello,
I have a client who is still using the version 7.4.3
and creating an index like this doesn't work:
CREATE INDEX client__ascname__idx ON client
(TO_ASCII(lower(name),'LATIN 1'));
Does exists another way of creating an indexin varchar whotake
on considerationalso the accents
Hello,
When I try to create a database with pgAdmin III I
obtain :
"An error as occured : Could not signal for
checkpoint : no such process"
What can I do ?
Best regards.
Luc
BEGIN:VCARD
VERSION:2.1
N:ROLLAND;Ets
FN:Ets ROLLAND
ORG:Ets ROLLAND
TEL;WORK;VOICE:04 66 81 56 62
Sorry, maybe I was not clear.
No, it´s not Peoplesoft ERP, it´s a small brazilien ERP software house.
- Original Message -
From: Bruno Wolff III [EMAIL PROTECTED]
To: Reimer [EMAIL PROTECTED]
Cc: Mark Aufflick [EMAIL PROTECTED]; pgsql-general@postgresql.org
Sent: Wednesday, April 05,
Well, the problem is I want the result on one row for each depth, so it
will fit nicely into a table, like this:
depth measuretype1_value measuretype2_value
10 1.782.55
20 2.12
30 3.12
40 1.3 1.4
...with missing rows for a depth appearing as missing
Patrick TJ McPhee wrote:
In article [EMAIL PROTECTED],
Jim Nasby [EMAIL PROTECTED] wrote:
% Not sure if it's still true, but DB2 used to limit varchar to 255. I
% don't think anyone limits it lower than that.
Sybase: 254. Silently truncates.
IIRC, Oracle is 4096.
Jeff
On Wed, Apr 05, 2006 at 01:59:46PM -0400, Ardian Xharra (Boxxo) wrote:
Hello,
I have a client who is still using the version 7.4.3
and creating an index like this doesn't work:
CREATE INDEX client__ascname__idx ON client (TO_ASCII(lower(name),'LATIN
1'));
Does exists another way of
Ets ROLLAND [EMAIL PROTECTED] writes:
When I try to create a database with pgAdmin III I obtain :
An error as occured : Could not signal for checkpoint : no such process
What do you see in the postmaster log? The postmaster should be pretty
unhappy about it if the bgwriter process is not there
On 5 apr 2006, at 18.37, Jonas F. Henriksen wrote:
ehh, sorry, yes, I also want to retrieve other values from the table,
but I left them out for clarity (which made it maby less clear...).
Maybe it makes more sense if you define the table as
CREATE TABLE testtable (
depth integer,
Jonas F. Henriksen [EMAIL PROTECTED] writes:
Well, the problem is I want the result on one row for each depth, so it
will fit nicely into a table, like this:
depth measuretype1_value measuretype2_value
101.782.55
202.12
303.12
401.3 1.4
I think what
No, it doesn't work always the same message:
ERROR: parser: parse error at or near ( at character 47
- Original Message -
From: Martijn van Oosterhout kleptog@svana.org
To: Ardian Xharra (Boxxo) [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Wednesday, April 05, 2006 3:01 PM
Ardian Xharra \(Boxxo\) [EMAIL PROTECTED] writes:
No, it doesn't work always the same message:
ERROR: parser: parse error at or near ( at character 47
In that case you're not really talking to a 7.4 server, but something
older --- either syntax works OK for me on 7.4.
regression=# create
Sorry, the exact version is
PostgreSQL 7.3.3 on sparc-sun-solaris2.8, compiled by GCC gcc (GCC) 3.3.2
- Original Message -
From: Tom Lane [EMAIL PROTECTED]
To: Ardian Xharra (Boxxo) [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org; Martijn van Oosterhout
kleptog@svana.org
Sent:
Ardian Xharra \(Boxxo\) [EMAIL PROTECTED] writes:
Sorry, the exact version is
PostgreSQL 7.3.3 on sparc-sun-solaris2.8, compiled by GCC gcc (GCC) 3.3.2
You really, really, really need to update that, ASAP. Even if you
don't need usable expression indexes, compelling reasons can be found at
Bob Powell [EMAIL PROTECTED] writes:
Hello everyone:
I have a systems admin that is backing up our Linux computers
(postgres) by backing up the directory structure. This of course
includes all the files that pertain to my postgres databases. I
maintain that using pgdump and creating a
In article [EMAIL PROTECTED],
Martijn van Oosterhout kleptog@svana.org writes:
As a british user, latin9 will cover most of your needs, unless
ofcourse someone wants to enter their name in chinese :)
Since british users don't use French OE ligatures or Euro currency
signs, even latin1 would
Bob Powell wrote:
I have a systems admin that is backing up our Linux computers
(postgres) by backing up the directory structure. This of course
includes all the files that pertain to my postgres databases. I
maintain that using pgdump and creating a file of SQL commands for
restore is a
We have used the pro*c program found in this discussion (for the exact
same purpose):
http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:45902
0243348
It is *blazingly* fast, and creates CSV formatted files suited perfectly
for postgresql's COPY command. Dumping 40Gb of data,
On Wed, 2006-04-05 at 12:19 -0400, Neil Conway wrote:
On Wed, 2006-04-05 at 14:46 +0200, Stefan Nobis wrote:
Is there any way (or working solution) to extend PostgreSQL to accept
Oracles outer join syntax with '(+)'?
Not AFAIK, and there are no plans to add support that I'm aware of.
Csaba Nagy [EMAIL PROTECTED] writes:
both postgres and Oracle, and I have to say it took quite some time
and a few nasty surprises until everything was stable
Thank you very much for your comments.
--
Until the next mail...,
Stefan.
pgpV8KsgMY9JV.pgp
Description: PGP signature
On Wed, 2006-04-05 at 15:42 -0400, Bob Powell wrote:
I have a systems admin that is backing up our Linux computers
(postgres) by backing up the directory structure. This of course
includes all the files that pertain to my postgres databases. I
maintain that using pgdump and creating a file
since i can't recover my database with $PGDATA/base - $PGDATA/pg_xlog -
$PGDATA/pg_clog, but not the global. i get always no realtions founds. i was
browsing the web and found this tool :
is there a new version compatible with version 8 of postgres?
http://svana.org/kleptog/pgsql/pgfsck.html
On Wed, Apr 05, 2006 at 05:29:36PM -0400, patrick wrote:
since i can't recover my database with $PGDATA/base - $PGDATA/pg_xlog -
$PGDATA/pg_clog, but not the global. i get always no realtions founds. i
was browsing the web and found this tool :
is there a new version compatible with
this is what i got when trying it:
./pgfsck -D /virtual/data -s 8192 -d mydb
-- Detected database format 8.0
Couldn't find relation pg_class(1259)
mydb should be a text or the oid... hum...
patrick
---(end of broadcast)---
TIP 5: don't forget to
Subscribe
End
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
patrick [EMAIL PROTECTED] writes:
this is what i got when trying it:
./pgfsck -D /virtual/data -s 8192 -d mydb
-- Detected database format 8.0
Couldn't find relation pg_class(1259)
I really seriously doubt that pgfsck would help at all anyway.
I think you've either not yet got your
Seneca Cunningham wrote:
the configure flags (option 3 from the FAQ). (And yes, I do now realize
that the optional nature of this matter could have been better expressed
in the FAQ by using something other than unadorned numbers to label the
options. They're options, not steps)
AIX FAQ
Hello everyone:
I have a systems admin that is backing up our Linux computers
(postgres) by backing up the directory structure. This of course
includes all the files that pertain to my postgres databases. I
maintain that using pgdump and creating a file of SQL commands for
restore is a better
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Version 1.48 of DBD::Pg has been released. This is mostly
a bug fix version. Another bytea problem was fixed, as well
as an obscure corner case with begin_work() after an error.
The minimum version required for DBI has been raised to 1.45.
CPAN
i have heard somewhere that writinga stored
procedure, is much better than firing a sql query(such as select * from
table_name)onto the database.
is it true and if yes how?
also i want to know that is the performnance in
java slower as compared to cpp, given that the same things is being
Nevermind, the problem was resolved when I discovered a typo in the
postgresql.conf line of listen_address.
The postgres message in /var/log/messages turned out to be more useful
than the one in the log file named by the start command.
Thanks for responding!
Jonathan
Jonathan Beit-Aharon
71 matches
Mail list logo
