karthick muthu scrisse in data 04/06/06 07:54:
hello hai,
I am new to linux,now i have a job to maintain database using postgre
in debian,so i want to know the completebasic details about how to use
this.
thanking you
There are very useful manual online: http://www.postgresql.org/docs/
Hav
am 06.04.2006, um 10:19:21 +0530 mailte deepak pal folgendes:
> hi
> how to select second heigest salary from employee table field are
> id,name ,salary...plz help
*untested*
select id, name, salary from employee order by salary desc limit 1 offset 1;
http://www.postgresql.org/docs/curre
hi
how to select second heigest salary from employee table field are id,name ,salary...plz help-- Deepak PalSoftware DeveloperWicenet ltd.Pune(M.H)
hello hai,
I am new to linux,now i have a job to maintain database using postgre
in debian,so i want to know the completebasic details about how to use
this.
thanking you
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 wrote
i have heard somewhere that writing a 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
do
-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 loca
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 m
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 FA
"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 tra
Hello everyone:
I have a trouble with the gendict (config.sh) script to create a new
stems for spanish on SOLARIS 10, sometime ago I created some stems on
Gentoo and worked fine so, now I'm moving to SOLARIS 10 (dont ask me
why) and when I tried on gendict directory:
$ ./config.sh
config.sh
Subscribe
End
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
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
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 ve
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
p
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 f
Tom Lane <[EMAIL PROTECTED]> writes:
> Sounds like both your database and your DBA are dinosaurs ;-).
Yes.
> If you can't get your DBA to update from Oracle 8 to modern Oracle,
> you've got zip chance of persuading him to deal with Postgres,
Postgres is for use with an extern customer, so the c
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 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.
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, sendi
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 bett
In article <[EMAIL PROTECTED]>,
Martijn van Oosterhout 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 do.
--
"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 crea
"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 a
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: ; "Martijn van Oosterhout"
Sent: Wednesday, April 05, 2006 3:14 PM
Subject:
"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=# crea
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"
To: "Ardian Xharra (Boxxo)" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, April 05, 2006 3:01 PM
Subject: Re: [GENERAL] Creating an in
"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 thi
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,
measur
"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 no
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 c
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
---
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 values
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]>;
Sent: Wednesday, April 05, 2006 2:28 PM
Sub
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
TEL;CELL;VOICE
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 index in varchar who take
on consideration also the accents
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 Pos
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 apprec
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
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,
valu
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: 157xxx
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 hel
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 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?
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 ;-).
I
> 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 th
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.
Y
> 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.).
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 (http://www.hub.o
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 syn
> -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:
> >
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 conv
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 exp
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 tran
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
> 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,
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, Share
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
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 th
"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 scr
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 tha
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 lo
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 -9'
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 d
> >> 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:
>
> ---
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 Nobis
>> 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 er
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 5:
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:
http://www.postgresql.org/s
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 i
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 sens
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 | Mo
> -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
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,
approver1_i
On 4/4/06, Ottavio Campana <[EMAIL PROTECTED]> wrote:
hubert depesz lubaczewski wrote:> 2) do you think it's possible in a 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.
75 matches
Mail list logo
