I've just upgraded a server from 9.0 to 9.3 using the pgupgrade.sh
script and setup the same config but now, when I connect with the
latest pgAdmin III I get a timeout after leaving the connection open for
a few minutes. Where can I diagnose this fault?
gvim
--
Sent via pgsql-ge
I want to use MS Access 2007 as a front end to a more robust/FOSS database.
Which is more compatible - MySQL or PostgreSQL? Unbiased answers please :-).
gvim
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
input but I want to
build forms which have the same fields as a VIEW derived from multiple table
joins. In other words, I want the CRUD to handle the the joins.
Any suggestions?
gvim
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
d and l.you_id. It seems simple but I can't
think of a JOIN which will do the trick.
gvim
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ld be better?
Suggestions?
gvim
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
etter? Suggestions?
gvim
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Setup duplicate users or
can I use a distinct set of users? I would ideally like to have the same
schemas setup with distinct users then simply have a data-only backup from the
remote server which I can restore to the local machine without resetting
privileges/permissions.
gvim
--
Sent via
I'm putting together a database for a web project which has a lot of HR
components which I imagine are fairly standardised so, to avoid re-inventing
the wheel, is there a source of standard, downloadable schemas for common
projects?
gvim
--
Sent via pgsql-general mailing list (pgsql-ge
uot;max. 2" situations? Keeping them as:
Primary Email
Secondary Email
also preserves priority though not strictly normalised, I know.
gvim
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Is it possible, with PostgreSQL 9.0, to restrict access to specific table rows by
`id`? I want a user to be able to INSERT new rows but not UPDATE or DELETE rows
with `id` < 1616.
gvim
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscript
with their current values, which have been augmented since the
database was setup. When I backup via pgAdminIII the sequences are not even
included. I also can't find anything in:
man pg_dump
... which specifies sequences.
gvim
--
Sent via pgsql-general mailing list (pgsql-general@pos
currval function while
REFERENCES is only required to create a foreign key, not to make use of it.
gvim
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
mydb;
Now, for some reason, when I recreate the datbase the old tables are still
present. I've tried the same procedure using a psql login but the result is the
same.
gvim
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www
I've been looking through the Date/Time functions and operators on the docs and
can't find anything obvious to do this simple task - filter a date column for
entries which are later than a specified date.
gvim
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.or
I'm running PostgreSQL 8.4.3 on OS X Snow Leopard via MacPorts and I'm getting
strange inconsistent errors such as:
dbuser-# select * from log_form;
ERROR: syntax error at or near "select"
LINE 2: select * from log_form;
^
Then later the same query will run fine,
any way I can limit access to the postgres user specified as
being logged in as postgres?
gvim
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
16 matches
Mail list logo