Lloyd Mason wrote:
> I have also tried the query using the same encoding with both the
> 8.1.5 and 8.1.8 versions and the query is still coming back with
> different results.
He said locale, not encoding.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(e
"Mike Frysinger" <[EMAIL PROTECTED]> writes:
> $ pg_dump -F c -s -d database-server mydb > mydb.schema
> $ psql -d mydb < mydb.schema
>
pg_dump -Fc does not produce a file that psql can read directly.
Is the above really what you did?
regards, tom lane
--
I was attempting to get info to answer a question on this mailing list.
I found a document that sounded appropriate here:
http://www.postgresql.org/docs/techdocs.71. Color me dumb, but I can't
figure a way to download the document "Apache 2.0, Tomcat 5.5, WARs &
PostgreSQL 8.1 JDBC DataSource
i'm trying to add the ability to dump our database as a backup in case
things go wrong with the db server, and so i'm trying to test things
now so that if/when things do go bad, i'm not scrambling then :)
as a test, i'm just trying to dump a database's schema and restore
that ... but it seems lik
chrisj wrote:
Thanks Alan,
This helped a lot, but ideally I want a tab field delimiter and -F '\t' does
not seem to work, any ideas??
I noticed one other post on this same problem of the fieldsep '\t' not
working but the only advise offered was to use \pset. Can \pset be used on
the command lin
Francisco Reyes <[EMAIL PROTECTED]> writes:
> I see tables and indexes can be moved to a different tablespace.
> Is there any way to move an entire database to a different tablespace?
No. Moving the system catalogs on-the-fly would be an interesting
problem ("uh, where did you say pg_class was?
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes:
> I wanted to bind a 64-bit integer, but it failed:
> "ERROR: incorrect binary data format in bind
> parameter 1".
It sorta looks like you are trying to send that value to a parameter
that the server doesn't think is int8.
r
chrisj <[EMAIL PROTECTED]> writes:
> This helped a lot, but ideally I want a tab field delimiter and -F '\t' does
> not seem to work, any ideas??
I don't think there's any provision for backslash-notation in that
switch; you'd need to type an actual tab character there. Depending on
what shell yo
Thanks Alan,
This helped a lot, but ideally I want a tab field delimiter and -F '\t' does
not seem to work, any ideas??
I noticed one other post on this same problem of the fieldsep '\t' not
working but the only advise offered was to use \pset. Can \pset be used on
the command line, I can only g
Kevin Murphy <[EMAIL PROTECTED]> writes:
> Has anybody tried making a 64-bit PostgreSQL on an Apple XServe w/
> Intel Woodcrest CPU's? My compile works, but the 'make check' fails
> because of failure to allocate shared memory. There's plenty of SYSV
> memory available.
> creating template
On Thu, 19 Apr 2007 23:45:47 +0200, Karsten Hilbert <[EMAIL PROTECTED]> wrote:
> I can't spot the trouble with this function definition:
>
> create function dem.trf_null_empty_title()
> returns trigger
> language plpgsql
> as $null_empty_title$
> begin
> if (NEW.title is nu
A.M. wrote:
On Apr 19, 2007, at 3:21 PM, Kevin Murphy wrote:
Has anybody tried making a 64-bit PostgreSQL on an Apple XServe w/
Intel Woodcrest CPU's? My compile works, but the 'make check' fails
because of failure to allocate shared memory. There's plenty of
SYSV memory available.
The con
Works for me on both 8.1 and 8.2. What client are you using?
John
On Apr 19, 2007, at 5:45 PM, Karsten Hilbert wrote:
I can't spot the trouble with this function definition:
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
Flying-
reading the source displays
http://doxygen.postgresql.org/postgres_8c-source.html
/* Trouble if it didn't eat the whole buffer */
if (!isNull && pbuf.cursor != pbuf.len)
ereport(ERROR,
(errcode(ERRCODE_INVALID_BINARY_RE
Hi all,
I'm using Solaris 10 with 64-bit libpq library.
I wanted to bind a 64-bit integer, but it failed:
"ERROR: incorrect binary data format in bind
parameter 1".
The code would succeed if the type of "val" is
uint32_t.
Doe anyone know how to fix this? Thanks a lot!
---
Richard Huxton wrote:
David Potts wrote:
David Potts wrote:
Any platform !
ie Web ,X, , L/Unix console, Mac or even Weandozz
pgadmin, phppgadmin - although these are pitched more towards admin,
they let you edit table data.
PGAccess provides a spreadsheet like view of tables which users
chrisj wrote:
I would like to do a selective export of a number of tables from a large
database to import into a smaller (test) DB.
I know about: psql dbname -tc "select * from tableX where whatever" >
tableX.dat
You might try
psql dbname -Atc "select * from tableX where whatever" > tableX.
Karsten Hilbert wrote:
> Hi all,
>
> I can't spot the trouble with this function definition:
>
> create function dem.trf_null_empty_title()
> returns trigger
> language plpgsql
> as $null_empty_title$
> begin
> if (NEW.title is null) then
> return NEW;
>
[EMAIL PROTECTED] (Kenneth Downs) writes:
> If you want end-users to be doing the data entry, Andromeda may be
> what you want.
>
> http://www.andromeda-project.org/
>
> The project is aimed at more complicated cases and may carry too much
> overhead for what you want, but perhaps not.
Their choic
I have one table.
create table u (
id integer,
__
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
Regístrate ya - http://correo.espanol.yahoo.com/
---(end of broadcast)--
Hi all,
I can't spot the trouble with this function definition:
create function dem.trf_null_empty_title()
returns trigger
language plpgsql
as $null_empty_title$
begin
if (NEW.title is null) then
return NEW;
end if;
if trim(NEW.titl
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 04/19/07 14:51, Francisco Reyes wrote:
> I see tables and indexes can be moved to a different tablespace.
> Is there any way to move an entire database to a different tablespace?
Move one table at a time?
- --
Ron Johnson, Jr.
Jefferson LA USA
G
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 04/19/07 15:11, Dave Page wrote:
> Walter Vaughan wrote:
>> Raymond Hurst wrote:
>>
>>> I have a requirement of incorporating a database in a hard disk drive.
>> Well, back in the day there was a man called Dick Pick. The US Goverment
>> had the sam
Kevin Murphy wrote:
> On Apr 19, 2007, at 3:21 PM, Kevin Murphy wrote:
> >Has anybody tried making a 64-bit PostgreSQL on an Apple XServe w/
> >Intel Woodcrest CPU's? My compile works, but the 'make check'
> >fails because of failure to allocate shared memory. There's plenty
> >of SYSV memo
On Apr 19, 2007, at 3:21 PM, Kevin Murphy wrote:
Has anybody tried making a 64-bit PostgreSQL on an Apple XServe w/
Intel Woodcrest CPU's? My compile works, but the 'make check'
fails because of failure to allocate shared memory. There's plenty
of SYSV memory available.
The call to shmge
I'm about to begin playing with incrementally updated backups for a
warm standby scenario, but I need some help understanding this
paragraph in postgres terms. From 23.4.5 in the 8.2.3 docs:
"If we take a backup of the standby server's files while it is
following logs shipped from the prima
On 19/04/07, Andrej Ricnik-Bay <[EMAIL PROTECTED]> wrote:
On 4/15/07, Anton Melser <[EMAIL PROTECTED]> wrote:
> it might even make more sense), and with KDE/Gnome these days, I don't
> think there is much difference with XP...
Of course you could use fluxbox, twm or something else less
bloated .
Walter Vaughan wrote:
> Raymond Hurst wrote:
>
>> I have a requirement of incorporating a database in a hard disk drive.
>
> Well, back in the day there was a man called Dick Pick. The US Goverment
> had the same request. They wanted a database incorporated into a hard
> disk drive, and that's wh
Andrew Toth wrote:
> 2007. 04. 18, szerda keltezéssel 18.21-kor Alvaro Herrera ezt írta:
>
> > Andrew Toth wrote:
> > > Dear List,
> > >
> > > I would like to download the version of source code containing
> > > catversion.h with the line "#define CATALOG_VERSION_NO 200611051". This
> > > is fir
I see tables and indexes can be moved to a different tablespace.
Is there any way to move an entire database to a different tablespace?
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an
Raymond Hurst wrote:
I have a requirement of incorporating a database in a hard disk drive.
Well, back in the day there was a man called Dick Pick. The US Goverment had the
same request. They wanted a database incorporated into a hard disk drive, and
that's what they got. An operating system
2007. 04. 18, szerda keltezéssel 18.21-kor Alvaro Herrera ezt írta:
> Andrew Toth wrote:
> > Dear List,
> >
> > I would like to download the version of source code containing
> > catversion.h with the line "#define CATALOG_VERSION_NO 200611051". This
> > is first met in Changeset 26624
> > (http
Has anybody tried making a 64-bit PostgreSQL on an Apple XServe w/
Intel Woodcrest CPU's? My compile works, but the 'make check' fails
because of failure to allocate shared memory. There's plenty of SYSV
memory available.
I compiled using:
./configure --without-readline --prefix=/usr/loc
This is very interesting and I'm interested if you write a paper, so
we could reference on.
Two days ago I gave a talk on Russian Internet Technologies conference
about new FTS we developed for 8.3 version and there was real interest.
btw, there are several performance optimization tips for ts
tsearch2 versus mysql FULLTEXT in the context of a large forum.
I guess you know the answer already, but it never hurts to have nice
graphics to show your boss.
http://peufeu.free.fr/ftsbench/
I will upload new versions with more results, and maybe other engines, as
I ca
If you want embedded SQL, you'll probably have only 1 user at a time so
sqlite is a better choice.
But do you want embedded SQL ?
On Wed, 18 Apr 2007 22:48:52 +0200, Raymond Hurst <[EMAIL PROTECTED]>
wrote:
I have a requirement of incorporating a database in a hard disk drive.
Reid Thompson wrote:
> On Thu, 2007-04-19 at 10:05 -0500, Tony Caduto wrote:
> http://www.gnome-db.org/
Glom (www.glom.org) would seem to fit the bill.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
-
In a hard disk drive? My god, why? If you're doing embedded
programming, don't carry over applications that were never intended
for it. Go port eForth or Pygmy Forth to your hard drive, or at least
set up a C cross compiler, and write whatever hash tables you need.
If you're trying to make a de
On Thu, 2007-04-19 at 10:05 -0500, Tony Caduto wrote:
> David Potts wrote:
> > Can any body recommend a generic opensource data entry tool that can be
> > used to make some simple forms for entering data in to postgres?
> >
> >
> > ---(end of broadcast)-
On Apr 19, 9:41 am, Kev <[EMAIL PROTECTED]> wrote:
> On Apr 17, 10:27 am, [EMAIL PROTECTED] (Mageshwaran) wrote:
>
> > hi everyone,
>
> > please any one give any methods to do incremental backups. it is urgent
> > .. help me
>
> > Regards
> > J Mageshwaran
>
> Sorry, I don't have anything implement
I have a requirement of incorporating a database in a hard disk drive.
Can postgresql do the job? Any consultants out here that have done this?
If not, any suggestions?
Ray Hurst
Western Digital
20511 Lake Forest Drive
Lake Forest, CA 92630
949-672-9853
On Apr 17, 10:27 am, [EMAIL PROTECTED] (Mageshwaran) wrote:
> hi everyone,
>
> please any one give any methods to do incremental backups. it is urgent
> .. help me
>
> Regards
> J Mageshwaran
Sorry, I don't have anything implemented, but I've been wondering
about this too. One way (not necessaril
Hi,
I am developing a web application for auditing tables from a postgresql
database.
My question is: when an update occurrs in the base table, should I insert in
the auditing table the new record or the old one?
I was first inserting the new one but a job partner, who are testing the
applica
David Potts wrote:
Can any body recommend a generic opensource data entry tool that can be
used to make some simple forms for entering data in to postgres?
---(end of broadcast)---
TIP 6: explain analyze is your friend
For Desktop applicatio
Peter Neu wrote:
Hello,
I have 2 tables:
In one I log the user name of a web site user like this:
Name Access time
"makost0001" " 2007-04-19 15:09:19"
"makost0001" " 2007-04-19 15:09:19"
In the other I have the user name his group and the expiry date of his
account.
Name
Bill and Tom
Best to find out what kind of index you want to create beforehand
If your data is evenly distributed and exhibits High Cardinality (2 entries
for A,B,C...Z) then I would recommend a BTREE Index
If not (low cardinality scenarios such as gender) then create Bitmap Index
I cant speak
In response to Tom Lane <[EMAIL PROTECTED]>:
> Bill Moran <[EMAIL PROTECTED]> writes:
> > Just an FYI ... I remembered what prompted the cron job.
>
> > We were seeing significant performance degradation. I never did actual
> > measurements, but it was on the order of "Bill, why is restoring tak
Hello,
I have 2 tables:
In one I log the user name of a web site user like this:
Name Access time
"makost0001" " 2007-04-19 15:09:19"
"makost0001" " 2007-04-19 15:09:19"
In the other I have the user name his group and the expiry date of his
account.
Name Group
Germán Hüttemann Arza wrote:
> Hi,
>
> I am developing a web application for auditing tables from a postgresql
> database.
>
> My question is: when an update occurrs in the base table, should I insert in
> the auditing table the new record or the old one?
>
> I was first inserting the new one
Ask the question: can I make sure I always have a complete trail? If
you insert the old row, you will always have the old values and the
table itself holds the new values.
Germán Hüttemann Arza wrote:
Hi,
I am developing a web application for auditing tables from a postgresql
database.
My
Germán Hüttemann Arza wrote:
Hi,
I am developing a web application for auditing tables from a postgresql
database.
My question is: when an update occurrs in the base table, should I insert in
the auditing table the new record or the old one?
Old - you already have the new version in the ma
Hi,
I am developing a web application for auditing tables from a postgresql
database.
My question is: when an update occurrs in the base table, should I insert in
the auditing table the new record or the old one?
I was first inserting the new one but a job partner, who are testing the
applica
If you want end-users to be doing the data entry, Andromeda may be what
you want.
http://www.andromeda-project.org/
The project is aimed at more complicated cases and may carry too much
overhead for what you want, but perhaps not.
David Potts wrote:
Can any body recommend a generic opensou
David Potts wrote:
David Potts wrote:
Any platform !
ie Web ,X, , L/Unix console, Mac or even Weandozz
pgadmin, phppgadmin - although these are pitched more towards admin,
they let you edit table data.
There are also lots of commercial admin/data tools that will work with
PG - check the
> David Potts wrote:
Any platform !
ie Web ,X, , L/Unix console, Mac or even Weandozz
>>
>> Can any body recommend a generic opensource data entry tool that can be
>> used to make some simple forms for entering data in to postgres?
>
> For the web? *nix console? GTK? Mac?
>
> --
>Richard Hux
David Potts wrote:
Can any body recommend a generic opensource data entry tool that can be
used to make some simple forms for entering data in to postgres?
For the web? *nix console? GTK? Mac?
--
Richard Huxton
Archonet Ltd
---(end of broadcast)--
Ashish Karalkar wrote:
Hello All,
can anybody please tell me which file name should given in %f parameter of
archive_command.
As per documantation
"When not using WAL archiving, the system normally creates just a few segment files and
then "recycles" them by renaming no-longer-needed s
Can any body recommend a generic opensource data entry tool that can be
used to make some simple forms for entering data in to postgres?
---(end of broadcast)---
TIP 6: explain analyze is your friend
Hello All,
can anybody please tell me which file name should given in %f parameter of
archive_command.
As per documantation
"When not using WAL archiving, the system normally creates just a few
segment files and then "recycles" them by renaming no-longer-needed segment
files to higher s
59 matches
Mail list logo
