>> I need to convert the integer values for the years into column names, i.e.
>> "1965" into "y_1965". How do I achieve this then?
>
> Try something like:
>
> create table foo (
> name text,
> year_start int,
> value float8);
>
> insert into foo values('a',2010,1.23),('b',2011,2.34);
>
> SELEC
(SELECT * from mydata,city WHERE mydata.sample = 1 AND
mydata.age_from >= city.age_from AND mydata.age_to <= city.age_to AND
basen not in ('A', 'T', 'G','C'))
INTERSECT
(SELECT * from mydata,city WHERE mydata.sample = 2 AND
mydata.age_from >= city.age_from AND mydata.age_to <= city.age_to AND
base
On Mon, Nov 1, 2010 at 4:39 PM, Jonathan Tripathy wrote:
>
> On 01/11/10 21:10, Vick Khera wrote:
>>
>> On Mon, Nov 1, 2010 at 3:53 PM, Jonathan Tripathy
>> wrote:
>>>
>>> The standby must support INSERTS and UPDATES as well (once the master has
>>> failed)
>>>
>>> Are there any solutions like th
Kevin Field writes:
> My guess is that it has something to do with the join to the table
> 'mandate'.
I was wondering about that too, but the error message is pretty clear
about which table it's complaining about.
Please see if you can put together a self-contained example.
Andy Colson writes:
> now now we have a membership record (100), but no customer record.
I haven't really been following this thread, but: isn't the answer
to that to establish a foreign-key constraint? If there's an FK
then the database will provide sufficient row locking to prevent
you from de
On 01/11/10 21:10, Vick Khera wrote:
On Mon, Nov 1, 2010 at 3:53 PM, Jonathan Tripathy wrote:
The standby must support INSERTS and UPDATES as well (once the master has
failed)
Are there any solutions like this? Looking on the Postgresql site, all the
standby solutions seem to be read only..
Merlin Moncure wrote on 01.11.2010 23:13:
On Mon, Nov 1, 2010 at 4:27 PM, Thomas Kellerer wrote:
The problem is, that the JDBC driver only returns information about the temp
tables, if I specify that schema directly.
Have you filed a bug report to jdbc yet? :-D.
I thought about it initially
On 11/01/2010 04:13 PM, Merlin Moncure wrote:
> On Mon, Nov 1, 2010 at 4:27 PM, Thomas Kellerer wrote:
>> The problem is, that the JDBC driver only returns information about the temp
>> tables, if I specify that schema directly.
>
> Have you filed a bug report to jdbc yet? :-D.
>
> merlin
>
Dear group:
I have a table structure like following:
city:
city_blockage_from age_to name
SF 10 20grade1
SF 21 30grade1
SF 35 40grade1
SF 53 19grade2
SF 100 153 grade2
NY
On Mon, Nov 1, 2010 at 4:27 PM, Thomas Kellerer wrote:
> The problem is, that the JDBC driver only returns information about the temp
> tables, if I specify that schema directly.
Have you filed a bug report to jdbc yet? :-D.
merlin
--
Sent via pgsql-general mailing list (pgsql-general@postgres
On Nov 1, 4:39 pm, t...@sss.pgh.pa.us (Tom Lane) wrote:
> Kevin Field writes:
> > Strange, no? Anybody have any ideas why this might be?
>
> Worksforme:
>
> regression=# create group "user";
> CREATE ROLE
> regression=# create group extranet_user in group "user";
> CREATE ROLE
> regression=# crea
On Mon, Nov 1, 2010 at 3:53 PM, Jonathan Tripathy wrote:
> The standby must support INSERTS and UPDATES as well (once the master has
> failed)
>
> Are there any solutions like this? Looking on the Postgresql site, all the
> standby solutions seem to be read only..
If they are RO it is only while
On Mon, Nov 01, 2010 at 11:54:25AM -0400, zhong ming wu wrote:
> I don't recall this being an issue with 8.4 I am also using
>
> Say your 8.1 server has SSL on. Even though pg_hba.conf have
>
> host or hostnossl md5
>
> either server or 8.1 psql insists that you have .postgresql/postgresq
On 11/1/2010 3:02 PM, Jonathan Tripathy wrote:
On 01/11/10 19:56, Andy Colson wrote:
On 11/1/2010 2:29 PM, Jonathan Tripathy wrote:
On 01/11/10 19:12, Andy Colson wrote:
On 11/1/2010 2:01 PM, Jonathan Tripathy wrote:
I'll give you the exact case where I'm worried:
We have a table of cust
How are adjacent word searches handled with FTS? tsquery doesn't do
this, so I assume this has to be done as a separate filter step, eg.:
# "large house" sales
SELECT * FROM data WHERE fts @@ to_tsquery('large & house & sales')
AND tsvector_contains_phrase(fts, to_tsvector('large house')));
Kevin Field writes:
> Strange, no? Anybody have any ideas why this might be?
Worksforme:
regression=# create group "user";
CREATE ROLE
regression=# create group extranet_user in group "user";
CREATE ROLE
regression=# create user x in group extranet_user;
CREATE ROLE
regression=# create view pag
Merlin Moncure wrote on 01.11.2010 21:13:
On Mon, Nov 1, 2010 at 6:46 AM, Thomas Kellerer wrote:
Hello,
I have created a temporary table using
create temporary table foo
(
id integer
);
and noticed this was created in a schema called "pg_temp_2"
My question is:
is this always "pg_temp_2"
On 01/11/10 20:26, Thomas Kellerer wrote:
Jonathan Tripathy wrote on 01.11.2010 21:12:
9.0 has streaming replication and "Hot Standby"
http://www.postgresql.org/docs/current/static/hot-standby.html
http://www.postgresql.org/docs/current/static/warm-standby.html#STREAMING-REPLICATION
But
On 01/11/10 20:21, Scott Marlowe wrote:
On Mon, Nov 1, 2010 at 2:12 PM, Jonathan Tripathy wrote:
On 01/11/10 20:01, Thomas Kellerer wrote:
Jonathan Tripathy wrote on 01.11.2010 20:53:
Hi Everyone,
I'm looking for the best solution for "Hot Standbys" where once the
primary server fails, the
Jonathan Tripathy wrote on 01.11.2010 21:12:
9.0 has streaming replication and "Hot Standby"
http://www.postgresql.org/docs/current/static/hot-standby.html
http://www.postgresql.org/docs/current/static/warm-standby.html#STREAMING-REPLICATION
But does that not only allow "read-only" things to
On Mon, Nov 1, 2010 at 1:31 PM, Andy Colson wrote:
> I dont think you can start a second query until you have called
> $dbh->pg_result. These constants just give you neat ways of waiting... its
> still just one at a time.
Correct. The C api also supports the ability to test if getting the
resul
On Mon, Nov 1, 2010 at 2:12 PM, Jonathan Tripathy wrote:
>
> On 01/11/10 20:01, Thomas Kellerer wrote:
>>
>> Jonathan Tripathy wrote on 01.11.2010 20:53:
>>>
>>> Hi Everyone,
>>>
>>> I'm looking for the best solution for "Hot Standbys" where once the
>>> primary server fails, the standby will take
Hi everyone,
I'm having a strange issue on PostgreSQL 9.0.1 on Windows Server 2003
SP2.
I connect as a superuser and then SET SESSION AUTHORIZATION to user
"X" who is a member of group role "extranet_user" which inherits
membership from group role "user". "X", "extranet_user", and even
"user" ar
On Mon, Nov 1, 2010 at 6:46 AM, Thomas Kellerer wrote:
> Hello,
>
> I have created a temporary table using
>
> create temporary table foo
> (
> id integer
> );
>
> and noticed this was created in a schema called "pg_temp_2"
>
> My question is:
>
> is this always "pg_temp_2"?
> Or will the name of
On 01/11/10 20:01, Thomas Kellerer wrote:
Jonathan Tripathy wrote on 01.11.2010 20:53:
Hi Everyone,
I'm looking for the best solution for "Hot Standbys" where once the
primary server fails, the standby will take over and act just like
the master did. The standby must support INSERTS and UPDATE
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Le 01/11/2010 20:54, hubert depesz lubaczewski a écrit :
> On Mon, Nov 01, 2010 at 08:31:10PM +0100, Cédric Villemain wrote:
>> It should stick at a maximum of 3 * checkpoint_segments + 1, if it
>> exceed it will remove the extra files after.
>
> if y
On 01/11/10 19:56, Andy Colson wrote:
On 11/1/2010 2:29 PM, Jonathan Tripathy wrote:
On 01/11/10 19:12, Andy Colson wrote:
On 11/1/2010 2:01 PM, Jonathan Tripathy wrote:
I'll give you the exact case where I'm worried:
We have a table of customers, and each customer can have multiple
membe
Jonathan Tripathy wrote on 01.11.2010 20:53:
Hi Everyone,
I'm looking for the best solution for "Hot Standbys" where once the
primary server fails, the standby will take over and act just like
the master did. The standby must support INSERTS and UPDATES as well
(once the master has failed)
Are
On Mon, Nov 01, 2010 at 08:31:10PM +0100, Cédric Villemain wrote:
> It should stick at a maximum of 3 * checkpoint_segments + 1, if it
> exceed it will remove the extra files after.
if you'd look at the graph you'd notice that it never goes down to 2n+1.
And really - so far I have not yet heard/se
Hi Everyone,
I'm looking for the best solution for "Hot Standbys" where once the
primary server fails, the standby will take over and act just like the
master did. The standby must support INSERTS and UPDATES as well (once
the master has failed)
Are there any solutions like this? Looking on
Hey Folks-
I've got 2 projects out that I'm finding useful, so I thought I'd share with
the wider postgres community.
The first is PgPartition [0]. This (python) tool eliminates the monotony of
dealing with partitions. It generates SQL to create/index/remove/alter
partitions.
The second is PgT
2010/11/1 hubert depesz lubaczewski :
> On Mon, Nov 01, 2010 at 08:13:49PM +0100, Cédric Villemain wrote:
>> 2010/11/1 hubert depesz lubaczewski :
>> > On Mon, Nov 01, 2010 at 07:22:50PM +0100, Cédric Villemain wrote:
>> >> > as I understand, max number of xlog files in pg_xlog should be ( 1 + 2 *
On 01/11/10 19:12, Andy Colson wrote:
On 11/1/2010 2:01 PM, Jonathan Tripathy wrote:
I'll give you the exact case where I'm worried:
We have a table of customers, and each customer can have multiple
memberships (which are stored in the memberships table). We want our
deleteMembership(int mem
Hi,
Installing postgis-pg90-setup-1.5.2-3 on windows after installing
postgresql-9.0.1-1-windows_x64 errors off (see below error). I believe that
postgres is a 64 bit application and postgis is a 32 bit application so I
don't know if that is the reason why it errors off.
*psql:C:/Program
Files/P
On Mon, Nov 01, 2010 at 08:18:24PM +0100, Cédric Villemain wrote:
> 2010/11/1 hubert depesz lubaczewski :
> > On Mon, Nov 01, 2010 at 07:18:22PM +0100, Filip Rembiałkowski wrote:
> >> 2010/11/1 hubert depesz lubaczewski :
> >>
> >> > as I understand, max number of xlog files in pg_xlog should be (
On Mon, Nov 01, 2010 at 08:13:49PM +0100, Cédric Villemain wrote:
> 2010/11/1 hubert depesz lubaczewski :
> > On Mon, Nov 01, 2010 at 07:22:50PM +0100, Cédric Villemain wrote:
> >> > as I understand, max number of xlog files in pg_xlog should be ( 1 + 2 *
> >> > checkpoint_segments ).
> >> (2 + che
On 11/01/2010 11:49 AM, Carlos Mennens wrote:
On Mon, Nov 1, 2010 at 2:27 PM, Steve Crawford
wrote:
I'm guessing you are missing an initdb. Move your old data directory
somewhere else for now and do a new initdb so you can start up version 9.
When you say 'old data' can you be more specific
2010/11/1 hubert depesz lubaczewski :
> On Mon, Nov 01, 2010 at 07:18:22PM +0100, Filip Rembiałkowski wrote:
>> 2010/11/1 hubert depesz lubaczewski :
>>
>> > as I understand, max number of xlog files in pg_xlog should be ( 1 + 2 *
>> > checkpoint_segments ).
>>
>> why?
>>
>> for a server overloaded
2010/11/1 hubert depesz lubaczewski :
> On Mon, Nov 01, 2010 at 07:22:50PM +0100, Cédric Villemain wrote:
>> > as I understand, max number of xlog files in pg_xlog should be ( 1 + 2 *
>> > checkpoint_segments ).
>> (2 + checkpoint_completion_target) * checkpoint_segments + 1
>> => 291
>
> this is f
On 11/1/2010 2:01 PM, Jonathan Tripathy wrote:
I'll give you the exact case where I'm worried:
We have a table of customers, and each customer can have multiple
memberships (which are stored in the memberships table). We want our
deleteMembership(int membershipID) method to remove the membersh
I'll give you the exact case where I'm worried:
We have a table of customers, and each customer can have multiple
memberships (which are stored in the memberships table). We want our
deleteMembership(int membershipID) method to remove the membership, then
check to see if there are no more membe
On 11/1/2010 1:38 PM, Jonathan Tripathy wrote:
Hi Andy,
Thanks for your reply. Would the above code be classed as a single
transaction then?
Yes, assuming there's no explicit transaction control
(COMMIT/ROLLBACK/END) in your queries.
Actually, we do have maybe one or 2 queries that use ROLLB
On Mon, Nov 1, 2010 at 2:27 PM, Steve Crawford
wrote:
> I'm guessing you are missing an initdb. Move your old data directory
> somewhere else for now and do a new initdb so you can start up version 9.
When you say 'old data' can you be more specific as to the path and
possible files I need to mo
On 01/11/10 18:38, Jonathan Tripathy wrote:
Hi Andy,
Thanks for your reply. Would the above code be classed as a single
transaction then?
Yes, assuming there's no explicit transaction control
(COMMIT/ROLLBACK/END) in your queries.
Actually, we do have maybe one or 2 queries that use ROLLBACK
Hi Andy,
Thanks for your reply. Would the above code be classed as a single
transaction then?
Yes, assuming there's no explicit transaction control
(COMMIT/ROLLBACK/END) in your queries.
Actually, we do have maybe one or 2 queries that use ROLLBACK, however
ROLLBACK happens at the end of a "c
On Mon, Nov 01, 2010 at 07:18:22PM +0100, Filip Rembiałkowski wrote:
> 2010/11/1 hubert depesz lubaczewski :
>
> > as I understand, max number of xlog files in pg_xlog should be ( 1 + 2 *
> > checkpoint_segments ).
>
> why?
>
> for a server overloaded with R/W transactions, it's possible to go b
On Mon, Nov 01, 2010 at 07:22:50PM +0100, Cédric Villemain wrote:
> > as I understand, max number of xlog files in pg_xlog should be ( 1 + 2 *
> > checkpoint_segments ).
> (2 + checkpoint_completion_target) * checkpoint_segments + 1
> => 291
this is formula gave to me by rhodiumtoad on irc, but we
2010/11/1 Jonathan Tripathy :
>
> On 01/11/10 18:08, Andy Colson wrote:
>>
>> On 11/1/2010 12:37 PM, Jonathan Tripathy wrote:
>>>
>>> Hi Everyone,
>>>
>>> I'm trying to create a server for a database system which will be used
>>> by multiple clients. Of course, table locking is very important. Read
On Sun, Oct 31, 2010 at 6:35 PM, Peter Neal wrote:
> Is there any way I can explain this to postgres? When I query the parent
> table of the partitions, "SELECT * from A, B where a.id=b.id;", the planner
> does a sequential scan on A, A1, A2, ... an index scan on B, B1, B2, ...
> then a nested lo
2010/11/1 hubert depesz lubaczewski :
> Hi
> have strange situation - too many xlog files.
>
> PostgreSQL 8.3.11 on i386-pc-solaris2.10, compiled by cc -Xa
>
> config:
> # select name, setting from pg_settings where name ~ 'checkpoint|wal' order
> by 1;
> name | settin
On Mon, Nov 1, 2010 at 2:00 PM, Bill Moran wrote:
> To clarify my earlier comments, if you're going to use pg_upgrade, you
> probably won't need to downgrade to 8.4. My comments about putting
> 8.4 back on would have be necessary if you were going to go the old
> dump/restore route.
I've already
2010/11/1 hubert depesz lubaczewski :
> as I understand, max number of xlog files in pg_xlog should be ( 1 + 2 *
> checkpoint_segments ).
why?
for a server overloaded with R/W transactions, it's possible to go beyond this.
checkpoints just do not keep up.
right now I have an 8.3 with checkpoint_
On Sun, Oct 31, 2010 at 4:43 AM, AI Rumman wrote:
> I using Postgresql 8.1 and during vacuum at night time, I am getting the
> following log:
> number of page slots needed (2520048) exceeds max_fsm_pages (356656)
> Do I need to increase max_fsm_pages to 2520048? Does it have any bad affect?
You d
On 11/1/2010 12:37 PM, Jonathan Tripathy wrote:
Hi Everyone,
I'm trying to create a server for a database system which will be used
by multiple clients. Of course, table locking is very important. Reading
the Postgresql docs, locking occurs on a transaction-by-transaction basis.
In our java cod
On 01/11/10 18:08, Andy Colson wrote:
On 11/1/2010 12:37 PM, Jonathan Tripathy wrote:
Hi Everyone,
I'm trying to create a server for a database system which will be used
by multiple clients. Of course, table locking is very important. Reading
the Postgresql docs, locking occurs on a transactio
Bill Moran writes:
> To clarify my earlier comments, if you're going to use pg_upgrade, you
> probably won't need to downgrade to 8.4. My comments about putting
> 8.4 back on would have be necessary if you were going to go the old
> dump/restore route.
Note that pg_upgrade depends on having a co
In response to Carlos Mennens :
> On Mon, Nov 1, 2010 at 1:32 PM, Scott Marlowe wrote:
> > you would do it with 9.0.x installed, and there should be a program in
> > one of the 9.0 packages that has pg_upgrade in it.
>
> So I have my 8.4.4-6 databases backed up. I don't know if I needed the
> de
2010/11/1 Carlos Henrique Reimer
>
> Hi,
>
> I currently have my PostgreSQL server running in a windows box and now we're
> migrating it to a Linux operational system.
>
> Current windows configuration:
> pg_controldata shows the LC_COLLATE and LC_CTYPE are Portuguese_Brasil.1252
> psql \l comman
Hi
have strange situation - too many xlog files.
PostgreSQL 8.3.11 on i386-pc-solaris2.10, compiled by cc -Xa
config:
# select name, setting from pg_settings where name ~ 'checkpoint|wal' order
by 1;
name |setting
--+---
Hi Everyone,
I'm trying to create a server for a database system which will be used
by multiple clients. Of course, table locking is very important. Reading
the Postgresql docs, locking occurs on a transaction-by-transaction basis.
In our java code, we are doing this:
//Start Code Block
Con
Hi Everyone,
I'm trying to work with connection pools. The example I'm looking at is
lockated here:
http://www.developer.com/img/2009/11/Listing1_ConnectionPoolClass.html
You will notice that the getConnectionFromPool method does not implement
any blocking, and only returns null.
I would l
On Mon, Nov 1, 2010 at 1:32 PM, Scott Marlowe wrote:
> you would do it with 9.0.x installed, and there should be a program in
> one of the 9.0 packages that has pg_upgrade in it.
So I have my 8.4.4-6 databases backed up. I don't know if I needed the
default 'postgres' database dumped but I did th
On Mon, Nov 1, 2010 at 11:06 AM, Carlos Mennens
wrote:
> On Mon, Nov 1, 2010 at 12:52 PM, Richard Broersma
> wrote:
>
>> oops: http://www.postgresql.org/docs/9.0/interactive/pgupgrade.html
>
> Thanks for the URL. I will try this but I am confused how to proceed?
> Can I attempt this with PostgreS
On 11/1/2010 11:58 AM, Alexander Farber wrote:
Hello Andy and others,
On Mon, Nov 1, 2010 at 3:33 PM, Andy Colson wrote:
On 11/1/2010 4:29 AM, Alexander Farber wrote:
I have a small multiplayer game, a non-forking daemon
reading/writing to sockets and running in a IO::Poll loop.
I.e. I would
I am trying to screw up the courage to update my systems ( 2 macs, 2 fedora )
from
the last 8.4 postgresql updates to the latest 9.0.1 versions.
I have a couple of concerns...
1) I have developed my own gui apps using tcl/tk and wxpython for accessing and
maintaining my db's.
I use psyco
On Mon, Nov 1, 2010 at 12:52 PM, Richard Broersma
wrote:
> oops: http://www.postgresql.org/docs/9.0/interactive/pgupgrade.html
Thanks for the URL. I will try this but I am confused how to proceed?
Can I attempt this with PostgreSQL 9.0.1-2 server installed and the
data is still 8.4 or do I need
Hello Andy and others,
On Mon, Nov 1, 2010 at 3:33 PM, Andy Colson wrote:
> On 11/1/2010 4:29 AM, Alexander Farber wrote:
>> I have a small multiplayer game, a non-forking daemon
>> reading/writing to sockets and running in a IO::Poll loop.
>>
>> I.e. I would like to "fire and forget" queries.
>>
On Mon, Nov 1, 2010 at 9:52 AM, Richard Broersma
wrote:
> On Mon, Nov 1, 2010 at 9:47 AM, Carlos Mennens
> wrote:
>
>> Sadly I blindly upgraded my database w/o doing a dump / restore so can
>> anyone tell me if I am dead in the water or is there a way I can
>> recover from this error on my part?
On Mon, Nov 1, 2010 at 9:47 AM, Carlos Mennens wrote:
> Sadly I blindly upgraded my database w/o doing a dump / restore so can
> anyone tell me if I am dead in the water or is there a way I can
> recover from this error on my part?
No, but you'll want to read this document to proceed.
--
Rega
In response to Carlos Mennens :
> On Mon, Nov 1, 2010 at 12:45 PM, Bill Moran wrote:
> > I can't speak for Arch Linux' upgrade setup, but going from 8.4 -> 9.0
> > requires that the data directory either be dumped/recreated, or ran
> > through the new upgrade process (which (as yet) I have no exp
On Mon, Nov 1, 2010 at 12:45 PM, Bill Moran wrote:
> I can't speak for Arch Linux' upgrade setup, but going from 8.4 -> 9.0
> requires that the data directory either be dumped/recreated, or ran
> through the new upgrade process (which (as yet) I have no experience
> with).
>
> If the Arch Linux st
On Mon, Nov 1, 2010 at 10:36 AM, Carlos Mennens
wrote:
> I did an upgrade on my database server this past weekend and the
> database fails to start. I checked /var/log/postgresql and found the
> reason:
>
> [r...@slave ~]# ps aux | grep postgres
> root 5189 0.0 0.0 8128 956 pts/0 S+
In response to Carlos Mennens :
> I did an upgrade on my database server this past weekend and the
> database fails to start. I checked /var/log/postgresql and found the
> reason:
>
> [r...@slave ~]# ps aux | grep postgres
> root 5189 0.0 0.0 8128 956 pts/0S+ 12:28 0:00 grep po
I did an upgrade on my database server this past weekend and the
database fails to start. I checked /var/log/postgresql and found the
reason:
[r...@slave ~]# ps aux | grep postgres
root 5189 0.0 0.0 8128 956 pts/0S+ 12:28 0:00 grep postgres
[r...@slave ~]# /etc/rc.d/postgresql
I don't recall this being an issue with 8.4 I am also using
Say your 8.1 server has SSL on. Even though pg_hba.conf have
host or hostnossl md5
either server or 8.1 psql insists that you have .postgresql/postgresql.*
Does that make sense to you?
Note: no "cert" in pg_hba.conf
On 11/01/2010 06:24 AM, Stefan Schwarzer wrote:
> I need to convert the integer values for the years into column names, i.e.
> "1965" into "y_1965". How do I achieve this then?
Try something like:
create table foo (
name text,
year_start int,
value float8);
insert into foo values('a',2010,1.23)
On 11/1/2010 4:29 AM, Alexander Farber wrote:
Hello,
I'm using CentOS 5.5 Linux with stock perl v5.8.8
and have installed DBD-Pg-2.17.1 via CPAN shell
and I'm using postgresql-server-8.4.5-1PGDG.rhel5.
I've prepared a simple test case demonstrating
my problem - it is listed at the bottom. It wo
2010/11/1 Georgi Ivanov :
> Hi,
> I have following situation:
> $q = 'select * from tbl1 where id = :id';
> $stmt = $dbh->prepare($q);
> $stmt->bindValue(':id', $id , PDO::PARAM_INT);
> $stmt->execute();
> //1000 ms
> and
>
> $q1 = ' select * from tbl1 where id = 100 ';
> $stmt = $dbh->prepare($q);
Hello I'm getting into strange problem with pgAdmin 3.
As we all know, PostgreSQL enforces index creation on primary key's.
The problem with this is the fact, that when i create a table in pgAdmin's
sql editor, in result window i'm getting success and a note that an index
will be created on tables
>> For one of the countries, I have a value for 2007, but not for 1960.
>> When using only the inner query, than I see one line: Andorra - 2007
>> - 539 But when running the whole SQL, the value for year 2007 get's
>> allocated to the year 1960. The table looks as follows:
>>
>> name |y_1
Hi,
I have following situation:
$q = 'select * from tbl1 where id = :id';
$stmt = $dbh->prepare($q);
$stmt->bindValue(':id', $id , PDO::PARAM_INT);
$stmt->execute();
//1000 ms
and
$q1 = ' select * from tbl1 where id = 100 ';
$stmt = $dbh->prepare($q);
//NO binding here !
$stmt->execute();
//2 ms
Le 01/11/2010 06:41, Eduardas Tcpa a écrit :
>>
>> Hello I'm getting into strange problem with pgAdmin 3.
>> As we all know, PostgreSQL enforces index creation on primary key's.
>> The problem with this is the fact, that when i create a table in pgAdmin's
>> sql editor, in result window i'm getting
On 1 November 2010 13:41, Eduardas Tcpa wrote:
> Hello I'm getting into strange problem with pgAdmin 3.
>> As we all know, PostgreSQL enforces index creation on primary key's.
>> The problem with this is the fact, that when i create a table in pgAdmin's
>> sql editor, in result window i'm getting
Hello I'm getting into strange problem with pgAdmin 3.
As we all know, PostgreSQL enforces index creation on primary key's.
The problem with this is the fact, that when i create a table in pgAdmin's
sql editor, in result window i'm getting success and a note that an index
will be created on tables
>
> Hello I'm getting into strange problem with pgAdmin 3.
> As we all know, PostgreSQL enforces index creation on primary key's.
> The problem with this is the fact, that when i create a table in pgAdmin's
> sql editor, in result window i'm getting success and a note that an index
> will be create
>> For one of the countries, I have a value for 2007, but not for 1960.
>> When using only the inner query, than I see one line: Andorra - 2007
>> - 539 But when running the whole SQL, the value for year 2007 get's
>> allocated to the year 1960. The table looks as follows:
>>
>> name |y_1
Em 1/11/2010 09:00, Fujii Masao escreveu:
On Fri, Oct 29, 2010 at 9:58 PM, Norberto Delle wrote:
I'm testing a warm standby setup using PostgreSQL 9 x64 on Windows 2008 R2.
What command (pg_standby? cp?) is supplied in restore_command for warm-standby?
Or you are testing streaming replication
Thom Brown wrote on 01.11.2010 12:33:
You can use:
SELECT nspname
FROM pg_namespace
WHERE oid = pg_my_temp_schema();
to get the name of the current temporary schema for your session.
Thanks that's what I was looking for.
Regards
Thomas
--
Sent via pgsql-general mailing list (pgsql-gene
On 1 November 2010 10:46, Thomas Kellerer wrote:
> Hello,
>
> I have created a temporary table using
>
> create temporary table foo
> (
> id integer
> );
>
> and noticed this was created in a schema called "pg_temp_2"
>
> My question is:
>
> is this always "pg_temp_2"?
> Or will the name of the
On Fri, Oct 29, 2010 at 9:58 PM, Norberto Delle wrote:
> I'm testing a warm standby setup using PostgreSQL 9 x64 on Windows 2008 R2.
What command (pg_standby? cp?) is supplied in restore_command for warm-standby?
Or you are testing streaming replication + hot standby?
> The problem is that when
Hello,
I have created a temporary table using
create temporary table foo
(
id integer
);
and noticed this was created in a schema called "pg_temp_2"
My question is:
is this always "pg_temp_2"?
Or will the name of the "temp schema" change?
If it isn't always the same, is there a way I can r
Hello,
I'm using CentOS 5.5 Linux with stock perl v5.8.8
and have installed DBD-Pg-2.17.1 via CPAN shell
and I'm using postgresql-server-8.4.5-1PGDG.rhel5.
I've prepared a simple test case demonstrating
my problem - it is listed at the bottom. It works ok,
when I remove {pg_async => PG_ASYNC}.
I
Hi,
I currently have my PostgreSQL server running in a windows box and now we're
migrating it to a Linux operational system.
Current windows configuration:
pg_controldata shows the LC_COLLATE and LC_CTYPE are Portuguese_Brasil.1252
psql \l command shows we have databases with encoding WIN1252 and
93 matches
Mail list logo
