Naz Gassiep <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> No, that implies a lack of error checking.
> Surely, then, that's a bug? Shouldn't postmaster check if a DB is in an
> encoding that differs from the selected locale?
Yeah, it should. Whether it can is a different question.
Part of th
Tom Lane wrote:
>> I've successfully created a utf8 database, does that imply that
>> because I was able to create a DB with a different encoding to the ones
>> all the others use (SQL_ASCII) that my locale is set to "C" ?
>>
>
> No, that implies a lack of error checking.
Surely, then, that's
Naz Gassiep <[EMAIL PROTECTED]> writes:
> OK I understand now, I think. How do I check what locale is currently
> set?
"show lc_collate" (maybe check the other lc_ settings too for luck).
> I've successfully created a utf8 database, does that imply that
> because I was able to create a DB with a
Tom Lane wrote:
> Are you clear on the difference between encoding and locale?
>
I confidently reply with "maybe".
> You can make new databases with whatever encoding you say, but the
> server's lc_collate and lc_ctype are frozen at initdb, and it will
> not work well to select an encoding tha
On 07/07/2007 20:06, Carmen Martinez wrote:
Please, I need to know where the catalog tables (pg_class,
pg_attrdef...) are located in the postgresql rdbms. Because I can not
see them in the pgAdminII interface, like other tables or objects. And I
There is a separate list for pgAdmin questions
Naz Gassiep <[EMAIL PROTECTED]> writes:
> Why have I been told that I need to do a re initdb to change the char
> encoding? The man says i can just createdb foodb -E utf8so why
> would i need to dump/initdb/create/restore? cant i just dump/create/restore?
Are you clear on the difference be
Why have I been told that I need to do a re initdb to change the char
encoding? The man says i can just createdb foodb -E utf8so why
would i need to dump/initdb/create/restore? cant i just dump/create/restore?
It'd save all the messing around with changing the data dirs etc.
On Sat, 7 Jul 2007 00:12:32 +0200 Andreas 'ads' Scherbaum wrote:
> On Fri, 6 Jul 2007 12:06:41 -0400 Alvaro Herrera wrote:
>
> > Andreas 'ads' Scherbaum wrote:
> > > The value is '0' for all columns in all entries, except 'vacrelid' and
> > > 'enabled'.
> > > Can a VACUUM run happen, even if ena
On 7/7/07, rupesh bajaj <[EMAIL PROTECTED]> wrote:
Hi,
When I run the following query Postmaster crashes. For your reference I have
attached information regarding the query (query plan, table , index, server
log).
My observation is that when Postmaster starts taking lot of memory because
of which
"rupesh bajaj" <[EMAIL PROTECTED]> writes:
> When I run the following query Postmaster crashes.
> ...
> LOG: background writer process (PID 5808) was terminated by signal 9
> LOG: terminating any other active server processes
> LOG: statistics collector process (PID 5809) was terminated by signa
Hello
you can test it. PostgreSQL 8.3 supports it.
postgres=# CREATE TYPE at AS (a integer, b integer);
CREATE TYPE
postgres=# CREATE TABLE foo(a at[]);
CREATE TABLE
postgres=# INSERT INTO foo VALUES(ARRAY[(10,20)::at]);
INSERT 0 1
postgres=# INSERT INTO foo VALUES(ARRAY[(10,20)::at, (20,30)::at
Thank you for the answer.
At least I'm glad it is possible!
But , as I don't know Perl, could you, please, tell me how to accomplish it
in plpgsql.
Thanks,
Zlatko
- Original Message -
From: "Greg Sabino Mullane" <[EMAIL PROTECTED]>
To:
Sent: Saturday, July 07, 2007 1:47 PM
Subject:
Hi,
When I run the following query Postmaster crashes. For your reference I have
attached information regarding the query (query plan, table , index, server
log).
My observation is that when Postmaster starts taking lot of memory because
of which system runs out of memory and OS kills the process.
On Jul 7, 2007, at 2:15 PM, Tom Lane wrote:
Perry Smith <[EMAIL PROTECTED]> writes:
On Fri, Jul 06, 2007 at 08:02:54PM +0400, Viatcheslav Kalinin wrote:
# select start_date from show_date
# order by
# case when start_date > CURRENT_DATE then start_date end desc,
# case when start_date <= CURR
On Sat, Jul 07, 2007 at 01:49:09PM -0500, Perry Smith wrote:
> >># select start_date from show_date
> >># order by
> >># case when start_date > CURRENT_DATE then start_date end desc,
> >># case when start_date <= CURRENT_DATE then start_date end asc;
> >>
> I am very novice, but that looks odd to m
Perry Smith <[EMAIL PROTECTED]> writes:
>> On Fri, Jul 06, 2007 at 08:02:54PM +0400, Viatcheslav Kalinin wrote:
> # select start_date from show_date
> # order by
> # case when start_date > CURRENT_DATE then start_date end desc,
> # case when start_date <= CURRENT_DATE then start_date end asc;
>
>
Please, I need to know where the catalog tables (pg_class, pg_attrdef...) are
located in the postgresql rdbms. Because I can not see them in the pgAdminII
interface, like other tables or objects. And I can not find any reference about
where this information is, please any help would be welcome.
On Fri, Jul 06, 2007 at 08:02:54PM +0400, Viatcheslav Kalinin wrote:
# select start_date from show_date
# order by
# case when start_date > CURRENT_DATE then start_date end desc,
# case when start_date <= CURRENT_DATE then start_date end asc;
I am very novice, but that looks odd to me. I would
"Louis-David Mitterrand" <[EMAIL PROTECTED]> writes:
> However if I try:
>
> select start_date from show_date order by 'start_date desc';
>
> I get a:
>
> ERROR: non-integer constant in ORDER BY
The quotes mean you are asking to sort by the string "start_date desc" which
is an error
Hi all;
I was wondering how one would define an array of complex data types or
records. Any ideas or is this simply not supported?
Best Wishes,
Chris Travers
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your de
Why not just write the trigger function as:
if old.a is distinct from new.a or old.b is distinct from new.b
...
end if
--
Scott Ribe
[EMAIL PROTECTED]
http://www.killerbytes.com/
(303) 722-0567 voice
---(end of broadcast)---
TIP 6: explain anal
"Leon Mergen" <[EMAIL PROTECTED]> writes:
> Now, I enter a 'vacuum verbose;' and wait for about a day (the
> database is 1TB in size) -- it completes, and I start the database
> again; it starts replaying the +- 1K WAL log files for a while, and
> after completion, I try to attempt to connect to th
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> Is it possible to retrieve information about how many rows were
> changed/inserted in a table that fired after statement trigger?
Not directly, but you can store the information from row-level
triggers and gather it at the end. See this plp
Hello,
Okay, I was stupid -- I didn't check my database server for a while
(vacation), returned, and found out I didn't run vacuum for a too long
time:
bash-3.1$ psql --version
psql (PostgreSQL) 8.1.9
contains support for command-line editing
bash-3.1$ psql
psql: FATAL: database is not acceptin
Hello,
Okay, I was stupid -- I didn't check my database server for a while
(vacation), returned, and found out I didn't run vacuum for a too long
time:
bash-3.1$ psql --version
psql (PostgreSQL) 8.1.9
contains support for command-line editing
bash-3.1$ psql
psql: FATAL: database is not acceptin
On Fri, Jul 06, 2007 at 08:02:54PM +0400, Viatcheslav Kalinin wrote:
>
> # select start_date from show_date
> # order by
> # case when start_date > CURRENT_DATE then start_date end desc,
> # case when start_date <= CURRENT_DATE then start_date end asc;
The strange thing is when I try:
sel
On Fri, Jul 06, 2007 at 08:02:54PM +0400, Viatcheslav Kalinin wrote:
> Louis-David Mitterrand wrote:
>
> # select start_date from show_date
> # order by
> # case when start_date > CURRENT_DATE then start_date end desc,
> # case when start_date <= CURRENT_DATE then start_date end asc;
But... this w
Hello.
These days I was trying to temporarily disable triggers, too, and had much
problems with ALTER TABLE..DISABLE TRIGGER ALL. So, I was googling for another
solution and have found this: http://www.varlena.com/GeneralBits/101.php. Works
OK in my case...
Turn off triggers for bulk
Hello.
Is it possible to retrieve information about how many rows were
changed/inserted in a table that fired after statement trigger?
Thanks,
Zlatko
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
29 matches
Mail list logo
