I want to get the output from
pg_dump --struct-only --table=whatever
inside a programm. Of course I could call pg_dump in a
seperate process and capture the output and all; but ...
as PGAdmin is doing it someway, I strongly suspect there is a
kind of call to recreate the DML language
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Magnus Hagander
Sent: 13 April 2006 08:40
To: Harald Armin Massa; pgsql-general
Subject: Re: [GENERAL] how can I create the DML for an
existing database - within an application
I want to get
Hi all I am a newbe in postgres and I'm trying to obtain an unattended
dump to pgsql. I mean, I've tryed to use pg_dump using the -U flag but I
havn't found a way to pass a password in a unattended way. So I have to
guess the only solution is to configure pg_hba.conf to use ident as
From: Harald Armin Massa
[mailto:[EMAIL PROTECTED] Sent: 13 April 2006
09:37To: Dave PageSubject: Re: [GENERAL] how can I
create the DML for an existing database - within an
application
Dave,
AFAIK, pgadmin opens a pipe to pg_dump.Yes, when creating an actual
On Thu, Apr 13, 2006 at 10:35:55AM +0200, Paolo Sala wrote:
Hi all I am a newbe in postgres and I'm trying to obtain an unattended
dump to pgsql. I mean, I've tryed to use pg_dump using the -U flag but I
havn't found a way to pass a password in a unattended way. So I have to
guess the only
I just added a new table to a slony relication set. The new table seems
to have a really high tab_reloid value of 94,198,669
I'm using Slon 1.1.5 with pg 7.4.6 and 7.4.11 on unix
On the master I see (wcprogallery is the new table added to set 4)
tab_id|tab_reloid|tab_relname
Ühel kenal päeval, N, 2006-04-13 kell 10:06, kirjutas John
Sidney-Woollett:
I just added a new table to a slony relication set. The new table seems
to have a really high tab_reloid value of 94,198,669
...
Is this something I should be worried about? Can I find out where all
the intermediate
hi.basic information:machine: desktop computer, with sata hard drive, no bad blocks. 2g ram.AMD Sempron(tm) Processor 2600+system: linux debian testing, using 2.6.11 kernel.postgresql: 8.1.3 compiled by hand using:
./configure \ --prefix=/home/pgdba/work \ --without-debug \ --disable-debug \
hubert depesz lubaczewski wrote:
hi.
basic information:
machine: desktop computer, with sata hard drive, no bad blocks. 2g
ram.AMD Sempron(tm) Processor 2600+
system: linux debian testing, using 2.6.11 kernel.
postgresql: 8.1.3 compiled by hand using:
...
version() - PostgreSQL 8.1.3 on
My tables are defined WITHOUT OID - does that make a difference?
John
Hannu Krosing wrote:
Ühel kenal päeval, N, 2006-04-13 kell 10:06, kirjutas John
Sidney-Woollett:
I just added a new table to a slony relication set. The new table seems
to have a really high tab_reloid value of 94,198,669
On 4/13/06, Richard Huxton dev@archonet.com wrote:
Hmm - I believe that means a data/index block was corrupted.indices were recreated (reindex table), so i think this is data related problem.
Have you seen any crashes, or hardware-related errors in your logs?nope. uptime is over 40 days.the
Martijn van Oosterhout scrisse in data 04/13/06 10:47:
On Thu, Apr 13, 2006 at 10:35:55AM +0200, Paolo Sala wrote:
Hi all I am a newbe in postgres and I'm trying to obtain an unattended
dump to pgsql. I mean, I've tryed to use pg_dump using the -U flag but I
havn't found a way to pass a
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] (John
Sidney-Woollett) transmitted:
I just added a new table to a slony relication set. The new table
seems to have a really high tab_reloid value of 94,198,669
I presume the database instance has been around for a while?
Hi,
like to know how, if possible, for patterns
asattribute in a table to be used in a regex search with a
fixed string. The query should therefore return the rows that
have matching patterns with the single text.
Regards
pgdb
Free POP3 Email from
Hello List,
After having compiled and installed PostGreSQL on IA64, Red Hat
Enterprise Linux 4 AS, I had to do the same thing on Windows 64 bits...
I have read that PostGreSQL wasn't test on Windows 64 bits, is it still
correct ?
My problem is to find how obtain an Unix/Linux environnement
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
DANTE ALEXANDRA
Sent: 13 April 2006 14:02
To: pgsql-general@postgresql.org
Cc: DANTE ALEXANDRA
Subject: [GENERAL] How to compile PostGreSQL on Windows 64 bits ?
Hello List,
After having
am 13.04.2006, um 12:47:38 + mailte pgdb folgendes:
HTMLDIV class=bgcolor STYLE=background-color: ;DIV
DIV
DIV
DIVHi,/DIV
DIVnbsp;/DIV
DIVlike to know how, if possible, for patterns
asnbsp;attribute in a table to be used in a regex search with a
fixed string. The query should
Hello All
I have only recently started to use Postgresql and have a problem. I am
using v8.1 on windows.
I cannot seem to get the DB to accept either INT or INTEGER as a type
when using the admin tool. Only INT2 or INT4 work.
I even downloaded Navicat trial and this has the same issue. Is there a
Hello!
I have a PostgreSQL database with UTF-8 encoding. It stores russian characters.
When I fetch a record from this database and output it to the web browser as
html page, it
looks like a garbage instead of normal russian characters. I'm using html with
meta http-equiv=Content-Type
I want to post some questions.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
This perl function doesn't work for me.
I keep getting a
Cannot decode string with wide characters at
/usr/lib/perl5/5.8.7/i386-linux/Encode.pm line 166 error
Do you have any suggestion?
Thanks
Balázs
---(end of broadcast)---
TIP 1: if
Hello!
I have a PostgreSQL database with UTF-8 encoding and Resin application server.
When I fetch a record from database using jdbc connection and output it to the
web browser as
html page, it looks like a garbage instead of normal russian characters. html
meta http-equiv=Content-Type
Thanks for the reassurance. You're right the db has been around for a while.
Doea anyone know if OIDs for data and system (DDL) objects from the same
number generator?
John
Christopher Browne wrote:
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] (John
On 4/13/06, Anton Andreev [EMAIL PROTECTED] wrote:
I want to post some questions.
Go ahead and post them :) We don't bite :)
--
Postgresql php tutorials
http://www.designmagick.com/
---(end of broadcast)---
TIP 1: if posting/reading through
Sadm,what is the encoding setting of your database driver?What happens if you put out the retrieved Data to a console or a debug window?Have you analyzed the garbage, what is it? Escaped Characters? Hungarian? Arabian? Chinese??
How do you fetch a record, how do you output it to THE Web browser?
I have only recently started to use Postgresql and have a problem. I am
using v8.1 on windows.
I cannot seem to get the DB to accept either INT or INTEGER as a type
when using the admin tool. Only INT2 or INT4 work.
I even downloaded Navicat trial and this has the same issue. Is there a
This problem has been solved, by the use of sequences. If you can't
use them as a default, you can use them instead of
MAX(clipid)
You would use
NEXTVAL(clipid_seq)
assuming you had first done
CREATE SEQUENCE clipid_seq;
SELECT SETVAL('clipid_seq', (select MAX(clipid) from whatevertable));
Hi,
Can I use a Postgre table as hashtable\\?
when I do select where column='test', I want this to be done by hashtable,
not linear, not by b-tree. I do not need to sort, sum or else I just want
to get the value as fast as possible.
10x to anyone answering me
Cheers,
Anton
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Devrim GUNDUZ wrote:
Hi,
On Wed, 2006-04-12 at 13:07 +0200, Gaetano Mendola wrote:
I was able to create it with:
--nodeps --define 'buildrhel3 1' --define 'build9 1'
I'll be hppy if you send the RPMs directly to me; so that I can upload
On Wed, 12 Apr 2006, Benjamin Smith wrote:
I'm stumped on this one...
I have a table defined thusly:
create table items (
id serial,
category integer not null references category(id),
name varchar not null,
price real,
unique(category, name));
I think this should work
select *
On 4/14/06, Zahir Lalani [EMAIL PROTECTED] wrote:
Hi Chris
I am using pgAdmin III.
Created a table, then started adding fields. This is where the problem
hits - the drop down does not give you an INTEGER option, so you cannot
shoose it.
Also I tried creating a script in the query view and
Anton Andreev wrote:
Hi,
Can I use a Postgre table as hashtable\\?
It's PostgreSQL or Postgres, BTW
when I do select where column='test', I want this to be done by hashtable,
not linear, not by b-tree. I do not need to sort, sum or else I just want
to get the value as fast as possible.
hubert depesz lubaczewski [EMAIL PROTECTED] writes:
On 4/13/06, Richard Huxton dev@archonet.com wrote:
Hmm - I believe that means a data/index block was corrupted.
indices were recreated (reindex table), so i think this is data related
problem.
AFAICS, the only non-index-related occurrence
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
chris smith wrote:
We don't bite :)
much. :-D
- --
Peter L. Berghold [EMAIL PROTECTED]
Those who fail to learn from history are
Hello everybody,
I am quite a newbie in the database business, so sorry for stupid questions.
Is there any convenient and simple method/tool to export data from views to
file, something like COPY TO (file) from a table?
I am using WinXP and Postgresql 8.1.
Many thanks in advance
Tomas
On Apr 13, 2006, at 23:58 , Tomas Lanczos wrote:
Is there any convenient and simple method/tool to export data from
views to
file, something like COPY TO (file) from a table?
In psql, take a look at \o (and \? while you're at it).
Hope this helps.
Michael Glaesemann
grzm myrealbox com
chris smith wrote:
What error do you get? I'm sure pgAdmin will show something.
Try it from console:
psql.exe dbname
create table t1(a int);
(Always CC the list, someone else might be able to help you if I don't
know the answer).
It's not a error, pgAdmin III simply does not display the
On Thursday 13 April 2006 13:12, Sadm sadm wrote:
Hello!
I have a PostgreSQL database with UTF-8 encoding. It stores russian
characters. When I fetch a record from this database and output it to
the web browser as html page, it looks like a garbage instead of
normal russian characters. I'm
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tony Caduto
Sent: 13 April 2006 16:19
To: chris smith
Cc: Zahir Lalani; pgsql-general@postgresql.org
Subject: Re: [GENERAL] the integer type
It's not a error, pgAdmin III simply does not
Dave Page wrote:
Which allows you to use any custom datatype or domain that you like.
double precision == float8
(http://www.postgresql.org/docs/8.1/interactive/datatype.html) which
works just fine.
Regards, Dave.
Actually if you try and type in integer in the combobox, it accepts the
This is exactly how I felt - It made me wonder whether I should go back
to MS SQL - the whole UI experience is much better.
But now that I have seen lightning - hopefully it will get easier. Also,
I was trying to connect this to ColdFusion/Dreamweaver.
Since the field was defined as int4,
Zahir Lalani wrote:
This is exactly how I felt - It made me wonder whether I should go back
to MS SQL - the whole UI experience is much better.
But now that I have seen lightning - hopefully it will get easier. Also,
I was trying to connect this to ColdFusion/Dreamweaver.
Since the field was
Tony
Just a thought. I have spent the last couple of weeks googling for admin
tools for Postgres - and never came across yours!
Zahir
PG Lightning Admin was created with input from several MS SQL server
DBAs who just absolutely detested pgAdmin III.
We where converting a large MS SQL
On 4/13/06, Richard Huxton dev@archonet.com wrote:
All looks fine. Can you isolate the row(s) in question that seem to bethe problem? Then we can have a look at the system columns.http://www.postgresql.org/docs/8.1/static/ddl-system-columns.html
i ran the test to find it. as soon as i will get it
On 4/13/06, Tom Lane [EMAIL PROTECTED] wrote:
hubert depesz lubaczewski [EMAIL PROTECTED] writes: On 4/13/06, Richard Huxton dev@archonet.com wrote: Hmm - I believe that means a data/index block was corrupted.
indices were recreated (reindex table), so i think this is data related problem.AFAICS,
hubert depesz lubaczewski [EMAIL PROTECTED] writes:
On 4/13/06, Tom Lane [EMAIL PROTECTED] wrote:
AFAICS, the only non-index-related occurrence of that error message
is in PageRepairFragmentation, which is invoked by VACUUM. I'd say
it indicates a real problem and you shouldn't ignore it.
Maybe add to it the
insert/update data in tables based on an XML (a'la MS
updategram)
Balázs
---(end of broadcast)---
TIP 6: explain analyze is your friend
Where can I find documentation on what client library version interoperate
with which server versions? I've been unable to find anything in the manual
or archives. The only thing I've found is some information in the archives
on certain psql versions. Is there a compatibility matrix somewhere
On Thu, 2006-04-13 at 15:06, Wes wrote:
Where can I find documentation on what client library version interoperate
with which server versions? I've been unable to find anything in the manual
or archives. The only thing I've found is some information in the archives
on certain psql versions.
Renato Cramer wrote:
Can someone where I can found DBMS Market Researches?
What institutes publish reliable researchs? Gartner, IDC?
Note it's hard for any company to provide reliable research
that spans both open-source and non-open-source products.
For example, one company I'm familiar with
Hi Andreas,
strange but I don't see html from my original email
received from the mailing list, hope this reply is ok:)
If I'm not wrong, the example you've provided is trying to
return matching rowsfrom multiple patterns and texts as
inputs in the regex search.
The text in regular
On 4/14/06, pgdb [EMAIL PROTECTED] wrote:
Hi Andreas,
strange but I don't see html from my original email received from the
mailing list, hope this reply is ok:)
If I'm not wrong, the example you've provided is trying to return matching
rows from multiple patterns and texts as inputs in
52 matches
Mail list logo