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 simple
[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 Varchar,
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)---
posted mailed
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);
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
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 have to
[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 testing is
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
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 changes
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
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 etiquette
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 to
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 columns
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, say
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.
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
20 matches
Mail list logo