Sebastián Baioni wrote:
> Every day we run a Windows Programmed pg_dump, it used to
> work fine with PostgreSQL 8.0, but since we installed the new
> version we are not able to make a backup. We tried to make a
> whole database backup and it never ends. We tried to backup
> table by table and i
Greg Smith <[EMAIL PROTECTED]> writes:
> On Tue, 1 Jan 2008, Chuck wrote:
>> Since I have a packaged installation, I don't believe that I will call
>> initdb directly.
> There is actually another command I don't think you've noticed yet:
> service postgresql initdb
Actually, that was only added
Richard Broersma Jr <[EMAIL PROTECTED]> writes:
> However, It seems the select doesn't yet see the non-committed records. I.E.
> the record that should be equal to NEW is in fact equal to OLD.
Please provide a self-contained example.
regards, tom lane
---
I have a PLpgSQL AFTER UPDATE constraint trigger that calls a trigger function
with an embedded select statement.
The select statement queries the affected table and returns a mult-result set
that includes the record equivalent to NEW.
However, It seems the select doesn't yet see the non-commit
On Tue, 1 Jan 2008, Chuck wrote:
Since I have a packaged installation, I don't believe that I will call
initdb directly.
There is actually another command I don't think you've noticed yet:
service postgresql initdb
That runs initdb with the user and permissions properly to get you
something
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 1 Jan 2008 18:49:40 -0800
Chuck <[EMAIL PROTECTED]> wrote:
> ### main question:
> I think that need to figure where initdb is being called from to
> modify its parameters. Or, I need to determine how to set the default
> encoding to be UTF8.
Thanks for Tomasz and Andrew's responses (as well as one person's
response off the list). There was a lot of valuable information. I've
done some further reading in the postgres manual and I've exchanged a
few emails from my web host.
My web host recommends sticking with the CentOS repo packag
Matthew Wilson wrote:
> I have a table MESSAGE with a text column and a timestamp column. I
> want to make sure that I have no rows with duplicates for both values.
> I have two ideas right now for how to do this.
>
> IDEA 1:
>
> CREATE UNIQUE INDEX nodups on MESSAGE (my_timestamp_col, my_text_c
I have a table MESSAGE with a text column and a timestamp column. I
want to make sure that I have no rows with duplicates for both values.
I have two ideas right now for how to do this.
IDEA 1:
CREATE UNIQUE INDEX nodups on MESSAGE (my_timestamp_col, my_text_col);
IDEA 2:
CREATE UNIQUE INDEX n
On Tue, Jan 01, 2008 at 06:05:32PM +0100, Tomasz Ostrowski wrote:
> > LC_CTYPE="POSIX"
> > LC_COLLATE="POSIX"
>
> This is bad. Make sure you have
> LANG="en_US.UTF-8"
> set in a file "/etc/sysconfig/i18n" and reboot.
If you do it that way, be _very sure_ you understand the interactions of
l
On Mon, Dec 31, 2007 at 02:39:02PM -0800, Chuck wrote:
> yum -y install postgre postgre-server postgre-devel
I assume that's all spelled "postgres". But otherwise, ok.
> Upgrade to PostgreSQL 8.2.5?
> Before I start creating databases, it seems like I should up consider
> upgrading to PostgreSQ
On Mon, 31 Dec 2007, Chuck wrote:
> I asked the web host to make sure that Postgres is installed. They did this
> by running the following command:
> yum -y install postgre postgre-server postgre-devel
I think the proper command was:
yum -y install postgresql postgresql-server postgresql-devel
On Jan 1, 2008 10:27 AM, Martin Gainty <[EMAIL PROTECTED]> wrote:
>
> Not the planner but you can hint the query as in this example
> select /*+ ordered use_hash(code1)*/ * from table_1;
no, that's an oraclism.
---(end of broadcast)---
TIP 6: expl
Not the planner but you can hint the query as in this example
select /*+ ordered use_hash(code1)*/ * from table_1;Martin
__Disclaimer and confidentiality
noteEverything in this e-mail and any attachments relates to the official
business of Sender. Thi
On 31/12/2007 23:06, dvanatta wrote:
Where are all the types I've created in the object browser?
Do you see a "Types" node at all in the tree, one level beneath the
schema in which you're working? If not, you need to go to File ->
Options -> Display tab, and make sure that "Types" is checked
Reg Me Please wrote:
Hello all.
I have some tables that contain exactly 1 row and that I use for searches with
JOIN.
Does it make any sense to hint the planner about this?
If so, how can I send such hints to it?
You don't give hints to the planner.
The planner does use statistics gathered
Hello all.
I have some tables that contain exactly 1 row and that I use for searches with
JOIN.
Does it make any sense to hint the planner about this?
If so, how can I send such hints to it?
--
Reg me, please!
---(end of broadcast)---
TIP 9: In
17 matches
Mail list logo
