On Fri, 2 Jul 2004, Jon Valvatne wrote:
> Pasted below, I demonstrate two queries which both produce the same two
> records in their result set (the two objects which have my full name in
> their name field). Based on my experiences with other DBMS, I would have
> thought Postgres could do a simpl
[EMAIL PROTECTED] (Vinay Jain) wrote in
news:[EMAIL PROTECTED]:
> Hi..
> I am newbe in postgresql so please help me though the question may be
> very easy to answer..
> Is there any formatting function to get output with fix lengths..for
> example my query is..
> schema is:
>
> Student
> (name V
Your message from 7/2 just showed up today.
> db=# explain analyze SELECT id FROM object WHERE name ~ '^Jon V';
I use leading substring indexing all the time. Try:
SELECT id FROM object WHERE name like 'Jon V%';
Wes
---(end of broadcast)---
T
Michal Taborsky wrote:
> Doug McNaught wrote:
>> But why not create a "products_restricted" view that uses the
>> CURRENT_USER function to see who's running it?
>>
>> CREATE VIEW products_restricted AS
>> SELECT * FROM products WHERE Producer_ID = get_producer_id(CURRENT_USER);
>>
>> [CURRENT_
At Sat, 03 Jul 04, Unidentified Flying Banana Greg Stark, said:
> Is there an NFS server involved? If an NFS server disappears any process
> waiting on I/O for it enters disk-wait indefinitely until it reappears.
Nope. Everything was local on this machine.
> --
> greg
--
| Christopher
+--
Gentle people, I don't get it.
I have a table where one of the columns is of type 'TIMESTAMP'
How can I do a query to filter on the TIMESTAMP value, e.g. to obtain
all rows earlier than a certain time stamp?
Regards,
---(end of broadcast)---
TIP 8:
The Slony-I team proudly presents the 1.0 Release of its new
enterprise-level replication solution for PostgreSQL.
After more than 9 months of design, planning, development and testing,
sponsored by the global domain registry company Afilias, we believe that
this software has reached production
On 7/8/04 11:28 AM, "Bruce Momjian" <[EMAIL PROTECTED]> wrote:
> OK, I have removed the changes I just added to allow threads for 7.4.X
> on OSX. This stuff had to be dealt with before 7.4 final, and I don't
> want to play with it at this point. 7.5 thread testing is automatic so
> people will h
[EMAIL PROTECTED] wrote:
> On 7/8/04 11:28 AM, "Bruce Momjian" <[EMAIL PROTECTED]> wrote:
>
> > OK, I have removed the changes I just added to allow threads for 7.4.X
> > on OSX. This stuff had to be dealt with before 7.4 final, and I don't
> > want to play with it at this point. 7.5 thread test
Greetings!
On Fri, 2 Jul 2004, Mike Rylander wrote:
> I find that experience does not bear this out. There is a saying a coworker
> of mine has about apps that try to solve problems, in this case caching,
> that are well understood and generally handled well at other levels of the
> "software st
On Thu, 8 Jul 2004 14:25:48 -0400 (EDT), Bruce Momjian
<[EMAIL PROTECTED]> wrote:
> > works on both OS X 10.2 and 10.3
>
> OK, I put this back in for 7.4.X since you tested to OSX versions, which
> helps me think it is reliable. Thanks.
I can confirm this as well, and I'll be including these ch
I'm thrilled by the news that nested transactions will make it into 7.5
after all, and trying to learn how this will work. The question is
what will be the syntax to start / commit / rollback a subtransaction.
Leaking a bit from pgsql-hackers [hope it's not bad etiquette to do this]
I see this ver
On Tue, Jul 06, 2004 at 01:27:29AM +0200, B.W.H. van Beest wrote:
> I have a table where one of the columns is of type 'TIMESTAMP'
>
> How can I do a query to filter on the TIMESTAMP value, e.g. to obtain
> all rows earlier than a certain time stamp?
SELECT ... WHERE timestamp_field < 'certain
Jim Rosenberg wrote:
> I'm thrilled by the news that nested transactions will make it into 7.5
> after all, and trying to learn how this will work. The question is
> what will be the syntax to start / commit / rollback a subtransaction.
>
> Leaking a bit from pgsql-hackers [hope it's not bad etiqu
On Mon, Jul 05, 2004 at 05:40:34PM +0800, Ramesh Yeligar wrote:
> We have been using pgsql for our retail business, now, due hard drive
> crash, the databse corrupted and we are unable to start pgsql
> database. Pl help me if you know any commands or tools to recover this
> database.
You'd need t
On 02/07/2004 16:02 Maus wrote:
[snip]
I'd like to know the equivalent instructions in C language using ODBC
for connecting a Postgres DB (with also includes library)
Please, is there anyone can tell me which these C language
instructions are?
ODBC involves a fair bit more programming than JDBC. I
On Thu, Jul 08, 2004 at 09:28:16AM -0500, Timothy Perrigo wrote:
> Thanks for the reply, Stephan. I guess I can see the rationale for
> this, though it is quite easy to cause yourself quite a bit of grief.
> It would certainly make things safer if columns in the subselect which
> refer to colu
On Fri, 2004-07-02 at 04:35, Rune Froysa wrote:
> I have one table with columns that are used as foreign-keys from
> several other tables. Sometimes deletion from this table takes +5
> seconds for a single row.
Do you have indexes on the foreign key columns in the child tables?
For example, sa
The Bricolage development team is pleased to announce the release of
Bricolage 1.8.1. This maintenance release address a number of
issues in
Bricolage 1.8.0. Here are the highlights:
Improvements
* More complete Traditional Chinese and Simplified Chinese
localizations. Al
I accidentaly deleted over 1.000.000 records from one table in my
database. Is there any way to recover them? Please help me as soon
as possible...
After the records were deleted, no other operation was made on the
database. In fact, all the postgres services were shut down.
I found a xlog file c
I realise that these have been discuuseed before, but a couple of things
have happened that caused me to bring this up again, and to raise some
questions.
A couple of nights ago, a seminar was presented in Perth, Western
Australia, by an institution offering IT masters degrees. One of the
mas
21 matches
Mail list logo
