The following sql statement fails because the column "user_id" does
not exist in the users table.
=# select user_id from users WHERE username = 'blah';
ERROR: column "user_id" does not exist
LINE 1: select user_id from users WHERE username = 'blah..
^
The following shows a v
On 1/31/06, Rich Doughty <[EMAIL PROTECTED]> wrote:
> We are currently migrating a cluster between hosts. I'd like to
> verify that the new database has been transferred reliably and
> that the datafiles are in tact.
>
> What's the recommended way to do this? We're using
> pg_start/stop_backup so a
On 17 Jan 2006 01:22:20 -0800, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> Hi All,
>
> I am using PostgreSQL 7.3.2 on a server running Red Hat Linux 9.0.
>
> I have two databases ( identical schema and similar data ).
>
> One database, D1 contains the actual data of a Production Application.
> T
On 1/12/06, Jeff Trout <[EMAIL PROTECTED]> wrote:
>
> On Jan 12, 2006, at 1:36 PM, Joshua D. Drake wrote:
>
> >>> "Built In" Failover/Clustering
> >>> This won't happen. The community stance, which is a good one is
> >>> that no single replication solutions fits everyone's needs and
> >>> therefore
On 1/10/06, John McCawley <[EMAIL PROTECTED]> wrote:
> Regarding the usefulness of triggers...I tend to stay away from them. I
> like to keep my data in my database and my logic in my application. I
> try to relegate triggers to very simple things like timestamping
> records. i.e. things that I
On 12/30/05, Scott Marlowe <[EMAIL PROTECTED]> wrote:
>
>
> On 12/30/05, Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
>
> QUOTE:
> I used it once (2004) because it supported Postgres. It got hacked in
> under a month. I admit that this was a one off but having searched
> around the Internet for
On 12/30/05, Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
> On 30 Dec 2005 at 9:36, Harry Jackson wrote:
>
> > PHPBB. I don't want to use PHPBB due to its complete lack of anything
> > resembling security.
>
> Just curious - where do you get your inf
What would people recommendation be for Bulleting Board software. I am
after something that uses PostgreSQL and has similar features of
PHPBB. I don't want to use PHPBB due to its complete lack of anything
resembling security.
--
Harry
http://www.hjackson.org
http://www.uklug.co.uk
--
On 12/17/05, hubert depesz lubaczewski <[EMAIL PROTECTED]> wrote:
> must have missed that one. thanks - we are moving to 8.1 anyway (50-150%
> increase in performance for some specific tasks!).
For which tasks in particular are you seeing this king of gain?
Harry
--
http://www.hjackson.org
http
I have been trying to use PQexecPrepared but so far have been having
little success. I have looked at the docs and there is very little in
there by way of examples. I am not really a native C programmer hence
my reason for assuming its my own fault and not a bug in PG but I have
noticed some things
David Teran wrote:
The real question was: are there open known bugs where a select
statement does not return a correct result, meaning a wrong number of
rows? Were there a lot of errors like this?
We are asking this because this makes trouble with the database we are
currently using. Of course w
11 matches
Mail list logo
