>
> Okay, so it is indeed the linker's fault. Now try plan
> (a) --- can you
> find a more up-to-date toolchain?
Well I've tried looking in apt, and the latest package is the version I've got,
(the toolchain is more than just gcc isn't it though?) is there another way to
get a more up to date
> Tom Tom wrote:
> > Hello,
> >
> > We have a very strange problem when restoring a database on Windows XP.
> > The PG version is 8.1.10
> > The backup was made with the pg_dump on the same machine.
> >
> > pg_restore -F c -h localhost -p 5432 -U postgres -d "configV3" -v
> "c:\Share\POSTGRES.bac
Brian Maguire wrote:
> We need to restore one table from a backup. What is the proper way to do
> this?
>
> Our backup command looks like this:
>
> pg_dump -C -Fc -S postgresql mydatabase > today.backup.sqlc
>
> I am using PostgreSQL 8.1.
>
> --
> Sent via pgsql-general mailing list (pgsql-
Glyn Astill <[EMAIL PROTECTED]> writes:
>> Okay, so it is indeed the linker's fault. Now try plan
>> (a) --- can you
>> find a more up-to-date toolchain?
> Well I've tried looking in apt, and the latest package is the version I've
> got, (the toolchain is more than just gcc isn't it though?) is
Hi,Greetings!!!We have developed a software which uses PostgreSQL as one of the
component. We would like to delever PostgreSQL along with our software as a
single package. So we have to create an installer which installs PostgreSQL
with all pre-install configuration first and then our software.
Hi, if I have such a table:
t_ref_id t_data
1 'abc'
2 '321'
1 'ddd'
2 'xyz'
9 '777'
...
I want to get data with a special t_ref_id:
SELECT t_data FROM THETABLE WHERE t_ref_id = '1';
I must use a while loop to
Hi,
I was trying to install postgreSQL with XML data type support. My OS is
ubuntu , kernel 2.6.15.. PostgresSQL version is 8.3.3 .I have libxml2 and
libxslt installed. I configured using
./configure --with-libxml --with-libxslt
configure went fine..
'make all' went fine
'make install' went fine.
hello everyone
I'm working on PostgreSQL XML Extension.
My system is windows xp professional sp2 and
PostgreSQL 8.3.3 and I am sure installed xml2 module.
I have a 2 colums table:
(frase di creazione tabella : create table ecc ecc)
I have a problem using a xpath function.
My query is:
SELEC
Hi,
here's a short example, the problem is at the end:
DROP TABLE IF EXISTS foo;
CREATE TABLE foo ( id SERIAL PRIMARY KEY, c2 VARCHAR NOT NULL );
INSERT INTO foo VALUES ( DEFAULT, 'foo' );
INSERT INTO foo VALUES ( DEFAULT, 'bar' );
INSERT INTO foo VALUES ( DEFAULT, 'baz' );
DROP TABLE IF EXISTS
Hi,
Is Heikki's Visibility Map patch included for the Postgresql 8.4 version
http://archives.postgresql.org/pgsql-hackers/2007-11/msg00142.php
If not whats the status of that patch? Im especially interested in the
index-only scan mentioned there!!!
Thanks
Sharmila
Its 8.1 and I'm doing a Vacuum using the vacuumdb program.
Thanks Matt, might be time for an upgrade.
> Date: Tue, 5 Aug 2008 11:21:44 -0400
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> CC: pgsql-general@postgresql.org; [EMAIL PROTECTED]
> Subject: Re: [GENERAL] Vacuum Vs Vacuum Full
>
>
On Thu, Aug 07, 2008 at 10:55:06AM -0300, Anderson dos Santos Donda wrote:
> Each client has a db, and each db has the same tables. I don't need to share
> datas with the clients ( and I can't do it ) , because each clients have
> differents datas in yours tables.
>
> My function is to help me to
ramamurthy kv wrote:
> Hi,
> Greetings!!!
>
> We have developed a software which uses PostgreSQL as one of the component.
> We would like to delever PostgreSQL along with our software as a single
> package. So we have to create an installer which installs PostgreSQL
> with all pre-install configur
In response to "窦德厚(ddh)" <[EMAIL PROTECTED]>:
> Hi, if I have such a table:
>
> t_ref_id t_data
>
> 1 'abc'
> 2 '321'
> 1 'ddd'
> 2 'xyz'
> 9 '777'
> ...
>
>
> I want to get data with a special t_ref_id:
>
>
Olá, estou com um problema, o Windows Vista não reconhece o odbc do
PostgreSQL, alguma dica?
Hello, I have a problem, Windows Vista does not recognize the odbc of
PostgreSQL, any hint?
--
Lucas Felix de Sousa
Técnico em Informática
[EMAIL PROTECTED]
"Se enxerguei mais longe que outros homens, f
On Thu, 2008-08-07 at 17:56 -0400, Jack Orenstein wrote:
>
> Can't find them. They aren't on postgresql.org (e.g.
> http://www.postgresql.org/ftp/binary/v8.3.3/linux/rpms/fedora/fedora-9-i386/),
>
> and apparently not on pgdg-83-fedora.repo.
pgdg-83-fedora.repo uses http://yum.pgsqlrpms.org as
Hi,
I can't find pgbench on the package we installed. I built, contrib pkg
and installed, but that still didn't generate pgbench anywhere.
Any idea where to get pgbench?
--
Heeman Lee
On Thu, 2008-08-07 at 17:24 -0400, Jack Orenstein wrote:
> Using pgdg-83-fedora.repo, yum finds two RPMs,
> postgresql-8.3.3-1PGDG.f9.i386 and
> postgresql-libs-8.3.3-1PGDG.f9.i386.
Uh... Use yum search postgresql :)
sudo yum search postgresql|wc -l
145
:)
--
Devrim GÜNDÜZ
devrim~gunduz.org,
Hi,
PHP has several functions related to postgresql - including a function to
fetch all the rows of the resultset at once into an array and then have a
loop that extracts one row at a time from that :
http://in.php.net/manual/en/function.pg-fetch-all.php
search for all functions with pg_ prefix
Steve Atkins wrote:
So, yeah, you're right. Generally, email is too complex to deal with
in the database as anything other than an opaque bytea blob, along
with some metadata
Only because that's the choice made by dbmail. As an IMAP server, it
doesn't _have_ to do more. The downs
Hi.
Is this helpful?
http://winpg.jp/~saito/psqlODBC/psqlODBC64/
as for AMD64.
http://www.geocities.jp/inocchichichi/psqlodbc/index.html
Regards,
Hiroshi Saito
- Original Message -
From: Lucas Felix
To: pgsql-general@postgresql.org
Sent: Saturday, August 09, 2008 12:00 AM
Subject: [GE
Never mind. I found it.
On Fri, 2008-08-08 at 12:16 -0400, Heeman Lee wrote:
> Hi,
>
> I can't find pgbench on the package we installed. I built, contrib pkg
> and installed, but that still didn't generate pgbench anywhere.
> Any idea where to get pgbench?
>
> --
> Heeman Lee
--
Heeman Lee
Our application is running Postgres 7.4, (working on conversion to 8.3
right now). Our testing involves various forms of violence, including
shutting off power and kill -9 postmaster.
Occasionally we observe a form of database corruption in which one of
the files storing a table or index disappea
Tom Lane wrote:
Kevin Murphy <[EMAIL PROTECTED]> writes:
Speaking as a near-ignoramus, would a simple RPM that wraps the binary
jar file make sense?
Sure, if you want to do it that way. We did in fact do it that way up
till about 8.0. We (or at least I) moved away from it because of
Jack Orenstein <[EMAIL PROTECTED]> writes:
> Our application is running Postgres 7.4, (working on conversion to 8.3
> right now). Our testing involves various forms of violence, including
> shutting off power and kill -9 postmaster.
Do you have reason to trust either your kernel or your disk drive
Hi all -
This is probably a new bee question... but, how do I change the
password of a role that has a hyphen in the name?
==
$ createuser --no-superuser --createdb --no-createrole foo-bar
$ psql
Welcome to psql 8.3.0, the PostgreSQL interactive terminal.
Type: \copyrigh
Tom Copeland <[EMAIL PROTECTED]> writes:
> This is probably a new bee question... but, how do I change the
> password of a role that has a hyphen in the name?
You need double quotes, not single quotes. Read about SQL identifier
syntax in the fine manual ...
regards, tom
On Aug 8, 2008, at 4:57 PM, Tom Lane wrote:
Tom Copeland <[EMAIL PROTECTED]> writes:
This is probably a new bee question... but, how do I change the
password of a role that has a hyphen in the name?
You need double quotes, not single quotes. Read about SQL identifier
syntax in the fine manu
use the double quotes (")
ALTER USER "foo-bar" WITH ENCRYPTED PASSWORD 'foo-bar'
--- On Fri, 8/8/08, Tom Copeland <[EMAIL PROTECTED]> wrote:
> From: Tom Copeland <[EMAIL PROTECTED]>
> Subject: [GENERAL] ALTER ROLE role-name-with-hyphen
> To: pgsql-general@postgresql.org
> Date: Friday, August 8
On Thu, 7 Aug 2008, Cyril SCETBON wrote:
What's the way to count the read/write bytes of the checkpoint process
before 8.3 (no pg_stat_bgwriter view :-[ ) I want to distinguish bytes
written by checkpoints and others written by the background process
The reason that view was added was because
30 matches
Mail list logo
