[GENERAL] Convert 2 foreign key values within the same SELECT

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

[GENERAL] Import id column then convert to SEQUENCE?

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

[GENERAL] Import ID column data then convert to SEQUENCE?

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

[GENERAL] Data backup to local duplicate without resetting permissions

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

[GENERAL] Standard schemas for common features?

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

[GENERAL] 2 versions of an entity worth distinct table?

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

[GENERAL] Row-level permissions?

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

[GENERAL] Backup and restore sequences

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

[GENERAL] Privileges for read-only tables with sequence and foreign keys

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

[GENERAL] Recreate database but old tables still present

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

[GENERAL] Timeouts after upgrade from 9.0 to 9.3

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

[GENERAL] "IS LATER THAN" filter for date column

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

[GENERAL] Pg CRUD for joined tables

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:

[GENERAL] Inconsistent SQL errors

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,

[GENERAL] Limit postgres user logins

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

[GENERAL] MS Access easier with PostgreSQL or MySQL?

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