On Monday 29 June 2009 09:26:24 am Craig Ringer wrote:
> Try connecting to the database with psql and running
> "select * from pg_stat_activity"
> while the web app is running. You should see only "IDLE" or working
> connections, never idle in transaction. If you have anything idle in a
> transac
On Tuesday 30 June 2009 10:48:50 am Scott Marlowe wrote:
> Oh I so do hope that we won't have to bother with currencies anymore THAT
>
> > far into the future!
>
> You laugh, but who will be fixing the Y20M problem, huh?
Not you or I that's for sure.
--
John Fabiani
--
Sent via pgsql-general
I added "datestyle = 'SQL,MDY' to the postgres.conf (restarted the server).
But it does not appear to work with any setting. Is this a bug? Did I do
it wrong?
openSUSE 11.0 postgres 8.3.7
--
John Fabiani
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
On Thursday 28 May 2009 07:28:04 am Scott Marlowe wrote:
> update-rc.d
>
> On Thu, May 28, 2009 at 7:25 AM, johnf wrote:
> > Hi,
> > I have installed postgres 8.3 and it runs if I manually start postgres.
> > That is to say I '/etc/init.d/postgresql start' as
Hi,
I have installed postgres 8.3 and it runs if I manually start postgres. That
is to say I '/etc/init.d/postgresql start' as root. Runs perfectly.
But if I restart the computer postgres does not auto-start. I've done a
little research but did not see anything that jumped off the page to tell
On Friday 08 May 2009 12:08:44 am Eugene . wrote:
> Hi all,
>
> I've been tasked with evaluating the feasibility of migrating our in-house
> application from MSSQL to PostgreSQL. It is fairly old and has lots of
> stored procedures, which is why we need to think carefully before making
> the switch
On Tuesday 10 February 2009 07:22:45 pm Tom Lane wrote:
> I don't think I believe the OP's premise anyway. The concept that every
> string column has to have a specific hard-coded maximum length is an
> evil hangover from the days of punched cards. It seems very unlikely
> that M$, who are not ex
Looks like microsoft is going to drop the data type "text" in the near future.
VarChar(max) will be taking it's place. Does Postgres have some like
varChar(max)?
--
John Fabiani
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
htt
On Thursday 29 January 2009 05:16:17 am Gregory Stark wrote:
> I'm putting together a talk on "PostgreSQL Pet Peeves" for discussion at
> FOSDEM 2009 this year. I have a pretty good idea what some them are of
> course, but I would be interested to hear if people have any complaints
> from personal
On Saturday 17 January 2009 07:14:06 am Adrian Klaver wrote:
> On Friday 16 January 2009 10:09:06 pm johnf wrote:
> > I'm using python and can execute standard
> > "select,update,delete,functions". What I'd like to do is execute a sql
> > script (a text fil
I'm using python and can execute standard "select,update,delete,functions".
What I'd like to do is execute a sql script (a text file). But I don't know
how?
Some thing like:
import psycopg2
import psycopg2.extensions
conn = psycopg2.connect("host=%s dbname=%s user =%s password
=%s "
On Tuesday 07 October 2008 08:11:05 am johnf wrote:
> I have a friend I asked to load postgres 8.3 on his XP machine. He then
> tested a python script which accesses several tables and discovered that it
> retrieves data very slowly. It takes about 20 seconds to retrieve the da
On Tuesday 07 October 2008 08:54:31 am justin wrote:
> johnf wrote:
> > I have a friend I asked to load postgres 8.3 on his XP machine. He then
> > tested a python script which accesses several tables and discovered that
> > it retrieves data very slowly. It takes about 2
On Tuesday 07 October 2008 08:20:16 am you wrote:
> On Tue, Oct 7, 2008 at 11:11 AM, johnf <[EMAIL PROTECTED]> wrote:
> > I then thought it had something to do with the data -although the data
> > set is small. I did a complete dump and restored on his machine and
> >
I have a friend I asked to load postgres 8.3 on his XP machine. He then
tested a python script which accesses several tables and discovered that it
retrieves data very slowly. It takes about 20 seconds to retrieve the data -
on localhost. However, using a remote connection to a postgres datab
On Monday 06 October 2008 10:34:12 am Scott Marlowe wrote:
> On Mon, Oct 6, 2008 at 11:30 AM, johnf <[EMAIL PROTECTED]> wrote:
> > When I open task manager there appears 10 'postgres.exe' in the list. I
> > this normal. Windows XP, postgres 8.3
>
> Yep.
When I open task manager there appears 10 'postgres.exe' in the list. I this
normal. Windows XP, postgres 8.3
--
John Fabiani
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thursday 11 September 2008 09:13:14 am Scott Marlowe wrote:
> On Thu, Sep 11, 2008 at 10:07 AM, johnf <[EMAIL PROTECTED]> wrote:
> > Hi,
> > I have read several of the posting on the list and I'm guessing I have a
> > router issue because I get disconnected f
Hi,
I have read several of the posting on the list and I'm guessing I have a
router issue because I get disconnected from the database after some idle
time. I'm connecting remotely to a postgres 8.3.1 on openSUSE 11. My
question is how can I determine what the real cause of dropping the
conne
On Tuesday 19 August 2008 10:06:55 pm Scott Marlowe wrote:
> On Tue, Aug 19, 2008 at 10:53 PM, johnf <[EMAIL PROTECTED]> wrote:
> > On Tuesday 19 August 2008 04:01:55 pm Adrian Klaver wrote:
> >> From: "Masis, Alexander (US SSA)" <[EMAIL PROTECTED]>
>
On Tuesday 19 August 2008 04:01:55 pm Adrian Klaver wrote:
> -- Original message --
> From: "Masis, Alexander (US SSA)" <[EMAIL PROTECTED]>
>
> > I have to explicitly specify the schema name to make SQL statement to
> > work.
> > Can I set the schema before the quer
On Saturday 02 August 2008 01:12:35 am Craig Ringer wrote:
> John Meyer wrote:
> > Especially when I haven't edited anything yet?
>
> You might want to tell the readers here just a *little* bit more about
> your problem.
>
> Start with "what menu?!?".
>
> More seriously:
>
> - What is your operatin
On Tuesday 05 February 2008 04:40:18 pm brian wrote:
> Jeff Davis wrote:
> > On Tue, 2008-02-05 at 16:10 -0800, johnf wrote:
> >> I create a table named "Account_Text_Table" the owner is 'johnf'.
> >>
> >> select has_table_privilege('
I create a table named "Account_Text_Table" the owner is 'johnf'.
select has_table_privilege('johnf', 'public.Account_Text_Table', 'SELECT')
I get the following error:
ERROR: relation "public.account_text_table&quo
On Sunday 27 January 2008 10:56:18 am Mike Ginsburg wrote:
> Hi Phil,
> Each of columns that you specify in your SELECT clause, must also
> appear in the GROPU BY clause.
>
> SELECT COUNT(*) AS cnt, name, comment, ...
> FROM tst
> GROUP BY name, comment, ...
> HAVING COUNT(*) = 1;
>
Is the requir
On Friday 25 January 2008 07:21:34 am Harald Armin Massa wrote:
> Bill,
>
> pgadmin3 provides the same: just dig down to the table, use the backup
> link and give the options. It also calls pg_dump just with the right
> parameters, you can copy that command for a .cmd for professional
> automatic b
On Friday 25 January 2008 02:56:12 am Gevik Babakhani wrote:
> Check out the docs for pg_dump utility.
> http://www.postgresql.org/docs/8.3/static/app-pgdump.html
>
>
> _
>
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of User Map
> Sent: Friday, January 25, 2008 10:18 AM
>
On Monday 21 January 2008 04:47:40 pm Tom Lane wrote:
> Guy Rouillier <[EMAIL PROTECTED]> writes:
> > Unfortunately, I think the stored procedure implementation in PG itself
> > introduces significant overhead. See thread "Writing most code in
> > Stored Procedures" from August 2007. I converted
On Wednesday 19 September 2007 10:19, Scott Ribe wrote:
> I'm asking this group because we tend to think alike wrt to data modeling
> and separation of concerns ;-)
>
> Any recommendations on ORM libraries for new Windows development? The last
> time I started anything from scratch was over 10 year
On Sunday 05 August 2007 21:43, snacktime wrote:
> I've been going back and forth on the best way to model this.
>
> A user can have one to many bill and ship addresses.
> An order can have one bill address and one to many ship addresses
>
> Let's assume I have a single address table, with an addre
On Friday 09 February 2007 04:43, A. Kretschmer wrote:
> am Thu, dem 08.02.2007, um 21:28:08 -0800 mailte johnf folgendes:
> > Hi,
> > I'm hoping someone has already taken the time to write a routine (in some
> > language - python,perl, etc..) to convert MS SQL T-SQL
Hi,
I'm hoping someone has already taken the time to write a routine (in some
language - python,perl, etc..) to convert MS SQL T-SQL stored procedures into
Postgres PL/pgSQL. And of course they are willing to share.
Thanks
--
John Fabiani
---(end of broadcast)-
Hi,
I would like to copy a schema X to a new schema Y within the same database.
Is this possible?
--
John Fabiani
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
33 matches
Mail list logo