> HI to all of you. I am a new member of this group and this is my
> first mail in this group.I am working in MS Reporting services.And
> i am new in this job.
>
> I have a problem.
> There is a table which has many columns.
> and i have to give selection to client that he can select any top
> 10,
> > > I try to find in the documentation whether PostgreSQL
> supports job,
> > > but I miserably failed. Does PostgreSQL support job? If
> not, what
> > > is the mechanism mostly adopted by PostgreSQL administrators for
> > > running jobs against PostgreSQL? I was thinking about using
> >
> > Imagine a table called 'message_table':
> >
> > mid | message | status
> > +-+---
> > 1 | Text1 | H
> > 2 | Text2 | H
> > 3 | Text3 | H
> > 4 | Text4 | H
> >
> > A web page presents the user with all messages flagged with
> 'H'. User
> > checks m
> We are putting a new application on PostgreSQL 8.0.1 (Windows
> 2003); we are coming off of MySQL, and are having a hard time
> finding all of the offending SQL calls.
>
> It would help a great deal if I could log the content of any
> SQL calls that fail. Am only interested in SELECT statemen
> [Win XP Professional 2002, SP 1, Pentium 4, 1.4 GHz, 512MB
> RAM] I'm trying to install postgres 8.0.4 on my windows machine.
> I downloaded
> ftp.us.postgresql.org/pub/mirrors/postgresql/binary/v8.0.4/win
> 32/postgresql-8.0.4.zip.
> I then double-clicked the file "postgresql-8.0".
> It says "
> I know that the server knows that ADT == -0400, and AST ==
> -0300 ... is there any way of reversing that? Basically, I
> want to say:
>
> SELECT timezone_str(-0400, 'not dst');
>
> and have it return ADT ... I've got a method of doing it
> right now, using a function, but just find it look
> Hi,
>
> I downloaded postgresql 8.0 MSI. How can I tell postgresql
> to install on a different drive letter?
Please see the FAQ at
http://www.postgresql.org/docs/faqs.FAQ_windows.html#3.6.
//Magnus
---(end of broadcast)---
TIP 2: Don't 'kill
>I am trying to find the best way for a database trigger to signal a
>client process to take an action.
>
>Specifically, I am working on the classic problem of creating and
>modifying system accounts based on the updates to a "person registry"
>database.
>
>The basic model I'm working with has t
> I don't work with M$ DBs, but saw that "autonumber" is an M$ concept.
> Purely for my own edification, how do you get the most resent
> value of an autonumber in M$? I was helping someone out who
> was using M$ stuff and was amazed that there was no currval function.
I beleive they call it ID
a1: Not 100% sure waht you are looing for. Try adding "/qb" and see if
that is what you meant :-)
a2: That exact commandline may not be supported. But we intend to
support commandline-driven silent installs, yes.
a3: See the installer FAQ on http://pginstaller.projects.postgresql.org.
a4: Yes
> Yes, I have several clients connecting to the db, using
> the same username, doing the same things, pretty much.
>
> Please educate me:
> When a table is accessed, is there an entry that is updated
> in pg_catalog.pg_tables (or somewhere else) in such a fashion
> that the MVCC ca
> On Wed, Jun 20, 2001 at 07:37:39PM +, sbelow wrote:
> > getting this error "Transaction cannot start while in
> firehouse mode." I
> > can't find in the books what this is trying to tell me.
> > new at dbs.
>
> That message is not coming from PostgreSQL, I've grepped the
> source tree:
>
12 matches
Mail list logo
