Travis Bauer <[EMAIL PROTECTED]> writes:
> That part works okay, but here is a more complicated situation that
> doesn't:
> create user user1;
> create table t1 (x int, y int);
> create table t2 (a int, y int);
> create view v1 as select * from t1 where x in (select a from t2);
>
That part works okay, but here is a more complicated situation that
doesn't:
create user user1;
create table t1 (x int, y int);
create table t2 (a int, y int);
create view v1 as select * from t1 where x in (select a from t2);
--
create
Someone mentioned that you had to include libpq, but you are also using the
wrong GCC command line. the -c switch tells gcc to just build an object
file, ignoring the main routine and not creating an actual executable
program. You want something like this:
$ gcc conn2.c -o conn2 -lpq
At 01
Jesse Scott <[EMAIL PROTECTED]> writes:
> Hello everyone,
>
> I'm just beginning a PHP / PostgreSQL project for someone and there are a
> couple of things where I am not sure the best design for the database.
>
> The first is that we want to store kind of a history of values for the past
> 3
Travis Bauer wrote:
>
> I have a set of tables and some views which perform calculations on
> those table to which no one except the group officestaff has
> any permissions. No problem.
>
> I tried to create views to which some particular client would have
> permissions. These views would be f
> Hello,
>
> We are using a postgresql-7.0.2. Consider the following scenario
>
> we have created a table t1 with columns
>
> c1 : having referential integrity with t2.c1
> c2 : having referential integrity with t3.c2
>
> where t2 and t3 are different tables
>
> Assume that t2 has also got
> hello ,
> i have a procedure as below.
>
> --
---
>
> create function retrec(integer) returns integer
> as
> 'declare
> uid alias for $1;
> begin
> declare retrec_cur cursor
Hi,
For the first question , having about 20,000 rows seems it will work fine.
(I do have about 100,000 rows table working fine.)
For the second, sure PG has enough locking some look for MVCC feature at the
PG docs(chapter 10).
>Will SELECT ... FOR UPDATE help me out here?
"However, take into a
Hello,
I would like to make a backup of a postgresql database
(version 6.5) with large objects. I tried pg_dump, but It
didn't saved the content of large object even with the -o
option. Is there an easy solution ?
__
Boîte aux lettres - Caramai
