When restoring a dump from sql_ascii encoding to latin9/utf8
the "THIS STRING|" result to "THIS STRINGŠ" thus it aborted the restore.
When I tried to dump a latin9/utf8 and restore it with the same encoding
having same string it goes well but it took a very long time to copy all data.
(1.6gb dump
Hi,
I am using copy command in psql
to load several million rows from a file
Is it possible to have a progress indicator print a
dot after every 100,000 rows are inserted ?
Regards,
Virag
On Mon, Feb 20, 2006 at 02:36:04PM +0800, Jan Cruz wrote:
> BTW I also got something like this:
>
> CREATE FUNCTION func2() RETURNS SETOF foo as $$
> DECLARE
> row foo;
> BEGIN
> SELECT INTO ROW * from FOO;
>return next foo;
> END;
> $$ LANGUAGE plpgsql STABLE;
Please post the actual code i
On 2/19/06, Michael Fuhr <[EMAIL PROTECTED]> wrote:
On Sat, Feb 18, 2006 at 04:48:55PM +0800, Jan Cruz wrote:
CREATE TABLE foo (id integer, t text);INSERT INTO foo VALUES (1, 'one');
INSERT INTO foo VALUES (2, 'two');
Thanks for the correct syntaxing Mike.
BTW I also got something like this:
C
Hi all,
I'm pretty sure the answer to this is "not possible" but I'll ask just
in case.
Is there a way to simplify the output that comes from explain?
I'm writing a script to check my database logs to see whether I am
missing any indexes.
Basically the process goes like this:
- Find a se
On Feb 18, 2006, at 20:46 , Harald Armin Massa wrote:
I do not know about the word "domains" in this usage.
http://www.postgresql.org/docs/8.1/interactive/sql-createdomain.html
Michael Glaesemann
grzm myrealbox com
---(end of broadcast)---
> Could this be a locale issue? The one where it does not work uses the C
> locale, the others use the default locale, en_US.UTF-8.
Nope, it's not a locale issue, it works on the test system using the C
locale as well as the default locale.
I though I had the backslash issue under control in my
> This has not changed from prior versions. It looks like you are
> neglecting to allow for the fact that backslash is an escape character
> both at the string-literal level and at the regex-pattern level.
> Therefore you must write twice as many backslashes as you normally
> would write in a rege
Mike Nolan <[EMAIL PROTECTED]> writes:
> When I moved up to 8.1.2 one of my PHP programs appears to be broken,
> I am getting backslashes in my data that I don't want.
> Investigating further, I have found some inconsistencies in how verion
> 8.1.2 handles data with backslashes in it:
This has n
"Christopher J. Bottaro" <[EMAIL PROTECTED]> writes:
> I want to use pg_dump to backup an entire Postgres database, including BLOB
> data. Then I want to restore it on a different machine with a different db
> owner and all the tables restored under that owner. I want the restore to
> create the
On Feb 19, 2006, at 3:25 PM, Christopher J. Bottaro wrote:
I want to use pg_dump to backup an entire Postgres database,
including BLOB
data. Then I want to restore it on a different machine with a
different db
owner and all the tables restored under that owner. I want the
restore to
cre
Hi,
I want to use pg_dump to backup an entire Postgres database, including BLOB
data. Then I want to restore it on a different machine with a different db
owner and all the tables restored under that owner. I want the restore to
create the db and all the tables.
What are the commands to do this?
When I moved up to 8.1.2 one of my PHP programs appears to be broken,
I am getting backslashes in my data that I don't want.
Investigating further, I have found some inconsistencies in how verion
8.1.2 handles data with backslashes in it:
uscf=> \d backtest;
Table "mikenolan.backtest"
Column |
=?ISO-8859-1?Q?Ken=E9z_Attila?= <[EMAIL PROTECTED]> writes:
> I would like to implement a function in plpgsql (or sql if it is possible)
> that can say me if I had some notification of some listened table.
Notifications are delivered to the client (and then promptly forgotten
by the backend). The
Hi,
Thanks for the suggestion. However I just wanted to give a brief
description of something I want to achieve. I believe such feature will
be very useful in more complicated environments.
Kind regards,
Peter
Michael Glaesemann wrote:
On Feb 19, 2006, at 2:12 , Stephan Szabo wrote:
O
On Sat, Feb 18, 2006 at 08:16:07PM -0800, Bill Moseley wrote:
> Is the Holy Grail encoding and lc_collate settings per column?
Well yes. I've been trying to create a system where you can handle
multiple collations in the same database. I posted the details to
-hackers and got part of the way, but
-
PostgreSQL New RPM Sets
2006-02-19
Versions: 8.1.3, 8.0.7, 7.4.12, 7.3.14
Set labels: 8.1.3-1PGDG, 8.0.7-1PGDG, 7.4.12-1PGDG, 7.3.14-1PGDG
-
Hi all,
I would like to implement a function in plpgsql (or sql if it is possible)
that can say me if I had some notification of some listened table. I mean
something like this:
create procedure do_i_have_notifications(text) returns boolean as '
...
' language (plpg)sql;
(or:
create pro
On Sat, 18 Feb 2006, Brendan Duddridge wrote:
> Hi,
>
> I have a query that returns 569 rows in FrontBase, but only 30 rows
> in Postgres. The data is the same as I just finished copying my
> entire database over from FrontBase to Postgres.
>
> I've reduced my problem to the following statement an
19 matches
Mail list logo
