Note:
Assumption tables are already created and/or in existence.
I dump all data from a 7.3.5 db using LATIN9 encoding.
When I restore it back to a 8.1.3 db using LATIN9 encoding
it is much slower than restoring back to a 7.3.xx db.
Restoration from 7.3.5 to 8.1.3 took more or less 24 hours aga
I believe PostgreSQL treat UTF-8 and LATIN9 Differently.
When I tried to dump a db to a UTF-8 encoding and restore it
with UTF-8 encoding (also) it encountered problems with fields
that have unicoded values thus it stop from restoring the whole dump.
So I tried using LATIN9 encoding for both dump
Correct me if I am wrong but SQL procedural language doesn't have support for variable declarations?
And
Why does my stored function returns only the first row of the query instead of the whole set of query?
Kindly educate me :)
On Fri, Feb 17, 2006 at 08:07:26PM -0800, Benjamin Smith wrote:
> How can I update a range of constrained values in order, without having to
> resubmit a query for every single possiblity?
>
> I'm trying to create a customer-specific sequence number, so that, for each
> customer, the number sta
On Sat, Feb 18, 2006 at 04:10:13PM +0800, Jan Cruz wrote:
> Correct me if I am wrong but SQL procedural language doesn't have support
> for variable declarations?
Correct, you'll need pl/pgsql for that.
> Why does my stored function returns only the first row of the query instead
> of the whole s
> Why does my stored function returns only the first row of the query instead
> of the whole set of query?Did you declare your function to return "setof " ?I did but I don't know if I have to iterate/loop and use "return next setof_foo"
or just use return next as it is.
Hi,
I wonder how to have a sort of "uniq" index on date interval, such
that there is no date interval overlaping in the table.
exemple:
create table test (start timestamp, end timestamp);
with the constraint: end > start
Cordialement,
Jean-Gérard Pailloncy
---(end o
On Sat, Feb 18, 2006 at 10:03:11AM +0100, Pailloncy Jean-Gerard wrote:
> Hi,
>
> I wonder how to have a sort of "uniq" index on date interval, such
> that there is no date interval overlaping in the table.
>
> exemple:
> create table test (start timestamp, end timestamp);
> with the constraint:
am 18.02.2006, um 10:03:11 +0100 mailte Pailloncy Jean-Gerard folgendes:
> Hi,
>
> I wonder how to have a sort of "uniq" index on date interval, such that
> there is no date interval overlaping in the table.
>
> exemple:
> create table test (start timestamp, end timestamp);
> with the constrai
Jan Cruz wrote:
> I believe PostgreSQL treat UTF-8 and LATIN9 Differently.
Certainly, considering that they are different encodings.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: Don't 'kill -9' the p
Rick Gigger wrote:
> I have this exact problem. I have dumped and reloaded other
> databases and set the client encoding to convert them to UTF-8 but I
> have one database with values that still cause it to fail, even if I
> specify that the client encoding is SQL_ASCII. How do I fix that?
Well
Hmm, I have found a small bug:
When there is a compound affix with zero length of search pattern (which
should not be!), ispell dictionary ignores all other compound affixes.
Original afix file contains
flag ~\`:
E > -E,NINGS#~ avskrive > avskrivnings-
Z Y Z Y
Hello,
I am migrating to postgresql from another database. I want to take
advantage of using domains. Let's suppose I create domain
'email'(varchar 128). Then I change my mind and want to increase all
columnst that have type 'emaill' to varchar(255). How do I change the
domain 'email' to the
I do not know about the word "domains" in this usage.But all your problems with "varchar(x)" for any values of x are solved by just using type "text"Harald
'email'(varchar 128). Then I change my mind and want to increase all columnst that have type 'emaill' to varchar(255). -- GHUM Harald Massapers
I've been going through the docs and list archives trying to get
clear on encoding issues, but still have a few question.
Do I have these statements correct?
- LC_COLLATE is set on the cluster at initdb time. From that point
on all database text is sorted based on that *regardless* of the
enco
Bill Moseley wrote:
> Do I have these statements correct?
yes
> 1) What else is the database's encoding used for besides to determine
> how to convert text in input and output based on the client encoding?
nothing
> 2) What client encoding is used if the client does not specify one?
the server
On Sat, Feb 18, 2006 at 05:20:19PM +0100, Peter Eisentraut wrote:
> > 2) What client encoding is used if the client does not specify one?
>
> the server encoding
What's the server encoding? The environment when the cluster is
started? How do you find out what it's running as?
Does that mean if
On Sat, 18 Feb 2006, Peter wrote:
> Hello,
>
> I am migrating to postgresql from another database. I want to take
> advantage of using domains. Let's suppose I create domain
> 'email'(varchar 128). Then I change my mind and want to increase all
> columnst that have type 'emaill' to varchar(255). H
Bill Moseley wrote:
> What's the server encoding?
When you say "My database is in utf8", then "utf8" is the server
encoding.
> Does that mean if the encoding is anything other than "C"
C is a locale, not an encoding.
> Just that sorting utf8 is a bit more work that sorting raw bytes.
Sorting
On 2006-02-18, "A. Kretschmer" <[EMAIL PROTECTED]> wrote:
> am 18.02.2006, um 10:03:11 +0100 mailte Pailloncy Jean-Gerard folgendes:
>> I wonder how to have a sort of "uniq" index on date interval, such that
>> there is no date interval overlaping in the table.
>
> You can write a trigger to che
Bill Moseley <[EMAIL PROTECTED]> writes:
> - To clarify the first point, if the database is encoded utf-8 and
> lc_collate is en_US then Postgresql does NOT try to convert utf-8 to
> 8859-1 before sorting.
Basically, this is a horribly bad idea and you should never do it.
The database encoding sho
Hi there,
I just wanted to let you know that I finally made the trigger work using
an external php script. Actually it always worked, the problem is that
I was trying the trigger in one machine and testing the results in other.
I know, very lame.
Some people suggested plphp, I tried it but I had
A. Kretschmer <[EMAIL PROTECTED]> schrieb:
> am 18.02.2006, um 10:03:11 +0100 mailte Pailloncy Jean-Gerard folgendes:
> > Hi,
> >
> > I wonder how to have a sort of "uniq" index on date interval, such that
> > there is no date interval overlaping in the table.
> >
> > exemple:
> > create tabl
On Sat, Feb 18, 2006 at 10:59:16AM -0800, David Rio Deiros wrote:
> Also, I took me a while to figure out how to compile my trigger on
> FreeBSD and MacOSX/Darwin. Finally I found this in the documentation:
>
> http://www.postgresql.org/docs/8.0/interactive/xfunc-c.html
>
> which perfectly expla
On Sat, Feb 18, 2006 at 12:34:23PM -0700, Michael Fuhr wrote:
> On Sat, Feb 18, 2006 at 10:59:16AM -0800, David Rio Deiros wrote:
> > Also, I took me a while to figure out how to compile my trigger on
> > FreeBSD and MacOSX/Darwin. Finally I found this in the documentation:
> >
> > http://www.pos
Hi yeah I was doing some reading today and realized that I had to
change the pg_hba.conf file from local host to something else but I
don't wuite understand what I am suppose to be entering for the
CIDR-Address setting. This database will only be accessed from the
network and surrounding computers.
Hi,
Has anyone else had troubles installing PGSQL using the Win installer package
(msi) on NT4 machines? I've tried on two separate machines and each time the
install sequence fails to complete successfully. Sorry the details are sketchy
(I was not performing the installations). PG 8.0.1.
I
"mmaclennan" <[EMAIL PROTECTED]> writes:
> Hi yeah I was doing some reading today and realized that I had to
> change the pg_hba.conf file from local host to something else but I
> don't wuite understand what I am suppose to be entering for the
> CIDR-Address setting. This database will only be ac
Douglas McNaught <[EMAIL PROTECTED]> writes:
>> I also noticed that I needed to change the listening_addresses under
>> the connection setting in the postgresql.config file. DO I have to do
>> this? I didn't find the information really clear and there weren't any
>> examples for me to understand w
Mmaclennan:
Restart Postgresql. If you need help with
this, let us know.
Ezra Taylor
On 16 Feb 2006 21:38:07 -0800, mmaclennan <[EMAIL PROTECTED]> wrote:
> I have installed postgresql with postgis on a server at my home and I
> have loaded some data into it but I can not a
> Hi,
>
> Has anyone else had troubles installing PGSQL using the Win
> installer package (msi) on NT4 machines? I've tried on two
> separate machines and each time the install sequence fails to
> complete successfully. Sorry the details are sketchy (I was
> not performing the installations)
On Feb 19, 2006, at 2:12 , Stephan Szabo wrote:
On Sat, 18 Feb 2006, Peter wrote:
Hello,
I am migrating to postgresql from another database. I want to take
advantage of using domains. Let's suppose I create domain
'email'(varchar 128). Then I change my mind and want to increase all
columnst
On Sat, Feb 18, 2006 at 01:40:09PM -0500, Tom Lane wrote:
> Bill Moseley <[EMAIL PROTECTED]> writes:
> > - To clarify the first point, if the database is encoded utf-8 and
> > lc_collate is en_US then Postgresql does NOT try to convert utf-8 to
> > 8859-1 before sorting.
>
> Basically, this is a h
On Sat, Feb 18, 2006 at 04:48:55PM +0800, Jan Cruz wrote:
> > > Why does my stored function returns only the first row of the query
> > > instead of the whole set of query?
> >
> > Did you declare your function to return "setof " ?
>
> I did but I don't know if I have to iterate/loop and use "retur
Bill Moseley wrote:
> What's a bad idea? Having a lc_collate on the cluster that doesn't
> support the encodings in the databases?
Exactly
> Again, not sure what "it" is, but I do find it confusing when the
> cluster can have only one lc_collate, but the databases on that
> cluster can have more
Bill Moseley <[EMAIL PROTECTED]> writes:
> $ LC_ALL=en_US.UTF-8 locale charmap
> UTF-8
>
> $ LC_ALL=en_US locale charmap
> ISO-8859-1
>
> $ LC_ALL=C locale charmap
> ANSI_X3.4-1968
Unfortunately Postgres only supports a single collation cluster-wide. So
depending on whi
On Sat, Feb 18, 2006 at 09:31:27PM -0500, Greg Stark wrote:
> Anything else and the collation just won't work properly. It will be
> expecting UTF-8 and be fed ISO-8859-1 strings, resulting in weird
> and sometimes inconsistent sort orders.
So if I have utf8 encoded text and the lc_collate is anyt
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 and have discovered that FrontBase returns null rows along with t
AFAIK NULL is not a value according to SQL spec, so it doesn't match in a "not
in" clause (or any other value comparing clause for that matter, i.e. blabla
>= 10 will not match rows where blabla is null). Therefor I'd say the result
of 30 is correct.
If you want to see null results too you shou
Brendan Duddridge <[EMAIL PROTECTED]> writes:
> I've reduced my problem to the following statement and have
> discovered that FrontBase returns null rows along with the rows that
> match the query and PostgreSQL only returns the not null rows.
> CON.IS_SUBSCRIBED NOT IN ('X', 'P')
You m
40 matches
Mail list logo
