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 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 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 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 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 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
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 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('
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
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 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
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 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 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 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]>
>
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 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
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 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.
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 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
> >
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: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
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 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
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
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 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
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
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
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
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)-
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
33 matches
Mail list logo
